Yes we are (finally) back for another exciting SQLCambs User Group Meetup and what better way to kick off proceedings than a double bill by the most magnificent Grant Frichey (blog|twitter), the Scary DBA. If you are not already aware, Grant is one of the leading experts on the SQL Server Query Engine and internals and is the author of several excellent books on the subject and related areas. Grant is a SQL Server MVP with over 20 years experience in IT including time spent in support and development and has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java and volunteers at PASS with the Editorial Committee and is president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011.
Session 1: Getting Started Reading Execution Plans
The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what’s important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You’ll learn where to start, what to look for first, and you’ll be better prepared to tune your queries. We’ll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.
Session 2: Building a Database Deployment Pipeline
The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, it’s data.
Redgate Golden Nugget
(Bigdata/ Hadoop lightning talk)
Registration will start from 6pm. Food and drink will be provided thanks to the generosity of our user group sponsor Redgate