Posts

Six Query Tuning Techniques

Hi There, This 100-minute session contains many relevant examples to tune your SQL query. Session Title: Six Query Tuning Techniques that will solve 75% of your performance problems. Where to watch? Watch here. Want more deep-dive content? Explore the SQLMaestros Master Class recordings at 60% off. See here. Use the BLACKFRIDAY coupon code. SQL Server [...]

Performance Tuning Master Class (BLACK FRIDAY)

Hi There, If SQL Server Performance Tuning is your day-to-day work, explore the SQLMaestros Master Class recordings at 60% off. See here. SQL Server Query Tuning & Optimization. 28 hours. Jump directly to the product. There are 64 modules/demos including Internals, Better TSQL, Indesu Tuning, Waits & Queues, Concurrency & Intelligence Query Processing. SQLMaestros also [...]

SQL Content from DPS 2022

Hi There, We are writing to you after a while, hope you are doing well. You will be happy to know that the breakout session recordings from Data Platform Virtual Summit 2022, are now available. To access the recordings, Click Here. DPS 2022 has dozens of sessions around SQL technologies including SQL Server 2022, 2019, [...]

SQL Server Performance Tuning

Hi There, We recently solved a performance issue in SQL Server. We tuned a stored procedure that was being plagued by multiple scalar function calls. And guess what - SQL Server 2019 Scalar UDF inlining feature did not work (due to some limitations). Are you facing similar performance issues in your SQL Server environment? Learn [...]

Upcoming Webinars from DataPlatformGeeks

Hi There, We at SQLMaestros support DataPlatformGeeks Community and its learning initiatives for the tech audience. They are coming up with weekly webinars. Each Thursday at 9.30 AM EDT starting from June 16, until Aug 4. Take a look and register for the ones you want to attend. Here are some popular SQL tutorials from [...]

New SQL Videos

Hi There, Here are the most popular SQL tutorials from SQLMaestros. Many of them are old but relevant with meaningful content: How to troubleshoot a slow-running query. Watch now. Query Tuning Techniques. Watch now. SQL Server Wait Types. Watch now. SQL Server Statistics. Watch now. Do not forget to subscribe to our Youtube channel. The [...]

Master Class Recordings & Lab Kit – Instant Access

Hi There, The much-awaited Master Class Recordings and the Lab Kit are now available. You can get instant access. #1 SQL Server Query Tuning & Optimization Master Class Recordings. 28 hours of content. Watch the sample content before you subscribe. And make sure to check out the module listing - it's quite exhaustive. Learn more. [...]

Master Class Recordings Released

Hi There, Trust you are doing well. You will be happy to know that Master Class recording for SQL Server Query Tuning and Optimization is now available. Total duration: 28 hours. You can subscribe and get instant access. Learn more. This 28-hour content is in-depth, comprehensive, demo-packed, and the learnings can be applied to production [...]

Query Tuning Training Next Week

Hi There, A lot of new SQL content and learning options announced. Please read carefully. #1 SQL Server Query Tuning & Optimization Master Class Recordings are now available. 28 hours of content. Learn more. #2 Query Tuning training coming up next week on April 28. No-cost. Block your seat and invite your team members too. [...]

Removing SORT Operator – SQL Server Execution Plans

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

TSQL TOP Clause Deterministic vs Non-Deterministic

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

TSQL WHERE Clause applies after ON Clause

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Monitoring Waiting Tasks (Groups) in SQL Server

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Server CPU Queue

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Server Index Union Operation

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Server – Non Clustered Indexes have the Clustering Key

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Server – What is my query doing?

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Non Clustered Indexes May Hurt Modification Queries Performance

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SCAN vs SEEK Performance – What to look for?

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Performance Tuning Master Class starts Feb 14

Hi There, SQL Server Performance Tuning Master Class begins on Feb 14. This is all you need to become a performance tuning specialist. Talk to your manager and get sponsored. Learn more. #1 New SQL Video: What is Execution Time? Yeah, this is a bit tricky. Watch on SQLMaestros home page or directly jump to [...]