To me this sounds pretty easy to do and I expect there are multiple solutions, but my approach would be to break it up into multiple steps for the sake...

I 99% agree with Grant (that is not one ugly dude).  In-person events get you so much more interaction and discussion than virtual.  Both from the presenter side and from...

• This reply was modified 3 years, 10 months ago by Mr. Brian Gale.

My opinion - this is the wrong site for that.  This is a SQL Server forum, not an SEO forum.

My best guess though as to why some newly published blog...

Your story sounds a lot like mine, except I don't lead a team... I'm just a member of a team of 3 DBA's who do non-DBA things (like development work)...

Getting sp_executesql to work is pretty easy.

DECLARE @sql NVARCHAR(MAX)
SELECT @sql = '<insert dynamic SQL here>'
EXEC sp_executesql @sql

The only thing that makes your query a bit more tricky...

Quick google of this brought me to this link:

https://stackoverflow.com/questions/13245364/ms-sql-server-pivot-table-with-subquery-in-column-clause

Which basically says you cannot do it because SQL is expecting a static number of columns to be returned, but a semi-dynamic...

I agree with Grant's first statement - that is asking for trouble and can be a scary practice... and if you read his signature, he is The Scary DBA!

Why it...

NOTE - I am not an LDAP expert, but the following is my understanding of how the authentication chain works.

I think this was answered previously and my answer was that...

My opinion - test it out.

Upgrading from 2008 R2 to 2019 MAY require upgrading your OS as well and, if I remember right, 2019 doesn't support 2008 compatibility  mode.

What I...

I wasn't sure if the Browser service was required for the default instance on port 1433 or not, but I generally start the browser service as soon as I install...

As I said multiple times - Firewall.  Just because port A is open in the firewall and you can connect to SQL instance B doesn't mean that port C is...

First, I think you would likely get better support on a MySQL forum than a SQL Server forum.

Second, my understanding of MySQL is that it keeps the temporary tables in...

I think there are multiple approaches to this, but if it was me, I would start by trying to define the problem you are trying to solve rather than starting...

Jeff - My GUESS is that it was an implicit conversion due to the division by int.  I expect that Length is a CHAR or VARCHAR datatype, but holds FLOAT...

To me it sounds like you have an Azure SQL instance, not an Azure SQL Managed Instance.

Did a quick google and found this document from Microsoft:

https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

If you scroll down a...

• This reply was modified 3 years, 10 months ago by Mr. Brian Gale.