SQL Clone
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: January 2013

Consider All the Possibilities When Troubleshooting

When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's time to expand to the unlikely ones. This is true even if the evidence would seem to rule out a possibility or if what you have for facts seem to… Read more

1 comments, 1,431 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 January 2013

Cash Over Credit

What does cash over credit have to deal with security? An awful lot, as it turns out.

Personal Story: Mere days after my family and I enjoyed a meal from this eating institution, I learn that there has been a potential data breach.

Let's assume the organization… Read more

Rename the SQL Server Management Studio shortcut

Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have the same name. If you're like most of us, you're working with multiple versions of SQL Server and have to have multiple versions of the tools installed… Read more

1 comments, 7,411 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 January 2013

Observe Carefully When Things Are Running Fine

Cross-posted from The Goal Keeping DBA blog:

As a worker in information technology, I’ve always been a big proponent of studying systems when they are working. I’ve also said that doing so helps me immensely when troubleshooting. However, I’ve never studied why that’s true. There’s a scientific explanation… Read more

2 comments, 1,970 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 January 2013

Speaking at Midlands PASS in February

On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia, SC.


Register here to attend (so we know how much food to bring)


I'm dropping SQL Server 2000 from my presentations as it's end of life. We'll… Read more

Re-Awarded as a Microsoft MVP

Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server. I enjoy participating in our great community and recognition as an MVP is a bonus.

As others have indicated, obtaining an MVP award is based on subjective criteria not made… Read more

Looking Forward to the New Year - Professional Goals

Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days. Let me challenge you not to do that. Most of the time when folks make resolutions, they are simple, wishful statements that are effectively meaningless. For instance, "I want to… Read more