Tomorrow Richard and I will do Session DAT 417- The Query Governor: SQL CLR in Action. Have you ever wanted to stop a user from running a query BEFORE they ran the query based on certain conditions? Conditions like the state of the server, the user’s role, or the cost of the query? That is what we will show you tomorrow, using XML Showplan, XQuery, TSQL, the CLR inside of SQL Server 2005, and the new EXECUTE AS keyword. We’re on at 2:45 on Tuesday. See you then. Bring your slow queries.
You can call it from a client (below) or all in T-SQL, your choice.
DAT417 The Query Governor: SQL CLR in Action
Day/Time: Tuesday, June 13 2:45 PM - 4:00 PM Room: 151 AB
Speaker(s): Richard Campbell, Stephen Forte
See how .NET takes SQL Server 2005 to a whole new level! In this session, learn how to build a query governor, a set of tools for evaluating whether or not a query should be run. Most query governors are simple limiters, automatically cancelling queries when they run too long or aborting queries with too high of a cost. Using the CLR, this governor evaluates not only the cost of the query using the XML based query plan, but also the state of the server using Windows Management Instrumentation (WMI). Along with information about the user executing the query, see how you can dynamically assess the state of the server and cancel a query before it runs. This would not be possible without .NET being integrated into SQL Server-see how you can use this technology in your projects!
Track(s): Database Development and Administration Session Type(s): Breakout Session Session Level(s): 400