Quiz & answers for my “Auditing your data and data access” session.
I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one ... Continue reading
2021-11-24 (first published: 2021-11-16)
234 reads
Kenneth Fisher
SQL Homework – November 2021 – Backup, restore, and move the system databases?
On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points ... Continue reading
2021-11-15 (first published: 2021-11-02)
376 reads
#PowershellBasics: Select the columns in the output.
After my post last week on sorting the list, I now have a list of files, sorted in the right ... Continue reading
2021-11-12 (first published: 2021-11-04)
469 reads
Pass Summit 2021: A quick thank you to @Redgate.
I’d just like to say a quick thank you to Redgate for hosting the Pass Summit, all of the amazing ... Continue reading
2021-11-11
32 reads
#PowershellBasics: The WHERE clause
Sometimes when you are trying to figure something out you run across something really interesting. In this case I discovered ... Continue reading
2021-11-09
10 reads
The DBA as a helpdesk.
Every one and again you will see people asking What skill do you think is the most important for your ... Continue reading
2021-11-05 (first published: 2021-10-28)
517 reads
#PowershellBasics: Get a list of files from a directory.
I’ve got a project I’m working on at the moment and it includes a number of elements from my recent ... Continue reading
2021-11-01 (first published: 2021-10-21)
6,720 reads
#PowershellBasics: Sort a list
In my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a ... Continue reading
2021-10-26
21 reads
#PowershellBasics: Adding data to a string using subexpressions.
I’m working on a project right now where I want to add the date/time to the end of a filename. ... Continue reading
2021-10-25 (first published: 2021-10-14)
266 reads
Commenting a branching IF-THEN-ELSE.
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
2021-10-19
66 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
FinOps - the new name for performance tuning
Comments posted to this topic are about the item FinOps - the new name...
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers