September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,251 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,591 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
13 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
17 reads
SQL Server – Creating and using Dump Devices for Backups
A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using...
2011-09-26
1,340 reads
Recovery Models
In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases...
2011-09-26
2,872 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone’s clamoring to cut taxes -but no...
2011-09-26
900 reads
What is a Microsoft Regional Director?
First off, they don’t work for Microsoft. A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and...
2011-09-26
1,486 reads
SSIS Lookup Cache Connection Manager with Excel
The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of...
2011-09-26
1,714 reads
Small Business Hardware
[NOTE] My blog post scheduling-fu is weak, so this post didn’t go out Friday as planned. My apologies.
This is the...
2011-09-26
1,451 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers