TTSSUG Event Review: SQL Server Security Best Practices

Last week Tuesday I presented at the TTSSUG September meeting which was a part of the Microsoft Tech Week! The session had less than twenty people but they were very lively and this led to various discussions. This contributed to a fun and very interactive session.

As I highlighted in the meeting the information that I was presenting was not best practices that I created but was information provided by Microsoft and some well-known MVPs. Most of the information on the slides was copied from the SQL Server 2008 R2 Security Best Practices white paper written by Bob Beauchemin. The information that I shared while presenting came from reading Denny Cherry's book (Securing SQL Server: Protecting Your Database from Attackers) as well as some other blogs and articles. Thanks Bob (Blog|Twitter) and Denny (Blogs|Twitter) . The slide information is available here!

My main focus was SQL Server 2008 but I mentioned what is available in 2005 and 2008 R2 as well. Due to time, I was unable to highlight all of the best practices so I decided to discuss the basic ones that are immediately useful to administrators and developers. Security is a big topic that continues to grow so you have to keep reading and upgrading your methods of security as needed to ensure that your instances and servers are being secured properly.

Thanks to all the TTSSUG members and newcomers for taking the time to attend this event and special thanks to Microsoft Trinidad and Tobago for giving us a spot at their Tech Week! We hope to see you at our next event in November: SQL Saturday #102.


Community Links