Corrected to varchar(30), and the target system always depends, but there is a format designed to convert cleanly to XML. Not all formats do this.

This post could really benefit by addressing those dedicated workers doing IT for government agencies.  My work group is only down 50% from the staff level in place when...

Glad it worked out.

Thanks,and yikes. Usually when I hear those rumblings I'm working on my...

I have no interest, but if you want to set something up, maybe others want to.

Had a request for a large schema from a developer. Wondering if anyone has a large (number of objects) schema that they can send to me for private use. This...

Added a placeholder for 2023. Reply there if you want to play again.

https://www.sqlservercentral.com/forums/topic/ssc-fantasy-football-2023

Chicago? Detroit?

Good to hear you document code. That's a good start. I think AI can be a good tool, but like anything else, you have to make an effort to change...

One thing I like about sqlcmd is that it's always around and easy to use. I hope this becomes the default sqlcmd, but without some of the breaking changes.

In general,...

I think any problem domain where you almost always deal with singletons and don't need complex joins, it's a good fit. This could be in relation to an RDBMS that...

How are you adding the user? Do they have roles? I tried this in SQL 2019, and with a system versioned table, if I create user from login, I don't...

But you can pass the password as an environment variable, or you should. I can't get that working, nor do I see a pwd prompt as you see.

To me, the...

For travel in the summer months, suggest Banff, Alberta and Jasper in the Rocky Mountains. Great place to unwind, relax, do some hiking\sight seeing and see all the beautiful...

My wife and I had a great experience on a Rhine-Danube cruise from Amsterdam all the way to eastern Europe ending with land travel to Ukraine and Romania where...