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
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
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
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?”
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
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?
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
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
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
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
Strate SQL 