SQL Server Geeks Annual Summit 2016 Pre-Conference Seminars

Pre-Con Code PRECON001
Pre-Con Title Azure SQL Database—Build, Deploy, and Maintain Secure Fast Cloud Applications
Track(s) CL
Trainer Joesph D’Antoni
Abstract

SQL Azure was one of the first cloud services in Azure in 2009. The database service was limited in features and scale. The world has changed tremendously since then, and Azure SQL Database offers a world class platform that offers all of the features of SQL Server and more. In this full day session, you will learn how to architect applications to take advantages of the features of SQL Database, how to optimize cost management versus performance, and how to design cloud architectures to optimize performance and uptime.

Modules/Topics Include
  • Introduction to Azure SQL Database
  • Building Secure Application in SQL Database
  • Performance Tuning in SQL Database
  • Managing SQL Database
  • Designing cloud applications using SQL Database
Key Takeaways for The Audience
  • Understanding the differences between SQL Server and SQL Database
  • The tenants of cloud application design
  • How to build secure applications in Azure
Demos
  • Building a SQL Database
  • Using the Query Store and Query Performance Insight
  • Building a scale out solution in Azure SQL Database
Attendee Pre-requisite (if any)
  • Familiarity with SQL Server
  • Understanding of cloud principals
Date August 10, 2016
Time 9:00 am to 5:00 pm IST
Duration 8 hours
Venue Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)
What Is Included?
  • Level 300-400, exclusive content from Joesph D’Antoni
  • Gain real-world knowledge, get real-world exposure packed with real-world demos and examples
  • Get your own copy of course material developed by Joesph D’Antoni
  • 8 hours of interaction with the Master
  • Lunch, Snacks, Tea/Coffee & loads of fun!
  • And may be some surprise goodies 🙂
List Price July 1 to July 20                       : INR 7,500 + 15% Service Tax
July 21 to August 10               : INR 8,000 + 15% Service Tax

PS: Additional 3% service charge is only applicable for online payments
PS: Prices might change without any prior notice

Pre-Con Code PRECON003
Pre-Con Title SQL Server in a Highly Available World
Track(s) DBA/DEV
Trainer Denny Cherry
Abstract

In this day long pre-con session we will explore the various high availability options within SQL Server including how to configure these various options. We will be looking into Windows and SQL Server Clustering (including what is needed for a geographically dispersed cluster), Database Mirroring, The AlwaysOn features, and SQL Server Log Shipping.

In addition to working through these high availability options, we will be discussing the most important part of high availability configuration, making sure that you know how to select the correct high availability solution. After completing this high availability pre-con session you’ll be able to make the correct decision about which high availability decision to deploy, as well as how to correctly deploy the selected solution.

Modules/Topics Include
  • Database Mirroring
  • Failover Clustering
  • AlwaysOn Availability Groups
  • Log Shipping
  • Geographically Distributed Options
Key Takeaways for The Audience
  • Knowing when to use each of the various technological solutions which are available.
  • Knowing how to use all the various technological solutions which are available.
  • Understanding the differences between the various solutions which are available.
Demos
  • Setting up and working with a Failover Cluster
  • Setting up and working with an AlwaysOn Availability Group
  • Setting up and working with Database Mirroring
Attendee Pre-requisite (if any)
  • None
Date August 10, 2016
Time 9:00 am to 5:00 pm IST
Duration 8 hours
Venue Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)
What Is Included?
  • Level 300-400, exclusive content from Denny Cherry
  • Gain real-world knowledge, get real-world exposure packed with real-world demos and examples
  • Get your own copy of course material developed by Denny Cherry
  • 8 hours of interaction with the Master
  • Lunch, Snacks, Tea/Coffee & loads of fun!
  • And may be some surprise goodies 🙂
List Price July 1 to July 20                       : INR 7,500 + 15% Service Tax
July 21 to August 10               : INR 8,000 + 15% Service Tax

PS: Additional 3% service charge is only applicable for online payments
PS: Prices might change without any prior notice

Pre-Con Code PRECON004
Pre-Con Title Query Performance Tuning With Execution Plans
Track(s) DBA/DEV
Trainer Grant Fritchey
Abstract

At least 80% of all database performance problems can be related directly to your T-SQL code and your data structures. This full-day workshop gets right to the heart of that issue and shows you how to identify common performance problems using the tools available to you within SQL Server. With the problems identified, we then proceed to figure out how to address those problems using execution plans to understand the choices made by the query optimizer. You’ll learn multiple ways to capture execution plans, how to interpret them, and how to query them directly. All the examples and scripts will be immediately applicable to your systems. You can address your performance problems in order to make your T-SQL code run faster.

