On 2/4/2017 I went to my third SQLSaturday hosted at Hyland Software in Westlake, OH. What is SQLSaturday? From their site: “SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.” http://www.sqlsaturday.com/
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