SQL Special Events are free community events from SQLMaestros. Why Special? At these events, we deliver deep-dive sessions on SQL Server & Azure SQL Stack. Each session covers a topic end-to-end, provides comprehensive coverage & advanced-to-expert level content. Putting these together, we make the events *Special*. So if you are looking for some advanced training, free of cost, check-out the schedule below. Spread the word, events are absolutely free.

Upcoming FREE SQLMaestros Special Events

Yeah, an event is coming up. Check out now.

Recent & Past Events

Session Title: A Practical Introduction to SQL Server Concurrency – Part 2

Webinar Recording | Browse Video Courses

Session Title: Understanding Parallelism in SQL Server

Webinar Recording | Browse Video Courses

Session Title: Top 5 Query Hints – A Practical Approach

Webinar Recording | Browse Video Courses

Session Title: A Practical Introduction to SQL Server Concurrency – Part 1

Webinar Recording | Browse Video Courses

Session Title: A Practical Introduction to Extended Events

Webinar Recording | Browse Video Courses

Session Title: SQL Server Wait Types – Let’s Cause One, Diagnose It & Fix It

Webinar Recording | Browse Video Courses

Session Title: Top 3 SQL Server Tuning Techniques – Part 2

Webinar Recording | Event Resources | Browse Video Courses

Session Title: Top 3 SQL Server Tuning Techniques – Part 1

Webinar Recording | Event Resources | Browse Video Courses

Session Title: 6 Query Tuning Techniques to Solve 75% of Performance Problems – V2

Event Resources

Session Title 1: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 1

Session Title 2: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 2

Event Resources

Session Title: 6 Query Tuning Techniques to Solve 75% of Performance Problems

Event Resources

Session Title: 6 Query Tuning Techniques to Solve 75% of Performance Problems

Event Resources

Session Title: Three Query Tuning Techniques For SQL Developers

Event Resources

Session Title: Implementing SQL Server Extended Events

Event Resources

Session Title: Implementing Extended Events Part 2

Event Resources

Session Title: Implementing Extended Events Part 1

Event Resources

Session Title: SQL Server 2019 Intelligent Query Processing Part-2

Event Resources

Session Title: SQL Server 2019 Intelligent Query Processing Part-1

Event Resources

Session Title: Part 2 – How to Troubleshoot a Slow Running Query in SQL Server

Event Resources

Session Title: Understanding NULLs in SQL Server

Abstract:
SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this 30 min session, we will try to go through different test cases to understand NULLs properly.

Event Resources

Session Title: Part 1 – How to Troubleshoot a Slow Running Query in SQL Server

Abstract:
You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.

Event Resources

Session Title: Understanding SQL Server Indexes – The Right Way

Event Resources

Session Title: Plan Caching & Recompilation in SQL Server

Event Resources

Session Title: DELETE vs TRUNCATE – Myths & Misconceptions

Abstract:
DELETE and TRUNCATE are two commands that helps in data deletion. Even though these commands are considered to be most basic ones, still there are lot of misconceptions around them, especially TRUNCATE. TRUNCATE can’t be logged, TRUNCATE can’t be rolled back etc. In this session, we will try to debunk all the myths and misconceptions.

Event Resources

Session Title: Top 10 SQL Server Performance Tuing Tricks

Abstract:
Do you want Top 10 Tricks to improve SQL Server Performance instantly? Join this demo-heavy 2-hour session with the master himself and watch the top 10 tricks in action with real-world scenarios. Tricks will be wide spread and will cover server-level tuning, database-level tuning, and a couple of tricks with CPU, Memory IO & Tempdb tuning. Finally special focus on Indexes & query tuning. These 10 ticks will be a life-saver and you can deploy in your production right away. If you are serious about SQL Server Performance Tuning, this session is un-miss-able.

Event Resources

Session Title: SQL Server Query Tuning – Step by Step

Abstract:
In this webinar, you will learn how to tune a SQL Server Query, step-by-step. You will investigate why a query is running slow, what it is waiting for, capture relevant information and then diagnose and fix the root cause of a performance issue.

Event Resources

Session Title 1: Real World Query Tuning in SQL Server
Session Title 2: SQL Server Backup & Restore

Event Resources

Session Title: Temporary Tables Vs Table Variables – SQL Server

Event Resources

Session Title: SQL Server Statistics – Things That You Didn’t Know

Abstract:
Join Microsoft Certified Master & MVP, Amit Bansal, and learn about the internals of SQL Server Statistics, Histogram, Cardinality Estimation and more.

Event Resources

