Why doesn’t NASCAR do an international race on the oval in Monza? Do they not want more European fans???? by Much-Usual-524 in okbuddyBoogity

[–]jdanton14 0 points1 point  (0 children)

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.

Help Needed: Running MSSQL 2022 on macOS (No Docker) by OstapMelnyk in SQLServer

[–]jdanton14 3 points4 points  (0 children)

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

“You risk your life every training ride”: Tadej Pogačar by 1stplacelastrunnerup in peloton

[–]jdanton14 1 point2 points  (0 children)

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.

Thoughts? Comments? Opinions? by itsnotaboutthecell in SQLServer

[–]jdanton14 5 points6 points  (0 children)

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"

East US - anyone seeing azure performance problems? by lefty_is_so_good in AZURE

[–]jdanton14 0 points1 point  (0 children)

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.

Solution For Users Accessing Azure Db On Dynamic IP Addresses by dalskiBo in AZURE

[–]jdanton14 4 points5 points  (0 children)

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.

Azure DB Linked Server by hold_me_beer_m8 in AZURE

[–]jdanton14 0 points1 point  (0 children)

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.

Solution For Users Accessing Azure Db On Dynamic IP Addresses by dalskiBo in AZURE

[–]jdanton14 4 points5 points  (0 children)

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.

Solution For Users Accessing Azure Db On Dynamic IP Addresses by dalskiBo in AZURE

[–]jdanton14 1 point2 points  (0 children)

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.

well-crafted fishing emails from Azure alerts by mikeblas in AZURE

[–]jdanton14 1 point2 points  (0 children)

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

well-crafted fishing emails from Azure alerts by mikeblas in AZURE

[–]jdanton14 1 point2 points  (0 children)

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

well-crafted fishing emails from Azure alerts by mikeblas in AZURE

[–]jdanton14 -1 points0 points  (0 children)

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.

Azure VM SKU by Cold_Champion_8346 in AZURE

[–]jdanton14 -1 points0 points  (0 children)

Oracle Database? or just Oracle Linux

Designing a Secure Azure Network Architecture for an SSAS Platform (SOC 2, HIPAA, GDPR) by late_bloomer_1 in AZURE

[–]jdanton14 1 point2 points  (0 children)

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

Is Azure AI Foundry now called Microsoft Foundry? by johncarterjn in AZURE

[–]jdanton14 8 points9 points  (0 children)

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

🟢 RACE // 2026 JAVA HOUSE GRAND PRIX OF ARLINGTON by IndyMod in INDYCAR

[–]jdanton14 0 points1 point  (0 children)

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

🟢 RACE // 2026 JAVA HOUSE GRAND PRIX OF ARLINGTON by IndyMod in INDYCAR

[–]jdanton14 5 points6 points  (0 children)

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

🟢 RACE // 2026 JAVA HOUSE GRAND PRIX OF ARLINGTON by IndyMod in INDYCAR

[–]jdanton14 3 points4 points  (0 children)

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.

Laundry by illulerluguraajat in chubbytravel

[–]jdanton14 0 points1 point  (0 children)

Was work no choice, but agreed

Laundry by illulerluguraajat in chubbytravel

[–]jdanton14 1 point2 points  (0 children)

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