Tag Archives: sql server

Recovery Models

In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases use the defaults, which mean that they are in the full recovery model. In that case, you need to be … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Recovery Models

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 , , , | Comments Off on Map a Login – Basic Skill #3

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 , , , | Comments Off on Create a Login – Basic Skill #3

Prepping for Certification

Having prepped for, taken, and then failed the MCM exam this year, perhaps I’m not the best person to give you advice for certification preparation. However the MCM is a hard test, I did better than I expected, and I … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Prepping for Certification