7th Anniversary
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
20 reads
Kenneth Fisher
SQL Homework – August 2019 – Getting the data out
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
325 reads
When Have You Used MOT Tables? T-SQL Tuesday #117
Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading
2019-08-13
226 reads
Is it just me or does msdb feel a lot like a user database?
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
660 reads
Short circuiting an AND
The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading
2019-08-06 (first published: 2019-07-15)
718 reads
Learning Powershell with Show-Command
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. ... Continue reading
2019-08-01 (first published: 2019-07-11)
868 reads
Header Query Crossword
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading
2019-07-31
57 reads
Optional vs Required parameters in Stored Procedures
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
172 reads
Custom error messages
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem ... Continue reading
2019-07-24
39 reads
Current database vs database locks
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
302 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Finding a Database Master Key
Comments posted to this topic are about the item Finding a Database Master Key
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers