Creating a Disaster Recovery Plan for your database (SQL)

Idera

 

Idera recently had a fantastic webinar that went over the creation of a disaster recovery plan concerning your databases.  This should be a high critical piece of work usually done by DBAs within a company.  Let’s go over a simple set of plans that depending on the type of company you are dealing with, can be done either large or small.

  1. Backups.  All backups should be done with incremental or full backups of your database.  There should be a protected network folder that contains the incremental in one and the full backups (usually done once a week) in a separate folder.  An incremental is a backup that contains only a snapshot of transactions that are done during a day while a full backup contains the entire database.
  2. Data model.  A data model provides a visual as well as a detailed layout of each database / table that provides a method for someone to read and understand how the data is stored.  It can be noted as a roadmap that contains the relationships between the tables within the database as well as the keys / indexes that work with the tables.
  3. User security profiles.  Each DBA should have a listing of the usernames / passwords in a safe area.  In the event a fellow member leaves but they had the password on a specific database you now possibly have the way in.  There are numerous companies that tend to not have that and during the exit interviews it becomes lost.
  4. Contact listing of people.  The contact list contains the individuals that have to be notified if a database is corrupted and has to be repaired or restored from the backups.  You can set the priority of each person as well.
  5. Checklist. By having a checklist of what to do in the event of a DRP it will keep you focus on getting everything back up and running.  One missed step could push you back thus delaying the recovery.
  6. Backup life cycles.  Each company is different and whether the backups are taken off site for now long and when are they removed / erased.  You have to plan this out and the usually lifecycle is between 3 months to a year.

These are only minor steps but at least they do enforce a DRP that any DBA needs to have in place prior to the disaster happening.

 

Idera and Embarcadero separate target businesses

 

Idera and Embarcadero have officially separated their businesses for software development Rad Studio that contains Delphi / C++ Builder and the Idera database tools.  This is a fantastic step in going forward and bringing both web sites with a fresh look on the future.

Embarcadero will continue to enhance the Rad Studio product that comprises of Delphi / C++ Builder plus the various tool kits that would enhance the product line. Seattle is the latest version that provides the software developer to build applications for Windows, databases, mobile devices and much more.

embarcadero-idera-separate

The Ultimate Application Development Platform for Windows 10, Mac, Mobile and IoT.

  • Rapid Development
  • Rich UI/UX
  • Measure User Activity
  • Build for Enterprise
  • Internet of Things
  • Embed Data Everywhere

Idera-embarcadero

Idera will be selling the various database tools on their own web site along with ER Studio making the company and product line stronger then before.  Listed below are the features for each product in the Powerstudio.

DBArtisan

Perform Multi-platform Database Administration

  • Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI
  • Proactively manage space, data and performance with built-in analytics
  • Easily find and fix performance issues using intelligent diagnostics
  • Move schema and table data across different platforms with ease
  • Protect data security with view, grant and revoke of permissions

DB Change Manager

Automate and Manage Complex Database Schema Changes

  • Quickly roll out and reconcile database changes
  • Reveal, track, and report on database changes
  • Comply with database audit and reporting requirements
  • Protect data privacy within the database environment
  • Track changes from multiple major database platforms

DB Optimizer

Automate SQL Tuning and Profiling

  • Streamline tuning of SQL code on major DBMSs from one interface
  • Tune SQL like a pro with automated performance optimization suggestions
  • Tackle complex SQL queries with visual SQL tuning diagrams
  • Pinpoint problem SQL with database profiling of wait-time analysis
  • Load test alternative SQL queries in simulated production environment

Rapid SQL

Develop SQL Code More Efficiently

  • Create high-performing SQL code on major DBMSs from one interface
  • Easily build complex SQL statements with visual query builder
  • Quickly construct, analyze and execute SQL code with code analyst
  • Simplify debugging SQL code, functions, and stored procedures
  • Collaborate effectively across development teams with version control

Microsoft SQL Server 2016 is coming to Linux will provide the ability for users to have the features and additional security.

Microsoft SQL Server 2016Click the image for more information about SQL Server

Microsoft will be releasing a version of their SQL Server 2016 for Linux which is a major step in the world domination plan.  With about 35 percent of the web servers in the world using Linux as their operating system this will open new revenue streams for Microsoft.

As you can see from the grid below the percentages of SQL Servers within companies.  The area where MySQL rules is on the web server which puts both at about 35 percent each on market share.  If Microsoft begins the move towards Linux the development tools will be released shortly.  What this means for a small company using a web server, they now have an option to use the Linux OS but with a robust SQL Server that also contains high end security and has better performance with tasks while MySQL is a low end database manager.

One of the most important things to secure a database is to use a mature data abstraction layer that exists as close to the data as possible.  MySQL is disqualified because it runs best when you minimize your abstraction layers to all but the most simple tasks.  SQL Server abstraction layers are just fine to write.  It is by far more mature than MySQL, but remember that MySQL is cheaper for web hosting firms and always include it with their packages.

If Microsoft does increase their market share within a web hosting firm that will provide additional revenue as well as allowing mobile devices designed with Visual Studio to gain access almost anywhere.  The design and development of database software will be better off due to the fact that a complete database can be migrated from a Windows Platform to a Linux Platform, now that would be pretty awesome.

Percentage