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,616 reads
Simple SQL Server
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
7 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
Advent of Code
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice, you call it a “challenge”. This is what the...
2015-12-23
2 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers