Changing Server Default Collation
An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the...
2009-05-29
1,616 reads
The Conference ROI
I saw recently that Brent Ozar wrote a blog about justifying the cost of attending the 2009 PASS Summit. I...
2009-05-29
3,373 reads
Book Review: Real Leaders Don't Do Powerpoint
I bought Real Leaders Don't Do Powerpoint by Christoper Witt ($15 at Amazon) on a trip, Powerpoint catching my eye...
2009-05-28
1,746 reads
Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,185 reads
Why I Say Something about Running as Administrator
On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start...
2009-05-28
2,168 reads
Good Article on Data Warehousing Best Practices in SQL Server 2008
If you are involved data warehousing, or even if you are just a beginner, you may want to check out...
2009-05-28
1,507 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,950 reads
I Can Run Hyper-V!
I noted recently that I purchased a new desktop with the intention of moving to Windows 2008 and Hyper-V. That...
2009-05-28
1,646 reads
Minimalist Design - Part 3
One of the labs I frequently do with students is to design a database for a training business, something which...
2009-05-27
1,453 reads
Configuring Auto-Retry on SQL Server Agent
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...
2009-05-27
7,264 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
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...
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