Planning for a Disaster
Early last week, my church suffered a lightning strike that did quite a bit of damage (relatively speaking) to computer and...
2009-06-11
835 reads
Why You'll Want to Create Your Temp Tables Before Populating them
The point of this post is to cleary explain how the combination of the use of data definition language for your temporary...
2009-06-11
1,120 reads
A $200 Knife
While I was in Pensacola last weekend, I sat next to Andy Warren and I was telling him about getting...
2009-06-11
699 reads
Writing Technical Articles - Finding Ideas
This is part two of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-06-11
1,679 reads
First Thoughts on Windows 7
I am at times an early adopter of technology. I like newer, better tools, but they have to be something...
2009-06-10
413 reads
What is wrong with people?
I hope this isn't real, but I suspect it is.
If this image disappears, I promise not to sue.
2009-06-10
619 reads
SQLSaturday #14 – Speaker Results
I got my results from Karla Remail on the SQLSaturday talk over the weekend. I was surprised since typically other...
2009-06-10
346 reads
PASS Connector Editorial for June 3, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-09
338 reads
One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use...
2009-06-09
395 reads
Starting Conversations - Part 6
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker...
2009-06-09
334 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