SQLM Bulletin #9. September 15, 2020. Spotlight: New Training Classes Announced @ DPS 2020. Click Here Hi There, Here is the SQLMaestros Bulletin of 15 September, 2020. Highlights of Today’s Bulletin This Thursday, LIVE Training on Implementing SQL Server Extended Events. Join Us Virtual Symposiums are announced on Advanced Analytics, AI & SQL Performance Tuning. [...]
SQLM Bulletin #8. September 10, 2020. Spotlight: New Training Classes Announced @ DPS 2020. Click Here Hi There, Here is the SQLMaestros Bulletin of 10 September, 2020. We kick-started FREE LIVE Training last Thursday and got tremendous response. Today, Thursday, we are LIVE again. Details below. Highlights of Today’s Bulletin LIVE Training today on Implementing Extended Events [...]
SQLM Bulletin #7. September 1, 2020. Spotlight: First List of Breakout sessions for DPS2020 Published. Click Here. Hi There, Here is the SQLMaestros Bulletin of 1 September, 2020. We are kick-starting a new initiative – FREE LIVE Training. Details below. LIVE Training Implementing Extended Events by Amit Bansal. Hosted by SQLMaestros. Click Here. LIVE Geek [...]
Spotlight: First List of Breakout sessions for DPS2020 Published. Click Here. Prices increase on Aug 28. Book Today. Hi There, Here is the SQLMaestros Bulletin of 25 August, 2020. SQL Video Tutorials Index Tuning – Index Column Sort Order - Click Here. Query Tuning – Implicit Conversion – Part 1 – Click Here. Query Tuning [...]
Spotlight: First List of Breakout sessions for DPS2020 Published. Click Here. Prices increase on Aug 28. Book Today. Hi There, Here is the SQLMaestros Bulletin of 25 August, 2020. SQL Video Tutorials Index Tuning – Index Column Sort Order - Click Here. Query Tuning – Implicit Conversion – Part 1 – Click Here. Query Tuning [...]
Spotlight: Learn about DPS 2020 Training Classes. Click Here. Hi There, Here is the SQLMaestros Bulletin of 12 August, 2020. SQL Video Tutorials Index Tuning – Page Splits & Fragmentation - Click Here. How To Enable Global Trace Flags In SQL Server – Click Here. All videos are available on SQLMaestros.com. Hands-On-Labs Advanced Data Cleansing [...]
Follow SQLMaestros on Twitter & LinkedIn Hi There, SQL Video Tutorials Database IO Cost – Read & Writes - Click Here. Tracking Page Splits using Extended Events – Click Here. All videos are available on SQLMaestros.com. Hands-On-Labs User Defined Functions - Click Here. TOP & APPLY Operators in SQL Server – Click Here. All labs [...]
Hi There, SQL Videos on Twitter Where are the estimates coming from? - Click Here. Power Plan config may affect SQL performance – Click Here. All videos are available on SQLMaestros.com. From SQLMaestros Archives Performance Monitor Counters - Quick technique to record performance counters data in SQL Server. Click Here. Learn to use RANK() function [...]
#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. • [...]
#1_July_01_2020_Wednesday Hi There, SQL Server optimizes Tempdb so that your CRUD operations go faster. There are many ways how this is done. One of them is optimized logging or minimal logging. Read the full blog post. Also a two-minute video on Twitter. See here. S-arg-ability is a much spoken term in SQL Server world. We [...]