The voting for sessions for SQL Rally has
been going on for a couple of weeks now. This week the Enterprise Database Administration & Deployment
sessions are up for voting.
I didn't go into politics because I don't feel comfortable telling people that they should vote for me
but this is how the sessions are being decided for this conference, so here goes.
I've submitted two abstracts, both grouped in the Summit Spotlight section. The first is a new session
based on what I learned implementing my first Service Broker implementation at a client site. We struggled
to get the kinks worked out, but the result was that the client's web application synchronizes with their
internal application in seconds rather than the hour round-trip it had taken before.
Let Service Broker Help You Scale Your Application
Service Broker was introduced in SQL Server 2005 to provide asynchronous messaging in
your database applications, but it's seldom used because it isn't well understood. In this
session we'll walk you through the basics of Service Broker and show how you can use
it to build highly scalable applications.
The second session I submitted is one I first did at SQL Connections in Las Vegas last November. Policy
Based Management is a great tool, but using the Object Explorer in Management Studio to create all the policies
on each of your servers can be tedious. I figured out how to build the policies in SMO using PowerShell, and
will walk you through that process.
Automate Policy-Based Management using PowerShell
The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure
your systems are configured consistently and correctly, but it can be tedious to implement
on each server in your environment. PowerShell scripts allow you to automate the implementation
of your policies so you can focus on more important problems. This session will walk you
through how PBM works, how to define your policies in PowerShell, and how to set up Agent
jobs to evaluate those policies regularly to let you know when you need to take action.
You can browse through all the submitted sessions
here.
I hope you take the time to vote on the sessions you find most interesting, and I hope to see you at SQL Rally
in Orlando in May.
Allen