SQL Server Blog

Home/SQL Server Blog/

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

Performance Tuning Master Class, Video Library, Magazine & More

Hi There , Performance Tuning Fast Track Class has been announced. 8 hours of intense, deep-dive training on performance troubleshooting & query optimization. Book your seat today. Learn More. Want to learn at your own pace, explore these video courses. With Performance Tuning course, you are getting Querying & Programming courses complimentary. Subscribe today. Not [...]

SQL Health Check Session Tomorrow

Hi There, Tomorrow (Apr 29), you can learn how to do SQL Server Health Check. Next week, you can join the Virtual Symposium having 15 sessions spread across AMERICA, EMEA & APAC Time Zone. And guess what, we are releasing DPS 2020 content each week. So here you go, check out below, whatever suits you. Finally, [...]

SQL Performance Webinar (Deep Dive Session) | Bulletin #15

SQLM Bulletin #15. March 16, 2021. Hi there, SQLMaestros is coming up with a deep dive session on March 24 & 25 for the SQL folks. Session Title: 6 Techniques to Make SQL Server Speedometer Go Crazy. This session is for you if you are someone working on SQL Server Performance Tuning stuff. How to [...]

LIVE Troubleshooting on Production Server – Plan Cache Bloating

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

LIVE Troubleshooting on Production Server – Physical vs Logical IO

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

SARGability and Selectivity 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 [...]

Finding Expensive Lookups 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 [...]

Why are Missing Index Hints Missing

Let’s understand a few reasons why SQL Server (sometimes) does not show missing index hints. We are using AdventureWorks2016 database for the demo. Let’s make a copy of Sales.Customer table as Sales.CustomerDup SELECT * INTO sales.customerdup FROM sales.customer Before jumping into the actual query, have a look at AccountNumber column which is of VARCHAR data [...]

Keynote Speaker – Rohan Kumar (CVP, Azure Data, Microsoft)

The full virtual tour of DPS 2020 has been released. Watch now. Hi There, We are thrilled to announce Rohan Kumar (Corporate Vice President, Azure Data, Microsoft Corporation) as the keynote speaker for Data Platform Virtual Summit 2020. Rohan Kumar will share the latest innovations from Microsoft Data Platform and showcase intriguing customer case studies. [...]

Virtual Symposiums Recordings Now Available

PS: Until DPS 2020, all our bulletins by DataPlatformGeeks, SQLServerGeeks, SQLMaestros, DPS and ConnectWithAB will be combined into a single bulletin which will be sent out every Monday/Tuesday of the week. Highlight: DPS 2020 Virtual Platform First Look – Click Here. Spotlight: Microsoft blogs about DPS 2020 – Click Here. Hi There, In today’s bulletin [...]

Do Not Miss The SQL Performance LIVE Training

PS: Until DPS 2020, all our bulletins by DataPlatformGeeks, SQLServerGeeks, SQLMaestros, DPS and ConnectWithAB will be combined into a single bulletin which will be sent out every Monday/Tuesday of the week. Hi There, Today’s bulletin is a lot about performance. Upcoming Session (Free) If you or your team members work with SQL Server or Azure [...]

SQL Analytics Event Today | 15 Sessions | Bulletin #11

SQLM Bulletin #11. October 08, 2020. Add SQLMaestros to your address book. Spotlight: Triple content compared to previous years. Half the price. Complimentary recordings. Microsoft Sessions Announced Learn More. Hi There, Here is the SQLMaestros Bulletin of 08 October, 2020. Highlights of Today’s Bulletin This Thursday, Virtual Symposium on Azure Analytics & Artificial Intelligence. Join Us General Sessions Part-2 announced for [...]

Geek Talk #3 on Implementing SQL Server Extended Events by Amit Bansal

Date: 17 September 2020 Topic: Implementing SQL Server Extended Events Abstract: In this session, you will learn how to implement Extended Events the right way. You will get a comprehensive overview of XEvents, a tour of GUI and key features, and a few real-world examples of putting XEvents to production to use. Trainer/Speaker: AMIT R [...]

Geek Talk #2 on Implementing Extended Events Part 2 by Amit Bansal

Date: 10 September 2020 Topic: Implementing Extended Events Part 2 Abstract: In this session, you will learn how to implement Extended Events the right way. You will get a comprehensive overview of XEvents, a tour of GUI and key features, and a few real-world examples of putting XEvents to production to use. Trainer/Speaker: AMIT R [...]

Geek Talk #1 on Implementing Extended Events Part 1 by Amit Bansal

Date: 03 September 2020 Topic: Implementing Extended Events Part 1 Abstract: In this session, you will learn how to implement Extended Events the right way. You will get a comprehensive overview of XEvents, a tour of GUI and key features, and a few real-world examples of putting XEvents to production to use. Trainer/Speaker: AMIT R [...]

Virtual Symposiums | Geek Talks | DPS SQL Sessions | Bulletin #10

SQLM Bulletin #10. September 29, 2020. Add SQLMaestros to your address book. Spotlight: Data Platform Virtual Summit Updated Content & Pricing Model. Click Here. (200 SQL Sessions + Recordings – You cannot afford to skip this) Hi There, Here is the SQLMaestros Bulletin of 29 September, 2020. Highlights of Today’s Bulletin This Thursday, LIVE Geek Talk [...]