SQL server security tips: part 1
Greg Robidoux, a Microsoft SQL Server expert who focuses on security, is chairman of the Professional Association for SQL Server DBA Special Interest Group (PASS DBA SIG). He is also a SearchDatabase.com expert and the founder of Edgewood Solutions, a Merrimack, N.H.-based database consultancy that focuses on Microsoft SQL Server.
Robidoux said he regularly sees security concerns pushed to the bottom of priority lists.
"Usually, there is a time crunch to get an application to production, and security is not even addressed," he said. "DBAs especially need to push ahead and say that security does need to be an important concern."
In an interview with SearchDatabase.com, Robidoux laid out 10 technical tips that can help any SQL Server administrator avoid security leaks. Here are five of them.
[ Read more ]