Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Microsoft’s Kevin Cox (from SQLCAT) and I co-authored a blog post titled Using SQL Agent Job Categories to Automate SQL...
2010-04-01
930 reads
Glenn Berry
Intel Xeon 7500 Series aka Nehalem-EX
Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight...
2010-03-31
2,011 reads
SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!
With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases...
2010-03-30
6,187 reads
To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
932 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,975 reads
Recovery Models and Backup Strategies for SQL Server 2008
I had a question via e-mail from one of my new students at University of Denver, University College this morning,...
2010-03-25
3,067 reads
Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,402 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
833 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,364 reads
The Coming Upgrade Tidal Wave
Microsoft is poised to release new versions of several different products and technologies that have the potential to have a...
2010-03-18
722 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