Brian Kelley looks at auditing in this article about SQL Server 2008 and the enhancements made in this version. The new Audit Object allows you to more easily determine what is happening on your SQL Server instance.
This article shows how the COPY_ONLY clause can be used to ensure that an ad-hoc database backup do not break the backup sequence
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
Brandon Galderisi brings us a new article that looks at how a table of dates can be useful in a SQL Server application.
SQL Server DBAs the world over have a problem that never seems to go away: troubleshooting, with the vast majority of troubleshooting being done to find a performance problem of some kind. Even the most carefully architected and tested application system will experience changes over time that can lead to significant performance issues.
Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.
Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers