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
7 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,653 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
10 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
681 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
1 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
540 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
1 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
506 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
2 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,540 reads
Blogs
Stack Overflow & AI
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
Checking Myself with GenAI
By Steve Jones
I had a suggestion from somone on a place where AI helps them and...
Redgate SQL Prompt in SSMS 21
Disclaimer: this post is not sponsored by Redgate 
For those who’ve missed it,...
Forums
Deadlocks and Backups - Need help
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Does Version Control Scare You
Comments posted to this topic are about the item Does Version Control Scare You
Unlimited Text
Comments posted to this topic are about the item Unlimited Text
Question of the Day
Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers