Security Questions: Server Role Tips

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: Server Role Tips

Security Questions: Logins, Credentials, and Proxies

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: Logins, Credentials, and Proxies

Security Questions: Logins Not In Use

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: Logins Not In Use

Security Questions: Prioritizing Security

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: Prioritizing Security

Security Questions: Migrate Logins Between Servers

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: Migrate Logins Between Servers

Security Questions: SQL Agent Permissions

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: SQL Agent Permissions

June 2013 – Monthly SQL Server Checklist

Today is the second Monday of June and guess what I didn't publish last week? That’s right, there wasn't an update and reminder to the SQL Server Monthly checklist. Not a big deal, of course, I was at TechEd with about 10,000 other people, talking about indexing SQL Server. Fortunately, for me, waiting a week … Continue reading June 2013 – Monthly SQL Server Checklist

Looking to SQL Server 2014 High Availability In Standard Edition

During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014.  As part of this announcement, AlwaysOn Availability Groups will now support up to 8 readable secondaries, and include a number of improvements that will improve stability.  While it hasn't been announced yet, it is probably safe to assume … Continue reading Looking to SQL Server 2014 High Availability In Standard Edition

Security Questions: TRUNCATE TABLE Permissions

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: TRUNCATE TABLE Permissions