Compression
SQL Server 2008 brings with is a new set of features involving compression. At first I was assuming this was...
2008-03-03
1,836 reads
SQL 2008 Schedule Slippage and SQL 2005 SP3
I've read with interest some of Steve's editorials about SQL 2005 SP3 and in large part agree with him that...
2008-03-02
599 reads
Documentation Value Formula (Part I)
As a DBA, documentation work is unavoidable, we need to do documentation about things we have done, for example, what...
2008-03-01
1,068 reads
New DBA type: Test DBA
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,891 reads
New Benchmarks
There are new TPC-E benchmarks available for SQL Server 2008. And it's not even out!!!!
The 3rd place, the IBM entry,...
2008-02-28
1,481 reads
Notes From My Visit with the Charlotte SQL Group
I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my...
2008-02-28
1,296 reads
Using TripIt for Travel Plans
Not a SQL related topic today.
I first noticed Tripit on Joels Blog and so far it solves a problem I've...
2008-02-26
1,288 reads
The Launch
The launch event is tomorrow in LA and I'm not going, and find myself a little disappointed. There will be...
2008-02-26
1,392 reads
Snapshots Part 1 Published on SSC
Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In...
2008-02-26
1,249 reads
Perks at Work - A Good Thing?
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,423 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