DBAs and the Dark Closet
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,026 reads
The Scary DBA
New DMO in Azure SQL Database: sys.dm_db_wait_stats
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....
2013-02-04
1,403 reads
Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,894 reads
Saving Execution Plans on Azure SQL Database
In my previous post showing how to get to execution plans in the Database Management Portal, I showed that it’s...
2013-01-23
1,837 reads
Pro SQL Server 2012 Practices: Chapter 12
I was very privileged to get the opportunity to write a chapter in a book with some of my friends...
2013-01-21
1,103 reads
You Can Say “No”
I heard about this new law that was passed to prevent employers from asking for your social media passwords. After...
2013-01-16
973 reads
Execution Plans on Azure SQL Database Portal
If you’ve been working with the Azure SQL Database portal, you know that you have a query window. Within the...
2013-01-16 (first published: 2013-01-14)
1,852 reads
Plans for 2013
I have lists. Lots of lists. I even have them in different locations sometimes. Some of them are carefully written...
2013-01-09
901 reads
Statistics Update Clarification
By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...
2013-01-11 (first published: 2013-01-07)
2,525 reads
SQLBits Public Sessions
If you’re over in the UK, or close to it, you’ve probably heard of SQL Bits even if you haven’t...
2013-01-07 (first published: 2013-01-03)
1,535 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers