K. Brian Kelley - Databases, Infrastructure, and Security
Archives: August 2012
An important query to remember
This is based on a post with respect to where our focus and efforts should be that I wrote at my Goal Keeping DBA blog:
SELECT Task, Priority, DueDate FROM [What_Is_Important] AS I INNER JOIN [What_I_Can_Control] AS C ON I.TaskID = C.TaskID ORDER BY DueDate, Priority, Task;
0 comments, 833 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 August 2012
Don't Disconnect Your Common Sense
This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker, whom I will call Marcus, to protect the guilty (he's not). Marcus in an IT director for a medical services provider. About two weeks ago the vendor of the… Read more
0 comments, 864 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 August 2012
Delaying AV Definitions?
Auto-deploying AV definitions has become common place throughout the industry. However, this post from the SANS Internet Storm Center raises the question about whether we should stagger deployments, much as we should be doing with security patches. This is a hard call.
AV updates can happen a lot, depending on how… Read more
0 comments, 679 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 21 August 2012
Resources for Those Dealing with Security Patches
It's been a while since I was in the day-to-day business of security patches. However, I still keep up with vulnerabilities and fixes as I expect every Microsoft SQL Server DBA should. Here are some resources I recommend to do the job right:
- Secunia Advisories - You'll need to…
0 comments, 1,579 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 21 August 2012
Rant: Applying Common Sense in IT
I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this in a non-production environment before you make a change in production."
In fact, he repeated it several times. In a recent article I wrote, I included the following warning:
The… Read more
17 comments, 3,329 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 17 August 2012
PowerShell Saturday in Charlotte, NC
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September 15, 2012. You can find out more information and register at:
PowerShell Saturday 002 Charlotte, NC
There looks to be a great set of speakers from infrastructure folks… Read more
0 comments, 613 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 15 August 2012
Speaking Tomorrow for Professional Development VC
As I blogged about previously, tomorrow (Wednesday) I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my career, how I got to where I am, and how I have developed the views I've developed with respect to the job, building yourself up in… Read more
0 comments, 570 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 14 August 2012
Audit Yourself Regularly
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried that we were going to get hit with more taxes than we had planned for. Okay, that's really not a correct statement. The problem is we hadn't adequately planned at… Read more
0 comments, 998 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 August 2012
Speaking for PASS Professional Development Virtual Chapter
This coming Wednesday I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my career, how I got to where I am, and how I have developed the views I've developed with respect to the job, building yourself up in the profession, etc.… Read more
1 comments, 905 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 August 2012
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current guidelines were for strong passwords. They vary, based on the capabilities of the system. A lot of the guidance nowadays is on passphrases modified in some manner, usually with a… Read more
3 comments, 1,081 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 August 2012
Learn to Use Books Online
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer careers is, "What tools/books do you recommend?" I've noticed my first answer catches quite a few folks off guard:
"Learn to use Books Online."
To the old hat SQL Server… Read more
0 comments, 746 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 6 August 2012



Subscribe to this blog