I am pretty sure that SQL Configuration Manager aliases just put aliases on the server or on one individual workstation, not on all the client machines (don't quote me on...

One thing about the CPU - a lot of SQL Server operations are single-threaded, so having a lot of cores may not benefit you.  There are exceptions (as queries can...

hahaha... no, that isn't what I meant Grant... I am going to edit that to be 99% agree with that.

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 4 years, 4 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...