Not a bad plan. I periodically send my passwords to one kid for safekeeping.

Agree with the ordering. If this is a single query that can be a TVF do that. Otherwise, you need to store the data somewhere and a temp table works...

I bet this is some poor design/testing on MS' part. They changed something and assumed people would have SSIS installed or Excel. The 32/64 bit thing is likely legacy in...

Smoke sucks. I hate working outside if we have it. I do have some light masks, but really need eye protection. It bothers my contacts.

I know in the old Redgate...

As a follow up, Larry, I'll add a new row. Notice the value is the same for avg.

Is it slower, perhaps. But what about this?

Here's a blog: https://www.sqlservercentral.com/blogs/command-line-to-configure-windows-firewall-for-sql-server-access

Essentially, on your machine, open firewall settings, add a new inbound rule (from remote computer to this sql server instance.

I usually add a port rule, not...

We've been sweating fires in CO. It's so dry and hot. Definitely hazy in places, and they have warned people about being outside too long.

Yikes, I'd hope buildings would filter...

Startup parameters don't take effect, except on startup.

Well, you can cut them with...

At my job we're in the midst of what we suspect is a "feed ALL OF THE DATA to an AI" project. The reason we only suspect is that...

Is this S3 storage? Or Azure blob?

AFAIK, with OpenRowset in SQL Server 2022 requires polybase to do this. I don't think there is a provider that enables this without PB.

Example...

and of course I found it 5sec after posting: https://www.red-gate.com/campaign/ai-can-accelerate-speed-to-market/?utm_source=sales&utm_medium=email&utm_campaign=wod-202607-flyway-github-actions-ai-guardrails-gm-all

The webinar is on-demand, so it's going to be available. I'm looking for a link now as I'm not sure if was released. It's basically  having GHCP react to an...

Thanks, should be fixed now

I love Power BI, but I think the complexity and cost can be challenging at times. SSRS is well known and proven. I certainly would be careful about migrating things.

I...