THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

SQL Rally Voting Open

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.


Published Wednesday, January 26, 2011 10:28 PM by AllenMWhite



Andy Warren said:

Nothing wrong with letting people know what you're doing! Nice post and good luck on the votes Allen:-)


January 27, 2011 10:16 AM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement