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: November 2010

Do the Packet Trace - Especially When Things Are Good

Last night we were troubleshooting really poor performance on a core system. One of the things being investigated was a network switch. On every interface of the network switch we were seeing flow control pause counters continually incrementing. This is usually an indication that the systems hooked to those interfaces… Read more

I Don't Worry about My Brand

And I guess the experts would say that I probably should. I know that the professional development presentations by Steve Jones (blog | twitter) and Andy Warren (blog | twitter) and the posts by Brent Ozar (blog | twitter) all say that I should.… Read more

5 comments, 1,588 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 November 2010

Free Training for the Week of November 22, 2010


Pragmatic Works - Building Calculations in SSAS 2008 - Brian Knight

PASS - PASS Summit 2010 Recap Round Table - Aaron Nelson


I'll be trying to catalog these as I find them, so if you know of training that I'm not covering, send me an email at kbriankelley… Read more

Part of the Election Review Committee...

... and I'm wary, but not weary. I'm not weary because I'm looking forward to trying to help. I'm not weary because there are some great folks on this committee. You can see the full list on Joe Webb's post about the ERC. So why am I wary?… Read more

Powershell: Calculating Seven Day Retention for Security Event Logs

I needed to figure out how much space was required to maintain 7 days of event log entries for the Security event log on my SQL Servers. Basically, this is a simple calculation where you check the size of the current event log, find the earliest event, and calculate how… Read more

0 comments, 1,800 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 17 November 2010

Can't Hit the Remote Registry through the Virtual Name

This is a problem we just solved, which was causing us to not be able to hit the remote registry via the virtual server name for a clustered SQL Server. You may wonder why that's important. Well, if you want to make sure you're monitoring the right server from remote,… Read more

0 comments, 1,830 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 16 November 2010

I Didn't Get Picked, but I Still Won...

and so did you, if you are a member of the SQL Server community. 

I had of the three abstracts in the DBA category selected to go up before a community vote for the PASS SQLRally Pre-Cons. I finished in 3rd place, behind Grant Fritchey and the PowerShell guys (Aaron… Read more

Successful Teams: Knowing When to Step Out of Your Role

I've talked about the fact that everyone needs to contribute for the success of the team and that everyone should have a well-defined backup who knows how to fulfill the tasks should someone be out or unavailable. But what if the unexpected happens? Do we stick by our roles? At… Read more

0 comments, 1,216 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 8 November 2010

Successful Teams: Capable Backups

No, not backups as in SQL Server backups, but who to tag when someone is out or so slammed with tasks that they could use a little help.

The Biggest Presentation of Our Careers

My second year in the US Air Force, my unit's commander was to give a full… Read more

1 comments, 1,866 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 5 November 2010

Slides and Example Code for SQL Lunch #42 - Auditing Database Permission in SQL Server

As promised, here are the slides and sample code from my SQL Lunch presentation today. Thanks for all who came out!

  Slides and Sample Code (zipped) Read more

Successful Teams: Everyone Performs

By day I'm a DBA. Nights and weekends I'm a junior high youth pastor and Awana commander. I have the pleasure of working with children and youth from 3 years old through senior high on a regularly basis, with most of my focus being on the 6th-8th graders at our… Read more

2 comments, 1,275 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 3 November 2010

Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server

Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation on SQL Server database auditing, so we postponed it. I apologize for anyone who didn't get the update about the postponment.

We've rescheduled my SQL Lunch session for this Thursday,… Read more