Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Is Fabric a Reliable Service or a Ripped Resource?

Over the last few weeks, I've noticed a few complaints from different friends and customers about issues with Microsoft's Fabric service. I had assumed these were isolated incidents in just a few places, and customers were being refunded according to an SLA. Then I saw Joey D'Antoni's post this week about Fabric going down. It lists quite a few of the incidents in June, including a few global ones.

However, the most surprising thing in the post was this link, noting Fabric doesn't have a dedicated SLA. Instead, it's under the general Microsoft support agreement, meaning your organization needs to have a support plan to get help. I think that makes some sense, but I'd really expect that a data service in the cloud, including an analytic service that touts itself as real-time, would have a high SLA. Some agreement on the order of 4 9s at least, if not 5.

For those of you who think you can do better on premises, I'll remind you that four 9s mean you get 52 minutes of downtime a year, or 1 minute a week (roughly). Five 9s is 5 minutes a year, and the weekly calculation doesn't matter. I've had systems run for a year, but a lot, and not a lot of databases, especially with patching 6 times a year. This year, with AI (my guess) finding lots of holes and GDR releasing quite often, I would guess that three nines is out the window for most SQL Server systems that aren't HA clustered in some way.

As a point of reference, Denny notes that Azure SQL database, Business Critical, has a four-and-a-half 9s level of reliability and financial refunds for costs if that's exceeded. You will need some sort of business insurance if you worry about revenue issues, but my guess is that most of us live with the downtime and work around it (and hopefully, plan for it).

I've been skeptical of Fabric (outside of Power BI). It feels cobbled together, so many issues are reported, and I feel like it's immature. If I were working on a new analytics project, and we didn't have a solution, I might PoC it, but I'd be more likely to consider Databricks, Snowflake, or Redshift rather than Fabric.

Perhaps you have a different view, or you have had success with Fabric. I know some people who have, but it seems one-sey two-sey and not commonplace. There seem to be so many workarounds and issues; it makes me skeptical that Fabric is really ready for primetime if Microsoft won't stand behind it. Databricks only gives credit up to three 9s, but if they fall below 95%, they issue a 100% credit. Snowflake offers four 9s.

I feel that if Microsoft were confident in their reliability, they'd offer refunds if they didn't perform.

 

Steve Jones - SSC Editor

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
AI/Machine Learning/Cognitive Services

This Week in AI: Who Controls the Loop?

From O'Reilly Radar - Insight

This week host and Turing Post founder Ksenia Se threaded the latest news into a single argument: AI is moving out of conversation and into the operational loops where...

Agentic Code Review

From O'Reilly Radar - Insight

The following article originally appeared on Addy Osmani’s blog site and is being republished here with the author’s permission. Coding agents are extraordinarily good now, and getting better fast....

Clustering Text via Embeddings and HDBSCAN

From Curated SQL

Ivan Palomaras Carrascosa groups things together: ...

Administration of SQL Server

SQL Server 2025 ZSTD LEVEL Isn't Exactly What You Think It Is

From SQLFingers

SQL Server 2025's new ZSTD backup compression is a...

Handling Growth in sysjobhistory

From Curated SQL

Aaron Bertrand has a lot of jobs: In the first few...

Azure CosmosDB

How to run an analytical query on a mirrored Azure Cosmos DB container using C#

From Hasan Savran

In my earlier post, I covered how to mirror Azure ...

Career, Employment, and Certifications

5 Reasons You Should Hire Richie Rump Today.

From Brent Ozar Unlimited

