SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2009

PASS Summit 2009 - PowerShell and Performance

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

0 comments, 308 reads

Posted in Allen White on 15 June 2009

Better Know A SSIS Transform – The Pivot Transform

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

0 comments, 1,554 reads

Posted in Devin Knight on 15 June 2009

Notes on SQLSaturday #12 in Portland

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

0 comments, 497 reads

Posted in SQLAndy on 15 June 2009

Update on PASS Selection

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

3 comments, 544 reads

Posted in Tim Mitchell on 15 June 2009

What I Learned at PASS

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

2 comments, 946 reads

Posted in The Voice of the DBA on 15 June 2009

Finding a New Laptop Bag – Progress!

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

7 comments, 657 reads

Posted in SQLAndy on 14 June 2009

SQLSaturday #19 Call for Speakers and Registration – East Iowa, October 10, 2009

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

0 comments, 707 reads

Posted in SQLAndy on 14 June 2009

What I’ve Read and Recommend to Others – SQL Server 2008 Part 1

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

7 comments, 1,024 reads

Posted in SQL Man of Mystery on 14 June 2009

Thanks, Brian!

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

0 comments, 500 reads

Posted in Advice from Aunt Kathi on 14 June 2009

PowerShell Whitepaper Published

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.


Share this post:

Read more

0 comments, 349 reads

Posted in Allen White on 13 June 2009

Give Me a Coconut and Six Months

Tim Benninghof tagged me with the 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 a virtual deserted island. Perhaps what I should simply ask…

Read more

0 comments, 405 reads

Posted in Chad Miller on 13 June 2009

Mentors and Perspective

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

Answers to Advanced SSIS Interview Questions


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…

Read more

10 comments, 46,657 reads

Posted in Devin Knight on 12 June 2009

Passive Influence

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

2 comments, 618 reads

Posted in The Voice of the DBA on 12 June 2009

Call for Speakers and Registration for SQLSaturday #17 in Baton Rouge on August 1, 2009

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

0 comments, 480 reads

Posted in SQLAndy on 11 June 2009

Book Review: American Promethius: The Triumph and Tragedy of Robert Oppenheimer

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

0 comments, 561 reads

Posted in SQLAndy on 11 June 2009

Book Review: First Man: The Life of Neil A. Armstrong

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

1 comments, 332 reads

Posted in SQLAndy on 11 June 2009

Tagged: The Desert Island Scenario

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

1 comments, 1,173 reads

Posted in Tim Mitchell on 11 June 2009

Planning for a Disaster

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

Why You'll Want to Create Your Temp Tables Before Populating them

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

0 comments, 987 reads

Posted in The Database Hive for SQL Server DBAs on 11 June 2009

Newer posts

Older posts