Better Know A SSIS Transform – The Sort Transform
This is part 2 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-24
8,668 reads
Blog Posts
Dell Mini – The Follow Up
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,378 reads
SQL Server 2008 Encryption - Extensible Key Management
One of the new features with SQL Server 2008 is the addition of extensible key management, allowing hardware devices to...
2009-06-24
3,952 reads
What’s the Typical Resignation Notice Period for DBAs?
I was recently talking to a friend from the U.K about how much notice a DBA should give to their...
2009-06-24
2,008 reads
Why Do I Blog?
It's late, it's been a busy day, so why bother to spend 10 or 15 minutes at night jotting things...
2009-06-24
1,497 reads
Windows 7 Issues
I went to add a few things to the new Windows 7 desktop today, and of course I have installer...
2009-06-24
790 reads
Clear Ceases Operations
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
630 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds...
2009-06-23
3,054 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I...
2009-06-23
2,022 reads
Spring Cleaning
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
531 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