Database Administration Pamela Mooney in Database Administration DBA in training: Backups, SLAs, and restore strategies There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that... 09 November 2020 21 min read
Joshua Feierman High Availability and Disaster Recovery for Small Businesses Too often in the past , High Availability and Disaster Recovery have been marketed as expensive choices for businesses with deep pockets. The truth is... 16 December 2014 13 min read
Allen White Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into... 03 May 2013 15 min read
Warwick Rudd Expanding AlwaysOn Availability Groups with Replication Subscribers High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the secondary replicas will need to... 18 January 2013 8 min read
Gail Shaw The SQL Server Instance That Will not Start Everyone's SQL Server nightmare: The instance will not start. If such a problem strikes you, keep calm, follow Gail's advice, and you'll soon be back... 17 January 2013 29 min read
Grant Fritchey How to Get Information About Your Backups When you need to restore but aren't 100% sure about the contents of your backup files, what do you do? Head to the headers. Grant... 23 March 2012 18 min read
Grant Fritchey Backup Verification: Tips for Database Backup Testing A Backup system is merely part of a recovery system. If your backups can't be used to recover the database, then they're useless. Do you... 06 December 2011 4 min read
Grant Fritchey Faster Restores: Best Practices to Increase Speed Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at... 02 December 2011 5 min read
Laerte Junior PowerShell Eventing and SQL Server Restores When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time, serially. PowerShell is able to... 05 July 2011 13 min read
Hugo Shebbeare Disaster Recovery for SQL Server Databases High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If... 28 August 2009 27 min read
Dan McClain How to Get Management Buy-In for Software purchases There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs will often initiate a request,... 02 March 2009 15 min read
Allen White Automate your Database Integrity checks using SMO Allen White shows how to use Visual Basic to create simple routines that use SMO for inserting and deleting jobs from SQL Server Agent and... 15 September 2007 22 min read
Pop Rivett Pop Rivett and the Expanding Log Pop Rivett comes to the rescue when an expanding log file threatens the very existence of a young man's website...… 22 June 2007 8 min read
Allen White Automate your Database Maintenance using SMO The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups, database integrity checks and optimizations.... 05 April 2007 33 min read
Pop Rivett Pop Rivett and the Suspect Database When a 'torn page' error corrupts a SQL Server database, threatening the survival of some vital data and a mainly harmless colleague, our curmudgeonly hero... 08 January 2007 6 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No.4: Pop does Log Shipping Pop Rivett demostrates the fine art of log shipping in SQL Server.… 30 October 2006 8 min read
Pop Rivett Pop Rivett’s SQL Server FAQ No2: Pop Backs Up Pop leaps into action to safeguard a young girls's data...… 22 September 2006 5 min read
