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

Archives: October 2010

Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)

Below is a longer version of the equivalent Technet Article  under Security TechCenter > Learn > Security Columns > MVP Articles >  Database Security Best Practices

The security of corporate databases and related aspects have become increasingly important as enterprises consider the data they store, purchase, or acquire as…

Read more

2 comments, 3,260 reads

Posted in The Database Hive for SQL Server DBAs on 31 October 2010

Notes from MySQL Enterprise Lunch and Learn With Representatives from Sun & Oracle (MySQL 5.5 Now Downloadable)

 

Today we sat through a pizza ‘n pop lunch while listening to a MySQL Offering and Licensing for the company I have been working for as a permanent for about a year now. Since the take-over by Oracle, the joke was that speculators were thinking that the new version… Read more

0 comments, 1,069 reads

Posted in The Database Hive for SQL Server DBAs on 27 October 2010

Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script

 

After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as High Safety with automatic failover, meaning synchronous commit on both servers (see operating modes), there was an obvious question that followed from those who need to employ this redundant database – which/what… Read more

2 comments, 3,319 reads

Posted in The Database Hive for SQL Server DBAs on 6 October 2010