Tag Archives: TopTenSkills

The Basics of Joins – Skill #4

Posted on October 25, 2011 by

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

Posted on October 4, 2011 by

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

Posted on September 19, 2011 by

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

Posted on September 12, 2011 by

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

Posted on September 7, 2011 by

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

Posted on August 29, 2011 by

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

Posted on August 25, 2011 by

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?

Posted on August 15, 2011 by

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

Posted on August 9, 2011 by

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

Posted on August 6, 2011 by

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