-
#PowershellBasics: Sort a list
2October 26, 2021 by Kenneth Fisher
In my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a …
Continue reading -
#PowershellBasics: Get a list of files from a directory.
4October 21, 2021 by Kenneth Fisher
I’ve got a project I’m working on at the moment and it includes a number of elements from my recent …
Continue reading -
Commenting a branching IF-THEN-ELSE.
1October 19, 2021 by Kenneth Fisher
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE …
Continue reading -
#PowershellBasics: Adding data to a string using subexpressions.
7October 14, 2021 by Kenneth Fisher
I’m working on a project right now where I want to add the date/time to the end of a filename. …
Continue reading -
Code examples : T-SQL Tuesday #143
Leave a commentOctober 12, 2021 by Kenneth Fisher
It’s TSQL Tuesday! John Armando McCormack (blog|twitter) is our host this month and he’d like us to share some of …
Continue reading -
Dealing with foreign keys when deleting rows.
2October 7, 2021 by Kenneth Fisher
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of …
Continue reading -
SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?
Leave a commentOctober 5, 2021 by Kenneth Fisher
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? …
Continue reading -
A DBA horror story in database file extensions.
4September 30, 2021 by Kenneth Fisher
-
Audit Columns
3September 28, 2021 by Kenneth Fisher
One of the easiest ways to collect information about table activity is to add a series of audit columns to …
Continue reading -
#PowershellBasics: Bulk insert.
Leave a commentSeptember 21, 2021 by Kenneth Fisher
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 