Backup History
Can you tell me the drive we were backing up server #58 to exactly 8 months ago, and, if possible,...
2013-05-14
420 reads
Simple SQL Server
Cluster Info
This script is so simple you’ll start off by asking why you’d ever use it. Then you’ll use it and...
2013-05-14
598 reads
File Sizes
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
444 reads
Copy / Paste Code
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
574 reads
Database Assessment
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
466 reads
2013-05-10
404 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
extended events to spy on our server between 8 and 9 am
Hi, our peer who owns a remote mysql server from which we extract warehouse...
Restore Job fails in Replication
Dear Folks, Restore jobs in my SQL2022 Standard edition replication were failing on a...
visual studio seems to lose "provider" on pkg imports
hi, just to get this part out of the way, if my intended target...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers