SQL Server Videos

Home/SQL Server Videos

SQL Server Videos (Short Tutorials & Demos)

CXPACKET Wait Type in SQL Server by Amit Bansal

In this video, you will understand what CXPACKET Wait Type is and how you can get rid of unwanted parallelism 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 [...]

When Did SQL Server Start (Database Engine Start Time) by Amit Bansal

In this video, you will see how you can find the elapsed time in milliseconds since SQL Server process started. 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 [...]

When Did SQL Server Start (Database Engine Start Time) (by Amit Bansal)

In this video, you will see how you can find the elapsed time in milliseconds since SQL Server process started. 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). SQLMaestros Master Classes Wish [...]

How To Create a SQL Server Login by Satya Ramesh

In this video, you will learn how to create a SQL Server login. 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. [...]

How To Restore a Database in SQL Server (by Satya Ramesh)

In this video, you will learn how to restore a database 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. [...]

SQL Server – The Concept of Density by Amit Bansal

In this video, you will understand the concept of Density. 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. Learn more about [...]

How To Take Database Backup In SQL Server by Satya Ramesh

In this video, you will learn how to take database backup 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. [...]

SQL Server – The Concept of Selectivity by Amit Bansal

In this video, you will understand the concept of selectivity. 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. Learn more about [...]

Row Number Function In SQL Server by Satya Ramesh

In this video, you will learn about the Row Number Frunction 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. [...]

Pivoting in SQL Server by Satya Ramesh

In this video, you will learn how to pivot the 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. [...]

Nested Loop Join in SQL Server by Satya Ramesh

In this video, you will learn about basics around Nested Loop join and how Nested Loop Join algorithm works. You will also learn about different scenarios where SQL Server decides to use Nested Loop Join operator and how it affects performance. Get new content directly in your inbox - Click here You can also visit [...]

Read Committed Isolation Level in SQL Server by Satya Ramesh

In this video, you will learn about Read Committed isolation level, which is SQL Server's default. This video explains how to overcome 'dirty reads' problem and also shows other concurrency problems like 'non-repeatable reads' and 'phantom reads' that you cannot avoid using Read Committed isolation level. Get new content directly in your inbox - Click [...]

How to work with INNER JOINs in SQL Server by Satya Ramesh

In this video, you will learn about INNER Joins 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. Learn [...]

SQL Server Index Internals – Multiple Index Hints by SSMS

In this video, you will see that SQL Server can, sometimes, recommend more than one index hint for a given query, but it is not so evident. 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 [...]

SQL Server Index Internals – Clustered Index Seek (Range Scan)

In this video, you will understand what really Clustered Index Seek means and why it can be misleading, sometimes. 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 [...]

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

Troubleshooting SQL Server IO – Part 2 (Avg Disk Sec per Read)

In this video, you will understand how Avg. Disk sec/Read performance monitor counter can be used to identify/detect/compute read latency on slow IO. 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 [...]

Troubleshooting SQL Server IO – Part 1 (sys.dm_io_virtual_file_stats)

In this video, you will understand how sys.dm_io_virtual_file_stats can be used to identify/detect/compute read latency on slow IO. 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 [...]