Modules/Topics Include
  1. Introduction to Execution Plans
    1. How execution plans are created
    2. How you can get execution plans
    3. Steps to query tuning
    4. The basics of reading an execution plan
  2. Common T-SQL Code Smells
    1. Functions and commands on predicates
    2. Data conversion (implicit & explicit)
    3. Cursors
    4. Nested views
    5. IF logic
    6. Multi-statement table-valued user-defined functions
  3. Worked Examples
    1. A series of different examples illustrating concepts learned so far in the session
  4. Querying the Plan Cache
    1. Using DMVs to query the plan cache
    2. Using XPath to query the execution plan
  5. More Worked Examples
    1. More examples adding to the concepts covered
  6. Parameter Sniffing
    1. Defining parameter sniffing
    2. Explaining what bad parameter sniffing is
    3. Show how to detect a possible bad parameter sniffing situation
    4. Show various mechanisms for fixing bad parameter sniffing including the strengths and weaknesses of each solution
  7. Additional Tools
    1. Supratimas
    2. SQL Sentry Plan Explorer
    3. Query Store
Key Takeaways for The Audience
  • Understand where, how and why performance issues appear within execution plans in order to better understand how to use execution plans to troubleshoot SQL Server query performance
Demos Every single module has multiple demos. This is a partial listing of the demos that will be walked through:

  • Functions on predicates
  • Data conversions (implicit & explicit)
  • Cursors
  • Nested views
  • IF logic
  • Multi-statement table-valued user-defined functions
  • Misc. worked examples
  • Mechanisms for querying plan cache
  • Various methods for addressing bad parameter sniffing
Attendee Pre-requisite (if any)
  • Fundamentals of SQL Server are assumed
  • T-SQL fundamentals are also assumed
  • General knowledge of databases and relational data structures are assumed
Date August 10, 2016
Time 9:00 am to 5:00 pm IST
Duration 8 hours
Venue Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)
What Is Included?
  • Level 300-400, exclusive content from Grant Fritchey
  • Gain real-world knowledge, get real-world exposure packed with real-world demos and examples
  • Get your own copy of course material developed by Grant Fritchey
  • 8 hours of interaction with the Master
  • Lunch, Snacks, Tea/Coffee & loads of fun!
  • And may be some surprise goodies 🙂
List Price July 1 to July 20                       : INR 7,500 + 15% Service Tax
July 21 to August 10               : INR 8,000 + 15% Service Tax

PS: Additional 3% service charge is only applicable for online payments
PS: Prices might change without any prior notice

Pre-Con Code PRECON005
Pre-Con Title SQL Server Masterclass for Business Intelligence Professionals
Track(s) BI
Trainer Jen Stirrup
Abstract

SQL Server Business Intelligence makes it easier to craft meaningful information and knowledge from your raw data. It delivers a comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions. Bring the Power of Data to every user in your organization! This Masterclass is for organizations who want to make the most of using their data, using the Microsoft SQL Server product suite. Join this one day SQL Server Masterclass to get the latest on SQL Server 2016 for the Business Intelligence and Data Visualization professional. Learn today through hands-on experience, and put it into practice tomorrow!

Join Jen Stirrup, Business Intelligence and Data Visualization industry veteran to learn more about what’s in SQL Server for the Business Intelligence specialist. You’ll get takeaway notes and experience hands-on demos that focus on integration with

  • Power BI
  • Excel
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
    • Datazen

There will be an emphasis on practical applications that mean you can make a difference in your organization, fast. Throughout the day, we will weave best practice data visualization theory so that, regardless of the technology, you will be able to apply the theory to make your data more meaningful and actionable.
You’ll get takeaway notes and experience hands-on labs to maximize your learning.

Modules/Topics Include
  • Overview of Microsoft SQL Server Business Intelligence
  • ETL for SQL Server Integration Services and Power Query
  • Data Modelling with SQL Server Analysis Services
  • Data Modelling with SQL Server Tabular Modelling and Power Pivot
  • Reporting with SQL Server Reporting Services
  • Enterprise Performance Management with Datazen
  • Self Service Business Intelligence Power BI
  • Self Service Analytics with R for the Business Intelligence Professional
Key Takeaways for The Audience
  • Self Service Business Intelligence for the Enterprise with SQL Server
  • Enterprise Data Storytelling using Visualization for effective decision making
  • Cleansing and Integrating your Data for Robust Business Intelligence
  • Self-Service Analytics with R
Demos
  • SSIS and Power Query Demos
  • Analysis Services cube demos
  • Tabular Modelling demos
  • PowerPivot demos
  • SSRS Reporting Demos
  • Power BI demos
  • Datazen demo
  • R demos for analytics
Attendee Pre-requisite (if any)
  • None, but if the users have a laptop with SQL Server on it, they can follow along with the demos.
Date August 10, 2016
Time 9:00 am to 5:00 pm IST
Duration 8 hours
Venue Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)
What Is Included?
  • Level 300-400, exclusive content from Jen Stirrup
  • Gain real-world knowledge, get real-world exposure packed with real-world demos and examples
  • Get your own copy of course material developed by Jen Stirrup
  • 8 hours of interaction with the Master
  • Lunch, Snacks, Tea/Coffee & loads of fun!
  • And may be some surprise goodies 🙂
List Price July 1 to July 20                       : INR 7,500 + 15% Service Tax
July 21 to August 10               : INR 8,000 + 15% Service Tax

PS: Additional 3% service charge is only applicable for online payments
PS: Prices might change without any prior notice