Subscribe to this blog
Archives: March 2012
SQL Server 2012 Synopsis - Mission Critical Applications Combined With The Fantastic 12 New Features or "The Baker's Dozen" as described by Microsoft this Week
Notes by Hugo S., Print Screens from three Microsoft Presentations
7 December, 2011 with Additions combined from early February 2012 day-long presentation of Server 2012’s Top 12 new features. Thank you Frank Wiemer (Data Platform head, Eastern Canada, based in Montreal, for your presentation slides). With these notes, I have…
0 comments, 557 reads
Posted in The Database Hive for SQL Server DBAs on 27 March 2012
Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)
You can the full details of the introduction here.
0 comments, 973 reads
Posted in The Database Hive for SQL Server DBAs on 20 March 2012
Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA
Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen (SQLserverBible.com), on this subject, the following is a re-introduction to one of our favorite Management Studio features: Activity Monitor.
To use AM, right click on a SQL Server… Read more
0 comments, 3,392 reads
Posted in The Database Hive for SQL Server DBAs on 18 March 2012
Avoid Database Restore Issues (Errors 3219 or 3514) by a Simple Script Edit - the DB Restore Work-around
Starting with the 1000 foot view: During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT method accordingly), we should always go through a thorough testing process on an exact copy and environment too, if possible, of the production…
Read more0 comments, 1,547 reads
Posted in The Database Hive for SQL Server DBAs on 18 March 2012