Change Data Capture
I started working through some labs for my SQL Server 2008 class and one of the labs was on the...
2008-02-12
1,154 reads
Blog Posts
Computed Columns Published on SSC
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
444 reads
Speaker Eval Form, Part 2
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
978 reads
Init from Backup Published on SSC
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it...
2008-02-11
342 reads
Kalen Delaney SQL Server Internals DVD
I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server internals...
2008-02-11
1,364 reads
Making Sponsorship Work at Community Events & User Groups (My Wish List)
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and...
2008-02-11
801 reads
Next oPASS Meeting is Feb 12
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the...
2008-02-11
511 reads
SQLSaturday Tampa 2008 is This Weekend (Feb 16)
The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past...
2008-02-11
561 reads
The Right Font
I was doing some development on my laptop tonight and I was getting fed up with the default font, Courier...
2008-02-09
3,637 reads
Do It My Way
Actually more it's "our way" as mentioned in Andy's post, and less my way than by committee these days with...
2008-02-08
808 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