Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
447 reads
Kendal Van Dyke
SQL Quiz #4 - Leadership
Chris Shaw posts SQL quiz #4, I make an observation on Twitter about who gets tagged, Brent Ozar tags me...
2009-07-14
710 reads
The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
753 reads
See You In Seattle For PASS 2009!
Last Friday I got the official notice that I've been selected to present a community session at the 2009 PASS...
2009-06-15
463 reads
Speaking At Space Coast SQL Users Group On June 11
Just a quick note to mention that I'm speaking at the next Space Coast SQL Users Group on Thursday, June...
2009-06-09
418 reads
Inside A Datacenter
I spent the last 4 days in Denver helping my company move in a new datacenter and while I was...
2009-05-20
575 reads
SQL Saturday Jacksonville Recap
Note: I intended to post this last week but life\work\burnout and installing Windows 7 RC got in the way.
Another weekend,...
2009-05-12
430 reads
SQL Saturday Atlanta Recap
I had a great time at SQL Saturday Atlanta last weekend. I drove from Orlando to Atlanta on Friday with...
2009-04-29
1,530 reads
PASS Summit Sessions Submitted
It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see...
2009-04-24
658 reads
Register A Server More Than Once In SSMS
In yesterday's post about using SQL 2008 Express as a Central Management Server I mentioned that you can't register a...
2009-04-21
545 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers