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

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

SQLBits Presentation Materials

Getting Excited: SQLBits is Coming