Public Role and Security
Having flown a fair amount lately, I was thinking about the various levels of security within an airport. Part of...
2011-12-29 (first published: 2011-12-20)
3,537 reads
Blog Posts
Ready for the new year?
The New Year is just around the corner. Every year I make a resolution. And every time I fail. That...
2011-12-29
2,290 reads
RedGate SQL Index Manager BETA
I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL...
2011-12-29
2,559 reads
SQL Saturday 99 – Confio Interview
Welcome to the seventh of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog |@ArnieRowland)...
2011-12-29
1,571 reads
SQL Server 2008 Diagnostic Information Queries (December 2011)
Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some...
2011-12-29
2,036 reads
SQL Server A to Z – CPU-Z
How fitting that I should close out the A to Z series while I close out the year. We’ve finally...
2011-12-29
2,080 reads
What is SQL Saturday?
I saw the following post from Andy Warren (blog | twitter), one of the creators of SQL Saturday. He was trying to...
2011-12-29
2,792 reads
2011 PASS Board Election Results
Results of the 2011 PASS Board of Directors election were officially announced this morning. I want to congratulate my friends...
2011-12-28
781 reads
Learn SQL 2012
Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...
2011-12-28
1,621 reads
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out of curiosity, I decided to take a look at...
2011-12-28
4 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
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
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