Labor Day 2011
It's a holiday in the US today and Steve Jones provides a little entertainment for those people still at work.
Piracy and Agile
Do Agile IT projects have anything to learn from the organizational structures and laws used by pirates? Phil Factor is not convinced.
TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
Using a SQL Server Alias for SSIS Package Configuration Database Connection String
In this tip we will walk through setting up the SQL Server Alias and using it with SQL Server package configuration in an SSIS package.
The Growth of Data Types
This week Steve Jones asks you what you think will make up the majority of your future databases? Will it be numerical data or will some other type come to dominate?
Configure SQL Server Database Mirroring Using SSMS
This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
Where Do You Park?
Today we have a guest editorial from Andy Warren. Most people work in an office and need to commute, which brings with it the inevitable fight for parking in many companies. How is it handled for you?
Preventing Problems in SQL Server
It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.
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