Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Archives: November 2009

Columbia Code Camp!

The Midlands of South Carolina will be hosting a Code Camp on January 30, 2009. You can register as an attendee, submit a session, or sign-up to volunteer here:

Columbia Code Camp 2010

The Code Camp is being run by the Columbia Enterprise Developers Guild, our .NET sister guild… Read more

More on DBAs and Local Administrator Rights

I'm looking over the comments about DBAs and local Administrator rights and I noticed an interesting trend: no one discussed the separation of duties aspect. Basically the comments that were returned either said, "DBAs should have that knowledge," or "You can't do the job without it because..." so let's took a… Read more

6 comments, 1,699 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 November 2009

Planning Out a Holiday Weekend

I've got a four day weekend thanks to the Thanksgiving holiday here in the United States. After reading Jazz in the Bittersweet Blues of Life, and reading of the kind of schedule Wynton Marsalis' father, Ellis kept in order to feed his family and teach the next generation of… Read more

Raising a Technology Savvy Daughter

I was introduced to electronics at a very young age. I think I was three when I first started doing the simple stuff with electronics. I started working with computers in 2nd or 3rd grade. I had an assortment of electronic toys like Speak and Spells and other things that… Read more

Should DBAs have local administrator rights?

This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on Twitter. He was discussing removing access from a local server admin to the SQL Server. My discussion was in regards to the fact that this isn't a successful preventative… Read more

31 comments, 6,781 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 20 November 2009

Why We Recommend Against xp_cmdshell

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for a reference as to the security risk of doing so. So let's look at what using xp_cmdshell means.

In SQL Server 2000 we used to have a recommendation to drop… Read more

19 comments, 8,783 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 November 2009

SQL Server Wish: Last Logon Information

The other day my wife and I were driving around and noticed that a Little Caesar's location had shown up near our house. The kids love their pizza and at the price, you can't beat it. So we decided after karate tonight that we'd pick up pizzas from there and… Read more

2 comments, 5,273 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 November 2009

Always Striving to Improve

I'm enjoying a relaxing Saturday morning and I'm doing a bit of reading on ESPN.  I see the article about Kobe reaching another scoring milestone and decide to give it a read. I'm admittedly a Lakers fan; I have been since I first watched Byron Scott knocking down outside shots. So… Read more

OFF-TOPIC: Surviving, Missing Folks, Glad I'm Home

I certainly wish circumstances were different and I would have been able to attend the PASS Summit this week. I miss being part of the active community and seeing old friends and meeting new ones, but I'm glad I was here at home. Being home means I've been able to… Read more