K. Brian Kelley - Databases, Infrastructure, and Security
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:
The Code Camp is being run by the Columbia Enterprise Developers Guild, our .NET sister guild… Read more
0 comments, 542 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 November 2009
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, 628 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
1 comments, 211 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 November 2009
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
2 comments, 111 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 November 2009
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, 2,449 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
18 comments, 2,235 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, 2,272 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
0 comments, 115 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 7 November 2009
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
0 comments, 121 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 6 November 2009



Subscribe to this blog