Try it with quotes around the table name.

1. Interesting question because it's really easy to get sloppy about these. I'm sure I do all the time. Here's Microsoft's tutorial on writing T-SQL Statements. Pretty sure there...

The host name is dependent on the connection string. If people leave this off, it's why you can't audit for it. You can use HOST_NAME to get this information...

Most people read more than one of the topics (or, like I do, look at which topics are new), so posting a question multiple times just leads to different answers...

Honestly, this is work I would put on to the front-end. There are ways to do translations. Otherwise, you're going to have to do pretty horrible stuff to your T-SQL...

Sounds great. Let me know when that gets implemented. I'm in.

If you are only storing the XML and not querying it or manipulating it in SQL Server, then I suggest you should use VARBINARY(MAX) rather than the...

BWA-HA-HA!!!

Exactly.

I sure wasn't trying to correct your answer, just add to it.

It's the choice of a compromise.

Most people are suffering from what they're currently doing. Further, even completely independent sources like the ISE recommend using a password manager. Everything online...

Yes. That's the one. You're mixing data types such that you have to do CONVERT in some cases and SQL Server is covering for you in others using CONVERT_IMPLICIT. These...

Query hints should absolutely be the exception, not the rule. So, I'm always inclined to remove them. However, using Chesterton's Fence as a model, we need to ask, why is...

Yeah, I see where the paranoia comes from. However, I can also see how the NSA would prefer a more secure Windows OS.

A & B) Sounds like someone isn't making well formed XML. This is a coding issue within nHibernate and no, it's not native, immutable, behavior. They're configured wrong and/or...

You can install both. Connections will be completely dependent on the defined connection string. If you define the ODBC driver, that's what will get used. If you define the...

With the noted exception of columnstore indexes, but only when working in 2016 SP1 or greater.