LinkedIn Groups
I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me...
2009-06-28
1,559 reads
Blog Posts
SQLPSX Release 1.6
I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions,...
2009-06-28
1,613 reads
Incorporating Kids Into Work
I recently attended SQL Saturday #14 in Pensacola and took my daughter along. This was the third presentation she's come...
2009-06-26
1,475 reads
Presentation materials: Intro to Analysis Services (SSAS)
I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group...
2009-06-26
1,515 reads
An Android Update - TMobile G1
I still love my G1, and I got a pleasant surprise recently. I was out at dinner with my wife,...
2009-06-25
1,488 reads
Exceptional DBA Award Entries Must Be In By July 10, 2009
If you have been considering entering yourself in the Exceptional DBA Awards this year, or nominating a DBA you know,...
2009-06-25
1,598 reads
How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around
During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT...
2009-06-25
2,669 reads
My Favorite Bad Movie
My favorite bad movie is The Master Gunfighter starring Tom Laughlin of Billy Jack fame. It’s a Western, and he’s...
2009-06-25
1,501 reads
Plug for a Cool Catalog
Ran across the Levenger site while researching laptop bags and it’s branded as ‘tools for serious readers’. Some of it...
2009-06-25
1,450 reads
Powershell + SMO Error Handling Tips
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,676 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