SQLRALLY.com PASS SQLRally 2011 www.sqlpass.org Twitter Facebook LinkedIn

To vote on which Database & Application Development sessions you would like to see presented at PASS SQLRally 2011, please click hereNote: To register to vote for PASS SQLRally 2011 sessions during future rounds, click here

The following abstracts have been submitted for the Database & Application Development category for PASS SQLRally 2011. Voting for these sessions will take place Jan 17-23, 2011.

Category Quick Links

.NET
Azure\Cloud
Design
ETL\BI
Misc
Performance
Source\Version Control
Summit Spotlight
TSQL Advanced
TSQL Fundamentals
Tips & Tricks


.NET

Title: A data-logic approach to EF4
Speaker: Mattias Lind
Category: .NET
Level: 300
Abstract: This session will discuss the benefits of a data-logic approach to EF4, database modelling, tables, procedures, views and functions and how to integrate this with EF4.
Session Goals
  • Efficient database models to support EF4
  • Learn how to implement EF4
  • Get better performance
Speaker Bio: Mattias Lind is a self-employed database specialist and SQL Server Trainer, as well as the User-Group Liaison and Co-founder of MCT Europe. He has been working with MS SQL Server since mid 90's and been focusing on performance and database modelling. With customers all over the world he travells alot and is a frequent speaker at events as techdays, teched and mct summit.



Title: Entity Framework for the DB Administrator
Speaker: Jonathan Aneja
Category: .NET
Level: 300
Abstract: ADO.NET Entity Framework 4 (EF4) is Microsoft’s recommended data access layer for new applications. EF4 can be used to perform CRUD operations with very expressive query capabilities. After a brief overview of EF4 use from a developer perspective we will discuss how the Entity Framework can be a compliment to the general concerns that Database Administrators express. In particular this talk will investigate how the Entity Framework enables developers and DBAs to agree on a conceptual model that acts as a shared contract, providing DBAs control over their database and the entry points into the system that developers utilize by using the Entity Framework’s mapping technology and related features. We will then look at EF query performance including dynamic SQL generation, stored procedure use, and views and will outline recommendations for how to use each with EF.
Session Goals
  • Help DBAs understand exactly what EF is and what it isn't, and how it can make their job easier.
  • Help DBAs understand some of the myths around dynamic SQL generation.
  • Demonstrate best practices for using Entity Framework regarding performance and security.
Speaker Bio: Jonathan Aneja is a Program Manager on the Entity Framework team at Microsoft. Prior to that, he was the Program Manager for the Visual Basic .NET compiler during the releases of Visual Studio 2008 and Visual Studio 2010. He has been with Microsoft for 5 years.

Azure\Cloud

Title: SQL Azure - Seeing your data through the Cloud
Speaker: Wendy Pastrick
Category: Azure\Cloud
Level: 100
Abstract: SQL Azure is still new on the scene and promises a variety of features, yet many are apprehensive to consider it. Why would you want to move data to the Cloud? We will take a look at what being in The Cloud really means and why taking advantage of some of the features could save your company money and make your adminstrator's lives a little easier. Learn about where your data is stored, how you interact with it and taking advantage of some flexibility features.
Session Goals
  • Understand the architecture that supports using Azure databases.
  • Understand how to access data on SQL Azure and options for data synchronization.
  • Discuss scalability, managed support and other features built into SQL Azure.
Speaker Bio: SQL Server DBA for 10+ years working with versions 6.5 thru 2008 R2. Works closely with development teams to see application development through the entire lifecyle. Also has experience with Transactional and Merge Replication along with High Availability and Disaster Recovery planning and implementation. Previously working for a Technical Training company, Wendy has comfortably taken the podium at local User Group meetings, SQL Saturday events and the SQL PASS Annual Summit to educate audiences on both SQL Server technologies as well as Women In Technology issues.



Title: Deploying Data Tier Applications to the Cloud
Speaker: Joseph Dantoni
Category: Azure\Cloud
Level: 200
Abstract: Interested in quickly rolling out new applications to your local environment or to SQL Azure? This session will cover the Data Tier Application functionality that is built into SQL Server 2008 R2 and Visual Studio 2010. The session will start out with an overview of the technology, how it works and how it functions in a typical development organization. We will then go under the hood in SQL Server and take a brief look at the internals that drive both the deployment and upgrade process. Lastly, we will walk through a demonstation of building a new application in Visual Studio and deploying it to SQL Server Azure, extracting a Data Tier application from SQL, and lastly the process of an application upgrade using the technology.
Session Goals
  • Understand the purpose and limitations of data tier applications in SQL Server 2008 R2 and Visual Studio 2010.
  • Understand the internals of DACPACs and how they are processed by SQL Server.
  • Understand how to deploy a data tier application package from Visual Studio to SQL Server.
Speaker Bio: Joe D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Synthes, a medical device firm in West Chester, Pennsylvania. He holds a BS in Computer Information Systems from Louisiana Tech University, and a MBA from North Carolina State University. He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays.



Title: SQL Azure 201 - Cloud Database Deep-Dive
Speaker: Scott Klein
Category: Azure\Cloud
Level: 200
Abstract: Going beyond a SQL Azure introduction, this session will show how SQL Azure can be used in real-world situations, providing real solutions for today's cloud initiatives. This session will discuss sharding and caching to enhance the cloud experience and performance. We will also look at the OData protocol as a way to consume SQL Azure data in your applications including Windows Phone 7. If time permits we will also look at the new SQL Azure reporting capabilities.
Session Goals
  • Attendees should come away from this session with the knowledge that SQL Azure is a viable solution today.
  • Attendees will know how sharding and caching can drastically improve performance.
  • How OData is quickly gaining ground and how the protocol can be easily used to gain access to their cloud database data via the many different applications.
Speaker Bio: Scott Klein, a Microsoft SQL Server MVP, is co-founder of Blue Syntax Consulting, an Azure training and consulting company. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States, working in a wide scope of fields such as medical, finance, and retail. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the recently released Pro SQL Azure. Scott is President of the South Florida SQL Server Users Group and the newly formed SQL Azure PASS Virtual Chapter. He speaks frequently as SQL Saturday events and user groups, and was lucky enough to speak at the 2008 European PASS conference.



Title: Azure Solutions - Using SQL Azure and Azure Storage Solutions
Speaker: Scott Klein
Category: Azure\Cloud
Level: 300
Abstract: This session will discuss how to use SQL Azure and the Windows Azure Storage functionality to solve today's many storage problems. We will first provide brief introductory looks at SQL Azure and Windows Azure Storage, then provide different examples of how the two can be used together to provide solutions to today's BLOB storage problems.
Session Goals
  • An introductory understanding of Windows Azure Storage
  • How SQL Azure and Windows Azure Storage can be used together to provide BLOB storage solutions.
  • Azure is a viable solution for today.
Speaker Bio: Scott Klein, a Microsoft SQL Server MVP, is co-founder of Blue Syntax Consulting, an Azure training and consulting company. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States, working in a wide scope of fields such as medical, finance, and retail. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the recently released Pro SQL Azure. Scott is President of the South Florida SQL Server Users Group and the newly formed SQL Azure PASS Virtual Chapter. He speaks frequently as SQL Saturday events and user groups, and was lucky enough to speak at the 2008 European PASS conference.

Design

Title: 3rd Normal Form: That's crazy talk!!!
Speaker: Thomas LeBlanc
Category: Design
Level: 200
Abstract: How did the development world conclude that an integer is the best primary key? What is 4th and 5th normal form? What has been added to SQL Server in 2005 and 2008 to help change the way database design has evolved over the years? Can we still use a VarChar(xx) for a primary key? What is the difference between a lookup and Parent/Child relationship? What is an example of a Many-to-Many relationship? This session will go through the history of 21 years of experience with various database designs – normalized and denormalized. The discussion will include the benefits and forward looking that should be required for using various design techniques. The flow will be a discussion with much attendee participation to share sucess and pains in database development, leading to standards for all of us to take advantage of while designing databases.
Session Goals
  • Visually design database before physically structuring the tables that helps create a discipline to follow standards
  • Using primary key to satisfy 1st normal form and using foreign keys to describe Lookup tables and Parent-Child(ren) relationships for 2nd and 3rd normal forms
  • See where 4th and 5th Normal Forms can help further separate repeating values and less programming for these changing values
Speaker Bio: Thomas LeBlanc is a semi-retired Senior DBA turned ETL Lead Architect for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and even some .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 6 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Current activity at Amedisys involves 2 other DBAs and a manager supporting 300+ GB databases with replication to a Data Warehouse and DB Mirroring to a disaster recovery site. Performance tuning and reviewing database design and code are an everyday occurrence for DBAs at Amedisys. Thomas’ free time is spent helping those less fortunate and bettering the relationship with his family and God.



Title: Database "Insecurity"
Speaker: David Moutray
Category: Design
Level: 200
Abstract: Although we have had terrific tools for implementing fine-grained security since SQL 2005, database security remains one of the most neglected areas of database development. Database security is left to the Network Administrator and System Administrator, yet over 500,000 personal records have been breached in the United States alone just in the past few years. Clearly, we as database professionals need to do our part, too. It is also not enough to leave security to the Database Administrator. Like Data Integrity, data security is difficult (if not impossible) to retrofit into an application after development. (Question: Why is the average database administrator paid 25% more than the average database developer? I'll talk about that.) Database security, like Data Integrity or Data Access Performance, must be a design goal if we are to achieve it. This session is intended to get the participant to think about security from a design perspective and to illustrate some basic strategies for implementing security at the database level.
Session Goals
  • Illustrate the dangers of ignoring database security.
  • Explain why we often ignore database security during development and why database security must be an explicit goal during development.
  • Illustrate some simple development techniques for dramatically improving database security.
Speaker Bio: Database Administrator with five years' experience in database design, business intelligence, application development, performance tuning and day-to-day administration with SQL Server. Experience covers administration of both transactional and data-warehouse databases, application development and database design for business applications. Certifications include MCITP Database Administrator and Developer. Passionate about database security and promoting data integrity through rock-solid database design and good development practices.



Title: Growing Pains - A Cautionary Tale
Speaker: Brett Tomson
Category: Design
Level: 200
Abstract: It happens to everyone. One day your database is humming along quietly serving up choice nuggets of information quickly and efficiently while growing at a slow steady rate. The next day, your database has quadrupled in size and performance has ground to a halt as the system strains under the load. Management is screaming for answers and you're coworkers are running in circles screaming for their lives. In this session, we will examine how bad decisions and database design worst practices yielded an unwieldy monster that had the bravest of DBAs and database developers running for the hills. As we travel through this tale we will see how, with a little cunning and trickery, a schema change or two, the beast was tamed and the database was brought back to life. This session uses a real-world reporting system (names changed to protect the innocent) as the basis for its examples. Your mileage may vary.
Session Goals
  • Identify database design worst practices
  • Leverage best practices to correct performance and storage deficiencies
  • Have a good laugh at the expense of the presenter
Speaker Bio: Brett Tomson is an independent consultant specializing in delivering solutions using the Microsoft Business Intelligence stack and related .NET technologies. He is an accomplished architect and developer of large-scale enterprise systems as well as an author and mentor to others. Brett has been using SQL Server actively for the past 12 years and is the Chapter Leader of the Triangle SQL Server User Group (http://www.tripass.org).



Title: Sun Tzu and the Art of Software Development
Speaker: David Moutray
Category: Design
Level: 200
Abstract:

Most software development projects fail. They are either cancelled outright, vastly exceed their allotted budgets or are considered failures by the hapless end-users that are stuck with applications that have more bugs than a Roach Motel, run slowly and lock if more than two users try to use the same function at the same time. Developing good software on budget and on time is a battle. Sun Tzu on the Art of War, an ancient Chinese treatise on military strategy is required reading in the United States and around the world for military officers, business executives, attorneys and many others. Readers from all walks of life have found key advice in its pages on leadership and overcoming life's challenges. War may seem an odd metaphor for software development, but it is apt in at least two key respects: The first is simply the difficulty of the basic problem. Carl von Clausewitz famously said that "In war, everything is very simple, but even the simplest things are very hard, because the will is directed against an object which reacts." Software development has its own version of this: the Wicked Problem. A Wicked Problem is a problem which cannot be solved until you have tried and failed at least once. This is because you do not properly understand the problem when you first attack it. Software development is filled with Wicked Problems. Wicked Problems are the reason that estimating software development schedules is so difficult.

The second key similarity between war and software development is a four-letter word: T-E-A-M. With all due respect to the US Army, there is no such thing as an "Army of One". An army is a large team of people working to achieve a common goal under difficult, dangerous and arduous conditions. Likewise, all but the most insignificant software is developed by teams. Maintaining motivation, morale and focus during a long and difficult software development project is crucial to success. During this session we will explore examples not only from the history of war, but also politics, business and even culture to illustrate the intimate connection between war and all human endeavor. A great 19th century general said it best, "Strategy is more than a science: it is the application of knowledge to practical life, the development of thought capable of modifying the original guiding idea in the light of ever-changing situations; it is the art of acting under the pressure of the most difficult conditions."

Session Goals
  • Declare War on Your Enemy: Define your objective. Define the RIGHT objective. If you get this wrong, then you have lost before even starting.
  • Mobilize Your Army: Morale, Motivation and Teamwork in Software Development.
  • The Path to Victory: Motivation is important, but it is not enough. These are key things you must DO, concrete actions you must take in order to win your software development battles.
Speaker Bio: Database Administrator with five years' experience in database design, business intelligence, application development, performance tuning and day-to-day administration with SQL Server. Experience covers administration of both transactional and data-warehouse databases, application development and database design for business applications. Certifications include MCITP Database Administrator and Developer. Passionate about database security and promoting data integrity through rock-solid database design and good development practices.



Title: Unified Data Access in SharePoint 2010
Speaker: Cory Loriot
Category: Design
Level: 300
Abstract: In MOSS 2007, hybrid data system access (such as combining SharePoint Lists, DBMS and web services) for web parts and application pages was complicated, to say the least. In this session, we will discuss how Business Connectivity Services, External Content Types, External Lists, and LINQ to SharePoint make SharePoint 2010 a much simpler platform for integrating internal and external data systems. We will develop a solution that integrates data from SharePoint, SQL Server and other external data systems during the demonstration.
Session Goals
  • Learn about using Business Connectivity Services and creating External Content Types and External Lists.
  • Learn about using the SharePoint Object Model and Linq to interact with SharePoint Internal and External Lists.
  • Create a web part that uses internal and external data sources for a mashup.
Speaker Bio:  Cory Loriot has been working with SharePoint as an Administrator, Architect and Developer since January of 2007 beginning with SharePoint Portal Server (SPS) 2003, Microsoft Office SharePoint Server (MOSS) 2007 and currently working with SharePoint Server 2010. Cory works for Computer Technology Solutions, Inc. (www.askcts.com) as a Consultant designing and implementing Microsoft SharePoint 2010 and ASP.Net Solutions.

ETL\BI

Title: Using PowerShell to simplify your ETL
Speaker: Scott Weinstein
Category: ETL\BI
Level: 200
Abstract: * SSIS Considered Harmful - Poor example of visual programming - Poor VCS, etc * Intro to Powershell * Examples of common ETL tasks implemented in PowerShell - parallel bulk data transfer - star schema population - extract to csv - import from xls
Session Goals
  • Explain the limitations of SSIS - and why these matter on today's agile projects
  • Understand that many of SSIS's feature are available elsewhere
  • Get a feel for using PowerShell and .Net to replace SSIS
Speaker Bio: Scott Weinstein is a practice head at Lab49, manages the New York .Net Meetup, and is a frequent speaker on SQL, .Net, WPF, and reactive programming at SqlSaturday, CodeCamp, and the Alt.Net meetups in NYC



Title: Creating a Metadata Mart with SSIS - Data Governance , Data Profiling & Code Generation
Speaker: Ira Warren
Category: ETL\BI
Level: 300
Abstract: Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000s of hours of manual coding. For this client we implemented a reusable data driven architecture, via SSIS, that rely on a metadata mart. The end result a greatly reduced TCO(development effort) for generating the code required v.s manual coding. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts. After implementation the application can be maintained via the tables and automatically regenerated, providing a pro-active or self-healing application architecture to respond to changes in incoming source files or target changes.
Session Goals
  • Teach advanced use of Metadata Techniques.
  • Use SSIS for creating data driven Code Generation
  • Advanced SSIS Skills for using Variables, Dynamic File Connections and Derived columns
Speaker Bio:  Over 35 years experiences in Software Developemt, IT Management and BI Architecture.



Title: Developing Master Data Services Tools using Microsoft Office 2010 and Visual Studio 2010
Speaker: Patrick Gallucci
Category: ETL\BI
Level: 300
Abstract: In this session we will focus on developing tools for modeling and managing Microsoft Master Data Services as well as Governance tools that can be used in your organization. We will look at an Excel add-in for modeling your master data. The add-in will create all necessary scripts to create your model, entities and attributes as well as reverse engineer an existing model into the spreadsheet. We will then show how to create reports in word and SQL Server Report Builder 3.0 that can aid in compliance in your Governance Program. Finally we will look at how to develop SharePoint 2010 webparts to manage your member data. In this session we will focus on the different development tools that you can use to deploy Master Data Services solutions, including Visual Studio 2010 C#, Excel VBA, PowerShell Scripting SQL Server Report Builder 3.0.
Session Goals
  • Understanding of the development platform, tools and technologies for Microsoft Master Data Services.
  • How to create Office 2010 add-ins in C# and VBA to model and manage Master Data Services.
  • How to create SharePoint 2010 Web Parts for Information Governance.
Speaker Bio: Patrick Gallucci is a Data Warehouse/Business Intelligence Architect, Consultant and Trainer with 18 years’ experience working with relational databases including Microsoft SQL Server, Oracle, DB2, Sybase and MySQL. Before leaving Microsoft in February of 2009, Patrick’s role as BI Associate Architect saw him working on multi-terabyte DW\BI Solutions with PepsiCo, Conoco-Phillips, Cisco, MTV, Showtime, ABC\Disney, CBS, Kohl’s, Aetna, Chase, Citibank, WAMU, Kaplan University and Qwest. He is also a Microsoft Certified Architect, DBA, Engineer and Trainer. Currently Patrick is the BI\SQL Regional Practice Director for Neudesic and is based out of their Dallas Office.

Misc

Title: What's new in SQL Server 2011 (Denali)?
Speaker: Aaron Bertrand
Category: Misc
Level: 100
Abstract: This presentation will cover many of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Several demos and no marketing.
Session Goals
  • Show people some of the new features they will be getting in Denali.
  • Prepare people for some negative changes (e.g. mirroring now becomes most useful in Windows Enterprise Edition only).
  • Discuss issues of migrating / upgrading from current editions.
Speaker Bio: Aaron is a senior consultant for SQL Sentry, Inc, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.



Title: Programming with FileStream Object
Speaker: Sam Nasr
Category: Misc
Level: 200
Abstract: SQL Server 2008 introduced the FileStream object. This allowed developers to resolve an age long dilemma of storing large binary files in the database or accessing them on the file system. SS08 provides the best of both worlds while allowing applications to access the data readily through the FileStream object via Transact SQL or File I/O.
Session Goals  
Speaker Bio:  Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCAD, MCTS(MOSS), and MCT), Sam develops, teaches, and tours the country to present various topics in .Net. He is also actively involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he also started the Cleveland WPF Users Group in June 2009, and the Cleveland .Net Study Group in August 2009. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.



Title: Programming with StreamInsight
Speaker: Sam Nasr
Category: Misc
Level: 200
Abstract: StreamInsight is one of the new exciting features released in SQL Server 2008 R2. With Data volumes exploding with event data streaming from sources such as RFID, sensors, and web logs, the size and frequency of the data make it challenging to store for data mining and analysis. The ability to monitor, analyze and act on the data in motion provides significant opportunity to make more informed business decisions in near real-time. In this session, we’ll demonstrate how events can be processed with low latency so that action can be taken immediately based on the insights derived.
Session Goals  
Speaker Bio:  Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCAD, MCTS(MOSS), and MCT), Sam develops, teaches, and tours the country to present various topics in .Net. He is also actively involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he also started the Cleveland WPF Users Group in June 2009, and the Cleveland .Net Study Group in August 2009. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.



Title: Spatial Data in SQL 2008
Speaker: Michael Stark
Category: Misc
Level: 200
Abstract: During the session we will cover the new geographic features of SQL 2008. We will cover the reasons for using and the benefits of using. We will construct sql statements to query the data using built in geographic functions like distance and interection. We will then discuss some implementations of spatial data. Finally we will build a quick solution using ASP.net and the Bing Maps control to render the results of our query onto a real map. Time permitting we will quickly show how to render the data to Silverlight and Windows Phone 7.
Session Goals
  • Construct a SQL Query
  • Render SQL data in ASP.net
Speaker Bio:  Michael Stark has been developing software since 1992.  He has worked for both large and small companies.  He has worked in a variety of platforms and environments.  He prefers the newer technologies and enjoys learning new skills and applying them as solutions to existing processes.  He prefers client facing software development projects.  He gets personal satisfaction with build products that make business life easier for the end user.  Mr. Stark is originally from Miami, Florida and currently resides in Tampa, Florida.  In between the two he has live in Atlanta, Detroit, Deland, and Madrid Spain.



Title: SQL Server Service Broker – An Overview
Speaker: Janis Griffin
Category: Misc
Level: 200
Abstract: Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related applications and their data structures.
Session Goals
  • The student will learn about the many Service Broker components and understand the advantages of using Service Broker in their database applications.
  • This session will review several case studies, which use Service Broker, in order for the student to get a better understanding of how to design, implement and maintain a Service Broker application.
  • Demonstrations will be used to show the flexibility, reliability, and scalability of Service Broker applications
Speaker Bio: Before coming to Confio Software, I  held DBA positions primarily in the Telecom Industry, working with both real-time network routing databases and OLTP business to business applications.  During that time, I held positions of  Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning. In addition, I was responsible for managing all aspects of voice network databases,  including short and long-term technical and strategic planning.  Most notibly, I helped develop  several telephony patents: http://www.faqs.org/patents/inv/250539  

Performance

Title: Drive SQL Server Performance: Intro to I/O For Developers
Speaker: Eddie Wuerch
Category: Performance
Level: 100
Abstract: An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data? There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help. This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs. The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases.
Session Goals
  • Describe how SQL Server physically stores and accesses data
  • List the indexing options that exists within SQL Server, how they work to speed data access, and the pros and cons of each
  • Apply the discussed topics to table, index, and query design
Speaker Bio: Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the Principal Database Architect and DBA team lead at a leading SaaS company located in Indianapolis, Indiana.  Eddie and his team manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the application.  In addition to holding MCITP certifications in SQL Server 2005 and 2008 development and administration, Eddie is also Microsoft Certified Trainer, bringing his VLDB experience to developers and DBAs, delivering courses in SQL Server high availability, development, administration, optimization, and Reporting Services.



Title: AppFabric Cache and SQL Server 2008
Speaker: Todd Robinson
Category: Performance
Level: 200
Abstract: With all the hype about NoSQL going around in the SQL community its about time we looked at a Microsoft's distributed cache-aside solution, AppFabric Cache. In this session we will briefly go over what AppFabric Cache is, what it can and cannot do, as well as some of the compelling features that make it a complimentary product to SQL Server. We will go over some real-world examples on how AppFabric Cache can co-exist with SQL Server and increase performance. In addition, we will compare the speed of the AppFabric Cache in comparison to SQL Server 2008 in both queries and inserts/updates. This chalk-talk will go more in-depth into some of the information presented in the SQLCAT Optimizing application workload & performance by leveraging AppFabric Cache along with SQL Server session.
Session Goals
  • Educate users on what NoSQL is and what it is primarily used for.
  • Show users AppFabric Cache, Microsoft's distributed caching platform which competes with other NoSQL solutions.
  • Show users that AppFabric Cache is not a replacement for SQL Server, rather a supplemental upgrade to increase performance and scalability.
Speaker Bio: Todd Robinson has been working with SQL Server since the 6.0 release. He currently works for Travelport as a Sr. SQL Server Database Developer focusing on high transaction volume systems in the travel industry. Prior to his role at Travelport, he was an independent consultant for DevSQL, which focused on development and consulting of highly available and scalable systems in the financial, government and telecommunications industries. Todd has been involved as a volunteer with PASS since 2005.



Title: Ask Why My Query So Slow?
Speaker: Jason Wong
Category: Performance
Level: 300
Abstract: Working with SQL Server for many years, I have rescued a number of organizations from degrading database performance back to outstanding production database. I often see inefficient T-SQL code execution in production databases. In this session, I will elaborate on each of the following topics in detail by presenting real-world codes, and illustrate why they are bad and what is the remedy to improve performance. Configuration: 1. RAM (Memory) 2. RAID (IO) 3. Concurrency – • Dirty Read • Phantom Read • Non-repeatable Read • Select blocking update • Update blocking select Code: 1. inline function and expression 2. select * 3. compiled to incorrect plan 4. recompile plan 5. union (union all) 6. missing join 7. type implicit conversion 8. unfiltered delete (truncate) 9. like operator (and execution plan and index) 10. missing, unused, redundant indexes 11. query hint 12. database version compatibility 13. locking, blocking (isolation level) 14. not in, in, exists, not exists 15. schema naming convention What you can expect to take away from this session: 1. Learn the efficient T-SQL programming. 2. Understand the intertwined server configuration and code execution, such as between query and index, between cache and IO, between isolation level and locking etc. 3. Draw best practice principles based on real world scenarios 4. Learn how to re-factor old code to improve performance 5. Leverage the SQL Server 2008 new features to solve performance issues.
Session Goals
  • Learn the efficient T-SQL programming syntax. Learn how to re-factor old code to improve performance.
  • Understand SQL Server internals, concurrency. Best practice principles based on real world scenarios.
  • Leverage the SQL Server 2008 new features to solve performance issues
Speaker Bio: http://usa.redirectme.net

Source\Version Control

Title: Data Dude for Devs and DBAs - Making Database Development Painless and Productive
Speaker: Robert Cain
Category: Source\Version Control
Level: 200
Abstract: Whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka "Data Dude" can be a boon to you. In this session we'll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we'll look at the powerful data generation capabilities built into "Data Dude".
Session Goals
  • Show attendees how to use "Data Dude" to reverse engineer an existing database, then make changes to that database. Finally demonstrate deployment techniques for updating the target database.
  • Demonstrate the powerful data generation capabilities of Data Dude
  • Show attendees the power of unit testing their databases.
Speaker Bio:  Robert C. Cain is a Microsoft MVP in SQL Development, MCTS certified in BI, and works as a Senior Business Intelligence Architect for ComFrame. He is also a technical contributor to Plurasight Training, and co-author of the book "SQL Server MVP Deep Dives". Robert has over 20 years experience in the IT field, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power. He maintains the popular blog http://arcanecode.com.  



Title: Taming Database version control and deployments
Speaker: Scott Weinstein
Category: Source\Version Control
Level: 200
Abstract: * Why version control * Why are databases hard to version control? * Issues w/ T-SQL * Issues w/ managing schema changes * An approach & demo * Deployments * CI * Issues * Code review
Session Goals
  • Understand why VCS and regular deployment is needed
  • Understand why it's hard
  • Have a conceptual FW for implementing
Speaker Bio: Scott Weinstein is a practice head at Lab49, manages the New York .Net Meetup, and is a frequent speaker on SQL, .Net, WPF, and reactive programming at SqlSaturday, CodeCamp, and the Alt.Net meetups in NYC



Title: Visual Studio 2010 Database Projects
Speaker: Randy Knight
Category: Source\Version Control
Level: 200
Abstract: Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
Session Goals
  • Define project types, and how to create database projects. Cover SQL Server 2005 & 2008.
  • Define the real power of projects. Demonstrate schema comparisons.
  • Define data generation plans. Review foreign key relationships, and how to use RegEx to create strings that make sense.
Speaker Bio: Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for Match.com, one of the largest and most successful dot coms.  Randy made a name for himself as a full time SQL/Microsoft Trainer in the 1990's.  He traveled extensively around the country, helping employees of both small and large companies obtain Microsoft and Novell certifications.



Title: Sharing For DBA's: A Guide To Source Control.
Speaker: Joe Kuemerle
Category: Source\Version Control
Level: 300
Abstract: Source control systems have been successfully used for years by developers for collaborating without colliding. Todays DBA's must work closely with development teams to ensure that the solutions created are optimal. We will review the outlines of various source control platforms including Microsoft Team Foundation Server, Subversion and Mercurial and how to interact with them. The second half of the session will be an overview and discussion of techniques and practices to provide database versioning and how to ensure that every build of the application is able to have a matching version of the database.
Session Goals
  • Help DBAs to understand how source control systems work
  • DBAs will learn how to use standard source control functionality to collaborate with developers
  • DBAs will learn methods to ensure database objects stay synchronized with application deployments
Speaker Bio:  Joe Kuemerle is a developer and speaker in the Cleveland, OH area specializing in .NET development, security, database and application lifecycle topics.  He is currently a Lead Developer at PreEmptive Solutions, LLC .  PreEmptive is the maker of Dotfuscator, the premier obfuscator for .NET; DashO, the top Java obfuscator; and Runtime Intelligence, a solution to inject application usage tracking into .NET and Java applications.  

Summit Spotlight

Title: T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code
Speaker: Jennifer McCown
Category: Summit Spotlight
Level: 200
Abstract: You're a good SQL professional - you attend conferences and webinars, you read articles and books, you know your way around SQL Server. But sometimes - just SOMEtimes - some piece of T-SQL slips by you unnoticed, or falls out of memory. Come and revisit old favorites, and brush up on new T-SQL features and enhancements like MERGE, OVER, and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations.
Session Goals
  • This session will introduce (and reintroduce) attendees to at least one T-SQL feature new to them.
  • This session will emphasize that there are multiple T-SQL solutions for any given problem.
  • Attendees will learn to seek solutions in SQL Server BOL and other recommended materials.
Speaker Bio: I'm a SQL Server developer and DBA of over 10 years. I've worked for FedEx, Brinks, and Microsoft, and am currently working for a nonprofit financial institution. My hobbies include code and database optimization, fixing other people's scripts, and long walks with an ice cream cone. I'm the co-designer and administrator of ITBookworm.com and MidnightDBA.com. I write book and product reviews for Bookworm, and make training videos, articles, and blogs for MidnightDBA. My SQL blog is syndicated through SQLServerPedia.com, where I'm a contributor. I live in Dallas with the MVP with the pretty eyes (oh yeah, I said it) and our three so-cute-you-could-eat-em kids. Sean's right: they're growing up way smarter than us. I'm only a lowly orange belt in Kenpo Karate, but on the other hand,I hold a learner's permit to fly a single engine aircraft, so there's that. If they ever come on the intercom and say, "Is there anyone on the plane with flying experience?", then I get to go up to the cockpit.



Title: Characteristics of a Great Relational Database
Speaker: Louis Davidson
Category: Summit Spotlight
Level: 200
Abstract: When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be discussed.
Session Goals
  • Understanding the factors that go into a proper design.
  • Working towards a goal of having a checklist of things to look at when coming upon a new database, other than the initial "it doesn't look like mine" reaction of many architects.
  • Provoke thought about how certain aspects of a database design/implementation affect implementation time both during development and long after.
