Tag Archives: SQL Saturday

SQL Saturday 686–Upgrade your SQL Server like a Ninja

Posted on by

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!

Advertisement

SQL Saturday 613: Building 1 million predictions per second with R-services and SQL Server 2016

Posted on by

image

Last Saturday, I presented a session on how to use R-Services with SQL Server to build an analytical workflow for banking solutions. I talked about how our customer, Jack Henry & Associates, an S&P 400 company that supports more than 11,300 financial institutions with core processing services, is leveraging the power of SQL Server and R to make drive intelligent insights into their data warehousing software. Below you will find a link on how you can setup the complete solution that you can deploy on our Data Science Virtual Machine on Azure.

Our Corporate Vice President, Joseph Sirosh, had demonstrated this solution along with Jack Henry & Associates at Ignite. In this session, I talked about the nuts and bolts on how to build a scalable predictive engine with SQL Server and using the enhancements shipped in SQL Server 2016. After this session, you will be able to build your very own scalable predictive engine on SQL Server 2016!

As always, it’s always great to meet my friends and the community at SQL Saturday events!

The slide deck used for my presentation can be found on SlideShare. The PowerBI dashboard and the demo scripts can be downloaded from the tigertoolbox repo on GitHub.

SQL Saturday 511: Extended Events and more

Posted on by

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.

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 Saturday 76: The WiFi gods were happy

Posted on by

 

I just concluded my presentation on “Debugging the Deadlock for the Scheduler” at SQL Saturday 76 over a Lync meeting. The WiFi and Lync gods decided to be benevolent today and let me present without an untoward incident! As always it was fun to demonstrate the use of a debugger…Winking smileThe attempt of the presentation was to demonstrate what can be done proactively and reactively when dealing with a deadlocked schedulers condition.

A special thank you is due to all the sponsors without whom the event today wouldn’t have been possible: Microsoft New Zealand, RedGate, SQL Pass, New Zealand MS Communities and SQL Services!

The slide deck used for presentation today is available on Slide Share and is embedded below:

The demo files used are available at SkyDrive in the file SQLSat76_Demo.zip The walkthrough for the debugging that I explained along with the use of the Powershell script to automatically collect DMV outputs based on messages in the Windows Application event log are available using the posts available under the walkthroughs link below as well as the zip file mentioned above.

And last but not the least, a big Thank You to Dave [Twitter | Blog] for helping arrange all the logistics so that I could present and also for giving me this opportunity!

Resources:

Whitepaper: How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888
http://msdn.microsoft.com/en-us/library/cc917684.aspx

Walkthroughs
https://troubleshootingsql.com/tag/deadlocked-schedulers/

WinDBG
http://msdn.microsoft.com/en-us/windows/hardware/gg463009

Microsoft Public Symbol Server
http://msdl.microsoft.com/download/symbols

KB: New concurrency and scheduling diagnostics have been added to SQL Server
http://support.microsoft.com/kb/319892/en-us

Cheers!