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)
239 reads
SQLStudies
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
47 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
26 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)
488 reads
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)
393 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)
529 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
37 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)
10,653 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
72 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)
277 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers