Archives: June 2009
Over the weekend I received the great news that I've been selected to present a new session, Gather SQL Server Performance Data with PowerShell, at the 2009 PASS Summit in Seattle.
Here's the abstract:
We all know how important it is to keep a baseline of performance metrics that allow… Read more
This is part 1 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the series informative. I will tell you a little about each transform and follow it up with a demo you can do on your own. Screenshots are included at my regular blog site… Read more
I didn’t attend, but wanted to get this written down somewhere!
I’m just catching up on email, Ken Starnes said all went well and estimated attendance at 120. Said he needed better signs to the event, that an early appraisal of speaker evals looked good, volunteers did well, had enough… Read more
I received my notification from the PASS Program Committee on Friday evening, and found out that I will not be speaking at the PASS summit this year. It’s a little disappointing but not entirely surprising; it’s only been in the past year or so that I’ve committed to speaking professionally,… Read more
There’s a contest going on at PASS looking for answers to “Best Thing I Learned at PASS”. I don’t want to enter since I’m going and I don’t need to free admission to PASS, the hotel, etc, but it is a great question to answer. VP of PASS,… Read more
Way back on May 19 I wrote about my search for a new laptop bag to replace my somewhat tattered Targus bag. I had a few good comments on the blog, even some comments on LinkedIn, and was interesting to have people ask about it when they saw me in… Read more
Michelle Ufford (aka SQLFool) is leading the first SQLSaturday in Iowa at the University of Iowa in Iowa City on October 10, 2009. It’s supported by volunteers from the I-380 Corridor Professional Association of SQL Server, and I can’t wait to see the speaker list! In her blog Michelle… Read more
I read, a lot. I’ve been a prolific reader all my adult life.
I use to split my reading between tech books and my regular relaxing reading but since I got into audio books several years ago I just pretty much read tech books now. Some times I’ll listen to… Read more
This past Tuesday, Brian Knight visited the St. Louis SQL Server User Group to present on SSIS. The day ended up being one of the best meetings our group has ever had with a record turnout of 65 in person and 21 online. We really appreciated the wonderful tips that… Read more
My first whitepaper for Microsoft, Understanding and Using PowerShell Support in SQL Server 2008 has been published. It was a great honor to have been selected to write the paper, and I thank Kalen Delaney for giving me the opportunity. I hope you find it useful.
We had my organization's semi-annual combined IT and financial meeting this morning. At the end of these meetings awards and certifications are announced. I had earned an award but I wasn't recognized. I'm a bit disappointed, and I can understand why, but I also know that I shouldn't be. Oversights… Read more
3 comments, 410 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 12 June 2009
Last week I wrote a set of Advanced SSIS Interview Questions. Here are the answers I came up for these. Of course you may have some variation of what I have and I would love to hear how you would answer these. Feel free to email me how you…
I study karate on a regular basis, and over the years I've practiced a number of different martial arts, most of them in fairly strict in the traditions and routines of student behavior. When I started this new school with me son, it was a lot less strict. That was… Read more
Patrick Leblanc is the event lead for SQLSaturday #17 coming up soon on August 1st. Patrick emailed me just a couple weeks ago to get things started, it had been in discussion for a while and turns out that it was early August or wait until after football season! Event… Read more
I picked up a copy of this from the local library after reading The Making of the Atomic Bomb. Oppenheimer (Oppie) was definitely one of the main characters in that event and came across as interesting, so I decided to seek out more info. American Promethius: The Triumph and… Read more
First Man: The Life of Neil A. Armstrong ($14 @ Amazon) was a good book, enjoyed reading it. Some interesting tidbits in it. He learned to fly before he was old enough to drive, was a test pilot at the same time as Chuck Yeager (and has a interesting story… Read more
I was tagged by Scary DBA and recent MVP awardee Grant Fritchey with the latest viral question:
“So You’re On A Deserted Island With WiFi and you’re still on the clock at work. Okay, so not a very good situational exercise here, but let’s roll with it; we’ll call it… Read more
Early last week, my church suffered a lightning strike that did quite a bit of damage (relatively speaking) to computer and media equipment. I spent a lot of time last week during off hours working the issue along with some other very knowledgable folks. We're not out of the woods yet,… Read more
2 comments, 456 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 June 2009
The point of this post is to cleary explain how the combination of the use of data definition language for your temporary tables and non-clustered indexes can improve the performance of stored procedures that much join data from many large tables by up to seventeen times - as I have seen on… Read more