Subscribe to this blog
K. Brian Kelley - Databases, Infrastructure, and Security
Archives: January 2012
New article: Identifying What Runs at Startup on SQL Server
Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when SQL Server starts up as well as what jobs are set to run when SQL Server Agent comes online. An attacker could use both of these places to embed code to regain… Read more
0 comments, 374 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 January 2012
You require WHAT for a license?
I was trying to acquire a license for a product I was trying to look at using a free program. Now, because the organization is providing the license for free, I expect some strings to be attached. Want me email? Yup, how else would you send me the license? You… Read more
3 comments, 428 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 January 2012
About those backups...
So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information on my slides. This included the web site I have (had) as my brochure site: truthsolutions.com (it's not up, so no link). I hadn't checked it in a while because… Read more
0 comments, 1,053 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 January 2012
Clicking on Links in Email
Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know the sender or aren't 100% positive that the sender intended to send the email. Yet, despite this general warning, we all typically do it. For instance, if you're on Twitter and… Read more
0 comments, 495 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 January 2012
New Article: How to audit sysadmin members on multiple servers using PowerShell
My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit for a server role across multiple SQL Servers. It is assumed you have appropriate rights on those servers. You can read the article here:
0 comments, 665 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 January 2012
Speaking at Charleston PASS on January 19th
I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at the Charleston PASS website. I'm looking forward to it.
Both my wife and I graduated from colleges in Charleston. I'm a graduate of The Citadel and my wife graduated… Read more
0 comments, 354 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 4 January 2012
Renewed as MVP for SQL Server
I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the award each time, as many other MVPs have expressed. If you're wondering how to become an MVP, then Paul Randal's post (blog | twitter) from 2009 is probably the… Read more
5 comments, 649 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 2 January 2012