SQL Server

Learn when and how to use the SQL PARTITION BY clause in SQL Server and how it differs from the GROUP by clause.

Learn how to use multiple Postgres date functions to convert a date type to the required time zone, format or specific information.

Find out about the various types of constraints in SQL Server and understand the advantages they offer when implemented.

Explore this guide to learn about SQL Server tables and best practices to consider when creating user-defined tables in SQL Server.

Dive into what database schemas are, their advantages and what is needed to create and employ SQL Server schemas.

Learn the different methods for using the UPDATE from SELECT statement in SQL Server and explore their performance comparison.

Learn how to use the SQL CONVERT date function to get the specific date format you need, as they can vary between different countries.

Learn all about the different SQL join types and important best practices to remember and apply when using SQL joins.

CXPACKET and CXCONSUMER wait types in SQL Server are common occurrences when managing database performance. Learn how to fix them.

Learn more about the ways to fix concurrency issues like SQL deadlocks or blocks from Brent Ozar, Microsoft Certified Master.