ViewTube

Your SQL query can be 100% correct and still perform terribly. This chapter explains why — and how databases decide the fastest ...

In quantitative research, data loading becomes the hidden bottleneck long before strategy logic does. CSV files get slow.

A quick overview of PostgresSQL Topics: - ACID Transactions; - Schema Constraints; - Rich Data Types; - Row Level Security; ...

Why does it work this way: If in your query, you use Declare @startDate is calculated once at the beginning. By the time the ...

In this video, I delve into some common issues and questions from the SQL Server community, offering insights and solutions.

SQL is one of the easiest skills to start — and one of the most powerful for career growth. In this video, we'll see why SQL is perfect ...

Slow SQL queries in production are never “just slow queries”. They become high CPU, massive logical reads, timeouts, and ...

Database migration is rarely exciting — and that's exactly why it needs to be done right. In this video, I walk through a ...

January 2026 Blog: https://msft.it/6059Q1281 Timecodes: FabCon Atlanta - 0:23 Intro – 1:15 Generally Available – 1:27 Preview ...

In this video, SQL Server expert Steve Stedman shares essential performance monitoring best practices to truly understand what's ...

Slow queries are not a SQL problem — they are a design problem. This chapter shows how databases actually find data fast.

Every reliable app depends on database guarantees you rarely see. In this video, we'll map out ACID transactions, explore how ...

Welcome to Day 10 of the 100-Day Oracle DBA Challenge. In today's lesson, we break down Temporary Tablespaces and ...

Steve Stedman and Shannon Lindsay discuss SQL Server security and performance improvements for the new year.

In this Playlist, we start a complete Microsoft SQL Server course where you will learn SQL Server from scratch to advanced level in ...

Day 26 of showing up. Some days feel clear, some days feel messy, today was one of those thinking days. I spent time reflecting ...

Hibernate entity loading is expensive. If you fix N+1 with JOIN FETCH, you can still get row explosion, duplicates, and memory/GC ...

Your SQL query works perfectly in development. Indexes exist. Data is small. Everything is fast. Then it hits production… and ...

Performance problems don't start at SQL — they start at physical design. This chapter shows how databases store data on disk ...

In this Playlist, we start a complete Microsoft SQL Server course where you will learn SQL Server from scratch to advanced level in ...