We’re discontinuing our apps (not the First Resp...

Community Interests

Change is the only constant

From SQL Server Fast

(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who...

Computing in the Cloud (Azure, Google, AWS)

Want to look at cloud reporting but not sure what the costs will be?

From SQLServerCentral Blogs

Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea what it would actually cost? ?? That’s the scariest thing, and... The...

Hardware

Setting Up a Mac for Data Engineering and AI Work

From SQLServerCentral Blogs

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac with Apple Silicon is genuinely one of the best machines you can have as a... The...

Apple Raises Prices on Macs, iPads, and More as AI Drives Memory Shortage

From Past News - RSS Feeds

Apple raised prices on Macs, iPads, and other devi...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Medallion Architecture for IoT Data in Microsoft Fabric

 

Fabric for Operational Reporting & SQL Endpoint Trap

From Joyful Craftsmen – The Business Intelligence Agency

With Fabric Mirroring, Microsoft is promoting a ni...

Rethinking Fabric Data Agent Deployment Using the Data Agent SDK

From Data – Marc

Over the past year, I’ve frequently blogged abou...

Microsoft Fabric–Why Are You So Down?

From The SQL Herald (Joey D'Antoni)

Microsoft Fabric is software-as-a-service platform...

Performance Tuning SQL Server

Learn T-SQL With Erik: Controlling Memory Grants

From Erik Darling Data

Learn T-SQL With Erik: Controlling Memory Grants C...

PostgreSQL

Christophe Pettus: All Your GUCs in a Row: enable_hashagg

From Planet Postgres

PostgreSQL 13 made hash aggregation memory-safe by allowing it to spill to disk — but that safety introduced a surprise regression for some queries on upgrade.

PowerPivot/PowerQuery/PowerBI

Power BI Copilot, Data Agent Optimization & Performance

From Paul Turley's SQL Server BI Blog

Amid the AI frenzy, there is a lot of conversation about how business users will use agentic chat to answer business questions rather than interactive, dashboard-style reports. Is there...

Product Upgrades and Releases

SQL Server Always On Read-Only Routing Now Has a UI

From DCAC

Microsoft introduced Read-Only Routing to Always O...

Python

Part 2: Using the Companies House API

From Purple Frog Systems

Part 2: Using the Companies House API Welcome back following part 1… Getting a list of companies via Python – Advanced Filtering. This example will look at the transport...

R Language

Snapshot Testing in R: Beyond Screenshots

 

SQL Server News

SQL Server Isn't Dying. It's Being Promoted to Cash Cow

From SQLFingers

Last week, The Register ran a line about SQL Serve...

Security News and Issues

Interesting Paper Exploring Prompt Injection

From Schneier on Security

This is a fascinating explotation of how LLMs fall for prompt injection attacks. It turns out that they learn to recognize the style of text in different role/instruction blocks,...

Meta Halts Employee-Tracking Program After Employee Data Exposed

From Past News - RSS Feeds

Meta pauses MCI after private conversations and em...

One Million Passports Leaked Online

From Schneier on Security

A database of almost a million passports from arou...

Anthropic Accuses Alibaba of Extracting 28M Claude Responses

From Past News - RSS Feeds

Anthropic accused Alibaba-linked operators of extr...

T-SQL and Query Languages

Regular expressions that work “everywhere”

 

An interesting concept: Splitting queries with OR for performance

From Dr SQL

In a recent LinkedIn post, a poster had a novel idea. Say you have a query that has an OR condition. Usually the OR condition in question are related...

CU6 Is Here. SESSION_CONTEXT Is Still Broken in Parallel

From SQLFingers

Back in March I wrote about a SESSION_CONTEXT bug that lies to you in parallel plans, with wrong results or AV dumps, no error, no warning. At the time...

5 T-SQL features that should already exist (2026 SQL Server wish list)

From Simple Talk

2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage — features SQL Server still needs.… The post 5 T-SQL features that should already exist...

A Quick Solution for ‘INSERT statement exceeds the maximum allowed number of 1000 row values’

From Andy Broadsword

If you’re building a large INSERT statement us...

Get Your Blog Posts Ready for T-SQL Tuesday #200. Here’s the Topic.

From Brent Ozar Unlimited

Way back in December of 2009, Adam Machanic publis...

Tech News

2026 Layoffs Tracker: Meta, Robinhood, Walmart, and Oracle Lead AI-Driven Job Cuts

From Past News - RSS Feeds

Tech layoffs are accelerating as companies invest heavily in AI, raising questions about automation, over-hiring, and corporate accountability.

Chinese Cyber Firm Claims New AI Tool Rivals Anthropic’s Mythos

From Past News - RSS Feeds

China’s 360 says its Yitian Tulong AI cybersecur...

Orbital Data Centers Aren't Ridiculous, But They Won't Save Us From Earth's AI Infrastructure Crunch

From Past News - RSS Feeds

Orbital data centers may eventually support AI and...

AI agents are reshaping government. What should leaders know?

From AllAnalytics

AI agents are moving beyond individual productiv...

US Firm’s Humanoid Robot Teaching Assistant to Support 500 Students in 2026

From Past News - RSS Feeds

Realbotix is deploying Optio and a humanoid robot ...

The Lighter Side

Super Mario is mathier than you think

From Technology Review Feed - Tech Review Top Stories

Here’s a problem you probably didn’t solve in school: You’re an ambitious young plumber from Brooklyn in a world inhabited by violent human-size mushrooms called Goombas. The love of...

If I Got Hit by a Bus, Could Traci Keep the Lights On?

From SQL DBA with A Beard

The Uncomfortable Thought Every techie I know has one. A box. Or a stack of boxes. Humming away in a cupboard, under the stairs, in the garage, in the spare...

Advice I Like: Respect

From SQLServerCentral Blogs

“Don’t aim to have others like you; aim to hav...

Tools for Dev (SSMS, ADS, VS, etc.)

Copilot in SSMS Runs As You — Until You Fence It In

From SQLFingers

Here is a piece that many people miss when they wi...

SQL Formatting in SSMS 22.7

From Callihan Data

Code formatting can be a touchy subject. Sometimes...

 
RSS FeedTwitter
This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -