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.
A guide to using Postgres indexes
Indexes are used to improve the speed of data retrieval in a database. Learn the various types of Postgres indexes and the best use case for each.
How to use UPDATE from SELECT in SQL Server
Learn the different methods for using the UPDATE from SELECT statement in SQL Server.
Exploring the various Postgres data types
Relational databases organize data into tables of rows and columns with assigned data types. Learn the various Postgres data types and supported values.
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.
Key methods for creating Postgres tables
To work with data in a relational database, tables need to be created. Learn what Postgres tables are and how to create different types of tables in Postgres.
3 easy ways to improve your database performance
Here are three common sources of database issues and suggestions for how to improve database performance quickly before issues impact users.
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.
How to read and analyze SQL Server execution plans
SQL Server execution plans are a gateway for query optimizer and query executions. Learn how to read, interpret and analyze execution plan data.