Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros), Sarabpreet Singh Anand (SSG), Ahmad Osama (SSG)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros), Narendra Ragho Angane (Microsoft), Mahendraprasad Dubey (Microsoft)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros), Narendra Ragho Angane (Microsoft), Mahendraprasad Dubey (Microsoft)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: Get involved in IoT by Sudhir Rawat (Microsoft)
Abstract:
There is lot of buzz around IoT. It involves not only understanding of services but also the hardware. There are lot of devices and sensors available to achieve the solution. This session will help you to connects the dots and help you to build solution around it. How devices connect each other and send information to event hub. How then information is presented to end user.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Session 3: Introducing Azure Machine Learning by Deepthi Anantharam (Microsoft)
Abstract:
Microsoft Azure Machine Learning (MAML) is a service on Azure which a developer can use to build a predictive analytics model using machine learning over data. ML Studio provides functionality to support the end-to-end workflow for constructing a predictive model, from ready access to common data sources, data exploration, feature selection and creation, building training and testing sets, machine learning over data, and final model evaluation and experimentation. In this presentation, we present an overview of the basic data science workflow, with details on select machine learning algorithms, then take you on a guided tour of ML Studio.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server 2014 Hidden Gems by Amit R S Bansal (SQLMaestros)
Abstract:
In-Memory tables and Availability Groups are all well-known features in SQL Server. But how about tempdb hidden performance, Delayed Durability and Cardinality Estimator? And have you seen how clustered columnstore indexes can improve performance? Come to this session and witness some lesser-known, yet awesome features of SQL Server.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: Let’s explore AlwaysOn Availability Group by Narendra Ragho Angane (Microsoft) & Mahendraprasad Dubey (Microsoft)
Abstract:
In this session, we’ll discuss following

  • HADR Existing features before AlwayON
  • AlwaysON introduction
  • Benefits offered by availability groups
  • Setup prerequisites, database consideration, limitations etc…
  • What’s new in AlwaysON SQL 2014?
  • Demo

Session 2: In-Memory OLTP & SQL Tuning by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your high throughput workload can benefit from Memory Optimized Tables. You will witness blazing fast performance. Learn the concept, the technique and implementation strategies of In-MemoryOLTP.

Session 3: Panel Discussion: Ask the Experts by Narendra Ragho Angane (Microsoft) & Mahendraprasad Dubey (Microsoft)
Abstract:
oin the expert panel from Microsoft. SQL Stalwarts will be there to answer your questions. Whether you are a DBA, Developer, BI Specialist, Architect or just a SQL enthusiast – feel free to ask any question and get your doubts cleared!

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: Prepare yourself for running SQLServers on AzureVM by Sarabpreet Singh Anand
Abstract:

  • Are you planning to move your SQLServers on Azure?
  • Want to get clarity in terms of Support?
  • Are you worried about the Performance?
  • Want to avoid common mistakes?
  • etc.

If you are worried about these\related questions attend this session where Sarabpreet Singh will help you find answer to most of your queries.

Session 2: SQL Server Query Tuning Simplified by Amit R S Bansal
Abstract:
SQL Server Query Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a query tuning methodology that can be put into production right-away!

Session 3: Performance tuning from the field – Optimising stored procedures by Ahmad Osama
Abstract:
They say that performance tuning is an art. So let’s see what this art is all about. In this demo only session, we’ll together write an optimized stored procedure for a real life and the most common problem.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Query Tuning Simplified by Amit R S Bansal
Abstract:
SQL Server Query Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a query tuning methodology that can be put into production right-away!

Session 2: Panel Discussion: Ask the Experts by Devashish Salgaonkar (Microsoft), Anmol Bhasin (Microsoft), Sanjiv Gore (Microsoft)
Abstract:
Join the expert panel from Microsoft. SQL Stalwarts will be there to answer your questions. Whether you are a DBA, Developer, BI Specialist, Architect or just a SQL enthusiast – feel free to ask any question and get your doubts cleared!

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Query Tuning Simplified by Amit R S Bansal
Abstract:
SQL Server Query Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a query tuning methodology that can be put into production right-away!

