February SQL Server User Group meeting

Post date: Jan 27, 2019 3:49:26 AM

When: Wednesday, 02/13/2019

Agenda:

• 5:45 - 6:15: Introduction/Food and Drinks

• 6:15 - 7:30: Presentations

• 7:30 - Until: Open forum for questions

Location: Alliance Safety Council

Main Presentation:

Performance Optimization with Azure SQL Database

The cloud is just using someone else's compute. You still need to care about and optimize for performance.  Just as a dropped call frustrates cellular customers, an app with data issues, high latency, connection timeouts will create the same frustration for users.  Do you want to catch the performance issues before your customers?  Do you want to automatically identify database issues and quickly drill down into details? Azure provides built in tools just to do that. 

In this session I will show you 4 of those tools.  You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance.  Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure  automatically optimize your database. 

At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance  issues with built in tools in Azure Portal.

Main Speaker: Taiob Ali

Taiob Ali, an accomplished technical leader with proven record of success. He has spent the last 13 years working with SQL Server and MongoDB platform both on premise and cloud. His experience includes three major business sectors: financial industry, e-commerce and healthcare. Taiob has hands on experience in managing large database projects including large data migration, complex process design, testing and deployment, performance tuning, long term capacity planning.

Taiob is currently working at “GMO LLC” as lead DBA. Focusing on automation, improving and streamlining operational workflow, plan and prepare for cloud migration. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays and Azure conferences. This month's meeting is brought to you by Vinformatix - http://www.vinformatix.com/