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 2: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 2
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.
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.
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.
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.
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.
Session Title 2: SQL Server Backup & Restore
Abstract:
Join Microsoft Certified Master & MVP, Amit Bansal, and learn about the internals of SQL Server Statistics, Histogram, Cardinality Estimation and more.
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.
Abstract:
Learn some real-world, practical, index tuning strategies that will help SQL Server Developers & DBAs to make their queries run faster
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.
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.
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).
Abstract:
Join Microsoft Certified Master & MVP, Amit Bansal, and learn about the internals of SQL Server Statistics, Histogram, Cardinality Estimation and more.
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
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.
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!.
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.
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.
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.
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
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 !
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
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)
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!
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
Leave A Comment