K. Brian Kelley - Databases, Infrastructure, and Security
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
0 comments, 221 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 November 2010
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, 543 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 November 2010
Free Training for the Week of November 22, 2010
Tuesday
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
0 comments, 129 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 November 2010
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
0 comments, 265 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 18 November 2010
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, 564 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, 517 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 16 November 2010
Free SQL Server Training for the Week of November 15, 2010
Tuesday
SQL Lunch - Get a Lever and Pick Any Turtle: Lifting with Metadata - Cade Roux
Pragmatic Works - SSIS Dataflow - Designing for Performance - Jamie Thomson
Wednesday
Idera - Delivering Information with Reporting Services - Stacia Misner
Thursday
1 comments, 197 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 12 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
0 comments, 111 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 November 2010
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, 335 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, 623 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 5 November 2010
Free SQL Server Training for the Week of November 8, 2010
Tuesday
PASS - Day One Opening Keynote (Ted Kummert) Live Stream
Wednesday
PASS - Day Two Keynote (Quentin Clark) Live Stream
PASS - Women in Technology Luncheon Live Stream
SSWUG - Operational Excellence for DBAs, Part 1: Setup and Configuration
Thursday
1 comments, 138 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!
1 comments, 126 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 4 November 2010
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, 459 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
0 comments, 136 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 1 November 2010



Subscribe to this blog