If you have ever used Oracle and needed to create a string padded with zero’s, they have a nifty function called LPAD which allows you to do this easily. In SQL Server we need to create our own way.
Tag: sql server
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
SQL Server find users connected to databases
If you need to find out who is currently connected to your databases or how many users are currently connected, the two scripts below are life savers.
Continue reading SQL Server find users connected to databases
Restoring your Sql Server Database
In a previous posting, we backed up your WideWorldImporters database and created a job to run transaction log backups so we can recover with no more than 30 minutes of data loss. Continue reading Restoring your Sql Server Database
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
Jim Salasek's SQL Server Blog 