#ADD EXCEL DATA TO SQLPRO PLUS#
#ADD EXCEL DATA TO SQLPRO FREE#

Some companies consider backups or even Replication as a DR mechanism. Also, an important part of this is understanding your different DR options. Are you prepared? If not, stop reading and go get prepared before you go on to #3. Even if you have everything maintained and backed up, you could lose your server. On the flip side, you have to make sure you have some sort of Disaster Recovery setup.After that night, maintenance was a priority and I have not had this problem since. I never want to experience that again and I doubt anyone wants to. Let’s just say we finished getting things in order around 8pm which is just before sunset (Google the fasting thing). I received a call from my manager who was concerned about a Database server acting up. Keep in mind, I leave my house a little after 6am to get to work by 7am and I was fasting for Ramadan (you can Google that it’s too much to explain here). I recall around this time last year getting home around 4pm. One of the things I really enjoy about work is 3pm that’s when I get to go home! What makes it possible is having your servers up and running the way they should be.

Be proactive with Maintenance and Disaster Recovery Plus, if you get a new employee that keeps bothering you about names, just send them this document and even get them to contribute. You’ll look really smart in all your geeky gatherings at work. This document will pay for itself when you use it because you will start to remember which servers have what on them and what they are used for.Put any Aliases in parenthesis so you know what other names the servers go by. Now write down your different servers from Production, Staging, and Development.No excuses! If you can’t pay for excel use Open Office or Google Docs. First step is to create an excel file like the one in the screen shot below. Know your servers, what they do, what applications they support, and their names in Production/Staging/Development.

#ADD EXCEL DATA TO SQLPRO FREE#

Although I come from the Microsoft SQL Server world, I believe most of these traits or skills can be adapted cross-platform.įeel free to add your feedback in the comments section, this is after all just my own opinion.ġ. So anyway, these are the eight habits/skills of Highly effective Database Administrators in my humble opinion.

#ADD EXCEL DATA TO SQLPRO PLUS#

The whole “7 Habits” title is so cliché so I decided to make it eight! Plus that will probably relieve me from any copyright violations as well.

Add excel data to sqlpro