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

Archives: May 2010

Yesterday's Vermont SQL Server User Group Presentation on Database Mirroring (Official PASS Chapter for Vermont)

To celebrate the Victoria Day Holiday in Canada I drove down to the U.S.A. with 'ol Volvo Wagon (not Smart this time, since 3k of maintenance awaits it today :) to present on Database Mirroring on SQL Server 2008.

Yesterdays’ meeting when well and I met some very interesting people at the Competitive Computing’s… Read more

2 comments, 615 reads

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

Two Speaking Engagements Coming Up: Next Monday in Burlington, Vermont & SQL Saturday #43 June 12th

Next Monday, I shall be driving the Smart down to Burlington, VT, again to visit Roman Rehak's Vermont SQL Server User Group and discuss Automatic Failover with Database Mirroring on SQL Server 2008.  We shall examine the prerequisites of Mirroring (port verification, service pack levels, optimisation, etc), the preference to… Read more

0 comments, 371 reads

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

Simple Production Script Auditing Best Practices: Including Query in the Result Set

 
To make it easier for others to audit the results of a script you have run on current production servers, I suggest two ways to best accomplish the debugging of the potentially problematic code. One would hope that such issues are dealt with already in a testing or development environment,… Read more

0 comments, 836 reads

Posted in The Database Hive for SQL Server DBAs on 11 May 2010