SQL 2012 Roadshow. 7th to 10th November, 2011

The SQL 2010 Roadshow is announced as per the Microsoft Ireland blog site here http://blogs.technet.com/b/ieitpro/archive/2011/10/11/sql-server-denali-roadshow-microsoft-ireland-in-association-with-prodata.aspx We are going to be spending nearly a week touring Ireland demoing the most important new features in SQL 2012 that will definitely affect anyone working with high availability of Business Intelligence. Content wise we have some great demos covering … Continue reading SQL 2012 Roadshow. 7th to 10th November, 2011

Compress an entire database

By Bob Duffy16. September 2011 04:30http://www.facebook.com/widgets/like.php?href=http://blogs.prodata.ie/post/Compress-and-entire-database.aspx I posted a script earlier to generate the script to compress an entire database. here is one to do the compress/rebuild partition by partition. one thing to bear in mind is that ONLINE rebuild is not supported  when rebuilding partition by partition. See http://technet.microsoft.com/en-us/library/ms188388.aspx  My simpler script to just do compression … Continue reading Compress an entire database