SQLSaturday Update - 215 Registered!
We're at 215 registered with 3 weeks to the big day! This week I'll be having the last planning meeting...
2007-10-21
1,460 reads
SQLAndy
ZFS & Hard Drive Defects
The most recent ACM Queue Magazine (Vol 5 #6, Sep/Oct 2007) had two really interesting articles. The first was about...
2007-10-21
1,501 reads
Suggestions for PASS Published on SSC
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,349 reads
The Troubleshooting List & Replication Statement Delivery Options
All of these are new articles that have gone up on SSC recently. The troubleshooting one was my attempt to...
2007-10-14
628 reads
Bill Graziano Visits oPASS & JSSUG
Bill Graziano (main man at SQLTeam.com, consultant, and VP of PASS) was in town recently to speak at both the...
2007-10-13
683 reads
Schema as Folder
I'm catching up on my reading today and ran across an article from Kathi Kellenberger called Understanding the Difference between...
2007-10-13
604 reads
Partitioning Part 2 Posted on SSC
I'm a couple days late updating the blog, the article went up on Mon.
2007-10-11
572 reads
Views, Temp Tables, Data Types - Aha!
I spent last week onsite with a client teaching performance tuning and it was really a good week. Great company...
2007-10-08
607 reads
Flawed URL Validation and Not Eating Your Own Dog Food
MS includes a bunch of reasonably nice validation controls in VS 2005 and one of them includes the ability to...
2007-09-25
1,380 reads
Building a Local User Group
I've had a couple people ask me about ideas for growing (as opposed to starting) a SQL user group. While...
2007-09-24
1,340 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