SQL PASS Summit 2017

It is that time of the year when I get to meet the SQL Family. It is always wonderful to put a face to that Twitter handle that I exchanged #sqlchats with or connected with on LinkedIn. SQL PASS Summit is probably one of the largest gathering of data professionals under a single roof.

This year, I will be presenting a session on “Building One Million Predictions Per Second Using SQL-R”.

Date: Nov 3rd, 2017
Time: 11am
Room: Tahoma 5 (TCC Level 3)
Using the power of OLTP and data transformation in SQL 2016 and advanced analytics in Microsoft R Server, various industries that really push the boundary of processing higher number of transaction per second (tps) for different use cases. In this talk, we will walk through the use case of predicting loan charge off (loan default) rate, architecture configuration that enable this use case, and rich visual dashboard that allow customer to do what-if analysis. Attend this session to find out how SQL + R allows you to build an “intelligent data warehouse”.

There will be a number of sessions delivered at PASS from the Tiger team this year and you will find a lot of the folks at the SQL Server Clinic.

If you have a technical question, a troubleshooting challenge, give product feedback, or want to find out about best practices running your SQL Server? Then the SQL Clinic is the place you want to go to. SQL Clinic is the hub of technical experts from SQL Product Group (including Tiger team), SQL CAT, SQL Customer Support Services (CSS), SQL Premier Field Engineering (PFE) and others.

SQL PASS Summit gives me an unique opportunity to meet the #SQLFamily during an annual event, gather feedback from customers and get to see some old friends from across the globe!

Hope to see you at the event!

SQL Saturday 686–Upgrade your SQL Server like a Ninja

There is a plethora of Data Platform subject matter experts who will be descending at Portland this weekend to mingle with data professionals. What’s more a number of them will be surfacing a week later at the SQL PASS Summit as well.  I am eagerly looking forward to the data drive conversations. I have always been a big proponent of sharing the knowledge with the community and SQL Saturday is great way to do that.

There are multiple tracks which will be running on the same day. There are a number of sessions from various known community subject matter experts on various subjects on the tracks listed above and also from the Microsoft SQL Server Tiger team. I am really looking forward to this event! This will be an awesome prelude to PASS!

I will be presenting a session on upgrading your SQL Server and how we have helped Enterprises upgrade their SQL Server instances through various automations that are available using recent tools that Microsoft has shipped.

Session name: Upgrade your SQL Server like a Ninja

Duration: 70 minutes

Date: 28th Oct, 2017

Timing: 10.10am – 11.20am

Session Abstract

Are you thinking about upgrading your SQL Server environment to the latest and greatest that your data platform has to offer? If yes, then let us show you how you can perform risk-free and automated upgrades for SQL Server. In this session, you will see the new experiences Microsoft is building for performing Tier-1 SQL Server upgrades at scale through automated assessments, robust performance validation and using product features to minimize downtime.

Hope to see you at the event!

Data Platform Summit 2017

PrintI will be speaking at the Data Platform Summit happening at Bangalore from Aug 17-19, 2017. I will be delivering sessions on achieving a million predictions/sec using SQL Server and introduce our latest entrants into the Azure Database family: MySQL and PostgreSQL.

Session: CLOUD/IoT/NoSQL_C13Running Applications On Azure Using Postgres/MySQL
: 17th Aug, 2017
Time: 11:30am – 12 noon
Session Type: Chalk Talk
Room: Kilimanjaro
Abstract: A chalk talk on Azure’s managed database offering for PostgreSQL and MySQL and how we make it easy to run your existing apps using PostgreSQL and MySQL on Azure.

Session: BIA_B02 – Advanced – Building 1 Million Predictions Per Second Using SQL-R
Date: 17th Aug, 2016
Time: 1:45PM – 3PM
Session Type: Breakout Session
Room: Hydra
Abstract: Using the power of OLTP and data transformation in SQL 2016 and advanced analytics in Microsoft R Server, various industries that really push the boundary of processing higher number of transaction per second (tps) for different use cases. In this talk, we will walk through the use case of predicting loan charge off (loan default) rate, architecture configuration that enable this use case, and rich visual dashboard that allow customer to do what-if analysis. Attend this session to find out how SQL + R allows you to build an “intelligent datawarehouse”.

In this session, I will show you the actual demo where we hit 1 million transactions/sec.

Session: CLOUD/IoT/NoSQL_B40 – Basic – Azure Database for MySQL and PostgreSQL
Date: 18th Aug, 2016
Time: 11:45AM – 1PM
Session Type: Breakout Session
Room: Sphinx
Abstract: Azure Database for MySQL and Azure Database for PostgreSQL are managed database services built for developers using the community edition of MySQL PostgreSQL. Learn how you can leverage these new choices of managed database services to build scalable, secure and intelligent apps. Using insights from current customer scenarios and through live demos, we walk through the service management capabilities, best practices to move your databases to the service, and also focus on how the Microsoft Azure ecosystem of app and data services is unlocking the potential of MySQL and PostgreSQL in the Azure cloud platform.

There is a surprise element in this session as well! And if I let the cat out of the bag now, it wouldn’t remain a surprise would it? Come to the session to find out what it is.

We also have other members from the SQL Server Tiger, SQL CAT, Data Migration and our field teams delivering sessions about various different data related topics. My colleague, Ajay Jagannathan, published a post on the upcoming Tiger sessions at the conference. There is a great list of accomplished speakers that will be delivering sessions at the conference. Apart from a great lineup, it always feels great to connect with customers and the community in general to learn about how they are using the products that we are building and gather feedback from the horse’s mouth!

Follow  SQLServerGeeks and the #DPS2017 hashtag on Twitter for new and exciting updates about the conference. We hope to meet you at the conference.

Upcoming PASS Summit 2016

PASS_2016_200x200[1] It’s that time of the year again when data professionals across the world converge at Seattle for one of the largest gatherings of data professionals around the world. This is one week of deep technical sessions delivered by community experts, MVPs and Microsoft engineers. With such a high concentration of data professionals around the world, you cannot discount the phenomenal networking opportunities at the event.

PASS Summit is the must-attend conference for all data professionals. There is a wealth of learning, connections, and immediate solutions gained in 3+ jam-packed and inspiring days. And possibly one of the largest congregation of data professional in the world with over 4000 attendees. Our Corporate Vice President, Joseph Sirosh, will talk about Cloud Intelligence Innovations during his keynote session on Day 1. David DeWitt, a very familiar face at PASS summit and in the community, will talk about Data Warehousing in the Cloud during his keynote session on Day 2.

The SQL Server Tiger Team (@mssqltiger) will be delivering sessions, will be at the clinic and is eager to hear from SQL Server customers. I published a blog post which is a summary of what the Tiger team will be upto at the PASS Summit.

Parikshit and I will be delivering a session on Always On enhancements and how it would help monitor, support and troubleshoot your environments better and even make your critical environment more reliable and available!

My session at PASS Summit

Session: SQL Server Enhancements that Keep Your Environment Always On
Speaker: Parikshit Savjani, Amit Banerjee
Session Code: DBA-313-M
Session Date: October 27th
Session Time: 1:30PM – 2:15PM PST
Level: 300
Duration: 75 minutes
Room: TCC Tahoma 5

What you can expect: SQL Server Always On Availability Groups provides a number of out-of-the-box enhancements in SQL Server 2012, 2014 and 2016 which helps analyze common issues with relative ease. Attend this session to find out more about how the new enhancements can be leveraged to improve reliability, reduce manual effort and increase uptime. This session will also do a deep dive using demos of the new visualizations available for common scenarios leveraging the new diagnostic and supportability improvements that were added. As a bonus, we will show you new visualizations and data analysis techniques for common issues that you face in your Always On environments.

#AskSQLTiger Twitter Chat on June 27

Join the SQL Server Tiger team for a Twitter Chat on Monday, June 27th from 10 -11 AM PST. You can ask anything about Query Performance on SQL Server for our first Twitter chat. 

Log on at the time above, make sure to include #AskSQLTiger in every Tweet you make, and you’ll be part of our discussion. Or, follow this link to see the #AskSQLTiger feed. Tools like TweetdDeck, HootSuite can be helpful in following along in a Twitter Chat. Members of the @mssqltiger will be moderating the discussion.

More details can be found here.

Recent session at PASS HADR VC session

I recently delivered a session for High Availability and DBA Fundamentals on June 14th about the recent High Availability and Disaster Recovery enhancements that were delivered/to be delivered in recent Service Packs of SQL Server. The session recording is available on YouTube, the slide deck is available on Slide Share and the demo scripts along with the Power BI dashboards are available on GitHub

SQL Server 2012 Service Pack 3 and the upcoming SQL Server 2014 Service Pack 2 provide extended events which helps track down two of the most common issues that DBAs have to cope with during an outage situation related to Availability Groups: Latency and Lease Timeouts (which could result in failovers). These new extended events have been shipped based on customer feedback that we heard, acted up and shipped. If you have an Availability Group setup, then come learn about the new enhancements shipped with SQL Server 2012 Service Pack 3 and the upcoming SQL Server 2014 Service Pack 2 and above which allows you to troubleshoot failovers more easily and pin point the latency in your environment more efficiently.

Sessions at SQLNEXUS and SQLBITS

I will be presenting at two different conferences in Europe: SQL Nexus and SQLBITS. Joseph Sirosh, Corporate Vice President of the Data Group, will be delivering the keynotes at both these conferences. There are multiple sessions from Microsoft speakers from Data Group, SQL Server Customer Advisory Team (more famously known as SQLCAT) and other SQL Server community experts which would make this conference worth your time.

My team, MSSQLTIGER, will be presenting other sessions at these events. A full list can be found on the Tiger blog.

SQL Nexus – 2nd – 4th May, 2016

Session Name: Recent SQL Server Enhancements: We heard, We built, We shipped! (Session Link)

Length: Full Day

Date: 2nd May, 2016

Session Abstract:

  • Have you wondered if there was an enhancement which made your job easier in monitoring or troubleshooting a SQL Server issue?
  • Have you ever wished for a change in SQL Server which made your job easier?
  • Did you wonder what SQL Server can do for you in the cloud?

If your answer was YES to any of the questions above, then attend this session to know more about the improvements in SQL Server which would help your current workloads on SQL Server 2012, SQL Server 2014 and SQL Server 2016.  We will discuss enhancements done for high availability and disaster recovery, monitoring, performance, scalability and much more along with demos and scripts that you can take home. We will talk about how we listened, understood and delivered on feedback that we received from customers using SQL Server.  We will also show you ways to leverage data movement capabilities between your on-premise datacenters and Azure which will help you expand your boundaries to Azure SQL DB and Azure Virtualizations.

This is a session for DBAs, Database Developers and anyone who runs a production SQL Server instance on the ground, up in the cloud or anywhere in between!

You can also catch us at SQL Clinic where we you can drop by to say Hi, ask your SQL Server question or provide feedback about the product!

SQL BITS – 4th May – 7th May, 2016

Session Name: Debugging made easier using Extended events (Session Link)

Level: 300

Date: 6th May, 2016

Time: 3:30pm – 4:45pm

Session Objectives:

  1. Understand the diagnostics enhancements available in SQL Server database engine in SQL Server 2012 Service Pack 3 and above
  2. Leverage the diagnostics to troubleshoot and mitigate issues quickly in mission-critical environments
  3. Simplify troubleshooting experience for common SQL Server scenarios

Session Name: Always On Availability Group Troubleshooting Ninja (Session Link)

Level: 400

Date: 6th May, 2016

Time: 12:15pm – 1:15pm

Session Objectives:

  1. Troubleshoot failovers in your Availability Group easily
  2. Determine the reason for connectivity loss and timeouts
  3. Understand which part of your topology is the reason for latency