EventResourcesRecording
SQLMaestros Special Event – 23 March 2023
Session: Top 3 SQL Server Tuning Techniques – Part 2
Speaker: Amit R S Bansal
DownloadWatch Now
SQLMaestros Special Event – 3 March 2023
Session: Top 3 SQL Server Tuning Techniques – Part 1
Speaker: Amit R S Bansal
DownloadWatch Now
SQLMaestros Special Event – Apr 2022
Session: Query Tuning – From Soup to Nuts
Speaker: Amit R S Bansal
DownloadWatch Now
SQLMaestros Special Event – Jan 2022
Session: Query Tuning – From Soup to Nuts
Speaker: Amit R S Bansal
DownloadWatch 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
DownloadWatch 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
DownloadWatch Now
Data Ceili May 2021
Session: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits
Speaker: Amit R S Bansal
DownloadWatch 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
DownloadWatch 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
DownloadWatch Now
Data Weekender – MAY 2021
Session: 6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits
Speaker: Amit R S Bansal
DownloadWatch Now
Watch Now
Data Saturday Malta – April 2021
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
Data Saturday Redmond – April 2021
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
Data Saturday Haiti- March 2021
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch 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
DownloadWatch Now
Watch Now
Data Saturday Pordenone – FEB 2021
Session: SQL Server Memory Internals & Troubleshooting
Speaker: Amit R S Bansal
DownloadWatch Now
EightKB – JAN 2021
Session: SQL Server Memory Internals & Troubleshooting
Speaker: Amit R S Bansal
DownloadWatch Now
Data Saturday Guatemala – JAN 2021
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
SQLSaturday Plovdiv – DEC 2020
Session: Understanding SQL Server Views – The Right Way
Speaker: Satya Ramesh
DownloadWatch Now
SQLSaturday Montreal – NOV 2020
Session: Real-World Query Tuning Examples
Speaker: Amit R S Bansal
DownloadWatch Now
PASS Summit – NOV 2020
Session: Developer Best Practices in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
Data Platform Summit 2020 – DEC 2020
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
DataPlatformGeeks Webinar, October 29, 2020
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
Group By – OCT 2020
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
SQLSaturday Oregon – October 24, 2020
Session: How To Troubleshoot A Slow Running Query In SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
SQLSaturday Oregon – October 24, 2020
Session: Understanding SQL Server Views – The Right Way
Speaker: Satya Ramesh
DownloadWatch Now
DataWeekender – OCT 2020
Session: 6 Query Tuning Techniques to Solve 75% of Performance Problems
Speaker: Amit R S Bansal
DownloadWatch Now
SQLSaturday Malaysia – October 17, 2020
Session: Real-World Query Tuning Examples
Speaker: Amit R S Bansal
DownloadWatch Now
SQLSaturday Sofia – October 10, 2020
Session: Real-World Query Tuning Examples
Speaker: Amit R S Bansal
DownloadWatch Now
SQLSaturday Sofia – October 10, 2020
Session: Understanding SQL Server Views – The Right Way
Speaker: Satya Ramesh
DownloadWatch 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
DownloadWatch Now
SQLSaturday Salt Lake City – August 29, 2020
Session: Understanding NULLs in SQL Server
Speaker: Satya Ramesh
DownloadWatch 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
DownloadWatch Now
Data Platform Day, Bengaluru – February 22, 2020
Session: Understanding NULLs in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
DataPlatformGeeks Webinar – February 18, 2020
Session: Understanding NULLs in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
DataPlatformGeeks Webinar, February 11, 2020
Session: Part 1 – How to Troubleshoot a Slow Running Query in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
Data Platform Day, Bengaluru – November 9, 2019
Session: Understanding SQL Server Indexes – The Right Way
Speaker: Satya Ramesh
DownloadWatch Now
DataPlatformGeeks Webinar, November 7, 2019
Session: Understanding SQL Server Indexes – The Right Way
Speaker: Satya Ramesh
DownloadWatch 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
DownloadWatch Now
DataPlatformGeeks Webinar, October 3, 2019
Session: DELETE vs TRUNCATE – Myths & Misconceptions
Speaker: Satya Ramesh
DownloadWatch 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
DownloadWatch 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
DownloadWatch 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
DownloadWatch 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
DownloadWatch 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
DownloadWatch 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
DownloadWatch 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
DownloadWatch Now
Data Platform Day, Gurgaon – February 24, 2018
Session: Real World Query Tuning Examples
Speaker: Amit R S Bansal
DownloadWatch Now
Data Platform Day, Bengaluru – February 17, 2018
Session: Real World Query Tuning Examples
Speaker: Amit R S Bansal
DownloadWatch 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
DownloadWatch 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
DownloadWatch 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 Indexes Deep 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

