The SSMS Super Clipboard (Day 13)
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
397 reads
A Discussion of SQL Server-Related Topics
Changing Case (Day 12)
In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However,...
2018-01-12
283 reads
Block Select/Replace (Day 11)
While Regular Expressions lets us work with text not cleanly formatted, if you are trying to work with text that...
2018-01-11
240 reads
Regular Expressions (Day 10)
Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...
2018-01-10
453 reads
Multi-Server Queries (Day 9)
Have you ever had to run a query on multiple servers? You could connect to each server one by one...
2018-01-09
444 reads
SQLCMD Mode (Day 8)
Have you ever had a script where you needed to run parts of it on different instances of SQL Server...
2018-01-08
441 reads
Template Variables (Day 7)
Do you have scripts that you need to run frequently, but every time you need to set some different parameters?...
2018-01-18 (first published: 2018-01-07)
1,557 reads
Vertical Scroll Bar Map Mode (Day 6)
Have you ever had a long script that you are trying to scroll through? Do you wish that you could...
2018-01-06
569 reads
Working with Query Files (Day 5)
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
374 reads
Pinned Tabs (Day 4)
Have you ever been working in SSMS where you need to frequently access one particular script, but you are spending...
2018-01-04
421 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