Subscribe to this blog
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…
2 comments, 2,470 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, 746 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, 1,914 reads
Posted in The Database Hive for SQL Server DBAs on 6 October 2010