Want to be able to read your database between restores?
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...
2016-07-20
774 reads
Kenneth Fisher
Is the network your last performance bottleneck?
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...
2016-07-18
441 reads
Altering a column in a large table: A case study
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...
2016-07-14
1,025 reads
Default database file sizes
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing...
2016-07-12
755 reads
Finding, disabling and enabling foreign keys
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,959 reads
Zilch to Speaker: 2016 Summit Abstract Reviews
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
447 reads
Perfectly Placed Parentheses
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc....
2016-07-05 (first published: 2016-06-27)
2,888 reads
Phantom SSIS Changes
That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing...
2016-07-05
996 reads
Minimizing Cloud cost
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working...
2016-06-27 (first published: 2016-06-20)
1,476 reads
Database snapshots
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating....
2016-06-22
557 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