Session 2: Panel Discussion: Ask the Experts by Sudhir Rawat (Microsoft), Vijay Rodrigues (Microsoft), Deepthi Anantharam (Microsoft), Kumar Bijayanta (Microsoft) & Sunil Kumar Charkapani (Microsoft)
Abstract:
Join the expert panel from Microsoft. SQL Stalwarts will be there to answer your questions. Whether you are a DBA, Developer, BI Specialist, Architect or just a SQL enthusiast – feel free to ask any question and get your doubts cleared!

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: Developer Vs DBA by Sarabpreet Singh Anand (SQLServerGeeks President) & Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
Bugs, Crashes, Meltdowns, we run into issues almost every day. The first thing we do is to find who’s 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 get over this blame game and resolve issues as a team. In this grueling, demo heavy 2.5 hours session, Sarabpreet and Ahmad will play as developer and DBA to resolve real life bugs and performance issues collectively.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: Master The Art of Public Speaking – Part 1 by Amit R S Bansal
Abstract:
Yes We Can! Remember this? Good oratory skills can land you the top job, be it the President of the United States or the Prime Minister of India – public speaking skills is indeed that important today! Even if you don’t need to make regular presentations in front of a group, there are plenty of situations where good public speaking skills can help you advance your career and create opportunities. In fact, top jobs need those skills. And don’t you want to climb the ladder for that top job? Come to this session if you want to get a kick-start in public speaking. Amit Bansal, who has learnt the art of public speaking the hard way, will teach you these skills, step-by-step. Amit has delivered a number of sessions at international conferences like TechEd, PASS Summit, SQL Bits, GIDS, Economic Times – Power of Ideas, Images Retail Confernce, etc – and he will bring all his experiences in a series of sessions, starting from April 18, Part 1 of “Master The Art of Public Speaking”. These sessions are unmissable.

Session 2: From Nobody to Somebody by Amit R S Bansal
Abstract:
Your colleagues know you. Your friends know you? Your family knows you. They all know what you know? Isn’t that a common thing with most people around you? Don’t you want that people who don’t know you, should know you and what you know? Confused? 🙂 Well, this session is all about becoming Somebody from Nobody. What does it take to be popular? Why should you think about becoming famous? And how can you achieve fame and recognition within your community? It’s time you come out of your comfort zone and show the world what you know. This session will instill that thought in you, only if you are interested. This session is un-miss-able!

Session 1: Introduction to SSIS and Deployments by Jayaraj Vemula
Abstract:

  • Brief Introduction to SSIS
  • Differences between SSIS Package Deployment Model Vs Project Deployment Model (>= SQL 2012)
  • Advantages of Project Deployment Model
  • Couple of Demo Deployments

Session 2: From Nobody to Somebody by Amit R S Bansal (SQLMaestros)
Abstract:
Your colleagues know you. Your friends know you? Your family knows you. They all know what you know? Isn’t that a common thing with most people around you? Don’t you want that people who don’t know you, should know you and what you know? Confused? 🙂 Well, this session is all about becoming Somebody from Nobody. What does it take to be popular? Why should you think about becoming famous? And how can you achieve fame and recognition within your community? It’s time you come out of your comfort zone and show the world what you know. This session will instill that thought in you, only if you are interested. This session is un-miss-able!

Session 1: Deep Dive into Delayed Durability by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
I am going to introduce you to the one of the three top features of SQL Server 2014. In my previous sessions you have been introduced to In-Memory OLTP and Buffer Pol Extensions. In this session I will be covering Delayed Durability which readily boosts your transaction throughput. I will also be covering a case study of Delayed Durability in comparison with SSDs.

