+1 to what Brian wrote. Analyze a number of things to try and find the bottlenecks. Bad code can cause the CPU to rise, which may not be a problem...

Patching: https://www.brentozar.com/archive/2015/02/patching-sql-server-availability-groups/

For DBCC, if the primary fails, the DBCC work is lost. This is an internal snapshot of the db. Losing this doesn't hurt, but the DBSS work is...

DCAC is  Denny Cherry and Associates, the consulting company.

There is no "PASS" anymore. I'm going to get an independent SQL Sat org, community run, up and running. The Summit will...

I think this is something to start a discussion thread in that forum about. I am looking to put up some "free"-ish hosting of things. I have a SQL Sat...

My pleasure.

FWIW:

https://popbi.wordpress.com/2012/05/02/fuzzy-match-your-data-without-enterprise-edition/

https://pawlowski.cz/2010/12/28/sql_server-fuzzy-strings-matching-using-levenshtein-algorithm-t-sql-vs-clr/

https://www.sqlservercentral.com/articles/roll-your-own-fuzzy-match-grouping-jaro-winkler-t-sql

https://stackoverflow.com/questions/2328357/are-there-any-alternatives-to-the-ssis-fuzzy-lookup-for-plain-net-code

If you find one of these to be helpful in your work, I'd love to work with you on an article to help others.

If you  don't see the named instance listed, that is strange. Can you post what you see in config manager?

Typically the default instance listens on 1433. Named instances get a...

It doesn't quite appear you've asked a question, and this isn't well formatted to understand what you want. Please format code as code, and explain what results or logic you...

Do you mean in SSIS? Or in Full-Text or something else?

If SSIS, doesn't appear to be: https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver15

The the KB page (https://support.microsoft.com/en-us/topic/kb5000685-cumulative-update-23-for-sql-server-2017-22b653c7-8487-4564-9db2-b5c1bd465145) for the latest, scroll down. There is an uninstall section.

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