TempDB memory leak?
I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a...
2016-01-05
13 reads
Simple SQL Server
Query the Buffer Pool
DBAs are known for asking for more memory, but often can’t say what’s in memory. While I agree that many...
2016-01-07 (first published: 2016-01-04)
2,727 reads
Query the Buffer Pool
SQL Server's buffer pool is a majority of your memory, but most DBAs can't tell you what's in it.
2016-01-04
18 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t...
2015-12-28
694 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t have had them if it wasn’t for three things. Getting...
2015-12-28
8 reads
Advent of Code – Day 4
Day 4 of the Advent of Code has us mining for data in MD5 hashes, which is out of the...
2015-12-24
548 reads
Advent of Code – Day 4
Day 4 of the Advent of Code has us mining for data in MD5 hashes, which is out of the comfort zone for a SQL DBA to say the...
2015-12-24
11 reads
Advent of Code – Day 3
Continuing with the language-independent code challenge on Advent of Code – Day 3, I’m tasked with figuring out how well a...
2015-12-24
512 reads
Advent of Code – Day 3
Continuing with the language-independent code challenge on Advent of Code – Day 3, I’m tasked with figuring out how well a drunken elf can guide Santa to houses. Since...
2015-12-24
21 reads
Advent of Code
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice,...
2016-01-04 (first published: 2015-12-23)
1,545 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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