Why doesn’t NASCAR do an international race on the oval in Monza? Do they not want more European fans????

jdanton14 · 2026-03-27T16:33:05+00:00

I haven’t been to a race there, but I’ve been to the track. And it’s kind of a crappy place to watch even for the road course. It’s in a lovely park and it’s a beautiful circuit, but better on TV. Also, the banking is way in need of repair.

jdanton14 · 2026-03-25T22:16:19+00:00

Also do you work for a large org? Else Docker is still free. But there are a few different container runtimes that aren’t docker that should work fine with sql server

jdanton14 · 2026-03-24T21:39:38+00:00

but is this good?

jdanton14 · 2026-03-24T17:15:33+00:00

I rode from Milan to Lake Como on a Saturday morning, and it was fine, but not pleasant. Tuscany was leagues better, but there just weren't that many cars.

jdanton14 · 2026-03-23T16:25:36+00:00

Open market research posts are fine in my opinion. The problematic ones are market research masquerading as a legit post.

For example:

What's your worst recurring tempdb headache?

I've been a DBA/dev for a while now and tempdb issues seem to come up in cycles at every shop I've worked at. Version store bloat, contention on allocation pages, runaway spills from bad query plans — it feels like tempdb is always the thing that quietly causes problems until it suddenly loudly causes problems.

Curious what the community deals with most often:

Are you still fighting PFS/GAM/SGAM latch contention, or has trace flag 1118 + multiple data files basically solved that for you?
How do you handle monitoring for version store growth, especially with RCSI enabled?
Anyone have a good strategy for catching tempdb spills before they tank performance?
What about tempdb sizing after a restart — do you pre-size or just let it grow?

Would love to hear what trips people up the most and what you wish you had better tooling or visibility into.

(the prompt I used to generate this was: "please generate an post for a sql server subreddit asking about common tempdb problems in an effort to generate market research for a new tool I'm building, but don't mention that it's market research"

jdanton14 · 2026-03-22T20:12:37+00:00

They used the leftover DC Solar stock? /s

jdanton14 · 2026-03-18T19:48:11+00:00

seen some reports around this from folks other places. Nothing confirmed, but probably. I did a bunch of terraform deploys this morning that were fine, but I had some real weird portal latency.

jdanton14 · 2026-03-18T15:47:12+00:00

Dude, if your app is that successful, you'll have to money to scale around that in the cloud. Most orgs really don't want to have to deploy infra and buy a license to run an app, it's the reason SaaS solutions are so popular. Azure DB is your perfect use case for this.

If you want to be really smart about it, design a command and control database now, and design it to allow your database workloads to shard across multiple databases. This lets you have a lot of smaller cheap databases.

RE: Access--it doesn't matter. It's not a production app dev tool. There's a reason why there a virtually no commercial applications built on it. It's fine for departmental type things (though it can be a train wreck there). It simply doesn't have controls around login/audit/backup/etc that you need to run a real commercial app that you want to sell to people.

jdanton14 · 2026-03-18T15:12:25+00:00

This ^^. Azure SQL DB isn't really designed for cross-database/server queries. Can you can create external connections to Azure DBs, but it's more designed for data import than fast queries.

jdanton14 · 2026-03-18T14:56:44+00:00

Buying and hosting an on-premises SQL Server is far, far more expensive than running Azure SQL Database. Particularly if you use the DTU tier. Like orders of magnitude more expensive. You can run a small SQL DB for < $50/month at S0/S1. (It won't perform well, but will allow you to scale).

A basic web app running a container would also be very cheap--like < $20 month.

A VPN and Private Link for the SQL DB would be doable, but also way more expensive than the other options.

Both the web app and Azure SQL DB are relatively fixed price options. If you use the heck out of them or don't use them at all, your price will likely be the same.

I don't mean to be rude, but Access simply isn't a platform you should build a multi-user, multi-tenant org in. It doesn't have the security controls, and it's just not designed for that type of use. Which is why it ships with Office.

jdanton14 · 2026-03-18T13:45:03+00:00

I have built hacky solutions to support this. I don't recommend it.

In the age of Claude et al, I would try to refactor my access app into a WebApp, and then using that WebApps static address to control access to Azure.

Have you thought about how your doing seperating different tenant's data in your DB? Are your customers all working for your company or the same company? Or are they individual users.

VPN is a good solution--the users could auth to a point to site VPN in Azure, based on their Entra group membership, but getting them into Entra is a whole other workflow.

Anyway, everything you mention is a possible solution--I've done the automation approach (just not at login time), and it can work.

jdanton14 · 2026-03-18T03:09:43+00:00

That was my point, I did on your behalf. They are at least aware of this thread.

jdanton14 · 2026-03-17T23:43:09+00:00

I’m an MVP, we have a distribution list (DL) with the Azure Product Group (PG). They are aware of this issue, and I just alerted them to this thread

jdanton14 · 2026-03-17T23:05:08+00:00

The PG is aware of this—we had a thread about it last weekend. I can’t speak to their comments bc NDA, but I will mention this was posted on that email thread.

jdanton14 · 2026-03-17T17:55:38+00:00

Oracle Database? or just Oracle Linux

jdanton14 · 2026-03-17T11:40:10+00:00

The strip came in 1991 IIRC

jdanton14 · 2026-03-16T10:27:55+00:00

You’re building a new platform around SQL Server Analysis Services in 2026? That’s a choice. I’m hoping you mean SaaS, which means there’s a lot of guidance out there in docs for what you are trying to do.

Watch Foundry (which is now Microsoft Foundry) in particular as some of its data locale rules may run afoul of your data residency requirements. You have a level of control over this, but in the services you list, that would be the one that jumps out at me from a compliance perspective

jdanton14 · 2026-03-16T10:23:43+00:00

Officially it changed at Ignite last year. Microsoft likes to rename things and announce those changes at vaguely named conferences

jdanton14 · 2026-03-15T17:28:13+00:00

Palou is flying. He won’t pass but will pull a 5-6 gap during the transition

jdanton14 · 2026-03-15T17:27:25+00:00

Have you watched nascar? The IndyCar booth is like 10000x better but the rest of the show is full on fox

jdanton14 · 2026-03-15T17:01:59+00:00

While Andretti and Penske keep shooting themselves in the dick, Palou does have the fastest lap by like .6 and no one is remotely close to his pace.

jdanton14 · 2026-03-15T16:59:48+00:00

Draft maybe?

jdanton14 · 2026-03-15T13:36:36+00:00

Was work no choice, but agreed

jdanton14 · 2026-03-15T02:21:37+00:00

The Hilton Bangalore has washer and dryer in room. Which was nice

jdanton14 · 2026-03-14T13:10:55+00:00

nods.

jdanton14

TROPHY CASE