All Posts by Ginger Keys

About the Author

Aug 09

AlwaysOn – Create a Basic Availability Group

By Ginger Keys | Always On , SQL 2016 , SQL 2017 , SQL Administration , SQL Server

AlwaysOn Basic Availability Groups (BAGs) are available with SQL Server 2016 and 2017 Standard edition.  The functionality is generally the same as database mirroring (which has been deprecated).  This feature replicates transactions to a database on a secondary server, and is useful for disaster recovery should something happen to the primary server. If you have […]

Continue reading
Feb 08

Notification for Restored Database

By Ginger Keys | Backup and Restore , Database Mail , SQL Administration , SQL Server

According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded (ahem…), or sometimes an organization simply does not have the financial resources to spin up separate servers for testing or development. Whatever […]

Continue reading
1 2 3 4
>