Tab Groups (Day 3)
Have you ever wanted to have two different queries open up at the same time where you could see them,...
2018-01-03
329 reads
A Discussion of SQL Server-Related Topics
Split Screens (Day 2)
Have you ever wanted to see different parts of the same query window at the same time? Well, in SSMS,...
2018-01-15 (first published: 2018-01-02)
2,323 reads
SSMS Solutions (Day 1)
Since SSMS is built upon Visual Studio, many of the features available to Visual Studio are also available to SSMS....
2018-01-08 (first published: 2018-01-01)
3,244 reads
A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-01
382 reads
The case of the missing database backup file
Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...
2017-12-27
567 reads
New Features in SSMS 17.3
SSMS 17.3
SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention:
Import Flat...
2017-10-20 (first published: 2017-10-11)
4,109 reads
Stop waiting for SQL Server Service Pack 1 before upgrading!
It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...
2017-09-29
768 reads
Seattle Freecon 2017
Announcing Seattle Freecon 2017
Are you going to the PASS Summit this year? (and if not… why not?)
Are you coming in...
2017-09-28
615 reads
Working with the registry in SQL Server – adding trace flags to startup parameters
In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...
2017-09-04
766 reads
Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,704 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
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...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
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
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