You can change the default language: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-default-language-server-configuration-option?view=sql-server-ver15

There is no choice in install. I thought that some languages had localized binaries, but the MS docs seem to indicate that you...

Are you using Hadoop, Eric?  I ask because some folks at work are talking about using "map reduce" (AWS EMR to be specific) and I may have been mislead...

Is this in the wrong topic? Not sure what you mean?

On a different note, here's one of the many reasons I fear both the cloud and any automatic performance metrics collected by any company...

https://mspoweruser.com/microsoft-accidentally-exposes-250-million-customer-support-records-online/

This has gotten to be a...

Hi Steve,

I am confused by this point :

" I find less and less resistance from developers about using sensitive production data in development environments, but still too much."

Are you...

Steve,

While I do like the article that you wrote, I would like to point out that you never defined PII ( Personally identifiable information ) in it.  I am...

Not really a switch, but an area of interest. I was hoping to get better at working with and gathering data. This is a big area of growth in SQL...

Calling another procedure isn't returning data from the procedure.

You can install Standard or Express on Win 10. Not Enterprise.

Win 10 has some limits on connections and resource usage. Windows server is designed for lots of connections. If this...

You have an implicit or explicit conversion taking place. Somewhere your code is trying to cast data to float, and there are values in the varchar field that cannot be...

Likely you don't have permission. The best way is just to ask someone. They might not give you permissions, but I'd hope they would send you the definition.

I've edited the question, to note data and directly returning, which should eliminate temp tables, etc. I think Print/Raiserror aren't really about returning data, but they do return info, so...

I tend to avoid dynamic SQL, and I'd usually just deploy the same report to all servers and call it without having to do any linked server or anything else....

Yep, everyone knows rule #1 of The Culture. 🙂

Steve, remember the importance of Me time. Sometimes tech types are a little OCD and focus too hard on the new...

Tends to vary over time. I like some sci-fi, spy thrillers,...