One of the things I’ve found is that so many people struggle to get started with SQL Server. There are regular questions about how to learn to work with SQL Server, so I built this quick talk that should help you get started.
This talk is built on the 80/20 rule, the idea that 80% of your job needs 20% of the DBA skills, and vice versa. So these are a series of skills, presented quickly, that should get you through most of the things that you need to deal with in SQL Server as an administrator.
Developers will find that spending a little time learning these skills will also let them easily setup a SQL Server instance that can maintain itself for the most part without them. And it will protect them in the event there are issues.
The talk moves quickly, but there are lots of links and references in the deck.
Slides
The slides are on my SkyDrive.
Length
This talk is built for 60-75 minutes
Related Blogs
These are the blog posts related to this talk:
Pingback: #2 Skill – Performing a Restore « Voice of the DBA
Pingback: When Do You Take a Full Backup? « Voice of the DBA
Pingback: Create a Log Backup Schedule – #1 Skill You Need « Voice of the DBA
Pingback: The Basic Security Model in SQL Server – Skill #3 « Voice of the DBA
Pingback: The Basics of Joins – Skill #4 « Voice of the DBA