Speaker Bio: Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. Louis has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information visit drsql.org.



Title: Database Design Contentious Issues
Speaker: Karen Lopez
Category: Summit Spotlight
Level: 200
Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Today's vs. Tomorrow's Requirements * Generalization vs. Specificity * Performance vs. Integrity * NoSQL in a RDBMS World * What is DBA work? Data Architect Work? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. In these sessions attendees will vote on how they stand on a range of issues, then discuss, debate, heckle and chuckle at the variety of positions and the foundations used to support them. Also, expect to get some exercise while we are at it.
Session Goals
  • Better understanding of Design Trade-offs.
  • Ability to discuss cost, benefit, and risk of design approaches
  • Better understanding of team roles and responsibilities.
Speaker Bio: Sr. Project Manager and Architect for InfoAdvisors, a Toronto-based consulting firm. I'm a frequent speaker at conferences and local user groups. I have 20+ years of experience in project and data management on large, multi-project programs. I'm a chronic volunteer for local and international professional societies. I want you to Love Your Data



Title: Database Structures for Programmers
Speaker: Louis Davidson
Category: Summit Spotlight
Level: 200
Abstract: All too often a person will complain that SQL Server isn’t up to the task of enterprise databases, and usually there are two things wrong with this statement. First, the person has a set of data that is hardly up to what SQL Server can deal with at “enterprise” level. Second they have no knowledge of how data is stored or how to manipulate the physical structures to their benefit. In this session, I will, at a reasonably high level cover most of the physical aspects of the SQL Server architecture page structures, table and index structures, files, and more, including some tips on how you can use these aspects to your advantage rather than struggling against the fundamentals of the SQL Server storage architecture.
Session Goals
  • Understanding the structural differences between a table with a clustered index, and a table without one (heap).
  • Getting an overall picture of the structure of all of the on disk structures, including SQL queries to view aspects of your structures.
  • Understand the basic structures of SQL Server storage so that as a developer, you can envision what the effect of design decisions will be.
Speaker Bio: Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. Louis has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information visit drsql.org.



Title: Deploying Visual Studio 2010 Database Projects
Speaker: Kevin Goode
Category: Summit Spotlight
Level: 200
Abstract: Declarative database development has made great strides forward with the Visual Studio 2010 data tools allowing developers to focus on the model instead of the implementation. But once you have the model, what are the options for deployment and what if your solution doesn’t match the Books Online example? The session will demonstrate multiple ways to deploy database projects using TFS Build, MSBuild, VSDBCMD, Powershell and more. For each deployment method, automation and customization techniques will be examined and demonstrated (including the common requirement of deploying one model to multiple targets.) Attendees will leave with a better understanding of database deployment options when using Visual Studio 2010
Session Goals
  • Understand ways to deploy database projects outside of visual studio
  • Understand how to customize database deployments to meet buisiness requirements
  • Learn how to automate the deployment of a single data model to multiple targets
Speaker Bio: Kevin Goode is an MCSE, MCSD, and MCDBA. Currently, he is the Senior Data Architect for Inmar Inc. Kevin has over 12 years SQL Server experience starting with 6.5 and 15 years of IT experience. He has worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing and has worked for several fortune 500 companies. His specialties include SQL Server development, Performance Tuning, Business Intelligence, and ETL.



Title: T-SQL Code Sins: The Worst Things We Do to Code, and Why
Speaker: Jennifer McCown
Category: Summit Spotlight
Level: 200
Abstract: It's impossible to follow every best practice all the time. "Code sins" are those things we do to our code that are either so horrendous that they can't be borne, or that have such tremendous consequences that your stored procedures wish they'd never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.
Session Goals
  • Identify common bad practices in database development.
  • Identify common-sense solutions to database development bad practices.
Speaker Bio: I'm a SQL Server developer and DBA of over 10 years. I've worked for FedEx, Brinks, and Microsoft, and am currently working for a nonprofit financial institution. My hobbies include code and database optimization, fixing other people's scripts, and long walks with an ice cream cone. I'm the co-designer and administrator of ITBookworm.com and MidnightDBA.com. I write book and product reviews for Bookworm, and make training videos, articles, and blogs for MidnightDBA. My SQL blog is syndicated through SQLServerPedia.com, where I'm a contributor. I live in Dallas with the MVP with the pretty eyes (oh yeah, I said it) and our three so-cute-you-could-eat-em kids. Sean's right: they're growing up way smarter than us. I'm only a lowly orange belt in Kenpo Karate, but on the other hand,I hold a learner's permit to fly a single engine aircraft, so there's that. If they ever come on the intercom and say, "Is there anyone on the plane with flying experience?", then I get to go up to the cockpit.



Title: T-SQL Enhancements in Denali
Speaker: Plamen Ratchev
Category: Summit Spotlight
Level: 200
Abstract: Take a look in the future of SQL Server and experience the new T-SQL features in SQL Server 11 (code named Denali). This session is a deep dive into the new OFFSET option for paging, error handling improvements with THROW, sequences, enhancements to EXECUTE for results sets, and new features to describe query and procedures result sets and parameters. You will see practical code demos describing the use cases for these T-SQL extensions.
Session Goals
  • Learn the new T-SQL enhancements in Denali
  • Understand the practical use cases for the new features
  • See how these new features compare to existing features and what improvements they offer
Speaker Bio: Plamen is an SQL Server MVP and founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization.



Title: Where should I be encrypting my data?
Speaker: Denny Cherry
Category: Summit Spotlight
Level: 200
Abstract: In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.
Session Goals
  • Encrypting and Hashing data within Application Tier
  • Encrypting data within the Database tier
  • Encrypting data within the MPIO / HBA
Speaker Bio: Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP. Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.



Title: Zen and the Art of Writing SQL Query
Speaker: Plamen Ratchev
Category: Summit Spotlight
Level: 200
Abstract: Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY!
Session Goals
  • Learn the correct way to write a query
  • Understand the logical processing of a query
  • Learn some pitfalls when writing queries and how to avoid them
Speaker Bio: Plamen is an SQL Server MVP and founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization.



Title:  100% Availability without 100% Uptime
Speaker: Thomas Grohser
Category: Summit Spotlight
Level: 300
Abstract: The problem of globally operating internet sites or any other real 24x7 operation is, that there is no or very little time for maintenance. This session will show how to partition your data across multiple servers and partitions in a way that you can maintain each partition at least once a day without affecting overall availability. You will hear how it works in theory, see a proof of concept and learn how to analyze your data to make the same partitioning for your application.
Session Goals
  • Understand the problems and challanges a 24x7 environment has
  • Learn how to partition data and access it via data dependent routing
  • Learn how to group your data in a way that allows taking portions to be taken offline without effecting availability
Speaker Bio: In the last 17 of my more than 23 years as an IT Professional I spent the majority of the time exploring the deeper inner workings of SQL Server and his features while working for entertainment , pharmaceutical and other industry leading companies. The main focus of my work is to architect, plan and provide a reliable, highly available, secure and scalable infrastructure for and with the features of SQL Server. This covers all angles from hardware, network, storage systems, Operating systems, SQL Server configuration and the Data Access Layer of applications; Currently I work at one of the largest SQL Server installations in the world processing hundreds of millions of transactions daily while moving peta bytes of data in a 24x7 environment ; Now its time to share all the findings and the gathered know how with the SQL Server community therefore I started speaking regularly at international conferences in North America and Europe and at local events and work closely with SQLCAT to make sure everyone interested can access the information. Recently I was awarded SQL Server MVP for these activities



Title: Bad SQL
Speaker: Geoff Hiten
Category: Summit Spotlight
Level: 300
Abstract: How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
Session Goals
  • Identify bad SQL patterns.
  • Replace bad pattern with good alternative
  • Improve query performance and stability
