SQLMaestros Admin

/SQLMaestros Admin

About SQLMaestros Admin

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

Amit Bansal’s SQL Performance Tuning Class in New Zealand & Australia – May, June 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 [...]

By |May 15th, 2018|Assignments|0 Comments

Troubleshooting SQL Server IO – Part 3 (Most Expensive IO Queries)

In this video, you will understand how to detect/identify most expensive IO queries/workloads. Or in other words, how to find out queries that are causing maximum IO in SQL Server (Top IO Queries) You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope [...]

By |April 26th, 2018|SQL Server Videos|1 Comment

Pivoting Data in SQL Server

Hi Friends, In this blog post, I’ll be talking about Pivoting Data in SQL Server. Pivot refers to rotating rows into columns with or without aggregation. Let’s understand this with an example. I’ll be using SQLMaestros database. You can download the SQLMaestros database from here - https://sqlmaestros.com/download/sqlmaestros-sample-database/ The SQLMaestros has a TransactionDetails table that records [...]

By |February 28th, 2017|SQL Server|0 Comments

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

By |February 28th, 2017|SQL Server|1 Comment

SQL Server Training, SQL Server 2012, Pune May 2013

Friends, here is another SQL Server assignment, successfully completed for one of our esteemed clients. As usual, wonderful training experience with the participants. I am always lucky to find energetic folks inside my class. My attendees add loads of value to the delivery & overall training with great questions and excellent participation. I thoroughly enjoyed [...]

By |May 13th, 2013|Assignments|0 Comments

SQL Server Training, SQL DBA, Gurgaon March 2011

Friends, here is another SQL Server assignment, successfully completed for one of our esteemed clients. As usual, wonderful training experience with the participants. I am always lucky to find energetic folks inside my class. My attendees add loads of value to the delivery & overall training with great questions and excellent participation. I thoroughly enjoyed [...]

By |March 11th, 2011|Assignments|0 Comments