Session 2: This Session will introduce you to powershell and how to use it with SQL Server by Jayaraj Vemula
Abstract:

  • Introduction to Powershell
  • Why use PS and how is it different from CMD?
  • First Powershell Command
  • Frequently used Powershell Commands or helpers
  • Introduction to SMO
  • Different ways to Connect to SQL Server from Powershell
  • Few Low hanging DBA activities that could be automated

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: What is Updatable Columnstore Index? by Sarabpreet Singh Anand (SQLServerGeeks President) & Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
Let’s learn Columnstore Index and see how Updatable Columnstore index work. It’s a new feature in SQL Server 2014.

Session 2: Extended Events by Rajiv Jog
Abstract:
What are Extended Events(XE)? Why to use Extended Events & how it works. Finally we will see a demo to find CPU expensive queries with the help of XE.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Operating System – What the heck is that? by Amit R S Bansal (SQLMaestros)
Abstract:
SQL Server Operating System is a mini OS inside SQL Server. In this demo-heavy session, you will see SQL OS in action, especially SQL scheduling. This session will be Level 400.

Session 2: Explore Delayed Durability in SQL Server 2014 by by Sarabpreet Singh Anand (SQLServerGeeks President) & Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
Come and join SQL Server MVP Sarabpreet as he helps us understand what is Delayed Durability and its usage in SQL Server 2014. Its a new feature introduced in SQL 2014. Do invite your friends\Colleagues to learn together & Share your experience.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Introduction to Azure SQL Databases by Kumar Bijayanta (Microsoft)
Abstract:
Being relatively new, Azure SQL databases, people often wonder what it really is? What is it capable of? What are the various editions and why do they really matter? If they did decide on moving to a cloud version of SQL Server, what are the options to migrate? What are the advantages and disadvantages? This session answers these questions and guides people through a knowledge of Azure SQL databases and methods to migrate.

Session 2: Something about SQL OS that you don’t know by Amit R S Bansal (SQLMaestros)
Abstract:
In this quick, demo-only session, the speaker will show something very interesting about SQL OS.

Session 3: Embrace Cloud – Why & how by Deepthi Anantharam (Microsoft)
Abstract:
Would you focus on your core business rather than worry about peripherals such as licenses, infrastructure, maintenance, upgrades ? Architect your solutions for the cloud. From a host of PaaS services to lifting and shifting your application as is – Microsoft Azure has it all. Let us focus on storage and analytical options in the tour of Azure for the data scientist in you.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Data Archive and Purge by Saurabh Kothari
Abstract:
As a DBA we always face challenge of managing and maintaining data growth considering data retention defined. While designing database if we cover all aspects of archive and purge than we can very well prevent all database performance and infrastructure related fears.

In presentation I will be doing some live demo of how a user can define and add such value or parameter which will help DBA in maintaining considering data retention provided by business and how all the process is getting automated.

Session 2: Stay alive on Social Network by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
In this professional development session I will talk about the importance of staying active on Social Network. I will share few tips on how to get the most out of it and benefit professionally over the social media.

Session 3: Explore the Power of Extended Events by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
Extended Events has been introduced in SQL Server 2008 and with deprecation of Profiler, now it is more critical to start using Extended Events. In this session I will briefly introduce this feature and demonstrate few scenarios of your choice from a list of Demos.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Realtime Analysis with Microsoft Technologies by Sudhir Rawat (Microsoft)
Abstract:
Mostly past data get analyzed and in other words there is always the case for latency. The current industry demands the evolution of Big Data and Hadoop solutions from batch oriented jobs to real-time stream based analytics. There are some scenario where data needs to analyse on real time basis. In this session we will cover the technologies from Microsoft to achieve the same.

Session 2: Benchmarking Disk Performance by Amit R S Bansal (SQLMaestros)
Abstract:
A well-performing IO Subsystem is super critical to SQL Server’s performance. And benchmarking disk performance is super critical for a DBA. In this demo-heavy session, you will learn all the important terminologies and concepts related to disk drives and how to benchmark disks using SQLIO.

Here is the photo collection!

Browse Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Introduction to Azure SQL Database by Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
In this session we’ll explore the Azure SQL database. We’ll see how to setup and use Azure SQL Database and will explore the query platform.

Session 2: A to Z of Managed Backups to Windows Azure | SQL Server 2014 by Sarabpreet Singh Anand (SQLServerGeeks President)
Abstract:
Microsoft introduces an innovative way to handle all your backup strategy related queries, this is a new feature introduced in SQL 2014 to automate SQL Server Backups. Attend this session to learn more about its capabilities.

Here is the photo collection!

Browse Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Want to extend your Memory? See how SQL Server can do it by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
Have you ever wanted to extend your memory so that you can have many threads running in your brain? In this session I am going to explain traditional relationship between our brain and SQL Server processing. I will introduce you to the new feature which is not explored much, Buffer Pool Extensions. How this can be corelated to our imagination.

Session 2: Troubleshooting perf problems using Xperf by Aditya Badramraju
Abstract:
Xperf is one awesome tool which is less used and which has the capability of debugging things more internally. In this session we will try to see the introduction of xperf, the ways to use it, solving complex problems such as High CPU, IO Latencies on SQL Server using Xperf.

Here is the photo collection!

Browse Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)


Session : Real-Time Operational Analytics in SQL Server 2016 by Manohar Punna (SSG)
Abstract:
SQL Server 2016 introduces real-time operational analytics, the ability to run both analytics and OLTP workloads on the same database tables at the same time. Besides running analytics in real-time, you can also eliminate the need for ETL and a data warehouse. In this demo-packed session, Manohar Punna, Data Platform MVP & SQLServerGeeks President, will get into the inner workings of this wonderful feature. Along the way, he will talk about use case scenarios and performance tips..

Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: Unlocking Data Insights from Any Data with SQL Server by Jen Stirrup
Abstract:
With business intelligence tools built right into Excel, and supercharged by a powerful back-end data platform in SQL Server, Microsoft makes it easier for everyone to discover new insights and uncover new connections and relationships across data sets. Create stunning, interactive views from any data using Excel, make real-time decisions using interactive charts and reports that can be changed on the fly directly in PowerPoint. Share and collaborate with other people by using SharePoint while retaining the rich data-linked visualizations that were built in Excel. Finally, Power BI transforms your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you.
Session 1: High Availability Options in SQL Server by Edwin Sarmiento
Abstract:
SQL Server boasts of variety of features to improve database availability and significantly reduce downtime. In this webcast, join SQL Server MVP and Microsoft Certified Master Edwin Sarmiento as he covers Availability Groups and Failover Clustering to achieve high availability for your SQL Server databases. He will also cover how you can implement a hybrid solution for stretching your SQL Server Availability Groups or Failover Clustered Instances to Microsoft Azure.
Session 1: Big Data on Microsoft Azure by Joseph D’Antoni
Abstract:
The traditional enterprise data warehouse has been around a long time, and it isn’t going away anytime soon. However, with modern options based on Hadoop like HDInsight and PolyBase, and new analytic and data mining techniques, the warehouse is no longer the center of our business analytics universe. Enterprises now have the flexibility to integrate and analyze external and internal data in ways previously not possible. In this session, we will cover these new platforms through and our approach for integrating them into your warehouse environment. We will demonstrate how to do initial data loading and analysis using HDInsight and Power Query, and then visualizing that data using Power View.

Session 1: SQL Server Hidden Gems by Amit R S Bansal
Abstract:
In-Memory tables and Availability Groups are all well-known features in SQL Server. But how about tempdb hidden performance, Delayed Durability and Cardinality Estimator? And have you seen how clustered columnstore indexes can improve performance? Come to this session and witness some lesser-known, yet awesome features of SQL Server.

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