SQLMaestros Admin

Home/SQLMaestros Admin
SQLMaestros Admin

About SQLMaestros Admin

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

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

Extended Events Tips & Tricks

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

SQLMaestros Bulletin: July 10, 2020

#2_July_10_2020_Friday Hi There, New Blog Posts Double Read – Reading The Same Record Twice. Watch a two-minute video on Twitter. Also read the full blog post. Click Here. Deadlock Due To Bookmark Lookups – Read the full blog post. The Scripts Garage • How to Defragment All The Indexes In a Database. Click Here. • [...]

Rank( ) Function in SQL Server (By Satya Ramesh)

In this video, you will learn to use RANK() function in SQL Server. RANK () is one of the four Ranking Functions that are available in SQL Server. 1. ROW_NUMBER() 2. RANK() 3. DENSE_RANK() 4. NTILE(N) In one of our previous videos we have already discussed about ROW_NUMBER() function, you can watch that video here: [...]

How to Rollback Truncate using Backup & Restore? (By Satya Ramesh)

In this video, you will learn to get back truncated data using backup and restore mechanism. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy [...]

Truncate Can be Rolled Back? (By Satya Ramesh)

In this video, you will learn about whether Truncate can rolled back or not? Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]

Performance Monitor Counters (by Amit Bansal)

Here is a quick technique to record performance counters data in SQL Server. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]