Ask for SQL Server 2005 SP3
In case you haven't seen this elsewhere, if you want Microsoft to release SP3 for SQL Server 2005. It's time...
2008-02-03
945 reads
Blog Posts
SQL Server MVP Randy Dyess webcast on SQL Server 2008 Security
SQL Server MVP Randy Dyess has a short webcast which provides the highlights of SQL Server 2008 security.He includes some...
2008-02-03
618 reads
SQL Server MVP Andy Leonard on .NET Rocks!
SQL Server MVP Andy Leonard is on the latest edition of .NET Rocks! If you're not familiar with .NET Rocks!,...
2008-02-01
751 reads
The Importance of Verifying Database Backups Regularly
Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and...
2008-01-31
1,665 reads
A Long Overdue Database Security Rant
I've been dealing with a security product from a security company in recent days that breaks best practices with respect...
2008-01-30
2,305 reads
First Heroes Happen Here (HHH) Comic
Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...
2008-01-29
1,562 reads
Hello Secure World - MS Site Worth Looking At
Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses...
2008-01-29
1,398 reads
IT Transparency Posted on SSC
As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to...
2008-01-29
1,304 reads
Ken Henderson has passed away
I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...
2008-01-29
1,918 reads
Part II of Troubleshooting Memory Issues
The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...
2008-01-29
1,681 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