Speaker Bio: Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet.  Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since.  He specializes in high-availability and high-performance SQL systems.  Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, and database strategy implementations.   Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Users group (AtlantaMDF) and can be found lurking in the halls at PASS (Professional Association for SQL Server) Community Summit events.  In addition, Geoff has been a Subject Matter Expert for Microsoft Training Curriculum materials and has authored articles, white papers and podcasts on SQL Server.



Title: Building a High Availability SQL Server 2008 R2 environment
Speaker: Ayad Shammout
Category: Summit Spotlight
Level: 300
Abstract: If you are new to SQL Server 2008 R2 HA features, you will learn how to utilize Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. In this session, I will show how to setup database mirroring, install SQL Failover Cluster instance and upgrade from SQL Server 2005 Cluster to SQL 2008 R2. This session includes real life deployment and upgrade scenarios to achieve high availability and disaster recovery, the lessons learned, and the best practices. Technologies covered include Failover Clustering on Windows Server 2008 R2 and SQL 2008 R2 Database Mirroring.
Session Goals
  • Setup database mirroring
  • Install SQL Failover Cluster instance
  • Build HA/DR SQL environment
Speaker Bio: Ayad Shammout is a Principal Consultant with Advanti Solutions Inc. Shammout has been involved in IT for 20 years as a Developer, System Engineer, System Analyst and Database Consultant. He has a long experience in Microsoft Platforms and products primarily specialized in SQL Server, SharePoint and Windows OS. He is working in OLTP design and development, DBA support, Performance Tuning and Business Intelligence. Ayad has been involved in many SQL Server Enterprise implementations for High-Availability, Disaster Recovery, Infrastructure Design, System Scalability, Security and Compliance. He has extensive experience in SQL Server Integration Service, SQL Server Reporting Service, SQL Server Analysis Service, and PowerPivot for Excel and SharePoint. Shammout was awarded “SQL Server Innovators Award 2006” and presented at different events. He is an MCDBA, MCSE, MCITP and MCTS



Title: Diagnosing connectivity issues with SQL Server
Speaker: Evan Basalik
Category: Summit Spotlight
Level: 300
Abstract: Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.
Session Goals
  • Understand how SQL Server client libraries communicate with SQL Server
  • Understand how to determine if the connectivity problem is a SQL Server problem or network problem
  • Be able to use some basic tools to solve connectivity problems.
Speaker Bio: I spent 10 years doing R&D for a major textile manufacturer. I joined Microsoft 5 years ago and is currently a Support Escalation Engineer on the SQL Server team. I specialize in connectivity, database client code, and Reporting Services. In addition, he has been working on SQL Azure since before it was even called SQL Azure. .



Title: DMV Emergency Room!
Speaker: Glenn Berry
Category: Summit Spotlight
Level: 300
Abstract: If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance,resulting in angry users and hovering managers and executives. If this hasn't happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level. Based on the initial assessment of the problem, different types of DMV queries will help you narrow down and identify the problem. This session will show you how to assemble and use an emergency DMV toolkit that you can use to save the day the next time a sick database shows up on your watch in the Database ER!
Session Goals
  • Learn how to assemble and maintain an emergency DMV toolkit.
  • Learn how to use DMV queries to diagnose critical performance issues.
  • Learn how to use DMV queries and other tools to work on correcting critical performance issues.
Speaker Bio: Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.



Title: Hardware 301: Selecting and Sizing Database Hardware for OLTP Performance
Speaker: Glenn Berry
Category: Summit Spotlight
Level: 300
Abstract: The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.
Session Goals
  • Understanding how to select and size server hardware and storage for the best possible performance.
  • Knowledge of current and upcoming hardware trends and how they affect SQL Server workloads.
  • Understanding on how to get the best performance with a given hardware budget, and how to make the best tradeoffs.
Speaker Bio: Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.



Title: PowerShell 2.0 Beyond the Dirty Dozen
Speaker: Aaron Nelson
Category: Summit Spotlight
Level: 400
Abstract: Now that you’ve learned the basics of PowerShell we’ll dive a little deeper and learn to develop scripts that help you get the most out of SQL Server. We’ll take a look at advanced functions, event logging and error handling. Then put everything together in a nice package and create our own modules to deploy to profiles across our entire SQL Server environment.
Session Goals
  • advanced functions
  • pipeline operarion/flow control
  • event logging
Speaker Bio: Aaron Nelson ( blog | twitter ) is a Senior SQL Server Architect with over 10 years of experience in Architecture, Business Intelligence, Development, and Performance Tuning of SQL Server. He has experience managing enterprise wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V). Aaron helps run the AppDev and PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF. He also co-runs the Atlanta PowerShell User Group, and helps organize SQL Saturday events in Atlanta.



Title: SQL Server Storage Engine under the hood: How SQL Server performs I/O
Speaker: Thomas Grohser
Category: Summit Spotlight
Level: 400
Abstract: How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.   Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
Session Goals
  • Understand the different types of IO that are performed and which operations cause them
  • Learn how to select and size a storage Subsystem
  • Understand IO bottlenecks and how to fix them
Speaker Bio: In the last 17 of my more than 23 years as an IT Professional I spent the majority of the time exploring the deeper inner workings of SQL Server and his features while working for entertainment , pharmaceutical and other industry leading companies. The main focus of my work is to architect, plan and provide a reliable, highly available, secure and scalable infrastructure for and with the features of SQL Server. This covers all angles from hardware, network, storage systems, Operating systems, SQL Server configuration and the Data Access Layer of applications; Currently I work at one of the largest SQL Server installations in the world processing hundreds of millions of transactions daily while moving peta bytes of data in a 24x7 environment ; Now its time to share all the findings and the gathered know how with the SQL Server community therefore I started speaking regularly at international conferences in North America and Europe and at local events and work closely with SQLCAT to make sure everyone interested can access the information. Recently I was awarded SQL Server MVP for these activities

Tips & Tricks

Title: Management Studio Tips & Tricks
Speaker: Aaron Bertrand
Category: Tips & Tricks
Level: 100
Abstract: A collection of tips, tricks and gotchas revolving around the use of Management Studio for database development, administration and maintenance. Will also outline a few alternative tools, some free tools to complement, and some changes coming in SSMS in SQL Server code-name "Denali."
Session Goals
  • Provide some insight into Management Studio features that users might not know about or haven't tried.
  • Let people know about some free tools that can complement their use of Management Studio.
  • Show off some of the future functionality coming with the new Visual Studio-based Management Studio.
Speaker Bio: Aaron is a senior consultant for SQL Sentry, Inc, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.



Title: Table Variables and Temporary Tables - What you Need to know!
Speaker: Wayne Sheffield
Category: Tips & Tricks
Level: 100
Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. While there are a lot of articles on the internet about both, most are incomplete in one form or another. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?
Session Goals
  • Understand the capabilities and limitations of table variables and temporary tables.
  • Compare and contrast the mechanisms behind table variables and temporary tables.
  • Investigate and debunk myths associated with table variables and temporary tables.
Speaker Bio:  



Title: (NOLOCK) FOR YESFUN: Games with Isolation Levels
Speaker: Kendra Little
Category: Tips & Tricks
Level: 200
Abstract: Understanding transaction isolation levels is critical for developing concurrent software. Unfortunately most of us learn about transaction isolation early in our careers and don't maintain an in-depth knowledge of different isolation levels. This talk will help! We'll cover all isolation levels and discuss problems and benefits. A broadsheet handout will keep your knowledge fresh later on.
Session Goals
  • Describe optimistic and pessimistic concurrency concepts and explain isolation levels
  • Describe benefits and problems of each isolation level
  • Discuss row-versioning isolation levels in greater depth, including the differences between snapshot isolation and read committed isolation using row versioning.
Speaker Bio: Kendra Little has spent ten years nerding out on SQL Server. She likes performance tuning, automating processes, building SQL Reports, and (secretly) writing documentation. Kendra has a Masters in Philosophy and a salt shaker full of certifications, but all the best stuff she's learned lately has come from her smarty-pants colleagues and the SQL Server community. Read her blog at http://littlekendra.com.



