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
