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

MSSQLTIGER and April PASS Virtual Conferences


Cross post from http://aka.ms/sqlserverteam

PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including an archive of past presentations, and special training events. The MSSQL Tiger team will be presenting at PASS VC sessions on different topics in the coming months. We will keep announcing the upcoming sessions on this blog.

The two sessions that we will be presenting in April are mentioned below. If you are interested in in-memory technologies or leveraging PowerShell for your SQL Server instances, then the two sessions below would be of interest to you.

April 20th at 10am PST (In-memory VC): Real-Time Operational Analytics in SQL Server 2016 [Session Registration Link]

SQL Server 16 enables customers can run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Operational Analytics.

April 20th at 9am PST (PowerShell VC): You, SQL Server and PowerShell [Session Registration Link]

In this session, Microsoft’s SQL Server Tiger Team will talk about how some best practice checks can be automated for SQL Server instances running on your on-premise data centers and on Azure Virtual Machines. Attend this session to learn how you can leverage the POWER of PowerShell to automate health checks, keep your systems healthy and run SQL Server efficiently! As an added bonus, this session will also cover some of the new enhancements available in SQL Server 2016 setup which will allow you to implement these best practices while installing SQL Server!

The PowerShell scripts can be downloaded from https://github.com/amitmsft/SqlOnAzureVM

The session slide deck is available below.

The session recording is available on YouTube.

SQL Saturday 511: Extended Events and more


imageExtended Events have evolved a lot since they were first introduced in SQL Server 2008. And today, there are multiple extended events available in SQL Server which allow you to debug common scenarios without collecting having to collect memory dumps or diagnostic data which can be detrimental to your SQL Server instance’s performance.

On April 2nd, join me at Redmond to understand how to leverage the new extended events that are available in SQL Server 2012 Service Pack 3 and above in your environments. I will talk about common scenarios where the new extended events are available and provide canned scripts to help collect and analyze data for complex scenarios.

There are a host of SQL experts and as well as folks from the Microsoft SQL Server product group who will be at the event to present and answer questions that you have! Looking forward to meet the SQL Community at the event!

WHEN: April 2nd, 2016, 2.15 – 3.15 PM PST
SESSION: Troubleshooting made easier using Extended events

Details about the session are available here. The full schedule of the event is available here.

The slide deck that I used during the session is available below.