Session Title: Understanding Dynamic SQL – The Right Way

Event Resources

Session Title: Understanding SQL Server Joins – The Right Way

Event Resources

Session Title: Concurrency Problems in SQL Server

Abstract:
In this session, we are going to discuss about various concurrency problems that are identified in SQL Server like, Dirty Reads, Non-Repeatable Reads, Phantom Reads etc., We will also discuss about Optimistic Concurrency & Pessimistic Concurrency models and how SQL Server uses locking behind the scenes to maintain data consistency.

Event Resources

Session Title: Advanced SQL Server Indexing

Abstract:
Learn some real-world, practical, index tuning strategies that will help SQL Server Developers & DBAs to make their queries run faster

Event Resources

Session Title: SQL Server Performance Tuning

Abstract:
If you have never attended Amit Bansal’s SQL Performance Tuning class, you have missed some solid stuff. So here is your opportunity to attend a free half-day SQL Server Performance Tuning class by the Master. Whether you are a Developer or DBA or Architect, you will learn things that you never knew about SQL Server. Assured.
So what are the topics? Well, that’s a surprise. The half-day content will be decided by Amit Bansal and the topics will span all versions of SQL Server and all roles that work with SQL Server. But one thing is guaranteed – you will learn new things that you can apply into your job & projects right away.

Event Resources

Session Title: SQL Server Indexing – Basics

Abstract:
In this session, we are going to cover the basics of Clustered Indexes & Non-Clustered Indexes.
1. How to create them and some best practices to follow.
2. What is a covering index and how is it useful.
3. What is fragmentation and how to defrag indexes
4. What is fill factor and how is is useful.
This is going to be a level 100 session targeted towards Developers & DBAs beginning their careers with SQL Server.

Event Resources

Session Title: Troubleshooting SQL Server IO Performance/Bottleneck

Abstract:
In this webinar, you will understand how sys.dm_io_virtual_file_stats can be used to identify/detect/compute read latency on slow IO, how Avg. Disk sec/Read performance monitor counter can be used to identify/detect/compute read latency on slow IO and how to find out queries that are causing maximum IO in SQL Server (Top IO Queries).

Event Resources

Session Title: SQL Server Statistics – Things That You Didn’t Know

Abstract:
Join Microsoft Certified Master & MVP, Amit Bansal, and learn about the internals of SQL Server Statistics, Histogram, Cardinality Estimation and more.

Event Resources

Session Title: Simplifying SQL Server Performance Tuning

Abstract:
SQL Server Performance Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a troubleshooting methodology that can be put into production right-away!

Event Resources

Session Title: Real World Query Tuning Examples

Abstract:
Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples. In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes & deal with statistics to improve query performance. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.

Event Resources

Session Title: SQL Server Memory – Part 1

Abstract:
Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured.

Event Resources

Session Title: Real World Query Tuning Examples

Abstract:
Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples. In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes & deal with statistics to improve query performance. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.

Event Resources

Session Title: SQL Server Memory

Abstract:
Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured.

Event Resources

Session Title: SQL Server Memory – Part 1

Abstract:
Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured.

Event Resources

Session Title: New Security Features Every SQL Professional Should Know

Abstract:
If you do not know security enough, you are not a pro yet. The foremost challenge any organization has today is to keep data secured. In this deep-dive session you will learn about Always Encrypted, Data Masking & Row-Level Security. Some really cool innovations in SQL Server 2014/2016/2017. Not only learn, but also watch some awesome demos.

Event Resources

Session Title: Real World Query Tuning Examples

Abstract:
Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples. In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes & deal with statistics to improve query performance. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.

Event Resources

Session Title: Benchmarking & Baselining In-Memory OLTP Performance

Abstract:
In this session by Microsoft Certified Master Amit Bansal, will take a deep-dive into SQL Server In-Memory OLTP. This will be a demo-packed session. Amit will show where and how exactly In-Memory OLTP help improve SQL Server performance. Many SQL Server professionals do not have the right understanding of these technology. In this session, all myths will be busted. The content presented in this session is from Amit’s Master Class. Make sure you do not miss this.

Event Resources

Session Title:SQL Server Performance Tuning Techniques with SQL 2014/2016 & Getting Started with Data Science in Azure

Session Title: Introduction to Machine learning

Session Title: Getting Started with Data Science in Azure

Session Title: Advanced Aggregations in SQL Server

