SQL Database Status with sys.databases
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
853 reads
Blog Posts
SQL Server MVP Deep Dives Volume 2 – My Review
Volume 1 was packed full of knowledge and a very welcome edition to my bookshelf! With the bar already set...
2011-12-09
847 reads
Book Review: Sixkill
Sixkill is the 39th Spencer novel, and the last that was written by Robert Parker before his death. The plot...
2011-12-08
646 reads
Data Usage
This is somewhat shocking to me. I was reading about ATT’s decision to throttle some high bandwidth users, and there...
2011-12-08
1,110 reads
DBA in Space: Behind the Scenes—Question 14
Part 1 of Question 14—The question.Part 2 of Question 14—The follow up to the question.This is a continuation of my...
2011-12-08
715 reads
First Blog Since the PASS Summit
The time following the PASS Summit has been absolutely crazy for me. Upon returning home I spent some much needed...
2011-12-08
553 reads
Junior DBA
At our company we have two DBAs to take care of all the databases in the production and QA. It...
2011-12-08
1,484 reads
SQL Saturday 99 – Data Education
Welcome to the third of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-08
481 reads
SQL Server A to Z – XML
I can’t believe it’s already December. This year has just flown by. The rush of holiday events has already started,...
2011-12-08
1,749 reads
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
843 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers