Trying to Figure Out if SQL Server 2008 Data Compression Will Benefit You?
SQL Server 2008 (Enterprise Edition) offers row and page compression, which can potentially offer a boost in disk I/O in...
2008-12-08
1,501 reads
Blog Posts
Using Result Set as Variable in Stored Procedure
I’ve been asked several times lately from non-SQL developers that are sometimes required to do some quick SQL work how...
2008-12-08
3,420 reads
A skinnier SQL Server Magazine
I could have sworn that my SQL Server Magazine seemed much smaller this month. When I pulled out last’s months...
2008-12-07
1,304 reads
Managing By The Numbers Part 1
I have a long held belief that if you really care about results, you have to measure them somehow. The...
2008-12-07
314 reads
Starting a Technical Blog (Link)
Brent Ozar had a nice post recently on starting a technical blog, well worth reading and a good addition to...
2008-12-07
278 reads
Database Administrtion Skillset Investment Rules
With each new release of SQL Server version, there is something new to learn. In SQL Server 6.5 days, it...
2008-12-05
788 reads
Inbox Zero
An interesting idea in this video. I’d recommend you watch this if you have too much email. It's from the...
2008-12-05
431 reads
Keeping Shorn
One interesting thing about doing the podcasts and working from home is that I tend to shave a bit more...
2008-12-05
391 reads
Being a Professional
There's a lot to it, but I see Tim Ford has a nice blog post on what it means to...
2008-12-04
489 reads
Code Name "Kilimanjaro" - A couple of new features
I attended this years PASS Summit in Seattle and it turned out to be a great event. Many of the...
2008-12-04
476 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers