This site is dedicated to those who are serious about security - specifically, Microsoft SQL Server security. Whatever your feelings about Microsoft, the bottom line is that these servers are showing up everywhere and its time we learned how to properly secure them. At this site we do just that. We find problems, post solutions, and get the word out. If anyone tells you that security ends with the OS, they are dead wrong. Many times excellent network and host-based security has been bypassed exposing the very heart of the enterprise: all because of poor SQL Server configuration.   

"There is no 'patch' for stupidity."

Recent Blog Entries

  • Version 1.3 of sqlver released
    Thanks to Frank Brown for releasing his additions to the sqlver tool.   Frank has added SQL 2012 detection as well as a new registry GetEdition()  lookup (single instances only for now).  Check it out in the Downloads area.
    Posted Oct 15, 2013, 5:48 AM by Chip Andrews
  • Mobile SQL Server Management
    I've been using the Solarwinds Mobile Admin Client (and server) now for several months and I have to say it is very powerful for managing SQL Server (among other things) while on the run.  It works by installing a server component on your network and then enabling SSL so you can connect from your mobile app.  While the connection to the Mobile Admin server can be encrypted - there is no requirement for doing so be sure to set your config properly.
    Posted Jul 20, 2013, 6:03 PM by Chip Andrews
  • Another patch tool
    While not open source, if you need a simple tool to patch third-party applications on a Windows machine you may want to check out  They've done a good job of automatic a process that should have been automated a long time ago.  What is needed now is to have a similar application delivered as a system service that runs on all computers in a domain.  Microsoft Systems Center Configuration Manager is close but who has time to constantly create new deployment packages?  The folks at patchmypc have the right idea.  They maintain the package database - you just choose which applications you want to patch.
    Posted Mar 24, 2013, 8:06 AM by Chip Andrews
  • Reviewing a New Book on SQL Security
    I am in the process of reviewing a copy of "Microsoft SQL Server 2012 Security Cookbook" from PackT publishing.  I will be sure to post my review when completed but in the meantime if anyone is interested in an eBook version the publisher is offering 5 to anyone who posts a response to this blog entry with a reason "why you would like to get the book".  Hey - free stuff - why not?  Only the "Top 5" comments will win and those will be the only ones given to the publisher for prize distribution.  I will leave this open for comments until 11/15/12. UPDATE: I've closed the contest and sent the top 5 reasons to the publishers.  The winners should receive their free copies at any time.
    Posted Nov 17, 2012, 5:30 AM by Chip Andrews
Showing posts 1 - 4 of 13. View more »

In The News