T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query
Everybody deserves a second chance in love, life, and in TSQL as well! Now that it's the beginning of a New...
2012-01-10
5,157 reads
Blog Posts
T-SQL Tuesday #26 – Second Changes with Date/Time
I missed the very first T-SQL Tuesday, so when this month’s topic of second chances came up, I decided to...
2012-01-10
1,407 reads
TSQL Tuesday #26 or #23 – Identity Crisis
This second chance, gives me the opportunity to finally talk about a topic that has been on my to-blog list for quite some time. I hope this post will...
2012-01-10
4 reads
TSQL Tuesday #26 or #23 – Identity Crisis
The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to...
2012-01-10
892 reads
31 Days of SSIS in a PDF
At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts...
2012-01-09 (first published: 2012-01-05)
7,122 reads
Capacity planning for new hardware
I get asked this question a lot: When getting a new application and database, what kind of hardware do I...
2012-01-09
1,641 reads
DBAs in Denver
I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need...
2012-01-09
779 reads
January #Meme15 Assignment
Last month, a number of us got together to share how we use social networks to enhance our careers and...
2012-01-09
570 reads
Meme Monday - All in the #SQLFamily
Yes, it's Monday again, and not only that - it's another edition of Meme Monday (the first of 2012), started by...
2012-01-09
1,357 reads
Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or maybe a bad thing or maybe a non-discussion at...
2012-01-09
6 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