A Cast of Thousands
In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.
Extract Objects from SSRS Reports
A discrete list of database objects is extracted from SSRS using SQL, SSIS, and RegExtractor in order to identify reports that might break when a schema upgrade is performed.
The Impact of Outages
Steve Jones talks about the problems of outages, and why we ought to perhaps introduce failure into our systems to help us learn to cope with them.
CLR Performance Testing
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
SQL Saturday #64 - Baton Rouge, LA
Come join Steve Jones for a day of SQL Server training in Baton Rouge on Aug 6, 2011. Free training!
Geeky Distractions
This Friday Steve Jones has a non-work related, but fun poll. Let us know what your geeky media recommendations are this year.
SQL Overview V - Monitoring Long Running Jobs
Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.
Backup to multiple files for faster and smaller SQL Server backup files
Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.
Third Normal Form
The third article in our series on normalization from Tom Thomson continues with an explanation on what constitutes third normal form.
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