Quick and Dirty Code Compare
MS Word 2007 (and probably earlier versions) have the ability to do a basic document compare, useful if you're at...
2008-06-30
1,328 reads
SQLAndy
Why Format TSQL?
Recently I had the chance to help a student debug a problem on a production server. It appeared to be...
2008-06-29
1,456 reads
Volunteering
Recently I was visiting with an old acquaintance and one of the topics that came up was volunteers. At some...
2008-06-26
2,217 reads
SQLSaturday Call for Speakers - Cleveland & Olympia
Call for speakers is open for SQLSaturday #5 in Olympia, WA on Oct 10 (note that the MS BI conference...
2008-06-25
1,466 reads
Employee or 1099?
My friend Wes Dumey does a lot of work in the business intelligence sector as a contract employee and has...
2008-06-24
1,618 reads
Microsoft BI Conference Oct 6-8, 2008
Had missed the announcement, came up in conversation yesterday with a friend, the BI conference will be Oct 6-8 in...
2008-06-23
1,638 reads
Notes on My Visit to Birmingham SQL Group
Spent last Tues/Wed in Birmingham, speaking at the user group Tuesday night and then presenting a seminar on Wed. Attendance...
2008-06-22
1,399 reads
Transparent, Translucent, or Opaque? Whats Your Strategy?
It's a couple weeks old, but there was a mild blog roar over some comments from Microsoft about wanting to...
2008-06-19
1,551 reads
SQLSaturday #4 Lessons Learned
Earlier in the week I posted a quick & positive note about the event, today I'll add some notes about things...
2008-06-18
1,389 reads
Link: Killing Terminal Service Connections
Needed to kill a connection so I get could logged on recently to a server and didn't have the server...
2008-06-17
1,394 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