Welcome to SQLMaestros Hands-On-Labs

SQLMaestros Hands-On-Labs is a library of documents (HOLs) that allows you to practice a concept step-by-step. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. Currently the HOLs are focussed on Microsoft Data Platform with majority of labs on SQL Server. SQLMaestros Hands-On-Labs enables the practical way of learning. With our HOL documents you will get hands-on with hundreds of topics in SQL Server & related technologies. It’s time to practice. The best way to learn is to do-it-yourself.

Wish to download a few HOLs from free? Register as a free user and download some HOLs, absolutely free.

Register as a free user.

Free Hands-On-Labs

Lab Title Download
Clustered Index Internals
Non-Clustered Index Internals
Heap Internals
Extended Events Part 1

To access the full library, become a paid user. Login now

Subscription Type Price Features
Gold $30 / INR 2100 Per Month + 15% Service Tax Unlimited access to full HOLs library for a month
Diamond $300 / INR 21000 Per Year + 15% Service Tax Unlimited access to full HOLs library for an year

Already a paid user, Login Now to access the complete library of HOLs.

Full HOL Library (Paid)

Title Download
New Security Features in SQL Server 2016
  1 files      1 download
Subscribe to Download
SQL Server Aggregations
  1 files      1 download
Subscribe to Download
Calling Web Service From SSIS
  1 files      1 download
Subscribe to Download
SQL Server Database Maintenance
  1 files      1 download
Subscribe to Download
Query Store, Live Query Statistics and Live Query Plans
  1 files      0 download
Subscribe to Download
JSON Support in SQL Server 2016
  1 files      0 download
Subscribe to Download
SQL Server Advanced Aggregations
  1 files      0 download
Subscribe to Download
Pivoting in SQL Server
  1 files      0 download
Subscribe to Download
SSIS Data Loading Part 1 – Excel & XML
  1 files      0 download
Subscribe to Download
Implementing Incremental Data Load And Inner Join in SSIS
  1 files      0 download
Subscribe to Download
Error and EventHandling in SSIS
  1 files      0 download
Subscribe to Download
Advanced Data Cleansing In SSIS
  1 files      1 download
Subscribe to Download
SQL Server Temporary Tables
  1 files      2 downloads
Subscribe to Download
Non-clustered Columnstore Indexes in SQL Server 2014
  1 files      1 download
Subscribe to Download
Slowly Changing Dimension In SSIS
  1 files      0 download
Subscribe to Download
SSIS Foreach Loop Container
  1 files      0 download
Subscribe to Download
Task Group Sequence and For loop Containers in SSIS
  1 files      0 download
Subscribe to Download
DBCC Commands in SQL Server
  1 files      3 downloads
Subscribe to Download
Constraints in SQL Server
  1 files      3 downloads
Subscribe to Download
Working with Date and time datatypes in SQL Server
  2 files      3 downloads
Subscribe to Download
Delayed Durability in SQL Server 2014
  1 files      4 downloads
Subscribe to Download
SQL Server Data Types Part 1
  1 files      4 downloads
Subscribe to Download
SQL Server Data Types Part 2
  1 files      4 downloads
Subscribe to Download
XML and Xquery in SQL Server
  1 files      2 downloads
Subscribe to Download
SQL Server Showplan Operator Part 2
  1 files      5 downloads
Subscribe to Download
SQL Server Advanced Index Operations
  1 files      4 downloads
Subscribe to Download
Troubleshooting Metadata Corruption in SQL Server
  1 files      4 downloads
Subscribe to Download
Backup and Restore Enhancements in SQL Server 2014
  1 files      4 downloads
Subscribe to Download
SQL Server Data Encryption
  1 files      4 downloads
Subscribe to Download
Troubleshooting SQL Server with WinDbg
  1 files      4 downloads
Subscribe to Download
SSIS Data Flow Transformations Part 1
  1 files      1 download
Subscribe to Download
SSIS Data Flow Transformations Part 2
  1 files      1 download
Subscribe to Download
Partitioning in SQL Server
  1 files      4 downloads
Subscribe to Download
Managing System Databases in SQL Server
  1 files      6 downloads
Subscribe to Download
SQL Server Change Data Capture
  1 files      4 downloads
Subscribe to Download
SQL Server Statistics Internals
  1 files      5 downloads
Subscribe to Download
SQL Server DMLTriggers
  1 files      4 downloads
