Adding to SQL Server
This week Steve Jones wonders what you might want to add to SQL Server. With SQL Server 2016 likely in the early planning stages, where would you want to see the development effort focused.
2014-01-31
241 reads
Editorials
The DBA is Dead
Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.
2014-01-29
483 reads
Servicing SQL Server in the Future
There hasn't been a service pack for SQL Server in a long time. Without knowing the plans for the future, Steve Jones asks you to express your own opinions.
2014-01-28
217 reads
Management at Scale
Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.
2014-01-27
194 reads
SQL Best practices, policies and code-smells.
Phil factor warns against taking SQL Coding 'best-practices' too much at face value. They can, at best, assist in reviewing code, and at the worst they can prevent the developer from finding the best solution.
2014-01-27
493 reads
Common Checks
This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.
2014-01-24
220 reads
Too Much Choice
More information and choice are generally good things, but there can be problems. Steve Jones notes that we can't let freedom paralyze us.
2014-01-23
123 reads
Software in 2014
What's the state of software in 2014. After reading Tim Bray's analysis, Steve Jones presents his.
2014-01-22
218 reads
Uncontrolled Code
Excel is used quite often to build software, or at least, it's worksheets and formulas simulate software. Steve Jones notes there are lots of problems with this practice.
2014-01-21
276 reads
Redundant Redundancy
When DBAs too often find themselves trading sleep for Megabytes, it's time for a different approach to detection and alerting of disk space problems. So argues Rodney Landrum.
2014-01-20
120 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