Query Tuning for Windows Azure SQL Database & Stupid Azure Tricks

[Note: NERD has instituted a new policy requiring all community visitors sign a waiver as they enter the facility. The text of this can be found here: https://www.meetup.com/bostonazure/pages/NERD_Waiver/ ]

AGENDA

6:00-6:25 - Gather, have some pizza, grab a cold drink, socialize
6:25-6:30 - Call to order, grab a seat
6:30-7:00 - Stupid Azure Tricks (Bill Wilder)
7:00-8:15 - Query Tuning for Windows Azure SQL Database (Grant Fritchey)
8:15-8:30 - Giveaways, announcements8:30-?:00 - Grab a cold beverage near

DETAILS

The featured speaker (and Scary DBA (http://www.scarydba.com/)!) is SQL Server MVP Grant Fritchey (@gfritchey (https://twitter.com/gfritchey)) from Red Gate Software.

(Opening Topic TBD and full schedule coming soon) but here's what we do know: pizza starting at 6:00 PM, first topic at 6:30...

Featured Talk Description:

Query Tuning for Windows Azure SQL Database - Grant Fritchey, SQL Server MVP

Just because you're using a Windows Azure SQL Database (formerly known as SQL Azure) doesn't mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using lots of resources. Data movement out of the Azure storage costs money. Federating databases means queries run on multiple systems all at the same time.

This session will introduce you to the tools available for identifying poor performing queries, including dynamic management objects, query I/O, and others. You'll learn how to understand why a query is running slow using the Azure Database Portal. With this understanding, you’ll be able to fix your poorly performing queries. All in the cloud.

Opening Talk Description:

Stupid Azure Tricks - Bill Wilder, Windows Azure MVP

Let's look at a few things that Windows Azure can do that maybe you didn't know it could do.

SPEAKERS

About Grant:

http://sqlbits.com/Gallery/Images/SpeakerPhotos/Grant_Fritchey.jpg

Grant Fritchey (https://acloudyplace.com/author/grant-fritchey/), SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG) and it’s current president. He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.

https://pbs.twimg.com/profile_images/1789892211/Twitter_Avatar_Scary_DBA_r2.jpg