Some Selected Official Microsoft SQL Server Blogs
Here is a list of a some of the official Microsoft SQL Server blogs that I have stumbled across. Some...
2010-02-01
333 reads
Glenn Berry
Teaching Two SQL Server 2008 Classes at University of Denver, University College in Spring Quarter
I’ll be teaching two SQL Server 2008 classes this spring at University of Denver, University College. The first one, which...
2010-02-01
778 reads
Paul Randal’s Benchmarking Series
Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has...
2010-01-29
2,750 reads
Are You Running the x86 Version of SQL Server 2005/2008?
If so why? Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008,...
2010-01-28
2,900 reads
Living with TED 5000
Since I installed my TED 5000 home energy monitor about a week ago, I have learned quite a bit about...
2010-01-25
937 reads
Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-24
1,903 reads
Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008
In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...
2010-01-20
910 reads
Three Big Things That Got Me Here
I was tagged by Steve Jones in the meme that Paul Randal started a few days ago, so I need...
2010-01-19
838 reads
SQL Server 2008 SP1 Cumulative Update 6 Released
Microsoft has released Cumulative Update 6 (CU6) for SQL Server 2008 SP1, which you can request here. This is Build...
2010-01-19
1,750 reads
A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS)
I had a hardware issue this past weekend on one of my database servers where I am running SQL Server...
2010-01-18
1,530 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