Service Pack 4
This week Steve Jones asks if Service Pack 4 for SQL Server 2005 is coming out and makes an argument why it should.
Auditing in SQL Server 2008
Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
TSQL Challenge 20 - finding repeating digits on Fibonacci sequence numbers
Can you generate repeating digits in a Fibonacci series?
Importing SharePoint ULS and IIS Logs into SQL
Importing data into SQL Server is one of the strengths of the platform. However it can require a bit of work for a DBA to make this an automated process. New author David Jansen brings us a technique for importing Sharepoint and IIS logs into SQL Server for later analysis.
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
Introduction to SQL Azure
Learn how to get started working with SQL Azure and migrating SQL Server databases to SQL Azure.
MySpace Using SSDs
Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
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