Event | Resources | Recording |
---|---|---|
SQLMaestros Special Event – 23 March 2023 Session: Top 3 SQL Server Tuning Techniques – Part 2 Speaker: Amit R S Bansal | Download | Watch Now |
SQLMaestros Special Event – 3 March 2023 Session: Top 3 SQL Server Tuning Techniques – Part 1 Speaker: Amit R S Bansal | Download | Watch Now |
SQLMaestros Special Event – Apr 2022 Session: Query Tuning – From Soup to Nuts Speaker: Amit R S Bansal | Download | Watch Now |
SQLMaestros Special Event – Jan 2022 Session: Query Tuning – From Soup to Nuts Speaker: Amit R S Bansal | Download | Watch Now |
Israel Data Platform Community Meetup – July 2021 Session: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits Speaker: Amit R S Bansal | Download | Watch Now Watch Now |
SQLMaestros Special Event – June 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems – V2 Speaker: Amit R S Bansal | Download | |
SQL Saturday Los Angeles June 2021 Session: Developer Best Practices In SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
Data Ceili May 2021 Session: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits Speaker: Amit R S Bansal | Download | Watch Now Watch Now |
Cloud Data Driven UG Meeting May 2021 Session: How To Troubleshoot A Slow Running Query In SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
GroupBy – May 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems – V2 Speaker: Amit R S Bansal | Download | |
SQL Day – May 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
Data Weekender – MAY 2021 Session: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits Speaker: Amit R S Bansal | Download | Watch Now Watch Now | Data Saturday Malta – April 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now | Data Saturday Redmond – April 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now | Data Saturday Haiti- March 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
SQLMaestros Special Event – March 2021 Session 1: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 1 Session 2: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 2 Speaker: Amit R S Bansal | Download | Watch Now Watch Now |
Data Saturday Pordenone – FEB 2021 Session: SQL Server Memory Internals & Troubleshooting Speaker: Amit R S Bansal | Download | Watch Now |
EightKB – JAN 2021 Session: SQL Server Memory Internals & Troubleshooting Speaker: Amit R S Bansal | Download | Watch Now |
Data Saturday Guatemala – JAN 2021 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Plovdiv – DEC 2020 Session: Understanding SQL Server Views – The Right Way Speaker: Satya Ramesh | Download | Watch Now |
SQLSaturday Montreal – NOV 2020 Session: Real-World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
PASS Summit – NOV 2020 Session: Developer Best Practices in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Summit 2020 – DEC 2020 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
DataPlatformGeeks Webinar, October 29, 2020 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
Group By – OCT 2020 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Oregon – October 24, 2020 Session: How To Troubleshoot A Slow Running Query In SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Oregon – October 24, 2020 Session: Understanding SQL Server Views – The Right Way Speaker: Satya Ramesh | Download | Watch Now |
DataWeekender – OCT 2020 Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Malaysia – October 17, 2020 Session: Real-World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Sofia – October 10, 2020 Session: Real-World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Sofia – October 10, 2020 Session: Understanding SQL Server Views – The Right Way Speaker: Satya Ramesh | Download | Watch Now |
SQLMaestros LIVE Training #4 – October 1, 2020 Session: Three Query Tuning Techniques For SQL Developers Speaker: Amit Bansal | – | Watch Now |
SQLMaestros LIVE Training #3 – September 17, 2020 Session: Implementing SQL Server Extended Events Speaker: Amit Bansal | – | Watch Now |
SQLMaestros LIVE Training #2 – September 10, 2020 Session: Implementing Extended Events Part 2 Speaker: Amit Bansal | – | Watch Now |
SQLMaestros LIVE Training #1 – September 03, 2020 Session: Implementing Extended Events Part 1 Speaker: Amit Bansal | – | Watch Now |
SQLSaturday Salt Lake City – August 29, 2020 Session: How to Troubleshoot a Slow Running Query in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
SQLSaturday Salt Lake City – August 29, 2020 Session: Understanding NULLs in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
SQLSaturday Auckland – August 08, 2020 Session: Developer Best Practices in SQL Server Speaker: Amit R S Bansal | Download | – |
DataPlatformGeeks Virtual Symposium – May 08, 2020 Session: SQL Server 2019 Intelligent Query Processing Part-2 Speaker: Satya Ramesh | – | Watch Now |
DataPlatformGeeks Virtual Symposium – May 07, 2020 Session: SQL Server 2019 Intelligent Query Processing Part-1 Speaker: Amit R S Bansal | – | Watch Now |
DataPlatformGeeks Webinar, April 30, 2020 Session: Part 2 – How to Troubleshoot a Slow Running Query in SQL Server Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar – April 21, 2020 Session: Understanding Views in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
Data Platform Day, Bengaluru – February 22, 2020 Session: Understanding NULLs in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
DataPlatformGeeks Webinar – February 18, 2020 Session: Understanding NULLs in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
DataPlatformGeeks Webinar, February 11, 2020 Session: Part 1 – How to Troubleshoot a Slow Running Query in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Bengaluru – November 9, 2019 Session: Understanding SQL Server Indexes – The Right Way Speaker: Satya Ramesh | Download | Watch Now |
DataPlatformGeeks Webinar, November 7, 2019 Session: Understanding SQL Server Indexes – The Right Way Speaker: Satya Ramesh | Download | Watch Now |
DataPlatformGeeks Webinar, October 12, 2019 Session: Plan Caching & Recompilation in SQL Server Speaker: Amit R S Bansal | – | Watch Now |
Data Platform Day, Bengaluru – October 5, 2019 Session: DELETE vs TRUNCATE – Myths & Misconceptions Speaker: Satya Ramesh | Download | Watch Now |
DataPlatformGeeks Webinar, October 3, 2019 Session: DELETE vs TRUNCATE – Myths & Misconceptions Speaker: Satya Ramesh | Download | Watch Now |
Data Platform Day, Bengaluru – July 20, 2019 Session: Top 10 SQL Server Performance Tuning Tricks Speaker: Amit R S Bansal | – | – |
Data Platform Day, Hyderabad – July 06, 2019 Session: Top 10 SQL Server Performance Tuing Tricks Speaker: Amit R S Bansal | – | – |
Data Platform Day, Bengaluru – June 08, 2019 Session: Top 10 SQL Server Performance Tuing Tricks Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, May 23, 2019 Session: SQL Server Query Tuning – Step by Step Speaker: Amit R S Bansal | – | – |
Group By – April 23, 2019 Session: SQL Server Memory Internals & Troubleshooting Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Hyderabad – April 20, 2019 Session: Real World Query Tuning in SQL Server Speaker: Amit R S Bansal Session: SQL Server Backup and Restore Speaker: Satya Ramesh | Download | Watch Now Watch Now |
Data Platform Day, Bengaluru – April 06, 2019 Session: SQL Server Memory Internals Speaker: Amit R S Bansal Session: Understanding Dynamic SQL – The Right Way Speaker: Satya Ramesh | Download | Watch Now Watch Now |
Data Platform Day, Chennai – March 30, 2019 Session: Real World Query Tuning in SQL Server Speaker: Amit R S Bansal Session: Understanding Dynamic SQL – The Right Way Speaker: Satya Ramesh | Download | Watch Now Watch Now |
DataPlatformGeeks Webinar, March 28, 2019 Session: SQL Server Backup & Restore Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Bengaluru – March 23, 2019 Session: Real World Query Tuning in SQL Server Speaker: Amit R S Bansal Session: SQL Server Backup & Restore Speaker: Satya Ramesh | Download | Watch Now Watch Now |
Data Platform Day, Hyderabad – March 09, 2019 Session: Temporary Tables Vs Table Variables – SQL Server Speaker: Satya Ramesh | – | – |
Data Platform Day, Bengaluru – March 02, 2019 Session: Temporary Tables Vs Table Variables – SQL Server Speaker: Satya Ramesh | – | – |
DataPlatformGeeks Webinar, January 31, 2019 Session: Understanding Dynamic SQL – The Right Way Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Mumbai – November 24, 2018 Session: SQL Server Statistics – Things That You Didn’t Know Speaker: Amit R S Bansal | – | Watch Now |
Data Platform Day, Kolkata – November 17, 2018 Session: Real World Query Tuning Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Hyderabad – November 17, 2018 Session: Understanding Dynamic SQL – The Right Way Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Hyderabad – November 10, 2018 Session: Understanding Dynamic SQL – The Right Way Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Hyderabad – October 27, 2018 Session: Concurrency Problems in SQL Server Speaker: Satya Ramesh | – | Watch Now |
DataPlatformGeeks Webinar, October 25, 2018 Session: Concurrency Problems in SQL Server Speaker: Satya Ramesh | – | Watch Now |
DataPlatformGeeks Webinar, October 16, 2018 Session: Understanding SQL Server Joins – The Right Way Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Hyderabad – October 13, 2018 Session: Concurrency Problems in SQL Server Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Bengaluru – September 29, 2018 Session: Advanced SQL Server Indexing Speaker: Amit R S Bansal Session: Understanding SQL Server Joins – The Right Way Speaker: Satya Ramesh | – | Watch Now Watch Now |
Data Platform Day, Hyderabad – September 22, 2018 Session: Advanced SQL Server Indexing Speaker: Amit R S Bansal Session: Understanding SQL Server Joins – The Right Way Speaker: Satya Ramesh | – | Watch Now Watch Now |
DataPlatformGeeks Webinar, September 06, 2018 Session: Advanced SQL Server Indexing Speaker: Amit R S Bansal | – | Watch Now |
DataPlatformGeeks Webinar, September 4, 2018 Session: SQL Server Indexes – Basics Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Bengaluru – July 21, 2018 Session: Half-Day Training on SQL Server Performance Tuning Speaker: Amit R S Bansal | – | – |
Data Platform Day, Hyderabad – July 14, 2018 Session: Half-Day Training on SQL Server Performance Tuning Speaker: Amit R S Bansal | – | – |
Data Platform Day, Bengaluru – July 07, 2018 Session: Half-Day Training on SQL Server Performance Tuning Speaker: Amit R S Bansal | – | – |
Data Platform Day, Bengaluru – June 30, 2018 Session: SQL Server Indexing – Basics Speaker: Satya Ramesh | – | Watch Now |
Data Platform Day, Bengaluru – June 9, 2018 Session: SQL Server Indexing – Basics Speaker: Satya Ramesh | – | Watch Now |
DataPlatformGeeks Webinar, May 17, 2018 Session: Troubleshooting SQL Server IO Performance/Bottleneck Speaker: Amit R S Bansal | – | Watch Now |
DataPlatformGeeks Webinar, April 12, 2018 Session: SQL Server Statistics – Things That You Didn’t Know Speaker: Amit R S Bansal | – | Watch Now |
DataPlatformGeeks Webinar, March 13, 2018 Session: Simplifying SQL Server Performance Tuning Speaker: Amit R S Bansal | – | Watch Now |
Data Platform Day, Hyderabad – March 10, 2018 Session: Real World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Gurgaon – February 24, 2018 Session: Real World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Bengaluru – February 17, 2018 Session: Real World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Hyderabad – February 10, 2018 Session: SQL Server Memory – Part 1 Speaker: Amit R S Bansal | – | Watch Now |
Data Platform Day, Pune – February 03, 2018 Session: Real World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
Data Platform Day, Bengaluru – January 20, 2018 Session: SQL Server Memory Speaker: Amit R S Bansal | – | Watch Now |
DataPlatformGeeks Webinar, January 17, 2018 Session: SQL Server Memory – Part 1 Speaker: Amit R S Bansal | – | Watch Now |
DataPlatformGeeks Webinar, December 12, 2017 Session: SQL Server Memory – Part 1 Speaker: Amit R S Bansal | – | Watch Now |
Data Platform Day, Gurgaon – November 25, 2017 Session: SQL Query Tuning Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, November 23, 2017 Session: New Security Features Every SQL Professional Should Know Speaker: Amit R S Bansal | – | – |
Data Platform Day, Bengaluru – November 18, 2017 Session 1: Real-World Query Tuning Examples Session 2: New Security Features Every SQL Professional Should Know Speaker: Amit R S Bansal | Download | – |
Data Platform Day, Hyderabad – November 11, 2017 Session 1: Dockerize SQL Server 2017 (on Linux) using Non-Windows OS Session 2: What’s New for Database Developers in SQL Server 2017 Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, November 09, 2017 Session: Real World Query Tuning Examples Speaker: Amit R S Bansal | Download | Watch Now |
DataPlatformGeeks Webinar, October 26, 2017 Session: Benchmarking & Baselining In-Memory OLTP Performance Speaker: Amit R S Bansal | – | Watch Now |
Data Platform Day, Bengaluru – October 21, 2017 Session 1: SQL Server Performance Tuning Techniques with SQL 2014/2016 Session 2: Getting Started with Data Science in Azure Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, October 16, 2017 Session: Introduction to Machine Learning Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, October 12, 2017 Session: Getting started with Data Science in Azure Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, October 5, 2017 Session: SQL Server Performance Tuning Techniques with SQL 2014/2016 Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, May 26, 2017 Session: Database DevOps – Part 3 – End To End Integration Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, May 24, 2017 Session: Database DevOps – Part 2 – Getting Started Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, May 19, 2017 Session: Database DevOps – Part 1 – An Introduction Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, March 01, 2017 Session: Advanced SQL Server Monitoring with Redgate SQL Monitor Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, February 09, 2017 Session: Advanced SQL Server Monitoring with Redgate SQL Monitor Speaker: Amit R S Bansal | – | – |
DataPlatformGeeks Webinar, January 25, 2017 Session: Monitoring SQL Server Performance – Part II Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event, November 22, 2016 Session: Advanced Aggregation SQL Server | Download | – |
SQL Special Webcast Event, November 15, 2016 Session: Advanced Pivot In SQL Server | Download | – |
SQL Special In-Person Event, November 12, 2016 Session: SQL Server Index Tuning Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event, November 8, 2016 Session: In-Memory OLTP for SQL Developers Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event, September 14, 2016 Session: Monitoring SQL Server Performance – The Right Way Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event, April 27, 2016 Session: SQL Server Concurrency Problems Speaker: Amit R S Bansal | – | – |
SQL Special In-Person Event, Hyderabad, April 9, 2016 Session: Troubleshooting Common Performance Issues in SQL Server Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event, April 6, 2016 Session: Data Cleansing With SSIS Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event, April 6, 2016 Session: Troubleshooting Common Performance Issues in SQL Server Speaker: Amit R S Bansal | – | – |
SQL Special In-Person Event, Bangalore, March 19, 2016 Session: Troubleshooting Common Performance Issues in SQL Server Speaker: Amit R S Bansal | – | – |
SQL Special In-Person Event, Hyderabad, October 10, 2015 Session: Deadlocks – Everything You Need to Know Speaker: Amit R S Bansal | – | – |
SQL Special In-Person Event, Bangalore, October 3, 2015 Session: Deadlocks – Everything You Need to Know Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event, June 03, 2015 Session: SQL Server Hidden Gems Speaker: Amit R S Bansal | – | – |
SQL Special In-Person Event, April 10, 2015 Session: Back to Indexes: The Original Culprit Speaker: Amit R S Bansal | Download | – |
SQL Special In-Person Event, April 4, 2015 Session: Back to Indexes: The Original Culprit Speaker: Amit R S Bansal | Download | – |
SQL Special In-Person Event, March 29, 2015 Session: Master The Art of Public Speaking – Part 1 Speaker: Amit R S Bansal | – | – |
SQL Special In-Person Event, March 21, 2015 Session: Back to Indexes: The Original Culprit Speaker: Amit R S Bansal | Download | – |
SQL Special In-Person Event, March 7, 2015 Session: Back to Indexes: The Original Culprit Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event, March 4, 2015 Session: SQL Server 2014 Cardinality Estimator Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event, February 7, 2015 Session: Dealing with Parameter Sniffing Speaker: Amit R S Bansal | Download | – |
SQL Special In-Person Event, February 7, 2015 Session: Session: Back to Indexes: The Original Culprit Speaker: Amit R S Bansal | Download | – |
SQL Special In-Person Event, 22 November 2014 Session: Mind Your IO: Resource Governor Shows You How Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event, 19 November 2014 Session: Tracking Page Splits using Extended Events Speaker: Amit R S Bansal | Download | – |
PASS Summit 2014 Session: Mind Your IO: Resource Governor Shows You How Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event, Oct 2014 Session: Simplifying SQL Server Performance Tuning Speaker: Amit R S Bansal | Download | – |
Great Indian Developer Summit 2014 Session 1: SQL Server 2014 eXtreme Transactional Processing (In-Memory OLTP) Session 2: SQL Server 2014 – Updatable Columnstore IndexesDeep Dive Speaker: Amit R S Bansal | Download | – |
Microsoft Reboot Bangalore 2014 Session: eXtreme performance with SQL Server 2014 In-Memory OLTP Speaker: Amit R S Bansal | Download | – |
Microsoft TechEd North America 2014 Session: Mind your IO: Resource Governor Shows You How Speaker: Amit R S Bansal | Download | – |
SQL Saturday Huston, May 2014 Session: Mind Your IO: Resource Governor Shows You How Speaker: Amit R S Bansal | Download | – |
Microsoft TechEd Europe 2013 Session: Back to Indexes: The Original Culprit Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event – Oct 2, 2013 Session: Always On – Introducing the Next Generation High Availability Solution in SQL Server 2012 Speaker: Amit R S Bansal | – | – |
Microsoft TechEd North America 2012 Session: Back to Indexes, the original culprit! Speaker: Amit R S Bansal | Download | – |
SQL Special Webcast Event – August 23, 2012 Session: Blazing Fast Performance with Columnstore Indexes part -1 Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event – April 27, 2012 Session: SQL Server 2012 Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event – March 27, 2012 Session: Concurrency in SQL Server Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event – March 15, 2012 Session: Index Tuning Speaker: Amit R S Bansal | – | – |
SQL Special Webcast Event – February 21, 2012 Session: SQL Server Locking Internals Speaker: Amit R S Bansal | – | – |
Microsoft TechEd India 2011 Session 1: Complex Event Processing: Power your middleware with StreamInsight Session 2: SSAS – Designing, Development and Deployment Best practices Speaker: Amit R S Bansal | Download | – |
Microsoft TechEd India 2009 Session 1: Guiding Query Plans for optimized query performance Session 2: Implementing High-Availability Solutions for the right problem with SQL Server 2008 Speaker: Amit R S Bansal | Download | – |
Microsoft TechEd North America 2008 Session 1: Microsoft SQL Server Coding to Maximize Concurrency Session 2: Maximizing Query Optimizer with Query and Table Hints Speaker: Amit R S Bansal | Download | – |
Video | Download | Recording |
---|---|---|
SQL Query Reason For Early Termination Speaker: Amit R S Bansal | Download | Watch Now |
SELECT Query But No Access Method Speaker: Amit R S Bansal | Download | Watch Now |
Why is the CPU Time more than the Elapsed Time? Speaker: Amit R S Bansal | Download | Watch Now |
IO_Completion Wait Type in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
Removing SORT Operator – SQL Server Execution Plans Speaker: Amit R S Bansal | Download | Watch Now |
TSQL TOP Clause Deterministic vs Non-Deterministic Speaker: Amit R S Bansal | Download | Watch Now |
TSQL WHERE Clause applies after ON Clause Speaker: Amit R S Bansal | Download | Watch Now |
Monitoring Waiting Tasks (Groups) in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server CPU Queue Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Index Union Operation Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server – Non Clustered Indexes have the Clustering Key Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server – What is my query doing? Speaker: Amit R S Bansal | Download | Watch Now |
Non Clustered Indexes may hurt modification queries performance Speaker: Amit R S Bansal | Download | Watch Now |
SCAN vs SEEK Performance – What to look for? Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Query Tuning – What is the execution time? Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Order By Clause – Tricky Behavior Speaker: Amit R S Bansal | Download | Watch Now |
Query Tuning – Estimates vs Actual Runtime Statistics Speaker: Amit R S Bansal | Download | Watch Now |
Index Usage Stats DMV gets reset Speaker: Amit R S Bansal | Download | Watch Now |
SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Sort Behavior – Basic yet Tricky Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Deadlock due to Bookmark Lookup Speaker: Amit R S Bansal | Download | Watch Now |
Deadlock within a single table Speaker: Amit R S Bansal | Download | Watch Now |
Extract Wait Type information from the Execution Plan Speaker: Amit R S Bansal | Download | Watch Now |
SPID blocking itself in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
Get the Actual Execution Plan from the Plan Cache Speaker: Amit R S Bansal | Download | Watch Now |
Minimize THREADPOOL Wait Type in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
Index Seek may not always be faster Speaker: Amit R S Bansal | Download | Watch Now |
Database IO Cost (Reads & Writes) Speaker: Amit R S Bansal | Download | Watch Now |
LIVE Troubleshooting on Production Server – Plan Cache Bloating Speaker: Amit R S Bansal | Download | Watch Now |
LIVE Troubleshooting on Production Server – Physical vs Logical IO Speaker: Amit R S Bansal | Download | Watch Now |
SARGability and Selectivity in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Expensive Lookups Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Missing Index Hints Missing Speaker: Amit R S Bansal | Download | Watch Now |
Extended Events Tips & Tricks – Detailed Speaker: Amit R S Bansal | Download | Watch Now |
Rank( ) Function in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
How to Rollback Truncate using Backup & Restore? Speaker: Satya Ramesh | Download | Watch Now |
Truncate Can be Rolled Back? Speaker: Satya Ramesh | Download | Watch Now |
Performance Monitor Counters Speaker: Amit R S Bansal | Download | Watch Now |
Monitoring Pressure – Observing Task Count Speaker: Amit R S Bansal | Download | Watch Now |
Tempdb Space Usage Monitoring Speaker: Amit R S Bansal | Download | Watch Now |
Database IO Cost (Reads & Writes) Speaker: Amit R S Bansal | Download | Watch Now |
CPU Cost by Database Speaker: Amit R S Bansal | Download | Watch Now |
Tracking Page Splits Using Extended Events Speaker: Amit R S Bansal | Download | Watch Now |
Index Tuning – Page Splits & Fragmentation Speaker: Amit R S Bansal | Download | Watch Now |
Index Tuning – Index Column Sort Order Speaker: Amit R S Bansal | Download | Watch Now |
Query Tuning – Implicit Conversion – Part 2 Speaker: Amit R S Bansal | Download | Watch Now |
Query Tuning – Implicit Conversion – Part 1 Speaker: Amit R S Bansal | Download | Watch Now |
How To Enable Global Trace Flags In SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Memory Troubleshooting – Buffer Pool Usage Speaker: Amit R S Bansal | Download | Watch Now |
RESOURCE SEMAPHORE Wait Type & SQLRESERVATIONS Memory Clerk Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Parallelism (Part 2 of CXPACKET) Speaker: Amit R S Bansal | Download | Watch Now |
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Index Tuning – Multi Column Seeking Speaker: Amit R S Bansal | Download | Watch Now |
Debugging SQL Server – Setting Up Windows Debugger Speaker: Amit R S Bansal | Download | Watch Now |
CXPACKET Wait Type in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
When Did SQL Server Start (Database Engine Start Time) Speaker: Amit R S Bansal | Download | Watch Now |
Processor Time (Processor vs Process) – Monitoring SQL Server Usage Speaker: Amit R S Bansal | Download | Watch Now |
How To Create A Login In SQL Server Speaker: Satya Ramesh | Download | Watch Now |
How To Restore A Database in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
SQL Server – The concept of Density Speaker: Amit R S Bansal | Download | Watch Now |
How to take database backup in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
SQL Server – The concept of selectivity Speaker: Amit R S Bansal | Download | Watch Now |
Row Number Function in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
Pivoting in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
Nested Loop Join in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
Read Committed Isolation Level in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
How to work with INNER JOINs in SQL Server Speaker: Satya Ramesh | Download | Watch Now |
SQL Server Index Internals – Multiple Index Hints by SSMS Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Index Internals – Clustered Index Seek (Range Scan) Speaker: Amit R S Bansal | Download | Watch Now |
Troubleshooting SQL Server IO Performance/Bottleneck – Part 4 – PAGEIOLATCH Wait Type Speaker: Amit R S Bansal | Download | Watch Now |
“Troubleshooting SQL Server IO Performance/Bottleneck – Part 3 (Most Expensive IO Queries) Speaker: Amit R S Bansal | Download | Watch Now |
Troubleshooting SQL Server IO Performance/Bottleneck – Part 2 (Avg Disk Sec per Read) Speaker: Amit R S Bansal | Download | Watch Now |
Troubleshooting SQL Server IO Performance/Bottleneck – Part 1 (sys.dm_io_virtual_file_stats) Speaker: Amit R S Bansal | Download | Watch Now |
How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1 Speaker: Amit R S Bansal | Download | Watch Now |
Missing Index Hints in SQL Server Management Studio Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Statistics – Are My Stats Objects Being Used? Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Statistics Histogram – Part 1 Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Statistics Basics – Part 1 Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk Speaker: Amit R S Bansal | Download | Watch Now |
Session Level Waits and Task Level Waits in SQL Server Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Wait Types, Queues & Wait Statistics Speaker: Amit R S Bansal | Download | Watch Now |
How to Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats) Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Cardinality Estimation – Quick Notes – Part 1 Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server NOT IN clause not working Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server Trace Flag 3608 Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server 2014 New System Objects Speaker: Amit R S Bansal | Download | Watch Now |
SQL Server 2014 New Dynamic Management Views and Functions Speaker: Amit R S Bansal | Download | Watch Now |
sqlservr.exe file size mystery Speaker: Amit R S Bansal | Download | Watch Now |
Thank you 🙂
Where can I get ticket for this class