Agenda & Schedule
| DEV – Database Development | DBA –Database Administration | BIA – Business Intelligence and Analytics | BD – Big Data | CL – Cloud and Azure Platform |
| B = Basic, I = Intermediate, A= Advanced | ||||
| Thursday – 27th of August, 2015 | |||||
| Room | HYDRA | SPHINX | SHILOH | YUKON | |
| 07:30 – 16:30 | Registration & Helpdesk | ||||
| 08:45 – 09:15 | Opening Address | ||||
| 09:15 – 10:15 | Keynote 1 – T K (Ranga) Rengarajan (R1) | ||||
| 10:15 – 10:45 | Tea/Coffee Break, Sponsor/Exhibitor Time & Networking | ||||
| 10:45 – 11:45 | Swastik Chakraborty – New Style of IT for New Style of Workload – (DBA-12I) | Raj Chaudhuri – Shaping your SQL and MDX queries for various client scenarios – (DEV-07I) | Praveen Srivatsa – Centralized Auditing with SQL Service Broker – (DBA-08I) | Satya Shyam K Jayanty – Power BI – Deployment Best Practices to Deliver Data Analytics to The Business – (BIA-09I) | |
| 11:45 – 12:00 | Break | ||||
| 12:00 – 13:00 | Ajay Jagannathan – Improve Application Availability Using Online Operations in SQL Server – (DBA-02A) | Sanjay Mishra – SQL Server 2016: New Innovations – (DEV-02B) | Lara Rubbelke – Azure SQL Database: Now and in the Future – (CL-05I) | Nauzad Kapadia – HDInsight for Dummies – (BD-01B) | |
| 13:00 – 14:00 | Lunch | ||||
| 14:00 – 15:00 | Denny Cherry – SQL Server 2014 High Availability & Disaster Recovery – (DBA-02I) | Praveen Srivatsa – Working with streaming data with StreamInsight – (DEV-06I) | Alberto Ferrari – Tabular vs. Multidimensional in SQL Server Analysis Services – (BIA-02I) | Deepthi Anantharam – Business Prediction Using Microsoft Azure Machine Learning – (CL-01B) | |
| 15:00 – 15:15 | Break | ||||
| 15:15 – 16:15 | Joey D'Antoni – 5 Steps to Being a Top DBA-Learning Automation in SQL Server – (DBA-06I) | Sunil Agarwal – ColumnStore Index: SQL Server 2014 and Beyond – (DEV-05A) | Charles Gaddy – Introduction to Data Quality Techniques in SSIS – (BIA-02B) | Lara Rubbelke/Sudhir Rawat – Choosing Right Platform for Big Data Problem – (BD-02I) | |
| 16:15 – 16:45 | Tea/CoffeeBreak, Sponsor/Exhibitor Time & Networking | ||||
| 16:45 – 17:45 | Vijay Rodrigues – Security Features in Azure SQL Database PaaS – (CL-09I) | Dr Subramani Paramasivam – Advanced SQL 2014 Reporting Techniques & Managing Reports – (DEV-04I) | Aniruddha Deswandikar – SMAC and the Future of Data Analytics – (BIA-04I) | Debarchan Sarkar – Building a Real Time Analytic Dashboard in the Cloud – (CL-02I) | |
| 17:45 – 18:15 | Day 1 Closing Note | ||||
| Friday – 28th of August, 2015 | |||||
| Room | HYDRA | SPHINX | SHILOH | YUKON | |
| 07:30 – 17:45 | Registration & Helpdesk | ||||
| 09:00 – 09:45 | Keynote 2 – Srikanth Karnakota (Microsoft India) | ||||
| 09:45 – 10:15 | Tea/Coffee Break, Sponsor/Exhibitor Time & Networking | ||||
| 10:15 – 11:15 | Stuart Padley – Azure SQL Data Warehouse (inc. similarities/differences with APS) – (BD-04I) | Ajay Jagannathan – SQL Server 2016 – Performance, Scale and Diagnostics Improvements for a Screaming Database Engine – (DBA-01A) | Nauzad Kapadia – Using PowerQuery to Enrich Traditional Data Models – (BIA-07I) | Scott Klein – Top 5 SQL Server 2016 Hybrid Cloud Features – (CL-07I) | |
| 11:15 – 11:30 | Break | ||||
| 11:30 – 12:30 | Rangarajan Srirangam/Mandar Inamdar – Lessons Learnt from Large Customer Projects on SQL – (DBA-07A) | Sunil Agarwal – In-Memory OLTP: SQL Server 2014 and Beyond – (DEV-06A) | Sriharsha Narasimhan – HP ConvergedSystem 300 for Microsoft Analytics Platform – (BIA-06I) | Sanjay Mishra – Business Continuity with SQL Server – Real-Life War Stories – (DBA-09I) | |
| 12:30 – 13:30 | Lunch | ||||
| 13:30 – 14:30 | Amit Bansal/Manohar Punna – SQL Server Performance Tuning – Present and Future – (DEV-01A) | Haf Saba – SQL Server and Flash Memory: A Perfect Marriage! – (DBA-04I) | Praveen Srivatsa – Analytics with Column Store Index – (BIA-08I) | Sudhir Rawat – Build End to End Solution Using Microsoft Azure Data Factory – (BD-05I) | |
| 14:30 – 14:45 | Break | ||||
| 14:45 – 15:45 | Joey D'Antoni/Denny Cherry – AlwaysOn Availability Groups Best Practices and Notes from the Field – (DBA-05A) | Amit Khandelwal/Sumit Sarabhai – Troubleshooting SQL Server Tips & Techniques from the Field – (DEV-02A) | Raj Chaudhuri – SSRS : Exactly how powerful is it? Some unusual use cases – (BIA-03B) | Lara Rubbelke – Elastic Scale for Azure SQL Database – (CL-06I) | |
| 15:45 – 16:15 | Tea/Coffee Break, Sponsor/Exhibitor Time & Networking | ||||
| 16:15 – 17:15 | Benjamin Nevarez – Query Processing in In-Memory OLTP (Hekaton) – (DEV-03A) | Lakshmana Kumar Kothapalli – How to become a Rich DBA? – (DBA-07I) | Amit Govil – Content Packs for Power BI – (BIA-03I) | Scott Klein – Big Data for the SQL Ninja – (BD-03I) | |
| 17:15 – 17:30 | Break | ||||
| 17:30 – 18:30 | Andreas Wolter – Tracing With Extended Events – Top Features – (DBA-03A) | Mayur Tendulkar – Building Occasionally Connected Mobile Apps – (DEV-01B) | Scott Klein – Data Exposed – MSDN Channel 9 show | Kalpesh Parmar (Vic) – IoT and Azure Stream Analytics Query Language – (CL-04I) | |
| 18:30 – 19:00 | Surprise & Day 2 Closing Note | ||||
| Saturday – 29th of August, 2015 | ||||
| Room | HYDRA | SPHINX | SHILOH | YUKON |
| 07:30 – 16:30 | Registration & Helpdesk | |||
| 09:00 – 10:00 | Benjamin Nevarez – Dive into the Query Optimizer-Undocumented Insight – (DBA-04A) | Andreas Wolter – SQL Server Under Attack via SQL Injection – (DEV-01I) | Alberto Ferrari – Budgeting with Power Pivot – (BIA-01I) | Joey D'Antoni – Flying Through the Clouds-Performance Tuning in Azure – (CL-03I) |
| 10:00 – 10:30 | Tea Break / Sponsor, Exhibitor and Networking | |||
| 10:30 – 11:30 | Gaurav Mathur (IBM) – Transactional Replication (One-way) Internals – (DBA-03I) | Prashanth Kumar – SQL Server Dump Analysis – (DBA-06A) | Amit Govil – Data Refresh using Power BI REST APIs – (BIA-01B) | Dr. Subramani Paramasivam – Life Saver – Resource Governor for Applications and Reporting – (BIA-11I) |
| 11:30 – 11:45 | Break | |||
| 11:45 – 12:45 | Denny Cherry – Where Should I be Encrypting My Data – (DEV-04A) | Sarabpreet Singh/Ahmad Osama – DBA vs Developer – (DEV-08I) | Sunil Agarwal – Operational Analytics in SQL Server – (BIA-10I) | Nosheen Syed – How to get Started, latest features and best practices to run SQL Server in an Azure VM – (CL-02B) |
| 12:45 – 13:45 | Lunch | |||
| 13:45 – 14:45 | Satya Shyam K Jayanty – What do I Need to Know About Data Platform Upgrade Best Practices & Techniques – (DBA-11I) | Benjamin Nevarez – Understanding Parameter Sniffing – (DEV-02I) | Alberto Ferrari – Inside xVelocity In-Memory Analytics Engine – (BIA-01A) | Stuart Padley – SQL Server 2016 Stretch Database (transparently stretch SQL Server tables to Azure) – (CL-08I) |
| 14:45 – 15:00 | Break | |||
| 15:00 – 16:00 | Joey D'Antoni – Dealing with Bad Roomates–SQL Server Resource Governor – (DBA-05I) | Mahendraprasad Dubey/Narendra Angane – Evangelizing SQL Server Developer paradise – (DEV-05I) | Akbar Farishta/Rishi Maini – Replication Troubleshooting & Performance – (DBA-01I) | Debarchan Sarkar – Social Media Sentiment Analysis Using Hadoop on Windows Azure – (BD-01I) |
| 16:00 – 16:30 | Tea Break / Sponsor, Exhibitor and Networking | |||
| 16:30 – 17:30 | Mayank Shukla – SSIS Utility for Variable Comparison, Search and Trail – (BIA-05I) | Selvakumar Rajakumar – Bursting through the power of Datazen – (BIA-04B) | Satya Shyam K Jayanty – Let’s Cook ‘Affordable DBA Practices’ Using SQL Server Features – A Prolonged Journey from 2008 to 2016 – (DBA-10I) | |
| 17:30 – 18:30 | Another Surprise | |||
| 18:30 – 19:00 | Day 3 Closing Note and Group Photo | |||
Pre-Conference Seminars
| Pre-Con Code | PRECON001 |
| Pre-Con Title | Storage and Virtualisation for DBAs |
| Track(s) | DBA |
| Speaker | Denny Cherry |
| Abstract |
This session will be a two part session in which we will be focusing on two of the biggest topics in the DBA field. How to properly design your SAN storage solution and how to properly design your virtualization solution. The storage portion of this session will focus on SAN storage, but most of the material will apply to direct attached storage as well. In the first half of the session we’ll be focusing on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as the storage configuration. After going over the components we’ll dig into some advanced storage configurations. This includes RAID groups, multi-pathing software, and proper redundant storage network design. We will also be digging into some advanced storage array backup techniques including taking storage level clones and snapshots. After going over these advanced techniques we will dig into how these can best be used to backup the SQL Server environment to provide maximum redundancy with no recurring tape costs. In addition to theory, we’ll be looking at an actual SAN so that we can translate what we see in the Storage Array with what we see on the actual server. In the second half of the day we’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like everything in the database world there are no hard set answers as to if virtualization is a good idea or not, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and virtualization isn’t a good idea. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. We’ll look into how tie the virtual platforms to the storage array so that you can maximize the storage performance for your SQL Servers and the virtual environment. Learn to talk to the storage admin. Learn best practices for server and storage configuration. Learn how to troubleshoot storage issues. Why Thin provisioning can be bad for SQL Server. Network Design. |
| Time | 9:00 am to 5:00 pm IST |
| Duration | 8 hours |
| Location | NIMHANS Convention Center |
| What Is Included? |
|
| List Price |
(Super Early Bird) Until June 30 : INR 6,000 + 14% Service Tax (Early Bird) July 1 to July 31 : INR 6,750 + 14% Service Tax (Regular) August 1 to August 26 : INR 7,750 + 14% Service Tax |
| Pre-Con Code | PRECON002 |
| Pre-Con Title | Power BI |
| Track(s) | Business Intelligence, Analytics, Developer, Cloud, Big Data |
| Speaker | Alberto Ferrari |
| Abstract |
Microsoft Power BI is a cloud service that provide a complete self-service analytics solution, including tools for data extraction, transformation, modeling and visualization. Data modeling is possible by using both Excel or Power BI Designer. The Power BI Service enables you to create reports and dashboards, sharing them with other users. Mobile apps for several platforms also improve access on any device. In this full-day seminar, you are guided in creating a complete solution step-by-step, using all the features of Power BI. Starting from scratch, you see how to create query in a visual way to import and integrate data from many different sources, with a particular attention on leveraging existing data in the company, transforming data in order to improve the resulting model and sharing the results of the queries created, so that they will be easy to reuse. Then you see how to create a data model following the best practices and using the resources available on the web in order to accelerate the creation of tables and formulas that can be shared in many models. The reference data model will improve over the day, adding metadata to improve the usability of other Power BI features. You will also learn how to connect to existing on-premises data models in Analysis Services, without copying and storing data in the cloud. Once the data model is ready, you see how to create reports and dashboards in Power BI, leveraging the many data visualizations available. After publishing the result on Power BI site, you see how to refresh the data on the cloud, including all the details about correct configuration and best practices for moving on premise data to the cloud in a secure way. At the end of the day, you will be ready to start using the entire Power BI stack in your company, choosing the right feature for each requirement and applying the best practices in each step. |
| Time | 9:00 am to 5:00 pm IST |
| Duration | 8 hours |
| Location | NIMHANS Convention Center |
| What Is Included? |
|
| List Price |
(Super Early Bird) Until June 30 : INR 6,000 + 14% Service Tax (Early Bird) July 1 to July 31 : INR 6,750 + 14% Service Tax (Regular) August 1 to August 26 : INR 7,750 + 14% Service Tax |
| Pre-Con Code | PRECON004 |
| Pre-Con Title | SQL Server Query Tuning & Optimization |
| Track(s) | Developer, DBA |
| Speaker | Benjamin Nevarez |
| Abstract |
This full-day seminar will show you how to optimize SQL Server queries and create high-performance applications. You will learn about the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You’ll also get tips for troubleshooting underperforming queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, will be covered as well. Topics include:
|
| Time | 9:00 am to 5:00 pm IST |
| Duration | 8 hours |
| Location | NIMHANS Convention Center |
| What Is Included? |
|
| List Price |
(Super Early Bird) Until June 30 : INR 6,000 + 14% Service Tax (Early Bird) July 1 to July 31 : INR 6,750 + 14% Service Tax (Regular) August 1 to August 26 : INR 7,750 + 14% Service Tax |
Breakout Sessions
| DEV – Database Development | DBA –Database Administration | BIA – Business Intelligence and Analytics | BD – Big Data | CL – Cloud and Azure Platform |
| B = Basic, I = Intermediate, A= Advanced | ||||
Important Notes:
- All sessions listed below are Breakout Sessions of one hour each.
- This is the first release. More sessions will be added regularly, almost on a daily basis.
- There may be minor adjustments to the sessions listed below without any prior notice.
- PDF download will be available shortly.
- Final schedule (day/time/room for each session) will be available by 3rd week of August.
- For any errors/corrections, please write to admin
[at]sqlservergeeks[dot]com.
| Session Title & Code | Abstract | Level | Speaker |
| SQL Server 2016 – Performance, Scale and Diagnostics Improvements for a Screaming Database Engine – (DBA-01A) | This session will talk about several improvements in the Database Engine for SQL Server 2016 that addresses some of the most common customer pain points involving tempdb, new CE, partitioning, alter column as well as diagnostics for troubleshooting query plans, memory grants, AlwaysOn and Backup/Restore. Come see this demo filled session to understand these changes in performance and scale of the database engine, new and improved diagnostics for faster troubleshooting and mitigation. Learn the benefits of upgrading and using these features to run SQL Server workloads with screaming performance. | Advanced | Ajay Jagannathan |
| Improve Application Availability Using Online Operations in SQL Server – (DBA-02A) | No DBA would like their 24×7 mission critical OLTP application to be down just for database maintenance activities. This demo filled session shows you how you can leverage new enhancements for some of the most common database administration tasks – Partitioning and Online Index Rebuilds and make them run efficiently thereby improving application availability. | Advanced | Ajay Jagannathan |
| Replication Troubleshooting & Performance – (DBA-01I) | Transactional replication – Agent failure troubleshooting Transactional replication – Latency troubleshooting Merge replication – Basics/Concepts Merge replication – Troubleshooting, best practices Replication and AlwaysOn (If time permits) |
Intermediate | Akbar Farishta / Rishi Maini |
| Tracing With Extended Events – Top Features – (DBA-03A) | Extended Events (aka XEvents), which entered the product in SQL Server 2008, are replacing the old SQL Trace & Profiler – and there are many good reasons for that. In this session MCM + MCSM Andreas Wolter will demonstrate a selection of the most fascinating possibilities using this Tracing Framework. If you want to find out how to trace in a flexible and lightweight way, how to do advanced analysis directly inside the GUI, how to audit Database and Table-access with Standard edition, analyze deadlocks without old-fashioned TraceFlags based on the built-in system_health session, this session is just for you. Having started my lectures on Tracing with Extended Events in 2012 under the slogan “Hasta la vista, Profiler”, I hope to convince the last one, to kick Profiler out of the door. | Advanced | Andreas Wolter |
| Dive into the Query Optimizer-Undocumented Insight – (DBA-04A) | The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. Why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are still being addressed today will be covered as well. | Advanced | Benjamin Nevarez |
| SQL Server 2014 High Availability & Disaster Recovery – (DBA-02I) | In this session we will look at options which are available to the administrator of a Microsoft SQL Server 2014 database server so that the system can provide the 99.99% or higher uptime which customers demand. These options will include Failover Cluster Instances, as well as AlwaysOn Availability Groups within a single site, stretching across multiple sites, as well as stretching into the Windows Azure public cloud. We’ll learn when we want to use each technique, how to decide which option to implement, and how to implement these solutions. | Intermediate | Denny Cherry |
| Transactional Replication (One-way) Internals – (DBA-03I) | In this session, we will learn the following:
|
Intermediate | Gaurav Mathur |
| Dealing with Bad Roomates–SQL Server Resource Governor – (DBA-05I) | Do you manage systems with a wide variety or workloads? Given budgeting and licensing constraints database servers have seen dramatic amounts of database consolidation. Managing performance in a densely consolidated environments is always a challenge–you have some users who are trying to run reports, while you have other uses that are trying to execute OLTP workloads. What if there was a way to do load balancing between these workloads, while putting your feet up on your desk? Well, there is and it’s called the Resource Governor.
The Resource Governor was introduced in SQL Server 2008, and has progressively gotten better and new features have gotten added–starting with SQL Server 2014 you can limit I/O use. In this session you will learn about how the Resource Governor works, as well as best practices and use cases. You will learn how to profile your workloads and keep all of your users and applications happy. |
Intermediate | Joseph D’Antoni |
| 5 Steps to Being a Top DBA-Learning Automation in SQL Server – (DBA-06I) | Being a DBA is tough job–there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
This session will benefit both Junior and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.. |
Intermediate | Joseph D’Antoni |
| AlwaysOn Availability Groups Best Practices and Notes from the Field – (DBA-05A) | AlwaysOn Availability Groups are a key part of any modern disaster recovery using SQL Server. In this session you will learn about best practices for implementation, changes in each version of SQL Server, and an understanding of how Windows needs to be configured for optimal performance. We will also share case studies and best practices from many implementations in the wild. | Advanced | Denny Cherry / Joseph D’Antoni |
| How to become a Rich DBA? – (DBA-07I) | Since my first job I worked on many technically challenging projects and worked with many talented leaders and team members who motivated and inspired me and encouraged me to keep learning new things. This includes both technical aspects and more importantly non-technical aspects which helped me grow myself and people around me. In my session I will share some of my experiences and how they helped me, my team and our business:
Best practices you can adopt as Database Engineer. How Database Administrators can help application developers understand potential challenges related to data growth. Simple techniques to monitor and analyze storage capacity using custom SSMS reports for Database Administrators. SAN technologies that we use in our business which allows us to present terabytes of refreshed data to our customers and to our internal users in minutes. Why it is important to spend quality time on learning and practicing few non-technical aspects which your job my not expect from you today. |
Intermediate | Lakshmana Kumar Kothapalli |
| SQL Server Dump Analysis – (DBA-06A) | While dealing with SQL Server administration, you might have come across scenarios when a session terminates abruptly, SQL Server instance crashes, SQL Server cluster fails over without a graceful message. Most often, it leaves a dump file behind which is unfortunately not in a human readable format. In this one hour session, you will learn the basics of a dump file, the tools available for reading through a dump, the different types of dumps and demos on various debugger commands, how to analyze a dump file to establish the root cause. | Advanced | Prashant Kumar |
| Centralized Auditing with SQL Service Broker – (DBA-08I) | In this session, we dive deep into asynchronous design pattern for implementing distributed data auditing in a central store using the SQL Service Broker. This pattern helps us in implementing centralized solutions like security and auditing across multiple different applications. | Intermediate | Praveen Srivatsa |
| Lessons Learnt from Large Customer Projects on SQL – (DBA-07A) | This session will focus on key lessons learnt from large or complex SQL projects deployed on-premises and on the cloud. We will cover specific challenges faced on aspects such as performance, scale, disaster recovery, high availability, security etc., and interesting solution approaches adopted. The rationale behind choices made, and the results achieved will be discussed. We will also consider if alternate approaches were possible and if the chosen approaches had specific consequences on other aspects such as maintainability or extensibility. | Advanced | Rangarajan Srirangam / Mandar Inamdar |
| Business Continuity with SQL Server – Real-Life War Stories – (DBA-09I) | Having worked with hundreds of customers over the years on their high availability and disaster recovery deployments, at SQLCAT, we have learned a few things. We have learned how old problems are solved by new technologies, and how new technologies bring up new challenges. We have learned what customers do when situations put them between a rock and a hard place, how they solve tough business problems, how they circumvent technology limitations. We will share these lessons with you in the form of war stories – stories you can apply to your world when you or someone you know encounter such situations. | Intermediate | Sanjay Mishra |
| Let’s Cook ‘Affordable DBA Practices’ Using SQL Server Features – A Prolonged Journey from 2008 to 2016 – (DBA-10I) | DBA trade is still in-demand and will remain as long as databases are alive! If you are an average IT person/Developer/SysAdmin who has been managing development and databases in your organization, now you want to manage SQL Server databases using tricks of DBA trade and you’ve got no idea what to do with it! In this session we will overview range of topics that every DBA handles, such as: backup/restore strategy, high availability, scalability and performance tuning. We will touch base on how best SQL Server technology will offer home-grown tools to keep your BAU tasks. Not giving opportunity of riding a super-duper car, but best learning techniques on how to manage your SQL Server database and make it efficient enough to run like a fast car on performance aspects. You will get o know what is needed to get that new features to implement, how best they can fit in. All the examples and demos in this session are originated from real-world work from my (18 years) Consulting experience. |
Intermediate | Satya Shyam K Jayanty |
| What do I Need to Know About Data Platform Upgrade Best Practices & Techniques – (DBA-11I) | Why Upgrade? Why Upgrade? Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe & India), SQLPASS, SQLSaturdays and SQLbits since the year 2008. In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 & SQL Server 2012/2014 (with a good overview on 2016 too) by using best practices and available resources. |
Intermediate | Satya Shyam K Jayanty |
| New Style of IT for New Style of Workload – (DBA-12I) | Tier 1 mission critical data processing demands in the OLTP realm often require very high transactional performance databases and are often implemented using dedicated physical database servers and storage. The high I/O and low latency requirements of these tier 1 databases preclude platform sharing with lower priority tier 2 databases. In addition to raw performance, these tier 1 systems must have high availability, and strong fault tolerance. On the other hand, tier 2 business critical systems are often built using several smaller database servers and shared storage. This combination of physical and virtual servers deployed on multiple platforms often strains IT resources to manage and has extended costs in terms of licensing and maintenance. A platform that can be used to address both business challenges need:
|
Intermediate | Swastik Chakraborty |
| Session Title & Code | Abstract | Level | Speaker |
| SQL Server Performance Tuning – Present and Future – (DEV-01A) | When it comes to performance tuning, a DBA is challenged with many problems and many solutions. In this session you will experience a journey through performance tuning in SQL Server from intermediate to advanced level. Amit will be covering the performance tuning techniques available in the current versions of SQL Server. How to identify the performance issues and the best methods to troubleshoot and provide a long term solution. Manu will be covering what SQL Server has to offer for performance tuning in the next version. The performance tuning techniques available in SQL Server 2016 that adds few extra points to the decision making to upgrade. |
Advanced | Amit Bansal / Manohar Punna |
| Troubleshooting SQL Server Tips & Techniques from the Field – (DEV-02A) | This session discusses some of the performance troubleshooting scenarios for SQL Server. Through demos, learn how to troubleshoot SQL Server performance issues and making sure it works excellently for your workload. Also, expect a few demos on some of the great in-house tools available for public consumption to troubleshoot complex performance problems. | Advanced | Amit Khandelwal / Sumit Sarabhai |
| SQL Server Under Attack via SQL Injection – (DEV-01I) | One of the most often successfully attacked targets is the data that resides in a database server. SQL Server is considered “secure by default”, but this is only relevant until the first databases and configurations have been changed. Which is why most of the exploited weaknesses are due to misconfiguration or weak coding practices as opposed to security bugs in SQL Server itself, of which we had the first one since 7 years in 2014. In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual SQL Injection, including a broadly unknown elevation of privileges attack for a non-sa account. If you have a database-server which is accessible by processes beyond your direct control or that even can be reached by some kind of frontend applications and you are unsure regarding the possible security implications to watch out for, this session is meant for you. | Intermediate | Andreas Wolter |
| Query Processing in In-Memory OLTP (Hekaton) – (DEV-03A) | In-Memory OLTP (code name Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained. | Advanced | Benjamin Nevarez |
| Understanding Parameter Sniffing – (DEV-02I) | Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics. | Intermediate | Benjamin Nevarez | Tips and Tricks for SQL Server Developers – (DEV-03I) | There are a lot of features and patterns that many developers probably aren’t aware of. Let’s look at some of them and how they can make your life a lot easier | Intermediate | Dave Dustin |
| Where Should I be Encrypting My Data – (DEV-04A) | IIn this session we’ll be looking at all the various places within the application stack that data can be encrypted or hashed, so that as an application/database administrator/developer/architect you can make the best decision as to where in the application stack to do this work. These layers include the application layer, the middle tier, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs. Encrypting and Hashing data within Application Tier Encrypting data within the Database tier Encrypting data within the MPIO / HBA |
Advanced | Denny Cherry |
| Advanced SQL 2014 Reporting Techniques & Managing Reports – (DEV-04I) | To manage reports, users, user activity, failed reports, failed subscriptions, report history, snapshots & other activities with a live dashboard. Take away a working dashboard to monitor all of these after this session. | Intermediate | Dr. Subramani Paramasivam |
| Evangelizing SQL Server Developer paradise – (DEV-05I) | In this session we will explore rarely but most effective used features by SQL developer community that will help improve performance speed by using same hardware you have today—and improve reliability at the same time. | Intermediate | Mahendraprasad Dubey / Narendra Angane |
| Building Occasionally Connected Mobile Apps – (DEV-01B) | All mobile apps face the challenge of intermittent network connectivity. Regardless, your users expect their data available to them all the time, so giving them anything less is sure to result in a poor user experience. In this session, attendees will get to know different techniques to build occasionally connected system with data caching and synchronization using popular tools and libraries. | Basic | Mayur Tendulkar |
| Working with streaming data with StreamInsight – (DEV-06I) | With IoT gaining more momentum, applications will need to handle large streams of data. StreamInsight is Microsoft solution for CEP (complex event processing) that can handle large streams of data and analyze the same in real-time. In this session, we explore how to deal with a large data stream using StreamInsight. | Intermediate | Praveen Srivatsa |
| Shaping your SQL and MDX queries for various client scenarios – (DEV-07I) | We all spend a lot of time optimizing the ‘selection’ part of our queries: the part that follows WHERE in SQL. But in today’s world, the ‘projection’ part, the part between SELECT and FROM, is also very important, especially considering the wide variety of client software that the query results can end up in. This session looks at a selection of client scenarios and software, and discusses how to write SQL and MDX queries in a manner which provides most power to these scenarios. | Intermediate | Raj Chaudhuri |
| SQL Server 2016: New Innovations – (DEV-02B) | Everything you want to know about next-generation SQL Server, mission critical performance and scale for transactional, data warehouse and mixed workloads, structured and unstructured data, security innovations, availability and reliability improvements, advanced analytics, business intelligence, world class scale on-prem and to the cloud. | Basic | Sanjay Mishra |
| DBA vs Developer – (DEV-08I) | Ahmad and Sarabpreet are back with their blockbuster session from popular SQL Server Day Events (fresh content has been added) Bugs, Crashes, Meltdowns, we lead into issues almost every day. The foremost thing we do is to find whose fault it is. Is it the developer who wrote the bad code or is it the DBA who didn’t plan the maintenance? It’s high time we take over this blame game and decide issues as a squad. In this grueling, demo heavy session, Sarabpreet and Ahmad will play as a DBA and developer to resolve real life bugs and performance issues collectively. If you receive such kind of friction between these two in your organization this session is for you. |
Intermediate | Sarabpreet Singh / Ahmad Osama |
| ColumnStore Index: SQL Server 2014 and Beyond – (DEV-05A) | The updateable clustered columnstore in SQL Server 2014 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional btree-based schemas. This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 | Advanced | Sunil Agarwal |
| In-Memory OLTP: SQL Server 2014 and Beyond – (DEV-06A) | SQL Server 2014 introduced in-memory technology for optimizing OLTP workloads. This talk provides an overview of the in-memory technology using common use cases. Additionally, we will take a deep dive into how in-memory tables and indexes are managed in memory and on storage. You will also learn how to provision and control memory usage, how durability and high availability is achieved and how these constructs and operations are integrated together with disk-based tables to provide you a seamless experience. | Advanced | Sunil Agarwal |
| Session Title | Abstract | Level | Speaker |
| Inside xVelocity In-Memory Analytics Engine – (BIA-01A) | The xVelocity engine used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq. We will show common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model. | Advanced | Alberto Ferrari |
| Budgeting with Power Pivot – (BIA-01I) | Budgeting is one of the most challenging scenarios in the Power Pivot arena. For example, you might need to summarize sales in previous years and to allocate the budget forecasts. You have to work with data at different granularities and to find a way to author DAX code to compute the forecasts at the desired granularity. When it comes to budgeting, each company is a unique scenario. In this session, Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on products that do not yet exist. |
Intermediate | Alberto Ferrari |
| Tabular vs. Multidimensional in SQL Server Analysis Services – (BIA-02I) | Since 2012, SQL Server Analysis Services has two engines: Tabular and Multidimensional. Somebody believes Multidimensional is granny stuff and aim to learn only Tabular. Somebody trust only the good-old well-debugged code of Multidimensional, and ignores Tabular. We try to use a more informed approach: by looking at the difference in features, hardware requirements, scalability, required knowledge and business needs, we will discuss which engine to use for which kind of project. The goal is to teach when to use what, and to avoid the common mistakes of choosing the wrong technology, which might be a very expensive error. | Intermediate | Alberto Ferrari |
| Content Packs for Power BI – (BIA-03I) | This session will explain about the power of Content packs for various SaaS providers (Microsoft Dynamics CRM, Google analytics, Salesforce, etc.) in the new Power BI and how the users can leverage pre-built dashboards and reports that are updated continuously and automatically and utilize Power BI’s powerful natural language search for instant insights with the underlying data. | Intermediate | Amit Govil |
| Data Refresh using Power BI REST APIs – (BIA-01B) | This session talks about the Power BI REST APIs that provide programmatic access to Dashboard resources such as Datasets, Tables, and Rows in Power BI and how to use these APIs to push data directly from an application into a dataset in Power BI. Hence, the dashboards will be updated in real-time when the data changes. | Basic | Amit Govil |
| SMAC and the Future of Data Analytics – (BIA-04I) | Social and Mobile Data Analytics is now mainstream. And Cloud is making it accessible to companies that wish to analyze data from millions of devices and improve predictions for their business, provide better services to the customers and increase customer mindshare. Yet, the Smart Apps running on Smart Phones seem rather dull and are very heavily dependent on this huge source of intelligence in the cloud and users seem to be at the mercy of the quality of connection they have and amount of power left on their device.
Is there a way out? Are there some novel architectures out there that can truly empower these Apps and make them smarter? Is it possible for these Apps to take on some of the Data Analytics using the powerful hardware under them? What would it take to make these Apps passively-active? I would love to share my thoughts around this and also listen to your ideas in this breakout session. |
Intermediate | Aniruddha Deswandikar |
| Introduction to Data Quality Techniques in SSIS – (BIA-02B) | Participate in an introduction session to Data Quality concepts focused on the Microsoft SSIS environment with advanced techniques for data cleansing explained. Covering the entire data quality spectrum we will review and discuss the key components of data quality as defined by Gartner and the industry. Profiling, matching, address hygiene are all topic areas of discussion in this session, as well as, how data quality challenges are addressed with MelissaData Data’s components for SSIS. | Basic | Charles Gaddy |
| SSIS Utility for Variable Comparison, Search and Trail – (BIA-05I) | Demo of SSIS Utility – Business Intelligence is always an important area for analysis, reporting and Data integration. Most popular module within Microsoft BIDS is SSIS which supplements our Sql Data demands. Lot of engineers working on SSIS maintenance projects struggle for below challenges:
To address above concerns, I have created a tool which easily addresses these issues and makes our life easy. Currently this tool is used by my whole team including Onsite. It also helped my colleagues of previous organization. |
Intermediate | Mayank Shukla |
| HP ConvergedSystem 300 for Microsoft Analytics Platform – (BIA-06I) | The Microsoft Analytics Platform System (APS) appliance provides a MPP scale-out solution for relational data warehouse implementations. The appliance has evolved from simply a collection of on premise servers to an integrated hybrid (on premise/cloud) appliance that enables customers to gain valuable insight no matter where the data lives. This session will provide an overview of the APS appliance, its capabilities and how the Azure SQL Data Warehouse cloud delivers value on premise. |
Intermediate | Sriharsha Narasimhan |
| Using PowerQuery to Enrich Traditional Data Models – (BIA-07I) | PowerQuery is part of the PowerBI stack and it enhances the self-service business intelligence experience by simplifying data discovery, access and collaboration. PowerQuery can be used to query on-premise structured data sources or semi-structed data available on the internet or social media trends, apply transformations on that data and then merge it with the traditional data model; thereby allowing managers to co-relate their sales information coming from the ERP system with social media sentiment analysis and compare it with their competitor’s sales information obtained from the internet. In this demo packed session, we will use PowerQuery to query different data sources, apply extensive transformations to the data and see different ways in which in can compliment traditional data sources. | Intermediate | Nauzad Kapadia |
| Analytics with Column Store Index – (BIA-08I) | Column stores are optimized data stores for high end analytics. In this session, we compare and contrast the traditional OLAP querying methods with that of a column store and talk about the best solution for a high end analytics solution. | Intermediate | Praveen Srivatsa |
| SSRS : Exactly how powerful is it? Some unusual use cases – (BIA-03B) | Usually, Reporting Services is associated with boring old tabular reports, with maybe a chart or a crosstab thrown in. But it doesn’t have to be that way. In this session, we will see reporting services being used to produce some unusual and interesting kind of reports, including trellis charts, heat maps and dynamic infographics. We will also see some interesting ways of making reports interactive. | Basic | Raj Chaudhuri |
| Power BI – Deployment Best Practices to Deliver Data Analytics to The Business – (BIA-09I) | How to deploy Power BI, how to implement configuration parameters and package BI features as a part of Office 365 roll out in your organisation. Having said that, cloud computing is another aspect of this technology made is possible to get data within few clicks and ticks to the end-user. Let us review how to manage & connect on-premise data to cloud capabilities that can offer full advantage of data catalogue capabilities by keeping data secure as per Information Governance standards. Not just with nuts and bolts, performance is another aspect that every Admin is keeping up, let us look into few settings on how to maximize performance to optimize access to data as required. Gain understanding and insight into number of tools that are available for your Business Intelligence needs. There will be a showcase of events to demonstrate where to begin and how to proceed in BI world. |
Intermediate | Satya Shyam K Jayanty |
| Bursting through the power of Datazen – (BIA-04B) | Understanding the Architecture, Capabilities, Features of Datazen and leveraging it’s visual capabilities across devices. | Basic | Selvakumar Rajakumar |
| Operational Analytics in SQL Server – (BIA-10I) | SQL Server 16 enables customers can run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Operational Analytics. | Intermediate | Sunil Agarwal |
| Session Title | Abstract | Level | Speaker |
| Planning, Implementing and Managing a Hybrid SQL Server Environment – (CL-01I) | Discussing options for extending or migrating existing on-premises SQL instances to ‘the cloud’ | Intermediate | Dave Dustin |
| Building a Real Time Analytic Dashboard in the Cloud – (CL-02I) | As opposed to traditional batch processing systems built on Hadoop, this demo will focus on the real time capabilities that can be built on top of Hadoop on Windows Azure with the help of surrounding modern day open source technologies. | Intermediate | Debarchan Sarkar |
| Business Prediction Using Microsoft Azure Machine Learning – (CL-01B) | Machines learning about data trends for predictions is a rapidly growing science. Microsoft’s cloud platform Azure offers a new service enabling users to predict outcome and productionize the same. It connects to various data sets and provides an ability to cleanse data before modelling which improves accuracy. | Basic | Deepthi Anantharam |
| Flying Through the Clouds-Performance Tuning in Azure – (CL-03I) | So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review. |
Intermediate | Joseph D’Antoni |
| IoT and Azure Stream Analytics Query Language – (CL-04I) | If you are an expert in SQL, it’s time to learn SAQL (Stream Analytics Query Language), the query language that gets data form devices, sensors, web sites, applications, static data, historic data, social media, and infrastructure systems to name a few, allowing you to do real-time analytic computations, detect patterns or the lack of patterns, visualize, alert, or act in near real-time, with various capabilities such as filtering, performing windowing functions on live streaming data and join multiple streams from various inputs in real time.
The future of data analytics and you is not just SQL Server. The future is in the vast amount of data that gets generated from connected devices, IoT and many such sources. Come join me in exploring the limitless possibilities that Azure Stream Analytics and SAQL brings on the table.n |
Intermediate | Kalpesh J Parmar |
| Elastic Scale for Azure SQL Database – (CL-06I) | Microsoft Azure SQL DB makes it easier to build and manage demanding and scalable data tiers for cloud applications. This session explores new Azure SQL Database features that support elastic scale data workloads including Elastic Database Pools, Elastic Database Queries, and deploying shared database models with Elastic Database Tools. | Intermediate | Lara Rubbelke |
| How to get Started, latest features and best practices to run SQL Server in an Azure VM – (CL-02B) | Azure as a cloud platform provides great benefits of cloud in terms of scaling while making it super easy for setting up solutions like HADR (Always On), Management activities like Back Up and Patching, using Provisioned IOPS for better performance. Whether setting up Hybrid solutions or fully manageable cloud instances, SQL Server on Azure has evolved as a major database workload service for Enterprise customers. Come learn about the latest features of the platform and portal experiences to start using SQL Server on Azure. | Basic | Nosheen Syed |
| Top 5 SQL Server 2016 Hybrid Cloud Features – (CL-07I) | Microsoft SQL Server 2016 builds on the awesome hybrid capabilities in SQL Server 2014 which simplify cloud adoption and help you unlock new hybrid scenarios. Building on this momentum, this demo-filled session will highlight these features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud to provide new disaster recovery and backup solutions. In this session we will look at 5 great hybrid scenarios that are made possible by both great new features as well as enhanced features of SQL Server 2016. We’ll not only look how to use and implement these hybrid features, but also look at look at and discuss scenarios around why you would use these hybrid cloud features to expand your on-premises options without adding complexity. We’ll look at how you can easily move workloads from your datacenter to Windows Azure while still maintaining a complete view of your infrastructure with increased proficiency and reduced cost. | Intermediate | Scott Klein |
| SQL Server 2016 Stretch Database (transparently stretch SQL Server tables to Azure) – (CL-08I) | Tables grown so big you dread to re-index? Long DB restore times due to large amounts of cold data? SAN budget all used up but end-users won’t allow data truncation? Imagine a solution that stretches a SQL Server table to Azure without application changes. Existing apps/queries continue to work. Maintenance operations take less time and resources while overall cost is lowered. Come find out how you can leverage this hybrid deployment while DBAs retain full control from the on-premises SQL Server. | Intermediate | Stuart Padley |
| Security Features in Azure SQL Database PaaS -(CL-09I) | While the Azure cloud service offers sophisticated, layered defenses to secure its services, Azure SQL DB offers additional security features to let customers tailor their databases to meet application needs yet at the same time minimize the chances of an incident. In this presentation, we will focus on customer-facing security features that must be configured correctly to meet the security and privacy needs of an application throughout the development cycle from prototyping, to test-in-production, to production deployment. | Intermediate | Vijay Rodrigues |
| Session Title | Abstract | Level | Speaker |
| Social Media Sentiment Analysis Using Hadoop on Windows Azure – (BD-01I) | This is a demonstration based session which will show how to use a HDInsight (Apache Hadoop exposed as an Azure Service) cluster to do sentiment analysis from live Twitter feeds on a specific keyword or brand. Sentiment analysis is parsing unstructured data that represents opinions, emotions, and attitudes contained in sources such as social media posts, blogs, online product reviews, and customer support interactions. | Advanced | Debarchan Sarkar |
| Choosing Right Platform for Big Data Problem – (BD-02I) | Microsoft HDInsight service offer different type of clusters (Hadoop, HBase, Storm, SPARK, Hadoop on Linux etc..) . That creates confusion what type of cluster I need to choose for my business load. We’ll discuss about the use cases of different types of cluster which help you to decide. Let us look at what is best applicable in the practical world. Also, What are the tools available to setup cluster, managing and deployment easier? We’ll also discuss how we extend cluster creation using script action | Intermediate | Lara Rubbelke / Sudhir Rawat |
| HDInsight for Dummies – (BD-01B) | Big data is becoming one of the most important technologies that has the potential for altering the way in which organizations use data to transform their business models. Big data is a combination of data management tools and technologies that enable organizations to store, manage and manipulate vast amounts of data at the right speed and at the right time to allow them to take maximum benefit of it. This sessions is targeted for those who are interested in coming to grips with this technology, but don’t know where to start. It will introduce you to the most important tools and APIs like Map-Reduce, Hive, Sqoop, Oozie etc. and show you how they can be put to use using the HDInsight service provided by Azure. | Basic | Nauzad Kapadia |
| Big Data for the SQL Ninja – (BD-03I) | As more enterprises start implementing big data solutions, how does the DBA support these efforts and do they have the skills and knowledge to integrate big data solutions into your current architecture and processes? This demo-filled session has two purposes; first, to help DBAs understand how to apply their existing SQL Server skills in understanding and utilizing HDInsight and related technologies. Big data technologies don’t need to be intimidating, and this session will help DBAs see how they can easily apply their current skill when working with big data. Second, this session will show how SQL Server and HDInsight be used together to create solutions to solve big data problems without the complexities of massive learning curves and using technologies DBAs are already familiar with. We’ll look at technologies that make working with big data much less daunting, including HiveQL and Sqoop, both of which don’t require a rocket science degree to use. | Intermediate | Scott Klein |
| Azure SQL Data Warehouse (inc. similarities/differences with APS) – (BD-04I) | Azure SQL Data Warehouse is a fully managed, elastic and petabyte-scale columnar data-warehouse service that’s fully compatible and integrated with the Microsoft SQL Server and BI ecosystem. This is the first enterprise class Massively Parallel Processing (MPP) cloud data warehouse service to enable customers to scale compute capacity up or down in seconds. SQL Data Warehouse can independently scale storage and compute power, so customers only pay for the query performance they need. Built on top of SQL Server, SQL Data Warehouse offers access to a large data warehouse ecosystem of tools that support data loading, transformation, visualization, and analytical scenarios—including Microsoft Power BI, Azure HDInsight, Machine Learning, and Data Factory, as well as supporting hybrid implementations of modern data warehousing. SQL Data Warehouse, together with Microsoft’s on-premises Massively Parallel Processing (MPP) modern data warehouse, the Analytics Platform System (APS), offer customers a choice: in the cloud, on-premises or both, truly enabling a modern hybrid approach to data driven analytics and data warehousing. | Intermediate | Stuart Padley |
| Build End to End Solution Using Microsoft Azure Data Factory – (BD-05I) | The data landscape is more varied than ever with unstructured and structured data originating from many cloud and on-premises sources. Combining and shaping complex data can take more than one try to get right, and changing data models can be costly and time consuming. Data Factory enables you to process on-premises data like SQL Server, together with cloud data like Azure SQL Database, Blobs, and Tables. This demo based session will focus on development of ADF solutions. | Intermediate | Sudhir Rawat |
Conference Material
To access all the session decks, click here.