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)
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 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!

Advertisements

SQL Saturday 446–Slow Query, Bring It On


The next two weeks is going to be a whirlwind and it all starts with the SQL Saturday at Portland. There is a plethora of Data Platform subject matter experts who will be descending on the city to mingle with the SQL Family. What’s more a number of them will be surfacing a week later at the SQL PASS Summit as well.

I have always been a big proponent of sharing the knowledge with the community and SQL Saturday is prime way to do that.

The day will get kick started with a keynote session from James Phillips, Microsoft Corporate Vice President of the Business Analytics Product Group. He will present an overview of Microsoft’s Data Platform and Cloud Strategy.

There are multiple tracks which will be running on the same day. It’s going to a be a difficult pick building your schedule but it will also give you a taste of what schedule building for PASS would be like.

  • Admin
  • Architecture
  • Business Intelligence
  • Development
  • Features
  • PowerShell
  • Professional Development
  • Reporting Services
  • Tuning

There are a number of sessions from various known community subject matter experts on various subjects on the tracks listed above. I am really looking forward to this event! This will be an awesome prelude to PASS!

I will be presenting a session on query performance troubleshooting under the Tuning tracks this Saturday which will feature Live Query Statistics and Query Data Store along with a guest appearance from the Query Plan Comparison feature in the latest SQL Server Management Studio.

There is also a SQL Server Clinic at the event. So if you want to chat about questions about SQL Server in your environment or anything data related, then bring them to the experts at the Clinic.

Session name: Slow Query: Bring It On

Duration: 60 minutes

Date: 24th Oct, 2015

Venue Mittleman Community Center

Timing: 10.30am – 11.30am

Session Abstract

Troubleshooting slow performance issues is hindered by lack of available repro or even at times lack of available statistics. This puts the chief troubleshooter in a Catch-22 situation. Without identifying the problem, the issue could resurface again and create another critical business problem. SQL Server 2016 introduces two new features to troubleshoot query performance issues in a reactive and proactive manner namely, Live Query Statistics and Query Data Store. In this session, you will learn about:

1. Using Live Query Statistics to perform live troubleshooting while it is running

2. Using Query Data Store and becoming a SQL superhero by answering questions about query performance with a click of a few buttons

As always, I will update this post with the session deck and any Q&A that comes my way during the event.

The slide deck that I used at the event is available below.

SQL PASS Summit 2015: Pre-Con and more


Sourabh and I completed our 24HOP session in the morning (or at least my morning… night, afternoon or evening, depending on which part of the world) you live in. A big THANK YOU to everyone that attended the session and we had a ball presenting the session. We have a little over 200 people attending the session and we hope see a good number of these during our pre-conference session at PASS.

The Summit gives you an opportunity to attend sessions from technical experts across the world and is the largest gathering of Data Platform Professionals in the world. To me SQL PASS Summit is a great way to connect with the SQL Family with whom I only have virtual conversations throughout the year. If you want to do deep-dive of sessions on various things in the SQL Server space, then you have a line-up of pre-con sessions.

There will be a contingent of engineers, program managers and Microsoft Services folks at the SQL Server Clinic to help answer your queries regarding SQL Server. So, don’t forget to stop by the SQL Clinic in case you have a question that you have been meaning to ask for a while!

Apart from all the nerdy and geeky overdose, you have the option of painting the town red during the week that you are in town and attend social gatherings after the sessions. There is always more than one happening and you get to take your pick! It was definitely fun when I attended it last time and it’s going to be fun this time as well. If you are attending for the first time, then brace yourself for an action-packed, geeky overdose and fun-filled SQL adventure! And don’t forget to check out the first-timers page on the Summit website. If you are returning attendee, then you know what I am talking about! J

Sourabh Agarwal [b|t] and I are going to be presenting on How to be a Ninja: Troubleshooting SQL performance on Azure Virtual Machines [DBA-399-PM]. This is a demo packed full day session which will cover a plethora of stuff related to SQL Server. To name a few:
1. Automation deployment on Azure Virtual Machines for SQL Server instances
2. Best practices for using SQL Server on Azure Virtual Machines and some of these apply to on-premise SQL Server instances as well. We will document the differences between the two based on our vast experience working on issues with Microsoft customers. We have gathered working for different teams within Microsoft specializing in SQL Server.
3. Troubleshooting performance issues. This is where you will gain your Ninja status! We have made a career within Microsoft on troubleshooting complex SQL issues. We will show you how to troubleshoot performance problems on SQL Server instances which applies to Azure VMs, on-premise SQL Server instances and virtualized environments.
4. We will also give you a preview of some of the enhancements done for SQL Server deployments on Azure by the SQL Server product group at Microsoft.
5. And it is about having fun…. We will definitely give you a thing or two to laugh about as well.

A screenshot of our agenda slide for the pre-con is available below. We also have a bunch of Easter eggs that we will crack open in the session. Psssst.. Some of the stuff is still under works and should be out of the door when we present!

image

When: 27th October

Time: 8:30am – 4:30pm PST

Where: Washington State Convention Center

Session URL: http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=38085

Lastly, we loved the notes that Matt Penny [t] took during our session. A screenshot of that is shown below. Thank you Matt! J The 24HOP session presentation is attached on the session page.

Notes