Session 1:Stored Procedure Optimization
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

Session 1: Monitoring SQL Server Performance – The Right Way
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

Session 1: Fill Factor – Let’s Look at Few Internals
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

Session 1: Monitoring SQL Server Performance – The Right Way
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

Session 1: Monitoring SQL Server Performance – The Right Way
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

Session 1:Stretch your Database onto the cloud by Devashish Salgaonkar (Microsoft)
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

Session 1: Understand ColumnStore Index by Sandip Pani (SSG)
Abstract:
Columnstore index was introduced in SQL Server 2012 and Microsoft has done many enhancement to this and added many features to it. In SQL Server 2016 Microsoft has made many changes to it, which enables user to use it for real-time analytics. Though It’s been there from a long time I have seen very few are using it. In this session I will explain the anatomy of columnstore index and how it is different from row store index and its use cases.

Session 2: Play smartly with SQL Server Auditing Method(s) by Avanish Panchal (SSG)
Abstract:
How CCTV camera (Auditing) of your SQL Server Database helps DBA/Developers to address compliance items and keep critical databases out of reach of unintended users & improper actions. In this session will talk about “native” auditing method(s) available in SQL Server followed by “Real-time” Demos.

Session 3: A look at the Plan Cache Basics by Vignesh Ravishankar (SSG)
Abstract:
Plan Cache in SQL Server is one of the most important entity that stores the execution plans generated for the queries that run in the server and helps facilitate plan re-use in cases where it is possible. Understanding how the queries are cached, enables to analyse the plan cache to identify and take necessary steps to address the plan cache pollution issues.

Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server 2016 Reporting Services New Features by Muthukumaran Arumugam (Microsoft)
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

Session 1: SQL Server Backups – A gaze into the internals by Yogeshwar Phull
Abstract:
One of the first things that a DBA learns is to take database backups. But very often this remains limited to right click and take backup. We hardly get into backup internals and build many misconceptions in our minds as we aren’t aware of what happens in the background. In this demo heavy session, we’ll deep dive into different types of database backups and observer what exactly happens behind the scenes.

Session 2: Improvements in SQL Server 2016 by Prince Rastogi (SSG)
Abstract:
Microsoft announced multiple improvements in SQL Server 2016 to make life easier for SQL Server Professionals. In this demo heavy session, Prince Rastogi will cover the various improvements across Trace Flags, Partitions and Alter Column operations. Attend this session to learn about these new features and get ready for SQL Server 2016

Session 3: Data Cleansing with SSIS by Ahmad Osama (SQLMaestros)
Abstract:
No one likes dirty data, especially business. Analyzing dirty data can result in business disasters. Join Ahmad Osama, Microsoft Data Platform MVP & world renowned BI Expert, and learn advanced data cleansing techniques in SSIS. Clean the data so that it makes business sense. Ahmad will show you how!

Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: From SQL to NoSQL by Sunil Kumar C (Microsoft)
Abstract:
This session will focus on fully managed NoSQL database service built for
fast and predictable performance, high availability, automatic scaling, and ease of development. Its flexible data model, consistent low latencies, and rich query capabilities make it a great fit for web, mobile, gaming, and IoT, and many other applications that need seamless scale. We’ll show case demo for better understanding of technologies.

Session 2: SQL Server Cluster Setup – Common mistakes and prevention methods by Avanish Panchal (SSG)
Abstract:
Windows Failover Clustering is widely acceptable High Availability solution (HA). It keeps SQL instance online most of the time and addresses hardware and operating system failure. WFC is equally helpful in case of maintenance. Committing mistakes while setting up foundation of SQL Server Clustering defeats the purpose of availability and bad performance.
Will learn how to nullify some of widely spread SQL Server Cluster setup mistakes.

Session 3: SQL Server Management Studio Tips & Tricks by Vignesh Ravishankar (SSG)
Abstract:
Management Studio is the primary tool/interface that anyone working with SQL Server spends most of the time.In this session we would be discussing about various SSMS Tips & Tricks, which would be helpful on a day-to-day basis at work. Different customization options, keyboard short-cuts, built-in templates & reports and some new features as seen in SSMS 2016 RC.

Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: Real-Time Operational Analytics in SQL Server 2016 by Sandip Pani (SSG)
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

Session 1: SQL Server 2016 – Performance Troubleshooting with Query Store and Live Query Plan by Devashish Salgaonkar (Microsoft)
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

Session 1: Leveraging Microsoft BI Solution for Data Insights by Aneek Arora (Microsoft)
Abstract:

