Database Management

Relational databases organize data into tables of rows and columns with assigned data types. Learn the various Postgres data types and supported values.

Date interpretations vary between different countries. Learn how to use the SQL CONVERT date function to get the specific date format you need.

How you approach database performance tuning depends on the performance issues you are trying to resolve. Here are 10 best practices to help improve database speed and efficiency.

To work with data in a relational database, tables need to be created. Learn what Postgres tables are and how to create different PostgreSQL table types.

Here are three common sources of database issues and suggestions for how to improve database performance quickly before issues impact users.

The adoption of software subscription services is growing. Learn the different types, and the pros and cons to determine if they are right for you.

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.

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.

Learn how to avoid SQL deadlocks through query tuning, courtesy of Microsoft Certified Master Brent Ozar.

SQL Server execution plans are a gateway for query optimizer and query executions. Learn how to read, interpret and analyze execution plan data.

Database performance lagging? Learn about database monitoring: what it is, how to perform it and the top metrics to keep your eye on.

When SQL query optimization is needed, apply these best practices to improve database performance first.