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

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

FileSystemHelper Update and Release

About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients.  As a result, I had created the CodePlex project FileSystemHelper.  I blogged about it back then and had meant to get back to it with a number of updates but that never really happened.  Along the … Continue reading FileSystemHelper Update and Release

Do You Protect Your Passwords?

Protect Your Password!As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password practices of others.  One of the most shocking things I’ve come to discover is how loose people are with their passwords.  At times, I am even included in this group. Over the past two years, I’ve … Continue reading Do You Protect Your Passwords?