SQLMaestros Admin

Home/SQLMaestros Admin

About SQLMaestros Admin

This author has not yet filled in any details.
So far SQLMaestros Admin has created 79 blog entries.

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. [...]

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 [...]

Query Tuning Training on Thursday (Jan 27)

Hi There, Jan 27, Thursday, is here. Query Tuning training. Do not miss. Register Here. #1 Take a glance at SQLMaestros Corporate Services. Learn More. #2 New SQL Videos: SQL Server Order By clause - A tricky behavior Estimates vs Actual Runtime Statistics Watch on SQLMaestros home page or directly jump to our video lobby. [...]

Query Tuning Training Next Week – Sign Up Now

Hi There, Loads of SQL content for you. #1 Ask your team members to join the Query Tuning training next week. Learn More. It costs nothing. Forward this email to your team members. #2 New SQL Videos: Index Usage Stats DMV gets reset SOS_Scheduler_Yield Wait Type Estimates vs Actual Runtime Statistics Watch on SQLMaestros home [...]

Are you attending the Query Tuning training?

Hi There, SQL stuff for the week. #1 Want to get started with SQL query optimization? Join this online training course on Query Tuning. Learn More. Don't miss. It costs nothing. #2 New SQL Video: SQL Server Sort Behavior – Basic yet Tricky. More videos here. #3 Short SQL Server Notes by AB. Here. #4 [...]

New SQL Tutorials

Hi There, We took a break, and now we are back with lot of SQL content and learning opportunities. #1 New SQL Video: Retrieve the Actual Execution Plan from the Plan Cache. More videos here. #2 SQL Tip of the day. Here. #3 SQLMaestros Master Classes: New batches for SQL Server Performance Tuning – Fast [...]

SQL Performance Tuning Master Class Recordings Available

Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list. Hi There, Class Recordings for SQL Server Performance Tuning Master Class are now available. Last week, the class was successfully executed. See here for some incredible feedback received. Recordings can be accessed now. Learn more. Next set [...]

SQL Performance Tuning Master Class This Week (Wednesday/Thursday)

Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list. Hi There, SQLMaestros Master Class on SQL Server Performance Tuning – Fast Track (Online) is coming up this week (21/22 July). Join this demo-filled, 8-hour class (4 hours per day), where you will learn the three approaches [...]

SQL Performance Tuning Master Class Next Week

Do you wish to continue getting SQL videos from us? If yes, please subscribe to our new list. Hi There, Here are the headlines for today's bulletin from SQLMaestros. #1 SQL Server Performance Tuning – Fast Track (Online) is coming up next week (21/22 July). Review the modules, topics now. And if you find it [...]

SQL Server Plan Cache Bloating

In this post we will see how & why Plan Cache bloating happens – just a few examples. We are going to use AdventureWorks2016 database for this demo. Let’s first free the Plan Cache: DBCC FREEPROCCACHE Next, let’s fire a simple select statement, with one predicate. select * FROM Person.Person where LastName = ‘duffy’ We [...]

Master Class: SQL Performance Tuning

Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list. Hi There, Here are the headlines for today's bulletin from SQLMaestros. #1 Performance Tuning Master Classes have been scheduled for 21/22 July & Nov/Dec time frame. We have the fast-track version (8 hours) in July & the [...]

Query Tuning Session This Week

Do you wish to continue getting notifications about our events? If yes, please subscribe to our new list. Hi There, Here are the headlines for today's bulletin from SQLMaestros. #1 LIVE Session This Week, June 24: 6 Query Tuning Techniques That Will Solve 75% of Your Performance Problems (version 2). Block your seat. #2 Looking [...]

LIVE Session: Query Tuning Techniques – version 2

Do you wish to continue getting new SQL content from us? If yes, please subscribe to our new list. Hi There, Here are the headlines for today's bulletin from SQLMaestros. #1 Video of The Day: Plan Cache Bloating - LIVE Production Troubleshooting. 9 mins. Watch Now. #2 LIVE Session: 6 Query Tuning Techniques That Will [...]

6 Query Tuning Techniques – version 2

We are cleaning up a bit. If you wish to continue getting SQL content from us, please subscribe to our new list. Hi There , Here are the headlines for today's bulletin from SQLMaestros. #1 New Webinar (LIVE event): 6 Query Tuning Techniques That Will Solve 75% of Your Performance Problems (version 2). Block your [...]

Performance Tuning Master Class (New Dates Announced)

Hi There, Performance Tuning Master Classes have been scheduled. We have the fast-track version (8 hours) & the deep-dive version (40 hours) - both options available. Review the modules, topics & see which one interests you. And if you find them interesting, talk to your manager, get approvals and book your seat soonest. Learn More. [...]