A Better Conference
Is there a better way to put together a conference or event? Today Steve Jones speculates on how events are run and how we might change things.
SQL Server Trace Flags
A comprehensive list of trace flags for SQL Server that you can use to configure your server instance.
SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model
SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. However, the traditional, package-based methodology remains available and supported, and, in some scenarios, it might be considered more viable, since it allows for separation of SQL Server Database Engine and SQL Server Integration Services.
Why SQL Server 2012 needs Windows Server 2012
While AlwaysOn and Columnar lookup are good enough reasons to migrate to SQL Server 2012, you need to be aware of the problems associated with certain virtualize environments.
Don Knuth and the Art of Computer Programming: The Interview
Fifty years after starting the 'Art of Computer Programming', Don Knuth is still working hard at the project. It is considered amongst the "hundred or so books that shaped a century of science”. Richard Morris asks him how things are going, and to find out more about his many achievements.
Who's Got Your Data?
The state of data security might get worse in the future as more companies gather and share more data.
Comparing Data Warehouse Design Methodologies for Microsoft SQL Server
In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.
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