PostgreSQL

What SQL Server People Should Know About Amazon Aurora Serverless

Last Updated April 5, 2023

You, dear reader, are most likely a Microsoft SQL Server user – either a DBA or developer. Set your pencil down for a second because you’re not going to learn about a Microsoft product today, nor are you going to learn something that is going to be immediately useful to you in your job. Today,…

Building SQL ConstantCare: Let’s Tune an Index in Postgres.

Last Updated January 14, 2020

Brent Ozar

Indexing, PostgreSQL

This week, our SQL ConstantCare® back end services started having some query timeout issues. Hey, we’re database people – we can do this, right? Granted, I work with Microsoft SQL Server most of the time, but we host our data in Amazon Aurora Postgres – is a query just a query and an index just…

Two Important Differences Between SQL Server and PostgreSQL

Last Updated August 6, 2018

Brent Ozar

PostgreSQL

SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I’ve spent a lot of time writing Postgres queries lately. Here are some of the things I’ve noticed that are different. CTEs are optimization fences. In SQL Server, if you write this query: Transact-SQL With AllPosts AS (SELECT * FROM StackOverflow.dbo.Posts)…

PostgreSQL

What SQL Server People Should Know About Amazon Aurora Serverless

Building SQL ConstantCare: Let’s Tune an Index in Postgres.

Two Important Differences Between SQL Server and PostgreSQL

Save your cart?