+++ PASS Austria / SQL Server Community SPECIAL featuring Scott Klein +++
Query Tuning and Troubleshooting in Windows Azure SQL Database
Windows Azure SQL Database is a fully-managed, scalable service based on SQL Server technology. It is also a shared-environment service which means that you can’t and shouldn’t avoid best practices when it comes to query tuning. Microsoft has put mechanisms in place to ensure that your queries and processes don’t use up too many resources which could seriously impact performance of not only your database, but the database of other organizations as well. This demo-filled session will look at tools and options available to help identify poor performing queries, such as dynamic management views. This session will help identify problem queries and help you understand why a query is running slow through execution plans and other tools in the SQL Database Portal. Ultimately, you will be enabled to find and fix your poorly performing queries and do it all in the cloud.
presented by Scott Klein, Microsoft Technical Evangelist @ Microsoft Corporation, Redmond
Scott Klein is a Microsoft Technical Evangelist focusing on Windows Azure SQL Database and related data services. His entire career has been built around SQL Server. Prior to Microsoft he was a SQL Server MVP for several years, then followed that up by being one of the first four SQL Azure MVPs. Scott is the author of over a half-dozen books by both WROX and APress, including the recently released "Pro SQL Database for Windows Azure." He can be found talking about Microsoft's Cloud-ready data services at events large and small all across the world wherever he can get people to listen.
Zeit und Ort
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association dedicated to supporting, educating, and promoting the global Microsoft SQL Server community. PASS Austria is the local Austrian PASS Chapter formerly known as SQL Server User Group Austria.
PASS is run by and for the community, made up of database administrators and developers, application developers, Business Intelligence and IT professionals, executives, consultants, educators, instructors, students, vendors, and many others who work with or use Microsoft SQL Server and Business Intelligence technologies.