Duplicate data in your database? I will show you two ways on how to delete duplicate data in your Sql Server database. How does it get there? The ways are limitless, but you more than likely do not have an adequate unique index or unique constraint setup for your table.
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
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