VideoDownloadRecording
SQL Query Reason For Early Termination
Speaker: Amit R S Bansal
DownloadWatch Now
SELECT Query But No Access Method
Speaker: Amit R S Bansal
DownloadWatch Now
Why is the CPU Time more than the Elapsed Time?
Speaker: Amit R S Bansal
DownloadWatch Now
IO_Completion Wait Type in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
Removing SORT Operator – SQL Server Execution Plans
Speaker: Amit R S Bansal
DownloadWatch Now
TSQL TOP Clause Deterministic vs Non-Deterministic
Speaker: Amit R S Bansal
DownloadWatch Now
TSQL WHERE Clause applies after ON Clause
Speaker: Amit R S Bansal
DownloadWatch Now
Monitoring Waiting Tasks (Groups) in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server CPU Queue
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Index Union Operation
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server – Non Clustered Indexes have the Clustering Key
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server – What is my query doing?
Speaker: Amit R S Bansal
DownloadWatch Now
Non Clustered Indexes may hurt modification queries performance
Speaker: Amit R S Bansal
DownloadWatch Now
SCAN vs SEEK Performance – What to look for?
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Query Tuning – What is the execution time?
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Order By Clause – Tricky Behavior
Speaker: Amit R S Bansal
DownloadWatch Now
Query Tuning – Estimates vs Actual Runtime Statistics
Speaker: Amit R S Bansal
DownloadWatch Now
Index Usage Stats DMV gets reset
Speaker: Amit R S Bansal
DownloadWatch Now
SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Sort Behavior – Basic yet Tricky
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Deadlock due to Bookmark Lookup
Speaker: Amit R S Bansal
DownloadWatch Now
Deadlock within a single table
Speaker: Amit R S Bansal
DownloadWatch Now
Extract Wait Type information from the Execution Plan
Speaker: Amit R S Bansal
DownloadWatch Now
SPID blocking itself in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
Get the Actual Execution Plan from the Plan Cache
Speaker: Amit R S Bansal
DownloadWatch Now
Minimize THREADPOOL Wait Type in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
Index Seek may not always be faster
Speaker: Amit R S Bansal
DownloadWatch Now
Database IO Cost (Reads & Writes)
Speaker: Amit R S Bansal
DownloadWatch Now
LIVE Troubleshooting on Production Server – Plan Cache Bloating
Speaker: Amit R S Bansal
DownloadWatch Now
LIVE Troubleshooting on Production Server – Physical vs Logical IO
Speaker: Amit R S Bansal
DownloadWatch Now
SARGability and Selectivity in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Expensive Lookups
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Missing Index Hints Missing
Speaker: Amit R S Bansal
DownloadWatch Now
Extended Events Tips & Tricks – Detailed
Speaker: Amit R S Bansal
DownloadWatch Now
Rank( ) Function in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
How to Rollback Truncate using Backup & Restore?
Speaker: Satya Ramesh
DownloadWatch Now
Truncate Can be Rolled Back?
Speaker: Satya Ramesh
DownloadWatch Now
Performance Monitor Counters
Speaker: Amit R S Bansal
DownloadWatch Now
Monitoring Pressure – Observing Task Count
Speaker: Amit R S Bansal
DownloadWatch Now
Tempdb Space Usage Monitoring
Speaker: Amit R S Bansal
DownloadWatch Now
Database IO Cost (Reads & Writes)
Speaker: Amit R S Bansal
DownloadWatch Now
CPU Cost by Database
Speaker: Amit R S Bansal
DownloadWatch Now
Tracking Page Splits Using Extended Events
Speaker: Amit R S Bansal
DownloadWatch Now
Index Tuning – Page Splits & Fragmentation
Speaker: Amit R S Bansal
DownloadWatch Now
Index Tuning – Index Column Sort Order
Speaker: Amit R S Bansal
DownloadWatch Now
Query Tuning – Implicit Conversion – Part 2
Speaker: Amit R S Bansal
DownloadWatch Now
Query Tuning – Implicit Conversion – Part 1
Speaker: Amit R S Bansal
DownloadWatch Now
How To Enable Global Trace Flags In SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Memory Troubleshooting – Buffer Pool Usage
Speaker: Amit R S Bansal
DownloadWatch Now
RESOURCE SEMAPHORE Wait Type & SQLRESERVATIONS Memory Clerk
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Parallelism (Part 2 of CXPACKET)
Speaker: Amit R S Bansal
DownloadWatch Now
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Index Tuning – Multi Column Seeking
Speaker: Amit R S Bansal
DownloadWatch Now
Debugging SQL Server – Setting Up Windows Debugger
Speaker: Amit R S Bansal
DownloadWatch Now
CXPACKET Wait Type in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
When Did SQL Server Start (Database Engine Start Time)
Speaker: Amit R S Bansal
DownloadWatch Now
Processor Time (Processor vs Process) – Monitoring SQL Server Usage
Speaker: Amit R S Bansal
DownloadWatch Now
How To Create A Login In SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
How To Restore A Database in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
SQL Server – The concept of Density
Speaker: Amit R S Bansal
DownloadWatch Now
How to take database backup in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
SQL Server – The concept of selectivity
Speaker: Amit R S Bansal
DownloadWatch Now
Row Number Function in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
Pivoting in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
Nested Loop Join in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
Read Committed Isolation Level in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
How to work with INNER JOINs in SQL Server
Speaker: Satya Ramesh
DownloadWatch Now
SQL Server Index Internals – Multiple Index Hints by SSMS
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Index Internals – Clustered Index Seek (Range Scan)
Speaker: Amit R S Bansal
DownloadWatch Now
Troubleshooting SQL Server IO Performance/Bottleneck – Part 4 – PAGEIOLATCH Wait Type
Speaker: Amit R S Bansal
DownloadWatch Now
“Troubleshooting SQL Server IO Performance/Bottleneck – Part 3 (Most Expensive IO Queries)
Speaker: Amit R S Bansal
DownloadWatch Now
Troubleshooting SQL Server IO Performance/Bottleneck – Part 2 (Avg Disk Sec per Read)
Speaker: Amit R S Bansal
DownloadWatch Now
Troubleshooting SQL Server IO Performance/Bottleneck – Part 1 (sys.dm_io_virtual_file_stats)
Speaker: Amit R S Bansal
DownloadWatch Now
How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1
Speaker: Amit R S Bansal
DownloadWatch Now
Missing Index Hints in SQL Server Management Studio
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Statistics – Are My Stats Objects Being Used?
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Statistics Histogram – Part 1
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Statistics Basics – Part 1
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk
Speaker: Amit R S Bansal
DownloadWatch Now
Session Level Waits and Task Level Waits in SQL Server
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Wait Types, Queues & Wait Statistics
Speaker: Amit R S Bansal
DownloadWatch Now
How to Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats)
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Cardinality Estimation – Quick Notes – Part 1
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server NOT IN clause not working
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server Trace Flag 3608
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server 2014 New System Objects
Speaker: Amit R S Bansal
DownloadWatch Now
SQL Server 2014 New Dynamic Management Views and Functions
Speaker: Amit R S Bansal
DownloadWatch Now
sqlservr.exe file size mystery
Speaker: Amit R S Bansal
DownloadWatch Now
ResourceDownload
SQL Server Wait Types – Ready ReferenceDownload
SQL Server DMV’s – Ready ReferenceDownload
SQL Server Performance Counters – Ready ReferenceDownload

2 Comments

  1. ravi krishna paladagu March 2, 2016 at 10:07 pm - Reply

    Thank you 🙂

    • Srinivas Gaddameedi April 1, 2016 at 4:37 pm - Reply

      Where can I get ticket for this class

Leave A Comment