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

Archives: April 2010

Two Ways to Get System and Server Information on SQL Server from Management Studio / Enterprise Manager

 

To collect information for your SQL Server Infrastructure, there are two ways I can recommend. 
The first, as mentioned from Technet recently, is to execute the following parameter details on any SQL Server installation (I tested back to 2000), by run the following command.

exec xp_msver "ProductName", "ProductVersion", "Language", "Platform", "WindowsVersion",… Read more

2 comments, 1,712 reads

Posted in The Database Hive for SQL Server DBAs on 30 April 2010

Need Data from a Mac: TransMac for Reading HFS Volumes a Lifesaver

 

Recently I was handed over a HFS volume to read from my colleague who uses his Macbook exclusively.  We had tried passing data through Bluetooth, but gave up due to some formatting that I hadn’t done yet on my 8GB MicroSD card on the CrackBerry.

So he handed… Read more

0 comments, 419 reads

Posted in The Database Hive for SQL Server DBAs on 25 April 2010

Free E-Book on SQL Server 2008 R2

 

Free E-Book on SQL Server 2008 R2

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

http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx


You can download the full ebook in XPS format here and in PDF format here.

 

 

The book contains 10 chapters and… Read more

6 comments, 1,507 reads

Posted in The Database Hive for SQL Server DBAs on 21 April 2010

Attending Microsoft Most Valuable Professional Open Day from Montreal

 

Currently, MVPs from across the country are attending an all day event.

 

We are discussing Azure, Windows Live, Office 2010, Windows Mobile, Hardware, Security and Xbox.

 

It is great to hang with all the local peers and get a heads up from our Canadian MVP Lead Simran… Read more

0 comments, 266 reads

Posted in The Database Hive for SQL Server DBAs on 21 April 2010

Latest Simple-Talk.com Article Published on Deployment Management - to be Front Page Starting Monday

After several months of reflection/rewrites with colleagues (because orignally I forgot the Rollback plan - oops), and reworking the bilingual templates, the great editors at Simple-Talk.com have pushed the latest work to the front page starting this Monday April, 19th:

 Deployment Management is Worth IT: These Templates Should Make… Read more

1 comments, 361 reads

Posted in The Database Hive for SQL Server DBAs on 17 April 2010