Analyze Data with a Serverless SQL pool in Azure Synapse Analytics

Learn how to query data stored in text files from Azure Synapse Analytics using the Serverless pool that is included with each workspace.

Build a Better WordPress Archives Page Using MySQL

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.

Creating Test Data

This editorial was originally published on Jan 9, 2020. It is being re-run as Steve is out of town. Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer […]

Build a Better WordPress Archives Page Using MySQL

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.

PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones)

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know.
In this follow-up webinar, find out how to take your first steps using PostgreSQL.

Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover:
-The freely available options to help you get started
-The essential tools you will need when using PostgreSQL
-Some learning resources to help you take the next steps

PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones)

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know.
In this follow-up webinar, find out how to take your first steps using PostgreSQL.

Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover:
-The freely available options to help you get started
-The essential tools you will need when using PostgreSQL
-Some learning resources to help you take the next steps

Abolish Disjointed Time

The European Parliment is considering getting rid of daylight savings time.

Bing Chatbot vs ChatGPT

A comparison of ChatGPT and the Bing Chat AI to see which one might be more useful for a user.

Defending the RDBMS

An attack and defense of using relational data stores.

Fitting Into RAM

Will your database fit into RAM? Steve Jones asks you to think about the possibility.