Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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…

Read more

0 comments, 810 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 :)


Free E-Book: Introduction to SQL Server 2012

Ross Mistry and Stacia Misner have again done a wonderful job on this free e-book


You can the full details of the introduction here.



The book contains 10 chapters and 268 pages:

PART I   DATABASE ADMINISTRATION (by Ross Mistry)
1.   SQL…

Read more

0 comments, 1,457 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, 7,972 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 more

0 comments, 2,639 reads

Posted in The Database Hive for SQL Server DBAs on 18 March 2012