SQL Server email trigger when table is updated

Sometimes you have very important tables that you need to be alerted if there are any changes made to the data.  You can setup a trigger that sends you an email whenever an insert/delete/update is done to any of the data.

Continue reading SQL Server email trigger when table is updated

Backing up your Sql Server Database

Good morning.  Today I am going to talk about the second most important task a DBA is responsible for….backups.  What is the most important?  That would be restores and will be next week’s topic.  If you cannot restore your database, you will be very sorry.  Seriously, if you cannot recover the data that your company needs, you may need to look new employment since your company might go out of business. Continue reading Backing up your Sql Server Database