Tag Archives: TopTenSkills

The Basics of Joins – Skill #4

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. Databases are built to store data. That’s the primary purpose, and in SQL Server, we … Continue reading

Posted in Blog | Tagged , ,

Basic Inner Joins – Basic Skill #4

This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server. This post is part of Skill #4 – Joins. This post is also serving as my T-SQL Tuesday post for … Continue reading

Posted in Blog | Tagged , , ,

Map a Login – Basic Skill #3

This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server. This post is part of Skill #3 – Setup Security. I wrote about the basic security model for SQL Server, … Continue reading

Posted in Blog | Tagged , , ,

Create a Login – Basic Skill #3

This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server. This post is part of Skill #3 – Setup Security. I wrote about the basic security model for SQL Server, … Continue reading

Posted in Blog | Tagged , , ,

The 80/20 Rule – Top Ten SQL Server Skills

Over the years that I’ve worked in technology, I’ve found that the 80/20 rule seems to apply pretty well to all the different areas that one can specialize in. It doesn’t matter whether you build PCs, work on the help … Continue reading

Posted in Blog | Tagged , , | 2 Comments

The Basic Security Model in SQL Server – Skill #3

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. Users and Objects The basic security model diagram that I use is the one below. … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Create a Log Backup Schedule – #1 Skill You Need

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. You Need Log Backups By default databases in SQL Server are created with the Full … Continue reading

Posted in Blog | Tagged , , , , ,

When Do You Take a Full Backup?

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. When is a Full Backup Taken? Most people might answer this with “every day”, or … Continue reading

Posted in Blog | Tagged , , , , , | 1 Comment

#2 Skill – Performing a Restore

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. You Will Restore a Database At some point you’ll need to restore a database. It … Continue reading

Posted in Blog | Tagged , , , , | 1 Comment

The Top Ten Skills You Need for SQL Server

This talk is designed to talk about the most common skills that you need to work with SQL Server on a daily basis. It is mostly for administrators, but quite a bit of this information would benefit developers if they … Continue reading

Posted in Blog | Tagged , | 1 Comment