Security Questions: Accessing SQL Server Securables

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Accessing SQL Server Securables

Security Questions: Authentication Performance

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Authentication Performance

Security Questions: Difference between sysadmin and CONTROL SERVER Permission

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Difference between sysadmin and CONTROL SERVER Permission

Security Questions: Differences between “Grant” and “With Grant?”

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Differences between “Grant” and “With Grant?”

Security Questions: Grant Permissions to All Stored Procedures

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: Grant Permissions to All Stored Procedures

Security Questions: What permissions are required to create temporary tables?

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer.  Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic.  Hopefully, this will … Continue reading Security Questions: What permissions are required to create temporary tables?

SQL Server Security Webcast Questions – Series Introduction

Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work's Training on the T's.  A video of the session is available at the Pragmatic Works website.  As a part of that session, I received a couple dozen questions about security that we didn't have a chance to go over during … Continue reading SQL Server Security Webcast Questions – Series Introduction

May 2013 – Monthly SQL Server Checklist

It's the start of the month of May, or at least the first Monday in May.  Hopefully you aren't nursing too much pain from a weekend that included two fairly dissimilar holidays.  First, there was Star Wars Day on Saturday.  Followed by Cinco de Mayo on Sunday.  There should have been something in there for … Continue reading May 2013 – Monthly SQL Server Checklist

Restoring Azure SQL Database to a Local Server

In last week's post, I talked about the steps required to backup a Azure SQL Database.  That post leaves us asking what's the use of having a backup of a database, if you aren't going to restore it somewhere.  And more importantly, if you can't restore a database, or don't know how, then the backup … Continue reading Restoring Azure SQL Database to a Local Server

Backing Up Azure SQL Database to the Cloud

When I first started working with Azure SQL Databases, I wasn't sure what it would take to backup a database.  In fact, I wasn't even sure if this concept was appropriate when it came to databases hosted in "the cloud".  What I found was that the concept of backing up databases in the Azure cloud … Continue reading Backing Up Azure SQL Database to the Cloud