Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...

Last month I told you about the overall set of features which Microsoft plans to release when SQL Server 2014 (SQL2014) is released to manufacturing. Microsoft has three major feature sets that they ...

Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...