Tag Archives: sql 2008 r2

sys.dm_db_stats_properties DMV

Service pack 1 for SQL Server 2012 has been released on 9th Nov 2012. It took couple of weeks for me to install it in our servers. Before I settle down I got another notification from Microsoft that Cumulative Update 1 has been released for SP1. So I started analyzing what they missed major in SP1 and finally I found a article by Aaron.

Continue reading sys.dm_db_stats_properties DMV

DAC – Data Tier Applications

This is one of the new feature released with SQL Server 2008 R2. I know it’s late to cover this topic. It has greater flexibility and easy of implementation for database perspective. I could say it’s a build which has all database & instance level objects for implementation, just run the build and get the database work done, just simple like that. I’m not sure why Microsoft chosen same acronym for Data tier applications as DAC is also know as Dedicated Administrator Connection, lets not dig into it, only Microsoft can answer!!

Continue reading DAC – Data Tier Applications