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,343 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,488 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,715 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,456 reads
Book Review: Smarter, Faster, Cheaper
In my continuing quest to not get personal visits from Buck Woody (blog|twitter) I’m making sure that I make good...
2011-09-26
1,491 reads
Notes from SQLSaturday #85
I’m writing this on Sunday afternoon after the event, thinking about the event and what I want to share with...
2011-09-26
639 reads
SQL University SSIS : Named Pipes -- Fundamentals
There comes a time when you look at how something is being done and say, "Does it have to be...
2011-09-26
616 reads
PASS 2011 Countdown – 2 Weeks To Go
I’m not sure how we got to 2-weeks until this year’s PASS Summit. If you haven’t registered yet it’s really...
2011-09-26
537 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers