Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Session 2:SQL Server Index Tuning
Amit R S Bansal (MCM, MVP, SQLMaestros)
Here is the photo collection!
Event Resources | Original Emailer | Browse Event Pictures | Browse Data Platform Geeks Photo Albums
Speaker: Amit R S Bansal (MCM, MVP, SQLMaestros)
Here is the photo collection!
Event Resources | Original Emailer | Browse Event Pictures | Browse Data Platform Geeks Photo Albums
Speaker: Sandip Pani
Session 2: In-Memory OLTP for SQL Developers
Speaker: Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Here is the photo collection!
Event Resources | Original Emailer | Browse Event Pictures | Browse Data Platform Geeks Photo Albums
Speaker: Amit R S Bansal (MCM, MVP, SQLMaestros)
Session 2: Comparing & Deploying SQL Server Database Schemas Quickly & Accurately
Speaker: Jahnavi Sudha (Consultant, SQLMaestros)
Here is the photo collection!
Event Resources | Original Emailer | Event Pictures | Browse Data Platform Geeks Photo Albums
Speaker: Amit R S Bansal (MCM, MVP, SQLMaestros)
Session 2: Comparing & Deploying SQL Server Database Schemas Quickly & Accurately
Speaker: Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Here is the photo collection!
Event Resources | Original Emailer | Browse Event Pictures | Browse Data Platform Geeks Photo Albums
Abstract:
If you are a SQL DBA or a Database decision maker and have faced any of these problems –
• The size of the tables is getting out of control.
• Your users say that they want access to historical data, but they only rarely use it.
• You have to keep buying and adding more storage.
• You can’t backup or restore such large tables within the SLA.
…Then this session is just for you!
Session 2: SQL Server Isolation Levels by Sandip Pani (SSG)
Abstract:
In this session I will be talking about different type of isolation levels SQL Server Supports and how are they different from each other. If you are working on a heavy transaction based system, this session will help you to choose right isolation level. This session will be full of demos to understand every part of different Isolation levels.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
SQL Server 2016 Reporting Services has loads of new features like Reporting Services as a Web Portal, new KPI improvements and better User Interface by integrating HTML5 rendering. This session speaks about new improvements in SQL server Reporting Services -2016.
Session 2: Automating DBA’s world – Series 1 by Jayaraj Vemula (S&P Global)
Abstract:
Automating DBA’s world with Powershell is a series of topics that deals with various automations that can be made possible with powershell in day-to-day activities. This session sets context for future automation series.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
When we talk about analytics most of the time we think about Datawarehouse.Which is efficient for complex analytics but we cannot do any real-time analytics on it.SQL Server 2016 supports real-time operational analytics both on disk-based and memory-optimized tables. Now We can run analytics queries directly on your operational workload. In this session I will demonstrate how to implement this. Trust me it is pretty simple and you will love to implement this in your project.
Session 2: Introduction to Powershell For DBAs by Jayaraj Vemula
Abstract:
This session speaks about necessity of automation at workplace. Introduces one of important automation tools available in windows platform – Windows PowerShell. This will be an introductory session on PowerShell basics and will include couple of cool demos in the lines of getting information from multiple windows and sql instances and notifying end users. This introductory session will set right precedence about importance of automation to varied stakeholders including DBA’s, administrators, developers and BI experts.
Session 3: SQL Server 2016: Temporal Tables by Muthukumaran Arumugam (Microsoft)
Abstract:
SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011 and is now supported in SQL Server 2016. In this session I will be talking about various use cases of temporal tables.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
Have you ever –
- Had your system down/slowed down and everyone waiting for you to magically fix the problem ASAP?
- Upgraded an application to the latest SQL Server version and had an issue with a plan change slowing your application down?
- Had a problem with your Azure SQL Database and been unable to determine what was going wrong?
..Then this session is just for you!
In this session, we will familiarize you to the new and powerful feature announced in SQL Server 2016 – Query Store. This feature will be provide greater insights into query execution patterns enabling them to troubleshoot query performance issues more efficiently. The following topics will be covered as part of the session –
- Introduction
- Key Usage Scenarios
- Query Store Architecture
- Accessing Query store information using Reports and Queries
- Live Query Plan
Session 2: Introduction: Azure SQL Datawarehouse by Nilabja Ball (Microsoft)
Abstract:
SQL Data Warehouse is an elastic data warehouse as a service with massive parallel processing and full enterprise-class SQL experience. Azure SQL DW offers elastic performance and scale to 1+ PB, market leading price/performance, and true SQL experience across structured and unstructured data. In this session, we take an in-depth look at implementing a SQL DW, elastic scale (grow, shrink, and pause) and hybrid data clouds with Hadoop integration via Polybase.
Session 3: Azure Data Lake by SudhirRawat (Microsoft)
Abstract:
Azure Data Lake is a hyperscale repository for big data analytic workloads. It dynamically provisions resources and lets you do analytics on exabytes of data. Data Lake Analytics is a cost-effective solution for running big data workloads. Join this session to figure out what and how it’s different from another analytic services. The demos will blow you to see how complexity broke down in simplicity.
Session 4: PowerBI by Deepthi Ananthraman (Microsoft)
Abstract:
This short tour of Power BI Desktop gets you acquainted with how it works, demonstrates what it can do, and accelerates your ability to build robust data models — along with amazing reports — that amplify your business intelligence efforts.
Session 5: What’s new in SQL 2016 by Avanish Panchal (SSG)& and Sandip Pani (SSG)
Abstract:
SQL 2016 is in air in data platform world. This session will walkthrough on latest innovation coming up with SQL Server 2016. Definitely a good sessions to learn high level items and explore opportunity in data platform area.
Session 6: SQL Server Concurrency Problems by Amit R S Bansal (SQLMaestros)
Abstract:
Well these are not SQL Server’s Concurrency Problems, there are concurrency problems that can happen in SQL Server 🙂 – Come to this session if you want a deep dive in concurrency problems that are causing performance issues in SQL Server. You are investigating everything else, but the problem lies in concurrency. We will go very deep into the nuts-and-bolts of how SQL Server handles concurrency.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
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
Session 2: Multidimensional Modelling – I’m Not Dead Yet! by Ahmad Osama (SQLMaestros)
Abstract:
MOLAP is in the market since SQL Server 2000 and is by far the most use OLAP product to date. With the introduction of Tabular model, people believed this myth that MOLAP is history. In this one hour demo heavy session, we’ll learn to model data with MOLAP. We’ll learn to define data sources, dimensions, attributes, relationships, hierarchies and cubes with SQL Server Data tools. MOLAP is very much alive!!!.
Session 3: SQL Server Cardinality Estimation by Amit R S Bansal (SQLMaestros)
Abstract:
In this level 400 session, you will understand how the SQL Query Optimizer produces those awesome execution plans. The demo packed session will show the you the magic and complexity behind cardinality estimator of SQL Server.
Session 4: Data Security In Your Next IoT Project by Anirudh Deswandikar (Microsoft)
Session 5: Managing “Unpredictable Database Resource Demands” with Azure Database Elastic Pool by Pooja Kamath (Microsoft) and Hitesh Chouhan (Microsoft)
Abstract:
A common SaaS application pattern is for each database to have a different customer, each with varying and unpredictable resource consumption (CPU/IO/Memory summarized with DTU). With these peaks and valleys of demand for each database, it can be difficult to predict and therefore provision resources. As a SaaS developer or Database administrator how can you predict the pattern for each database and provision resources accordingly? You’re faced with two options; either over-provision database resources based on peak usage–and overpay. How can you be within the budget for many such databases? In this session we’ll be focusing on elastic database pools specifically to help you solve this problem of managing “unpredictable database resource demands” Instead of overprovisioning databases to meet peak demand, customers can combine elastic databases in a pool where a large number of them leverage the same resources, all within a defined budget. There will be demo and discussions to showcase the service followed by Q&A
Session 6: Resource Governor for IO by Amit R S Bansal (SQLMaestros)
Abstract:
Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. In prior releases, there have been incremental enhancements to this feature. SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, Microsoft Certified Master Amit Bansal will demonstrate how to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQLServer:Resource Pool Stats.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
In the session, we are focusing on troubleshooting connectivity issues with SQL Server. We will cover the basics of connectivity troubleshooting and use the Netmon tool to debug the troubleshooting issues.
- Network protocols
- Few Common scenarios: Case Studies
- Analyzing connectivity issues with Netmon tool
Session 2: Multidimensional Modelling – I’m Not Dead Yet! by Ahmad Osama (SQLMaestros)
Abstract:
MOLAP is in the market since SQL Server 2000 and is by far the most use OLAP product to date. With the introduction of Tabular model, people believed this myth that MOLAP is history. In this one hour demo heavy session, we’ll learn to model data with MOLAP. We’ll learn to define data sources, dimensions, attributes, relationships, hierarchies and cubes with SQL Server Data tools. MOLAP is very much alive!!!.
Session 3: SQL Server Cardinality Estimation by Amit R S Bansal (SQLMaestros)
Abstract:
In this level 400 session, you will understand how the SQL Query Optimizer produces those awesome execution plans. The demo packed session will show the you the magic and complexity behind cardinality estimator of SQL Server.
Session 4: A Glance at R’s Integration in SQL Server 2016 by Muthukumaran Arumugam (Microsoft)
Abstract:
- Brief Introduction – What’s so exciting about this integration?
- Approaches of calling R in SQL Server
- Some of the common R functions illustrated with SQL Server integration
- Demo of a Scenario using R’s integration in SQL Server
Session 5: Resource Governor for IO by Amit R S Bansal (SQLMaestros)
Abstract:
Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. In prior releases, there have been incremental enhancements to this feature. SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, Microsoft Certified Master Amit Bansal will demonstrate how to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQLServer:Resource Pool Stats.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
Data is growing at every moment and security of data is vital. Microsoft SQL Server 2016 is going to hit market very soon with lot of interesting features, potentially gonna help to address quite a bit of security/audit items. This session will talk about several new “Security” features coming up with Microsoft SQL Server 2016.
Session 2: Introducing Query Store – MS-SQL Server 2016 by Sandip Pani
Abstract:
This year Microsoft will be releasing SQL SREVER 2016. There are many new features introduced in SQL SERVER 2016.I will be demonstrating one of the new feature called “Query Store”. This is a great tool to troubleshoot query performance. In this session I will demonstrate how to use this feature and how will this help in query performance troubleshooting.
Here is the photo collection!
Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
Data is growing and so as business needs. You know data services running on on-prem world but do you know how many data services are there in Azure and why? If not or somewhat then join me in this ride and we’ll explore such services and need for such services. I am sure it will be an eye opener for you. See you there!
Session 2: Understanding SparkSQL by Sunil Kumar C (Microsoft)
Abstract:
This session will Introduces how with Spark SQL you can query structured data. Showcase how data pipelines can be expressed with a combination of both relational queries and procedural algorithms.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
SQL Server Analysis Services? PowerPivot? Power BI? Power Query? Power Map? Power View? MDX? DAX? Confused??????
Over the years, Microsoft BI Stack has undergone tremendous change, all for the good. But it has left the BI developer fraternity pretty confused with so many components in the stack. Most importantly, when to use which tool/technology? Come to this session to get a solid understanding of the Microsoft Bi stack and the right tool for a given scenario. If you are a BI developer or an aspiring one, you ought to attend this session, delivered by Microsoft BI Expert & MVP, Ahmad Osama.
Session 2: In-Memory OLTP vs Columnstore by Amit R S Bansal (SQLMaestros)
Abstract:
Do they compete or complement each other? Join this intriguing & demo oriented session to clear any confusion you have around these blockbuster features of SQL Server. Microsoft Certified Master of SQL Server, Amit Bansal, will talk about the right usage scenario of these features and offer comparisons along the way. The session will close with an overview of SQL Server 2016 Operational Analytics. Do not miss this session if you plan to work on SQL Server 2014 or 2016.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
SQL Server Analysis Services? PowerPivot? Power BI? Power Query? Power Map? Power View? MDX? DAX? Confused??????
Over the years, Microsoft BI Stack has undergone tremendous change, all for the good. But it has left the BI developer fraternity pretty confused with so many components in the stack. Most importantly, when to use which tool/technology? Come to this session to get a solid understanding of the Microsoft Bi stack and the right tool for a given scenario. If you are a BI developer or an aspiring one, you ought to attend this session, delivered by Microsoft BI Expert & MVP, Ahmad Osama.
Session 2: In-Memory OLTP vs Columnstore by Amit R S Bansal (SQLMaestros)
Abstract:
Do they compete or complement each other? Join this intriguing & demo oriented session to clear any confusion you have around these blockbuster features of SQL Server. Microsoft Certified Master of SQL Server, Amit Bansal, will talk about the right usage scenario of these features and offer comparisons along the way. The session will close with an overview of SQL Server 2016 Operational Analytics. Do not miss this session if you plan to work on SQL Server 2014 or 2016.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Abstract:
SQL Server Analysis Services? PowerPivot? Power BI? Power Query? Power Map? Power View? MDX? DAX? Confused??????
Over the years, Microsoft BI Stack has undergone tremendous change, all for the good. But it has left the BI developer fraternity pretty confused with so many components in the stack. Most importantly, when to use which tool/technology? Come to this session to get a solid understanding of the Microsoft Bi stack and the right tool for a given scenario. If you are a BI developer or an aspiring one, you ought to attend this session, delivered by Microsoft BI Expert & MVP, Ahmad Osama.
Session 2: In-Memory OLTP vs Columnstore by Amit R S Bansal (SQLMaestros)
Abstract:
Do they compete or complement each other? Join this intriguing & demo oriented session to clear any confusion you have around these blockbuster features of SQL Server. Microsoft Certified Master of SQL Server, Amit Bansal, will talk about the right usage scenario of these features and offer comparisons along the way. The session will close with an overview of SQL Server 2016 Operational Analytics. Do not miss this session if you plan to work on SQL Server 2014 or 2016.
Here is the photo collection!
Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums
| Data Platform Summit 2017 August 17 – 19, 2017 |
| SQLServerGeeks Annual Summit 2016 August 11 – 13, 2016 |
| SQLServerGeeks Annual Summit 2015 August 27 – 29, 2015 |
