Interviews: What is ACID?
While thinking about interviews, Steve Jones shares a story of a job situation he encountered.
2017-09-20
136 reads
Editorials
2017-09-19
79 reads
Avoiding the Hell of having to Remember DDL syntax
What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.
2017-09-18
126 reads
2017-09-18
73 reads
Voting for Change
Microsoft changed some things in SQL Server 2017 in response to community requests. Steve Jones is asking for more.
2017-09-15
58 reads
2017-09-14
103 reads
A Backup Change
Steve Jones talks about backup of data today and the challenges of managing this at scale.
2017-09-13
64 reads
The Randomness of Analog
A look back at the random nature of finding information in libraries and bookstores. A feeling Steve Jones misses.
2017-09-12
78 reads
2017-09-11
81 reads
The struggle to renormalize data
You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.
2017-09-11
227 reads
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