SQL Server 2008 Database Mirroring in Action
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-13
1,322 reads
Blog Posts
Super Seven Cleanup Steps Before Deploying Your Cube
Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the...
2009-11-13
1,793 reads
Why We Recommend Against xp_cmdshell
Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...
2009-11-13
21,114 reads
Book Review: The Machine, The Story of the 1975 Cincinnati Reds
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
543 reads
Flight or Invisibility: Which do you Choose?
A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...
2009-11-12
1,059 reads
How did I become a DBA
This past Tuesday night I had the honor of speaking to a small group of college students who are all...
2009-11-12
787 reads
Looking Back – PASS Summit 2009 Day 4
Thursday started off with a meeting of the SQL Saturday minds over breakfast at Top Pot Donuts a few blocks...
2009-11-12
880 reads
New HP Envy 15 Laptop
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-12
1,956 reads
PASS Summit 2009 – Keynotes
I’m not going to look back at the keynotes since I blogged about them. If you are interested, you can...
2009-11-12
770 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-11-12
726 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
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