Posts

Amit Bansal’s SQL Performance Tuning Class in Denmark – 05 October 2018

Most SQL professionals start solving a performance issue by mere guess work. Indexes, Locking, Waits, IO, CPU, Query Plan, Parallelism – everything is guessed about, yet, there is no success. SQL Server Performance Tuning is a combination of art and science. When it comes to science, a proven methodology needs to be followed and you [...]

Bulletin #6: Aug 25, 2020

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

Bulletin #6: Aug 25, 2020

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

Bulletin #7 | Free LIVE Training by Amit Bansal

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

Cardinality Estimation in SQL Server – Quick Notes, Part 2

Hi Friends, A few days back I penned down a few quick notes about Cardinality Estimation in SQL Server. You can read Part 1 here. SQL Server Cardinality Estimation is a complicated topic until you understand the internals of SQL Server Statistics. Here are some quick notes that will answer some common questions that you [...]

Char vs Varchar (SQL Server Developer Series)

Hi Friends, Here is another small content  piece on Char v/s Varchar  from my Advanced SQL Developer Master Class. You can see all the blog posts in the Developer Series here. Datatypes is one of the most under rated thing which we ignore when designing tables. In most of the consulting assignments that we do, we [...]

CPU Cost by Database (by Amit Bansal)

When you have dozens of databases hosted in a single instance, it helps to narrow down on databases that are contributing towards maximum CPU cycles. 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 [...]