Subscribe to Download
SQL Server DDLTriggers
  1 files      4 downloads
Subscribe to Download
SQL Server Performance Tuning using Trace Flags
  1 files      3 downloads
Subscribe to Download
SQL Server Joins
  1 files      6 downloads
Subscribe to Download
SQL Server Execution Plans
  1 files      4 downloads
Subscribe to Download
SEQUENCE in SQL Server
  1 files      4 downloads
Subscribe to Download
Optimizing SQL Server Stored Procedures
  1 files      7 downloads
Subscribe to Download
OFFSET and FETCH in SQL Server
  1 files      6 downloads
Subscribe to Download
Merging Data in SQL Server
  1 files      6 downloads
Subscribe to Download
LAG and LEAD Functions in SQL Server
  1 files      4 downloads
Subscribe to Download
Inserting Data in SQL Server
  1 files      5 downloads
Subscribe to Download
Error Handling in SQL Server
  1 files      4 downloads
Subscribe to Download
Deleting Data in SQL Server
  1 files      5 downloads
Subscribe to Download
SQL Server Ranking Functions
  1 files      6 downloads
Subscribe to Download
SQL Server Set Operators
  1 files      5 downloads
Subscribe to Download
Subqueries in SQL Server
  1 files      4 downloads
Subscribe to Download
Table Expressions in SQL Server
  1 files      6 downloads
Subscribe to Download
SQL Server Stored Procedures
  0 files      5 downloads
Subscribe to Download
SQL Server Temporary Table And Table Variables
  1 files      4 downloads
Subscribe to Download
TOP and APPLY Operators in SQL Server
  1 files      5 downloads
Subscribe to Download
Updating Data in SQL Server
  1 files      5 downloads
Subscribe to Download
User Defined Functions in SQL Server
  1 files      4 downloads
Subscribe to Download
Views in SQL Server
  1 files      5 downloads
Subscribe to Download
Working with NULL in SQL Server
  1 files      6 downloads
Subscribe to Download
SQL Server Point-in-Time Recovery
  1 files      7 downloads
Subscribe to Download
Auditing SQL Server
  1 files      11 downloads
Subscribe to Download
Concurrency Problems in SQL Server
  1 files      8 downloads
Subscribe to Download
Fix SQL Server Database Corruption
  1 files      8 downloads
Subscribe to Download
Improving SQL Server Query Performance with Indexes Part 2
  1 files      9 downloads
Subscribe to Download
Improving SQL Server Query Performance with Indexes Part 1
  1 files      8 downloads
Subscribe to Download
Monitoring SQL Server with Extended Events
  1 files      6 downloads
Subscribe to Download
Moving User Databases in SQL Server
  1 files      6 downloads
Subscribe to Download
Securing SQL Server Part 1
  1 files      6 downloads
Subscribe to Download
SQL Server Backup and Restore
  1 files      9 downloads
Subscribe to Download
SQL Server Basic Query Tuning Techniques
  1 files      6 downloads
Subscribe to Download
SQL Server Deadlock Basics
  1 files      6 downloads
Subscribe to Download
SQL Server Deadlock Types
  1 files      7 downloads
Subscribe to Download
SQL Server Latches
  1 files      5 downloads
Subscribe to Download
SQL Server Parameter Sniffing
  1 files      5 downloads
Subscribe to Download
SQL Server Policy Based Management
  1 files      6 downloads
Subscribe to Download
SQL Server Resource Governor
  1 files      6 downloads
Subscribe to Download
SQL Server Showplan Operators Part 1
  1 files      13 downloads
Subscribe to Download
SQL Server Storage Internals Part 2
  1 files      6 downloads
Subscribe to Download
SQL Server Storage Internals Part 1
  1 files      8 downloads
Subscribe to Download
SQL Server Transaction Log Internals Part 1
  1 files      8 downloads
Subscribe to Download
SQL Server Transaction Log Management
  1 files      6 downloads
Subscribe to Download
SQL Server Wait Types Part 1
  1 files      7 downloads
Subscribe to Download
SQL Server Wait Types Part 2
  1 files      6 downloads
Subscribe to Download
SQLServer Plan Caching Recompilation and Reuse
  1 files      6 downloads
Subscribe to Download
Using Query and Table Hints in SQL Server
  1 files      9 downloads
Subscribe to Download