SQL Server authentication vs. Windows authentication: Which to use and when
Authentication is a critical component of security. Learn how SQL Server authentication works and how it differs from Windows authentication.
When and how to use the SQL PARTITION BY clause
Learn when and how to use the SQL PARTITION BY clause in SQL Server and how it differs from the GROUP by clause.
Exploring Postgres date formats and their different functions
Learn the different Postgres date formats and functions available.
Exploring the different constraints in SQL Server
Constraints in SQL Server are predefined rules that you can enforce in single or multiple columns. Learn the different types and benefits for using them.
A beginner’s guide to SQL tables
Check out this beginner’s guide to learn about SQL Server tables and best practices to consider when creating user-defined tables in SQL Server.
Using database schemas in SQL Server
Learn what database schemas are, their advantages and how to create and use SQL Server schemas.
13 SQL Server security best practices
Poorly secured databases are at risk for security breaches. Here are 13 SQL server security best practices to protect your database from malicious attacks.
How to use UPDATE from SELECT in SQL Server
Learn the different methods for using the UPDATE from SELECT statement in SQL Server.
Various ways to use the SQL CONVERT date function
Date interpretations vary between different countries. Learn how to use the SQL CONVERT date function to get the specific date format you need.
An overview of SQL Join types with examples
SQL join is a clause used to combine multiple tables and retrieve data in relational databases. Learn the different SQL join types and how to use them.
Demystifying CXPACKET and CXCONSUMER wait types in SQL Server
CXPACKET and CXCONSUMER wait types in SQL Server are common occurrences when managing database performance. Learn Brent Ozar’s advice on how to fix them.
Avoiding SQL deadlocks with query tuning: Advice from Brent Ozar
Learn how to avoid SQL deadlocks through query tuning, courtesy of Microsoft Certified Master Brent Ozar.