Use SQL 2008 Express As A Central Management Server
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he...
2009-04-20
891 reads
Kendal Van Dyke
Full Text Catalog Scripting "Gotcha" in SSMS 2008
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
582 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
538 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,436 reads
Launch Replication Monitor Without SSMS
I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs...
2009-03-25
847 reads
Ada Lovelace Day – Celebrating Women In Technology
Today is Ada Lovelace Day, an international day of blogging to draw attention to women excelling in technology. I don't...
2009-03-24
740 reads
Data Mining With Google Insights For Search
I recently read a NYT article that highlighted how Google search data is being used to predict flu outbreaks at...
2009-03-23
844 reads
Upcoming Speaking Engagements
I've got three speaking engagements lined up in next two months:
Wed, March 11 @ oPASS: The Truth About Disk Performance & Configuration....
2009-02-26
1,401 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