Abstract:
Aggregating and summarizing data is required in almost every domain. Aggregations can be as simple as calculating maximum/minimum/average or as complex as calculating sliding aggregations. Knowing how to write efficient aggregate queries is important to learn for every T-SQL developer. In this Advanced Aggregation session, Ahmad will talk about using Grouping Sets, ROLLUP and CUBE for aggregation and using OVER Clause with aggregate functions. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code, you won’t want to miss this session.

Event Resources | Orginal Emailer

Session Title: Advanced Pivoting in SQL Server

Abstract:
Pivoting is a technique to reorganize rows to columns to get an aggregated or summarized view of a possibly a large dataset. Pivoting is used in large number of applications and helps solve many reporting needs. In this all-demo Pivoting session, Ahmad will present advanced pivoting real life solutions involving relational division, data aggregations and dynamic pivoting. He’ll also talk about Un-Pivoting, which is the reverse of pivoting. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.

Event Resources | Orginal Emailer

Session 1:Stored Procedure Optimization
Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Abstract: Stored procedures in SQL Server provide multiple benefits such as encapsulating complex business logic, easy deployments and maintenance, data accessibility to name a few. Store Procedures are essential for any database deployment. Optimizing Stored Procedure performance is critical to increasing your application performance. Did you ever come across a situation when a stored procedure, working perfectly the other day, suddenly takes longer to execute? Did you ever come across a situation where a procedure takes longer time to execute for certain set of parameter values? If yes, then this session is for you. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.

Session 2:SQL Server Index Tuning
Amit R S Bansal (MCM, MVP, SQLMaestros)
Abstract: Having the right indexing strategy is super-critical to SQL Server performance. Join Microsoft Certified Master Amit Bansal in this demo-packed session and learn how to tune SQL Server Indexes. Both clustered and non-clustered indexes will be covered extensively and you can take the learnings back to your environment and apply immediately. Time to become an indexing hero!

Here is the photo collection!




Browse Event Pictures |Event Resources | Orginal Emailer

Session Title: In-Memory for Developers

Abstract:
Microsoft introduced In-Memory OLTP in SQL Server 2014. We all know about the technology and how it improves the performance, however how can a developer efficiently use in-memory tables and natively compiled stored procedures to get the blazing fast performance that the technology has to offer. In this demo heavy session, you’ll learn to create and access memory optimized tables and indexes and the latch and lock free new transaction model. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.

Event Resources | Orginal Emailer

Session Title: SQL Server Concurrency Problems

Abstract:
Well these are not SQL Server’s Concurrency Problems, there are concurrency problems that can happen in SQL Server 🙂 – Come to this session if you want a deep dive in concurrency problems that are causing performance issues in SQL Server. You are investigating everything else, but the problem lies in concurrency. We will go very deep into the nuts-and-bolts of how SQL Server handles concurrency.

Event Resources | Orginal Emailer | Blog

Session Title: Data Cleansing With SSIS

Abstract:
No one likes dirty data, especially business. Analysing dirty data can result in business disasters. Join Ahmad Osama, Microsoft Data Platform MVP & world renowned BI Expert, and learn advanced data cleansing techniques in SSIS. Clean the data so that it make business sense. Ahmad will show you how!.

Event Resources | Orginal Emailer | Blog

Session Title: Troubleshooting Common Performance Issues in SQL Server

Abstract:
Learn some internals and a few tips & tricks to solve common SQL performance issues. Take the learnings and apply back to your SQL Server Environment straight-away to improve performance. The content of this session is an extract from SQLMaestros Performance Tuning Master Class. And because this is a SQL Special Event, it will be a two-hour deep dive session.

Event Resources | Original Emailer | Blog

Session Title: Troubleshooting Common Performance Issues in SQL Server

Abstract:
Learn some internals and a few tips & tricks to solve common SQL performance issues. Take the learnings and apply back to your SQL Server Environment straight-away to improve performance. The content of this session is an extract from SQLMaestros Performance Tuning Master Class. And because this is a SQL Special Event, it will be a two-hour deep dive session.

Event Resources | Orginal Emailer | Blog

Session Title: Troubleshooting Common Performance Issues in SQL Server

Abstract:
Learn some internals and a few tips & tricks to solve common SQL performance issues. Take the learnings and apply back to your SQL Server Environment straight-away to improve performance. The content of this session is an extract from SQLMaestros Performance Tuning Master Class. And because this is a SQL Special Event, it will be a two-hour deep dive session.

Event Resources | Original Emailer | Blog

Session Title: Deadlocks – Everything You Need to Know

Abstract:
Whether you are a developer or a DBA, deadlocks bother everyone. So much so, deadlocks give sleepless nights even to the Chief Technology Officer. How? Well, how many times you tell your manager that “this is because of the deadlock” and you cannot do anything about deadlocks. And your manager vomits the same story up the chain.

Come to this session and learn the internals of deadlocks in SQL Server. Why they happen. Different types. Troubleshooting. How to minimize. Best Practices. Deadlock Internals. And much more, everything you want to know about deadlocks. This will be an extended two hour spotlight session with some awesome demos. Well, all SQLMaestros Special In-Person Events are deep-dives and each session is at least two hour of content followed by Q&A

Here is the photo collection!

Browse Event Pictures |Event Resources | Original Emailer | Blog

Session Title: Deadlocks – Everything You Need to Know

Abstract:
Whether you are a developer or a DBA, deadlocks bother everyone. So much so, deadlocks give sleepless nights even to the Chief Technology Officer. How? Well, how many times you tell your manager that “this is because of the deadlock” and you cannot do anything about deadlocks. And your manager vomits the same story up the chain.

Come to this session and learn the internals of deadlocks in SQL Server. Why they happen. Different types. Troubleshooting. How to minimize. Best Practices. Deadlock Internals. And much more, everything you want to know about deadlocks. This will be an extended two hour spotlight session with some awesome demos. Well, all SQLMaestros Special In-Person Events are deep-dives and each session is at least two hour of content followed by Q&A.

Here is the photo collection!



Browse Event Pictures |Event Resources | Original Emailer | Blog

Session Title: Back-to-Indexes, The Original Culprit

Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Event Resources | Original Emailer | Blog

Session Title: Master The Art of Public Speaking – Part 1

Abstract:
Yes We Can! Remember this? Good oratory skills can land you the top job, be it the President of the United States or the Prime Minister of India – public speaking skills is indeed that important today! Even if you don’t need to make regular presentations in front of a group, there are plenty of situations where good public speaking skills can help you advance your career and create opportunities. In fact, top jobs need those skills. And don’t you want to climb the ladder for that top job? Come to this session if you want to get a kick-start in public speaking. Amit Bansal, who has learnt the art of public speaking the hard way, will teach you these skills, step-by-step. Amit has delivered a number of sessions at international conferences like TechEd, PASS Summit, SQL Bits, GIDS, Economic Times – Power of Ideas, Images Retail Confernce, etc – and he will bring all his experiences in a series of sessions, starting from March 29, Part 1 of “Master The Art of Public Speaking”. These sessions are unmissable.

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Back-to-Indexes, The Original Culprit

Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Here is the photo collection!



Browse Event Pictures |Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Back-to-Indexes, The Original Culprit

Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Here is the photo collection!


Browse Event Pictures |Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: SQL Server 2014 Cardinality Estimator

Abstract:
Join SQL MCM, SQL MVP & Microsoft Regional Director, Amit Bansal, in this intriguing session that demo’s the new Cardinality Estimator in SQL Server 2014. Learn how calculations and assumptions are made inside the black box using statistics. Watch the old and the new cardinality estimator in action, you will love it!

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Dealing with Parameter Sniffing

Abstract:
Parameter Sniffing is a technique by which SQL Server query optimization engine sniffs the parameter value from the query and generates an optimized execution plan based on that value. A good thing? Or a bad thing? Well, not so easy to jump to an answer and that is why you should attend this session!

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Back-to-Indexes, The Original Culprit

Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Here is the photo collection!



Browse Event Pictures |Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Mind Your IO: Resource Governor Shows You How

Abstract:
Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. In prior releases, there have been incremental enhancements to this feature. SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, you will learn to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQLServer:Resource Pool Stats.

Here is the photo collection!


Browse Event Pictures |Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Tracking Page Splits with Extended Events

Abstract:
What are Page Splits? How do they cause index fragmentation? How to track them? How to fix them? Get your answers to all such questions! Microsoft Certified Master and MVP, Amit Bansal will take you through a demo-oriented session explaining all the concepts and show you a practical way to deal with page splits, a technique that you can take you your environment and get instant performance boost!

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session Title: Simplifying SQL Server Performance Tuning

Abstract:
SQL Server Performance Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a troubleshooting methodology that can be put into production right-away!

Event Resources | Orginal Emailer | Blog

 

Past SQL Server events sponsored by SQLMaestros

We sponsor SQLServerGeeks SQL Server Day events in India. This is our contribution towards SQL Server community. We have been sponsoring SQL Server Day events since last 3 years have sponsored more than 40+ events including in-person events and web casts.

You will love watching the SQL Server Day collection:
Check out SQL Server Day albums on Facebook

Do you want to be notified of future classes and events? Click Here

Leave A Comment