The DBA Financial Analyst
Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing.
Security Auditing Matching Up Logins And Users
I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?
The Semantics of NULL in SQL Server 2008
Learn the basics of NULL, what it is, and how to query for it in your databases from Adolfo Socorro. What NULL means, how to account for it, and how are expressions involving NULL evaluated
Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile
An interview with the Exceptional DBA of 2010, Tracy Hamlin.
When To Touch
When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.
Executing SSIS Packages Using DTExec
Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.
DMVs: are they worth the effort?
Many of the SQL Server DMVs still have a wild, unfinished feel but they are an incredibly useful tool for DBA, well-worth the sweat and toil required to learn and query them effectively.
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
Rating Bugs
How do you triage and rate the bugs that come in for software? How should Microsoft do this for SQL Server. Steve Jones has a few comments.
Tracy Hamlin elected Exceptional DBA of 2010
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers