No Opening Day
For the second year in a row I didn’t purchase opening day Rockies tickets. I had a nice streak of...
2009-04-10
796 reads
Book Review: Red Lightning
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
284 reads
My Kingdom for a Port
A Port, a Port! My Kingdom for a Port!!
One of the steps in setting up database mirroring is to assign...
2009-04-09
1,073 reads
NULL is not = to anything
One of the fun facts about SQL Server and the relation model is the
whole concept of three valued logic. Now...
2009-04-09
1,109 reads
Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,789 reads
Prius Repair Update
We decided to let the pros replace the seat belts and do the other repairs and file a claim on...
2009-04-09
371 reads
PASS Summit 2009 Call For Speakers Extended - And Why
Please consider this a not quite official announcement, look for that on the sqlpass.org site today or tomorrow.
You may have...
2009-04-09
1,212 reads
My Mini Identity Protection
Last week, on April Fool’s Day, I woke up to find quite a few birthday congratulations in my email. I...
2009-04-09
385 reads
Animation in Presentations
I've never been a fan of animation in Powerpoint presentations, and as a result almost never use them in my...
2009-04-08
419 reads
PASS Call for Speakers Deadline Extended
If you have been procrastinating about submitting a speaking abstract for the 2009 PASS Community Summit, you have been given...
2009-04-08
546 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