Strange String Splits

How Implicit Transactions Hurt SQL Server Performance Without You Knowing

Learn about implicit transaction and why you might not want to enable this setting.

I Love Editorials

Why do I love editorials, I can hear you asking. The answer is simple. It's all about opinions. I have opinions. Lots of them. Lots and lots of them. I'm flying home from Hong Kong after visiting a Redgate customer. They are doing amazing work.. It's so cool getting to see how people are solving […]

Building a RESTful API with FastAPI and PostgreSQL

This article shows how to use Python to create a REST API for your application that developers can use to access the database.

Identify Unused Tables in SQL Server and Azure SQL

This article presents a way to discover those tables that are unused over a period of time, along with suggestions on how to get rid of these tables.

Schema Design Basics for Power BI

You have a Power BI project that generates real-time reports for an inventory management system that uses SQL Server. You are aware that Power BI performance is heavily influenced by how your data is structured in SQL Server but don’t have a clear understanding of how to optimize your SQL data structure for Power BI. In this article, we look at different ways to structure the data and tables to help improve Power BI query performance.

Technological Dinosaurs or Social Dinosaurs?

You're going to have to bear with me on this one because my thoughts aren't fully formed. As I'm sure I've mentioned, I'm a little elderly (and you thought I was going to talk about radios). As such, I've seen the death of a few technologies. I may not have shared this widely, but my […]

Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.

Cleaning Up the Cloud

Trying to clean up a cloud subscription is an interesting experience.

How to Use SQL Server Features to Cut Web App Latency in Half

Discover how SQL Server features reduce web app latency. Learn key tactics to deliver faster queries and better performance in today’s web economy.