Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots. This new version fixes a bug that we’ve found in version 2...
2025-10-24 (first published: 2025-10-02)
1,534 reads
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
43 reads
In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...
2025-10-27 (first published: 2025-10-01)
1,742 reads
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I wasn’t sure about. Someone asked about the download size...
2025-10-01
47 reads
After setting up dozens of Internet of Things (IoT) smart home devices, I started to wonder: how hard could it be to build one from scratch?
I needed a project...
2025-10-01
18 reads
Are you diversifying your DBA skillset? My recent job search made one thing clear: the database landscape is broader than just SQL Server and Oracle. More and more companies...
2025-09-30
142 reads
I flew to Amsterdam last night and hopefully by the time this publishes I’ll be at my hotel, catching up on messages and prepping for another Simple Talk Podcast...
2025-09-29
17 reads
In every organization there is a hidden currency more valuable than capital, more enduring than strategy, and more transformative than technology. That currency is feedback. Leaders who learn to...
2025-10-22 (first published: 2025-09-29)
158 reads
Update for SQL Server 2025:
This post and the GitHub repo have been updated for SQL Server 2025 RC1 and Ubuntu 24.04.
New in SQL Server 2025: You no longer need...
2025-10-27 (first published: 2025-09-29)
398 reads
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve got resources listed below Slides Here are the slides from my two sessions Running a...
2025-09-27
30 reads
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers