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
119 reads
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
2013-08-05
116 reads
DBAs and the Fear of Time Off
Rodney Landrum on why many DBAs find it hard to ask for, and take, their due DBAcations.
2013-05-27
263 reads
To Specialize or Not to Specialize: that is the $132,000 Question
In a guest editorial, Rodney Landrum reflects on his career path as a an information-hungry generalist.
2012-05-28
257 reads
SQL Server 2012: Creative Thinking for a Creative New Licensing Model
It seems inevitable that many customers will end up paying more to get the same features they have today, under the new SQL Server licencing model, unless they respond to Microsoft's creativity with some of their own.
2012-02-06
252 reads
A Cast of Thousands
In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.
2011-08-01
138 reads
If you could stop working tomorrow, would you still do SQL?
Rodney landrum wonders what, if anything, you would do in SQL, or any other beloved technology, if you did not have to?
2011-03-21
232 reads
Life Without a Net
Today we have a guest editorial from Rodney Landrum that talks about life in the past, when we couldn't look up everything on the Internet.
2010-11-02
220 reads
Hunting and Gathering
A guest editorial from Rodney Landrum looks at how we get advice from others in the wild, wild world of the Internet.
2010-03-26
149 reads
Slipping out of the DBA trenches
Today we have a guest editorial from Rodney Landrum who wonders how DBA Managers, removed from the front lines, can keep up to date and retain their edge. Is it inevitable that, slowly but inexorably, they will feel the 'blunting of the blade'?
2010-01-05
161 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers