Tag Archives: Webcasts and Events

Data Platform Summit 2017

Posted on by

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_C13 – Running Applications On Azure Using Postgres/MySQL
Date: 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.

SQL Saturday 446–Slow Query, Bring It On

Posted on by

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

Posted on by

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

SQLBangalore UG Meeting – Sep 6

Posted on by

Come join us on Saturday, September 6th for another SQL Bangalore User Group meeting to learn more about Azure Backups, SQL Server 2014 In-memory OLTP, Hybrid cloud scenarios and Power BI.

The session line up is available below.

14:00PM 14:45PM – Azure Backup by Ravikanth
14:45PM 15:30PM – Performance Improvement and In-memory – Balmukund Lakhani
15:45PM 16:30PM – Hybrid Cloud Scenario with SQL Server – Vinod Kumar
16:30PM 17:15PM – Power BI Overview – by yours truly

I will show you how you can use Power BI and Excel can be used to analyze your Facebook data and much more. Register for the event here. As usual, I will post the content used during that day on this blog. Stay tuned in case you are not able to attend in person. And don’t forget to spread the word! Hope to see in person on the 6th!

Venue:
Microsoft Corporation, Signature Building,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Domlur, Bangalore – 560071

The slide deck that I used for this session is available below.

SQLBangaloreUG: It is going to be a cloudy day

Posted on by

sponsor-bangaloreUGWHEN: Saturday, August 2, 2014 from 10:00 AM to 1:30 PM (IST)

WHERE: Embassy Golf Links Business Park, Bangalore, India

We are prepping up for another SQL Bangalore User Group meeting on August 2nd, 2014. I will be presenting on SQL Server provisioning on Azure Virtual Machines. We will see how the latest hooks provided in Azure makes provision and post installation configuration easier.

And what’s more, this SQL Bangalore User Group session is devoted to AZURE! So, if you are interested in learning about Azure, then do come and attend the session. There is a great lineup of speakers who will be presenting on various interesting topics:

  • Be Smart with …Smart Backup – Pranab Mazumdar (Twitter) – Escalation Engg, Microsoft
  • Zero to hero with Azure ML (Machine Learning) – Govind Kanshi (Twitter) – Technical Director, MTC
  • Introduction to Azure Redis Cache – Angshuman Nayak – Escalation Engg, Microsoft

So join us for another day of learning. See you in-person on the 2nd!

As usual, I will post the content used during that day on this blog post. Stay tuned in case you are not able to attend in person.

Signup for the event here and don’t forget to spread the word!