I have a problem where I intend the following on a Transactional Replication with a Push subscription;

1 - 10 rows were inserted into Table 1 on Publisher. I want...

Without knowing what you are using xp_cmdshell to do, we can't really make a recommendation.

What are some of the things that you do with xp_cmsshell??

This is correct.  The services will start when the cluster fails over.

If the monitoring is an application that is installed on each server, then this can be created as a...

Thanks! Forgot that.

Are...

What is the point of dropping an re-creating the indexes?

Well, like I said,...

How often are you reindexing where this feature provides a benefit?  We re-index so infrequently. I can't see this providing much of a benefit.

Good article though!

Well said.  This thread, as well as many others, are filled with interview horror...

Uh-oh that means I am not following one my best practices which is 'Do what Jeff' recommends'. Any additional color or reasoning on why no fact table updates and...

The answer is "it depends"  While Kimball's "rules" state do not update a fact table, sometimes you need to do things like that.

There are instances where entire fact tables were...

Knowing the version is not nearly as important as knowing where it is say SQL 2014, 2017, 2019 etc... and what service pack is applied.

Knowing that it's say 15.2.3459...

I'm thinking that you need to be more clear on the job description that you use to hire people... a LOT more clear.  For more than just the most...

Well, here is a new one.

While reviewing design standards with a set of contract developers we pointed out that any object needs to be qualified with the schema of the...

I downloaded it a while back. It’s an extensive set of tools.

Am I using it in my production environment? Not yet.

Why?  Finding the time to perform the testing, and share...

Looking for the options whenever the primary replica is refreshed then synching the secondary replica would need to be done and which would take long time if there are...