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.

Pushing the Limits of AGs

Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like for HA/DR, upgrades, and probably other uses. As the technology has evolved from it's SQL […]

The Yutes

I recently had the opportunity to talk a little PostgreSQL with the Salt Lake City PostgreSQL Meetup group (thank you for having me by the way). Great bunch of people who were really engaged and asked a lot of questions. On the way out of the event, I was chatting with one person (who had […]

Data Sovereignty in the Cloud

Steve has a few thoughts on the lack of data sovereignty in the cloud, with an outlook that isn't very positive.

Change Tracking and Database Compatibility

Who is Using Standard Edition?

Today Steve is asking if any of you use Standard Edition with the coming of a developer edition that matches it.