I found execs moving from secretaries to doing their own email strange. At first, I think it is empowering and is efficient, but often this devolves into a low level...

Mark,

The old website is gone. No data or code. However, I have the XML files used for guidebook and have reconstructed quite a bit of the site. I am looking...

Congrats, Brian. Hope it goes well

When I was first in the workforce, a few of us reconfigured 3-4 cubes into one space, which we liked. Later, I shared a private office with someone and enjoyed...

No benefit here I can see. I was experimenting, as I've had MS people ask me to use ADS for PoSh. I was curious how it worked, since I use...

I agree, and I am pushing as a member of the Microsoft Data Community Advisory Board (https://www.sqlservercentral.com/forums/topic/is-there-room-for-independent-sql-or-data-integration-based-user-groups/page/2/#post-3858112), to build a more comprehensive directory. Not just of groups MS supports,...

Actually, you can just use the counter. Don't need the object, but certainly the explanation can usually be improved.

Love to see you or others submit something if you think of...

I am always looking to say "I don't know" in an interview, but then explain how I'd learn. I can do to the docs, or use Google to search these...

Not sure what your question is. The ref is a general link for the DMV. The link from there to SQL Server objects describes each counter. This would be the...

I'm not quite sure. Do you mean

a) using sys.dm_os_performance_counters to check deprecated features with a counter has the counter deprecated?

b) I have a function that calls sp_addserver, and that proc...

You can use ReadHost, like this:

$First = Read-Host -Prompt 'Input the TP lookup'

For the rest of the question, you really need to provide some text input or...

Likely you have a connection error, which might be due to a connection setting change from Power BI. I assume you are able to connect from SSMS.

From Power BI, is...

To add to what DesNorton noted, local variables only exist in a certain scope of this batch. Moving to some other batch, even inside a stored procedure, puts local variables...

The SQL Server setup program from the installation media.

These aren't databases. They are instances. A SQL Server install is an instance, and it can contain multiple databases. If these instances are not being used, and not ever started,...