Search results matching tags 'Speaking', 'PowerShell', and 'Service Broker'

SQLBits Presentation Materials

AllenMWhite — Sun, 09 Oct 2011 03:35:00 GMT

After a week of data recovery (see my blog post here) and travel via train with no internet access, I've finally been able to get my presentation materials together from the Training Day and two regular sessions I did at SQL Bits #9 in Liverpool last week. I've uploaded the materials here for the training day. If you were in the room that day you know the password to the file. (If you weren't, please don't ask. My income is partly derived from producing training material, and I don't ask you to work for me for free.)

You can download the material for my session on Gathering Performance Data with PowerShell here, and from my session on Service Broker here.

Thank you to everyone who came out to my sessions, and I look forward to hearing how you've made use of what you've learned!

Allen

Getting Excited: SQLBits is Coming

AllenMWhite — Mon, 19 Sep 2011 14:59:00 GMT

Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling there next week for SQLBits 9 - Query across the Mersey!

My wife and I will be spending a couple of days in London first, and since I'm a descendant of the Howard family from the Tudor period, I'm most interested in seeing the sites relevant to that time. I also want to spend as much time as I can at the British Museum, home of the Rosetta Stone and the Elgin Marbles.

During the SQLBits conference I'll be presenting a full Training Day session entitled Automate and Manage SQL Server with Powershell. I'll spend time introducing you to basics of PowerShell, so you don't need to know anything about it to start. I will be covering how to manage SQL Server with PowerShell using SMO (Server Management Objects), as well as going through the SQL Server provider and the cmdlets included with SQL Server 2008.

On Friday, September 30, I'll be delivering my session on Gather SQL Server Performance Data with PowerShell. The methods and scripts I'll show in this sessions are what I use at client sites to gather performance information to monitor their baseline performance and look for any anomalies.

Saturday, October 1, I'll present my session on Let Service Broker Help You Scale Your Application. I love how Service Broker can get information quickly and reliably to other servers, other databases, or even other tables within your current database asynchronously, so you don't have lock contention on highly active tables to worry about (as much). I've used it successfully in client implementations and this session will give you the basics on how to get started with Service Broker.

The SQLBits team has put together a great conference and I hope to see you all there!

Allen

[Speaking] Lots of Speaking Engagements in September and October

AllenMWhite — Mon, 22 Aug 2011 12:38:00 GMT

As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief list of what's coming up:

On Saturday, September 17 I'll be in Kalamazoo, Michigan for SQL Saturday #84, where I'll be presenting my Automate Policy-Based Management using PowerShell. The lineup of presenters for this event is amazing and I'll be looking to learn as much as I can from the other sessions that day.

The end of September takes me to Liverpool, UK where I'll be presenting at SQLBits 9. I'm thrilled to be a part of this great event, and excited to visit the UK for a short time. I'll be presenting a full day on Automate and Manage SQL Server with Powershell on Thursday, my Gather SQL Server Performance Data with PowerShell session on Friday and my Let Service Broker Help You Scale Your Application session on Saturday.

Saturday, October 8 brings me to Portland, Oregon, for SQL Saturday #92. They haven't published the schedule yet, but there'll be a LOT of great speakers there, and many of us are running in the Portland Marathon, Half Marathon and 10K on Sunday morning. I'll be running the full marathon, while most of the other people in the SQL Saturday group will be running the half marathon. Please come out and cheer us on. (Look on Twitter for the #sqlrun hashtag.)

The biggest SQL Server event in the world brings me to Seattle October 10-14, the 2011 PASS Summit. I'll be presenting two regular sessions this year, Automate Policy-Based Management using PowerShell and Let Service Broker Help You Scale Your Application, and one Lightning Session, So, You Want to Be a Consultant. I've attended every PASS Summit since 2003 and can't wait to see everyone there again this year.

As a side note, I'll be running the Poulsbo Marathon the Sunday after the Summit. I'm working on a goal of running a full marathon in all 50 states, and Portland and Poulsbo will allow me to cross off Oregon and Washington from my list. Wish me luck.

On October 29, I'll be in Louisville, Kentucky for SQL Saturday #87. Mala always does a great job with this event and I look forward to seeing everyone there. (They haven't published the schedule yet, so I don't know what sessions I'll be presenting there.)

Last, but certainly not least on my schedule, I'll be presenting a three-day course called Get to Know PowerShell: Analyzing and Managing SQL Server in Boston, Massachusetts for Data Education, November 14 - 16. I know of no other course that focuses specifically on using PowerShell to manage SQL Server, so sign up for this one as soon as you can. PowerShell is the tool effective administrators will use well into the future, and this course will bring you from zero to effective in three days. I look forward to seeing you there! (I also look forward to taking in a Bruins game while I'm there - they're playing the New Jersey Devils that Tuesday night!)

Well, that's everything I know of right now. I look forward to seeing you at one or more of these events.

Allen