This session will cover integrated view of redefined Microsoft BI platform Strategy to cover integrated view of entire suite of capabilities. This will cover how Microsoft solution can help you deliver superior capabilities while leveraging both on-premise and cloud offerings.

Session 2: 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 3: 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 4: In-Memory Database Technologies by Rahul Dutta (Microsoft)
Abstract:

Apart from the SQL Server In-Memory capability and when and why we should migrate will also share the competitive landscape.

Session 5: SQLServer Wait Stats – A Magical Wand to Solve Performance Issues by Sarabpreet Singh Anand (SQLServerGeeks)
Abstract:

Are you facing performance issues? Struggling to find the root cause of the delay? Don’t know where to start diagnosing? If yes, then SQL Wait Statistics is the answer to most of your problems; this works like magic and tells you what’s going wrong. The best part is SQL Server knows about the performance issue and the underlying cause, it’s just that we need to ask SQL and understand its language. Come and join this session where Sarabpreet Singh will help you learn this trick.

Session 6: Things That You Don’t Know About SQL Server by Prince Rastogi (SQLServerGeeks)
Abstract:

An un-miss-able session, Prince Rastogi will show you a few very interesting aspects of SQL Server database engine that Google cannot find for you 🙂

Session 7: 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.

Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: Build End to End Solution Using Microsoft Azure Data Factory by Sudhir Rawat (Microsoft)
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

Session 1: Tips and Tricks to Fix SQL Connectivity Issues by Don Rohan Castelino (Microsoft)
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

Session 1: SQL 2016 Security by Avanish Panchal
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

Session 1: Data Services on Microsoft Azure by Sudhir Rawat (Microsoft)
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

Session 1: Microsoft BI – Past, Present & Future by Ahmad Osama (SQLMaestros)
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

Session 1: Microsoft BI – Past, Present & Future by Ahmad Osama (SQLMaestros)
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

Session 1: Microsoft BI – Past, Present & Future by Ahmad Osama (SQLMaestros)
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


Speaker: Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Abstract: Aggregating and summarizing data is required in almost every domain. Aggregations can be as simple as calculating maximum/minimum/average or as complex as calculating sliding aggregations. Knowing how to write efficient aggregate queries is important to learn for every T-SQL developer. In this Advanced Aggregation session, Ahmad will talk about using Grouping Sets, ROLLUP and CUBE for aggregation and using OVER Clause with aggregate functions. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code, you won’t want to miss this session.
Event Resources

Speaker: Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Abstract: Pivoting is a technique to reorganize rows to columns to get an aggregated or summarized view of a possibly a large dataset. Pivoting is used in large number of applications and helps solve many reporting needs. In this all-demo Pivoting session, Ahmad will present advanced pivoting real life solutions involving relational division, data aggregations and dynamic pivoting. He’ll also talk about Un-Pivoting, which is the reverse of pivoting. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.

Event Resources

Speaker: Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Abstract: Microsoft introduced In-Memory OLTP in SQL Server 2014. We all know about the technology and how it improves the performance, however how can a developer efficiently use in-memory tables and natively compiled stored procedures to get the blazing fast performance that the technology has to offer. In this demo heavy session, you’ll learn to create and access memory optimized tables and indexes and the latch and lock free new transaction model. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.

Event Resources

Speaker: Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Abstract: Deploying database changes to production?? Let’s get this done by exploring on making deployments simple considering the challenges, benefits, testing and approvals for a smooth, reliable and robust production deployment. The session elaborates on how to move forward to create error free deployment scripts in minutes, getting version control at your fingertips inside the SSMS, Source control your schema and static data, comparing & synchronizing the backup files and deploying to SQL Server, SQL Azure & Amazon RDS.

Event Resources

Speaker: Amit R S Bansal (MCM, MVP, SQLMaestros)
Abstract: Do you want to find issues in SQL Server before they become a problem? Do you want to uncover root cause of a performance issue in 5 mins? Do you want to quickly identify slow running queries and learn how to fix them? In short, do you want to be rock star DBA? Join Microsoft Certified Master & MVP Amit Bansal in this demo-packed session where he will demo real world performance tuning cases, identify them & fix them.

Event Resources | Original Emailer

Data Platform Summit 2017
August 17 – 19, 2017
SQLServerGeeks Annual Summit 2016
August 11 – 13, 2016
SQLServerGeeks Annual Summit 2015
August 27 – 29, 2015


A Word From Our Knowledge Partners

DPS 2019 Registrations Open
Data & Analytics Summit
Video Course by Amit Bansal
Hands-On-Labs
Learning Kit
SQL Server Health Check

 

Ads by Google