Title: So You've Inherited the "DB From Heck" (v2.0)
Speaker: Troy Ketsdever
Category: Tips & Tricks
Level: 200
Abstract: It's nice when, as database developers, we have a clean slate to work with. Most of the time, however, we inherit and must support existing designs and implementations. To add to the challenge, more often than not documentation of the database doesn't exist or is out-of-date with respect to the production system. In this updated session, we'll start with a quick look at some tools, techniques, and scripts that will accelerate your understanding of that beast you're now in charge of supporting and extending. After that, we'll explore some query-based methods for detecting design and implementation anomalies, and some things to consider when undertaking a project to correct such deficiencies.
Session Goals
  • Learn techniques and queries for discovering the current implementation and design of an "inherited" database
  • Identify potential design "anti-patterns" and other anomalies in the database.
  • Learn techniques for correcting database design and implementation problems, including migrating existing data to the new, improved version
Speaker Bio: Troy Ketsdever is a data architect with over 15 years of commercial software development experience, and has maintained a love/hate relationship with SQL Server since version 4.2. In addition to his "day job", Troy enjoys writing articles and presenting at user groups on a variety of database design and implementation topics. His main objective and vision is “making the right information available to the right people at the right time”.



Title: Deadlocks: What to do about the dreaded 1205
Speaker: Michael DeFehr
Category: Tips & Tricks
Level: 300
Abstract: Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We will start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.
Session Goals
  • Get a better understanding of the different types of deadlocks and what can cause them
  • Learn how to investigate a deadlock
  • Learn some techniques for minimizing deadlocks
Speaker Bio:  Michael DeFehr is the primary database analyst/developer at Protegra, a leading technology solution provider based in Winnipeg, Manitoba. His career has focused on database administration and development using Microsoft SQL Server. A SQL MVP, Professional Engineer and Microsoft Certified Information Technology Professional in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity. Mike is the chapter president of the Winnipeg SQL Server Users Group



Title: SQL Tricks
Speaker: A. P. Ward Pond
Category: Tips & Tricks
Level: 300
Abstract: A number of T-SQL coding tricks for improved performance are discussed, and demonstrations of each are provided.
Session Goals
  • Understand the programming tricks and techniques that are presented.
  • Gain comfort in deploying these techniques in business scenarios.
  • Gain further appreciation for the richness and flexibility of the T-SQL programming environment.
Speaker Bio: IT professional since 1978, SQL Server Developer/DBA since 1994. Eleven years' experience as a Senior Application Developer and Technology Architect at Microsoft (1999-2010). Helped design, administer, and present the first four rotations of the Microsoft "SQL Ranger" (now Certified Master) program. SQL Server blogger since 2005 (http://blogs.technet.com/wardpond; http://pondonsql.wordpress.com) Panelist, SQLPASS Summit 2006 Presenter/Instructor, TechEd EMEA 2007, TechEd EMEA 2008

TSQL Advanced

Title: Zero to "MERGE" in 60 minutes
Speaker: Troy Ketsdever
Category: TSQL Advanced
Level: 100
Abstract: SQL Server 2008 saw the introduction of the new MERGE DML statement. In this session, we'll take a look at the basic syntax and capabilities of the command, with a focus on how it can be leveraged in your OLTP environment. Once we have reviewed some simple examples, we'll dive into some of the more advanced uses (abuses?) of the command, reinforcing our understanding by looking at more complex examples.
Session Goals
  • Learn benefits and potential drawbacks for the new "MERGE" statement
  • Learn basic and advanced syntax of the command, with an emphasis on its use in an OLTP environment
Speaker Bio: Troy Ketsdever is a data architect with over 15 years of commercial software development experience, and has maintained a love/hate relationship with SQL Server since version 4.2. In addition to his "day job", Troy enjoys writing articles and presenting at user groups on a variety of database design and implementation topics. His main objective and vision is “making the right information available to the right people at the right time”.



Title: Developing Robust T-SQL for High Concurrency
Speaker: Alex Kuznetsov
Category: TSQL Advanced
Level: 200
Abstract: Many T-SQL modules run correctly when we test them from single connection, but they intermittently break when they are exposed to real life concurrency in OLTP systems. You will learn common real life scenarios when concurrency breaks T-SQL code, such as selects returning incorrect results, deadlocks, lost updates, modifications blowing up with PK or UNIQUE constraint violations In each case you will learn how to develop robust T-SQL which works in those situations.
Session Goals
  • Learn how to develop robust T-SQL which works correctly under concurrency.
  • Get better understanding of isolation levels
  • Get better understanding of deadlocks
Speaker Bio: Alex Kuznetsov is a database developer with more than a decade of experience. Alex has written a book entitled "Defensive Database Programming with Transact-SQL", and contributed to "MVP Deep Dives" and "The Red Gate Guide to SQL Server Team-based Development". He blogs on sqlblog.com and publishes articles on simple-talk.com and devx.com,.



Title: Refactoring SQL
Speaker: Jeremiah Peschka
Category: TSQL Advanced
Level: 200
Abstract: Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.
Session Goals
  • Learn what refactoring is and how it applies to SQL.
  • Gain an understanding of how and why to test SQL code.
  • Identify core methods for refactoring SQL code to improve application performance and maintanability
Speaker Bio: Jeremiah Peschka is an Emerging Technology Expert with Quest Software. Jeremiah works with different software to identify new techniques and trends in the world of data storage. Over the course of his career, Jeremiah has worked as a system administrator, developer, and DBA. When he is not volunteering with the development community, Jeremiah blogs about data storage, relational databases, and software development at http://facility9.com. He can also be reached on Twitter via @peschkaj



