The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,349 reads
Edward Polley
Hidden Tricks To SQL Server Table Cleanup
How to delete millions of rows with virtually no contention.
2015-09-04 (first published: 2013-03-06)
28,346 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,373 reads
Super Fast Transactional Replication Repair
Your production SQL Server transactional replication just failed and the business impact is critical. How do you get replication restored in minutes?
2013-05-30
8,537 reads
The Trouble with Transactional Replication and large articles.
This article will show you one way to quickly restore SQL Server replication with huge tables.
2012-05-18
7,719 reads
Large table cleanup with minimal locks
How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.
2012-03-06
15,478 reads
Blogs
SQL Clone at Scale with Striped Backups
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
Designing for Observability in Fabric Powered Data Ecosystems
By Chris Yates
In today’s data-driven world, observability is not an optional add-on but a foundational principle....
SQL Server 2025 Unleashed Live Training – A New Era Begins
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Connecting to SQL express 2019 server
Hello, Our old server is on its last legs, and I'm transitioning to a...
Docker Advice for SQL Server in Production
Comments posted to this topic are about the item Docker Advice for SQL Server...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers