T-SQL Tuesday #14: Resolutions
January 10th, 20111
T-SQL Tuesday #14: Resolutions
January 10th, 20111

T-SQL Tuesday #14 : ResolutionsThis month, T-SQL Tuesday's topic is Resolutions. I already gave a rough sort of overview on my goals for 2011, but I thought I would be able to dig a little deeper with enough relevance to participate.

With that in mind, and with a goal of not setting the bar too high, here are a few of the resolutions I hope to achieve in 2011:

To become better at PowerShell

Not just because all the cool kids are doing it, but because I truly see the value in automation and scripting. I am currently working on an intensive project which involves running workloads, gathering performance counters, measuring wait stats, and bulk loading all of the output into a database for analysis… previously I was using a hodge-podge of PowerShell, LogMan, VBScript, and SQL Server Agent, and I am begrudgingly consolidating everything to PowerShell. I like the results, but I am not all that comfortable with the learning curve. And I am finding some frustrating things missing along the way. For example, Export-CSV can only export to a new file – they forgot to support append. There are workarounds, sure, and the bug is closed as fixed (albeit, with no comment, so I'm not sure exactly what that means). Still, even if we get an enhanced Export-CSV function in PowerShell 2.5 or 3.0, this seems like core functionality that should have been there from the beginning.

To have faith in Connect again

{ Removed content because, well, Connect died anyway. }

To practice my presentations more

Brent Ozar had a great post today, entitled "How to Rehearse a Presentation." He has some great thoughts in there, and while – with all due respect – there's nothing truly rocket science about it, it is very useful to see it all in one cohesive place like that: it makes it very easy to identify which steps I'm currently NOT performing when preparing for speaking events. The point that best hit home for me was to consider each audience member's time at an hourly rate, and that anything less than stellar is a disservice to them. I have several engagements on tap in 2011, and I'm going to strive to make each presentation better than the last – and not to treat them like my own personal Toastmasters meetings. In a conversation today I identified some of the key points I need to work on to improve my presentation skills, and that's as good a start as any.

By: Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

1 Response

  1. Arthur says:

    To help you delivering good presentations please visit http://www.hanselman.com/blog/content/radiostories/2003/01/22/scottHanselmansTipsForASuccessfulMsftPresentation.html by Scott Hanselman which is a nice, short post on how to prepare with useful links to some free software to use in presentations. Personally, when I used ZoomIn it astonished people. Have a good year 2011!