Title: Bend SQL to your will
Speaker: Jana Sattainathan
Category: TSQL Advanced
Level: 300
Abstract: Users are mostly set in their ways when it comes to querying especially if they have been doing so for a very long time. The newer querying features of SQL Server are more powerful and suprisingly simpler to get the same results. The performance of these new constructs are also superior. Specifically, the analytical functions (CTE's) Row Number, Rank, Dense Rank, Cube, NTile, Compute, With Rollup & OVER clause will be discussed with examples. The windowing functions will demoed with practical usage scenarios. In addition, other "not commonly used" aspects like recursive querying, MERGE, "Grouping Sets" of GROUP BY and other SQL features will be covered.
Session Goals
  • To open-up developers to the possibility of using the new querying features of SQL Server
  • With practical examples show when and where the newer features can be used in the real-world
  • Go in-depth with illustration of explain plan efficiencies when using the newer constructs
Speaker Bio: Jana Sattainathan is a Database/Application Architect with Transamerica Reinsurance, one of the biggest reinsurers in the U.S. He has been in the IT industry for over 15 years with a career centered mostly around databases from different vendors. Jana loves architecting efficient database solutions for effectively dealing with extremely large volumes of data. He currently holds the following certifications: MCITP - SQL Server 2005 Developer and Administrator & Oracle Certified Professional Admin He is currently working on a Database Querying tool that he plans to release a beta version of in mid to late 2011.



Title: Death By UDF
Speaker: Kevin Boles
Category: TSQL Advanced
Level: 300
Abstract: User Defined Functions provide several benefits that developers strive for: code encapsulation and code reuse. But they come with the likelyhood of many huge downsides: severe performance impact, concurrency issues and even incorrect results. The "cursor-under-the-covers" that improperly coded scalar UDFs can cause also don't get represented in query plans and statistics IO output either, so even developers that might use those tools will be misled. We will review the various types of badness that can come from common UDF designs, including how to properly see what is going on. Then we will cover some refactors and a few tricks that can help mitigate the issues.
Session Goals
  • Show numerous ways in which UDFs, especially scalar one's, can be devastating to performance.
  • Show how SSMS will not tell the truth about UDF plans and performance and how to use Profiler to really see what is happening.
  • Provide guidance on how to refactor bad UDFs out of code, including a trick to use when it comes time for impact analysis later down the road.
Speaker Bio: Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally, LOVES to present (including ELEVEN SQL Saturdays in 2010!) and has been a very successful independent consultant for over ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning.



Title: Writing faster queries
Speaker: Tim Chapman
Category: TSQL Advanced
Level: 300
Abstract: Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this all-demo session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.
Session Goals
  • Deliver a through understanding of common SQL Server query performance killers and the options we have for correcting them.
  • Understand how SQL Server uses the plan cache so that we can construct queries for maximum plan reuse. We'll also look at situations where plan reuse is not the best option for our queries.
  • Cover the importance of factors that are not often taken into account when writing SQL statements, such as statistics, parameters, local variables, table variables, predicate pushing, and windowing functions.
Speaker Bio: Tim Chapman is a SQL Server MVP and MCITP (Development and Administration) originally from Louisville but now resides in Chapel Hill, NC where he works as a database engineer and consultant. Tim has over 10 years of database architecture and administration experience.



Title: Advanced TSQL Solutions
Speaker: Kevin Boles
Category: TSQL Advanced
Level: 400
Abstract: The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.
Session Goals
  • Show, using extensive code demos, a wide range of methods to solve common business problems in efficient ways using TSQL.
Speaker Bio: Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally, LOVES to present (including ELEVEN SQL Saturdays in 2010!) and has been a very successful independent consultant for over ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning.

TSQL Fundamentals

Title: Avoid Common Mistakes in T-SQL Programming
Speaker: Alex Kuznetsov
Category: TSQL Fundamentals
Level: 100
Abstract: We shall consider several typical real life examples of poorly written T-SQL, see how and why it breaks, and fix them. We shall discuss some common misconceptions about SQL Server, see how our T-SQL can break because of them, and learn better alternatives.
Session Goals
  • Learn to avoid common mistakes in T-SQL programming.
  • Learn to identify the assumptions that we make when we develop code, and to either eliminate or enforce these assumptions.
  • See how testing and defensive programming help us develop robust high quality code.
Speaker Bio: Alex Kuznetsov is a database developer with more than a decade of experience. Alex has written a book entitled "Defensive Database Programming with Transact-SQL", and contributed to "MVP Deep Dives" and "The Red Gate Guide to SQL Server Team-based Development". He blogs on sqlblog.com and publishes articles on simple-talk.com and devx.com,.



Title: SQL 201: Stored Procedures, Functions, and Triggers
Speaker: Arnie Rowland
Category: TSQL Fundamentals
Level: 200
Abstract: Arnie will demonstrate how to create rock solid and efficient T-SQL stored procedures, functions, and triggers. He will demonstrate the ‘best’ way to handle input and output parameters, how to deal with return parameters, how to make sure that errors are properly handled. Sometimes overlooked, yet simple coding can make the difference between ‘mostly OK’ and ‘without a doubt’ confidence levels in your SQL code objects. Just one tip from this packed session will make your PASS SQL Rally experience worthwhile. Don’t miss it!
Session Goals
  • Participants will gain better respect for coding discipling and standardization.
  • Participants will gain new insights into handling T-SQL errors.
Speaker Bio: During his career as a outspoken architect and application developer with very large databases, Arnie realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other's objectives. As a frequent Trainer and Mentor for Developers and Database Administrators, he has nurtured a knack for helping to 'bridge the gap'. Arnie is a rare mix of expert developer and gifted database administrator, bringing both sets of skills to better communicate with development teams to create a working solution. Arnie is a Microsoft SQL Server MVP and has been a Subject Matter Expert (SME) working on SQL Server 2000 through 2008 training courses and has been involved as a SME with the development of the SQL 2008 Microsoft Certification Exams. He is also a Microsoft Certified Trainer, and has served as a technical editor for several publishers, including multiple SQL Sever titles in the Microsoft Official Curriculum. Arnie has served as adjunct faculty at the University and Community College levels. Clients include Multi-National and Fortune 500 companies, Federal and State agencies, Foreign governments, nationally recognized training facilities, and local enterprises –both public and private. Arnie is a pilot and flight instructor, holds post-graduate degrees, and is an avid bicyclist and sailor. Arnie is a Senior Moderator on the MSDN and TechNet SQL Server related Forums, and is a member of the TechNet Wiki Leadership Council.



Title: XQuery Basics for the DBA
Speaker: Jason Strate
Category: TSQL Fundamentals
Level: 200
Abstract: For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery. Oh, and if you aren’t a DBA you can come too.
Session Goals
  • Discuss the importance of learning XQuery
  • Discuss the XQuery methods
  • Demonstrate methods of using XQuery
Speaker Bio: Jason Strate, Digineer Inc, is a database architect and administrator with over twelve years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with the local PASS chapter (SQL Server User Group) and is currently serving as the Director of Program Development. In the past year, Jason worked with the current board to organize the PASSMN SQL Summit 2009 in September for the local community. Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse 2009, SQL Saturday #19, and at PASSMN user group meetings. He is scheduled to speak at this year’s PASS Summit in Seattle, WA. Jason is also a contributing author for the Microsoft white paper “Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition.” Jason is an active blogger with a focus on SQL Server and related technologies.



Title: Set-Based Thinking for the T-SQL Developer
Speaker: A. P. Ward Pond
Category: TSQL Fundamentals
Level: 300
Abstract: This is an interactive “chalk talk” session. I intend to lead with a brief discussion of the differences between set-based and procedural code, and then show and discuss three “before and after” examples. The first example concerns finding all of the prime numbers less than one million. A trivial exercise, but there are a sufficient number of ways to do it, with dramatically different results, that the techniques applied are very interesting. We’ll start with a script that takes 36 hours to complete, and end with one that takes three seconds. The second example involves extracting data from multiple levels of an XML document in a single statement. “Parent axis access” works across all platforms, but has performance issues due to the query plan it generates. As of SQL Server 2005, the CROSS APPLY operator can be used to address this requirement with markedly improved performance. The final example involves making 100% reliable daylight savings time adjustments in a global scheduling system. This requirement is addressed through a data modeling approach intended to enable a specific T-SQL statement. We’ll then move on to questions and examples from the participants.
Session Goals
  • Gain an understanding of why T-SQL programming is different than 4GL programming (set-based vs. procedural paradigm)
  • Gain insights into syntax and techniques that provide more performant code
  • Gain sufficient comfort with the analytical techniques discussed to deploy them in production scenarios.
Speaker Bio: IT professional since 1978, SQL Server Developer/DBA since 1994. Eleven years' experience as a Senior Application Developer and Technology Architect at Microsoft (1999-2010). Helped design, administer, and present the first four rotations of the Microsoft "SQL Ranger" (now Certified Master) program. SQL Server blogger since 2005 (http://blogs.technet.com/wardpond; http://pondonsql.wordpress.com) Panelist, SQLPASS Summit 2006 Presenter/Instructor, TechEd EMEA 2007, TechEd EMEA 2008



Title: TSql Techniques
Speaker: Dave Ballantyne
Category: TSQL Fundamentals
Level: 300
Abstract: So, you’ve got good design, got correct indexes, hell, you’ve even got good sargability. But your system is still slow. What’s the problem? The chances are your SQL Code is asking too much of your hardware. In this session, I will demonstrate why a set-based mindset is so critical to performance and some simple techniques to lower resource usage through better use of TSQL code.
Session Goals
  • Demonstrate the difference in Set based and procedural based routines.
  • Describe why throwing hardware at the problem should not be the first port of call , but the last.
  • Introduce tally tables and show a few examples of how resource use can be lowered through their use
Speaker Bio: Dave has been working with SQLServer since the early days of 6.5. He currently works within the travel industry as a Database Designer / T-SQL Developer. He is very active on SqlServer central and MSDN forums and having fun solving and optimizing TSQL problems. He now also run the Kent Sql Server user group.
RegisterToAttend Agenda
The Orlando World Center
Resort Marriott
Hashtag:#sqlrally
Connect with us on Twitter
Presenting Sponsor
 
 
Silver Sponsors


 
  
 
 Bronze Sponsors