Thanks guys.   I'll check out mirroring as I have enterprise.

how about having a check to say   "Is the subscriber database the same as the publishing database"

I might be able...

hey,

hold on - wasn't this why hierarchyID types were invented ?

you can even use persisted computed columns to make it nice and fast.

you would need a 1 time hit on...

SSRS is fairly solid for this

you can subscribe to reports (and get them emailed to you) and keep historic versions on the server... plus you can export in excel, pdf...

most likely you have a few  solutions here

1. lock down the permissions on the subscriber database so that only the distribution agent can write, but everyone else has read permissions

...

Any slowdown would be on your T-Log drive (the commands are read from t-log and pushed to the distributor database) - if replication fails, then you might get some issues...

Rod,

perhaps I can help - I have about 30 or more azure devops repositories that we use. but I've never hit a warning about publishing email addresses. can you give...

I run transactional replication all day every day (to get around linked server performance issues)

performance won't be an issue, but as soon as your subscriber (target) has data deleted, modified...

back to KTFlash's comment about "everything already documented"

I was listening to a stereophonics song the other night and the song was called "a thousand trees"

The more I listened, the more...

I think what put me off XE was the initial documentation and the user interface for the results (creating an XE trace is almost the same as profiler) but viewing...

I did also say extended events 🙂

but look how useful profiler is !!!!!! 15 seconds of capture while my user re-creates...

But interestingly, as I get older, my personal goals have changed. Salary is not a measure of success. I'm more happy when I get 2000 reads on an...

Hmmmmm….. looks like that is the correct fix as i'm getting the following error on my commands

Cannot query table xxx.dbo.historic_xxxx' because this operation is currently disabled for this object.

if I...

I worked for a company who "pimped out" test engineers and DBA people... to sell our "man hours" to clients we were encouraged to build a personal brand. this really...

I'm not aware of any CE issues moving between versions greater than 2014. The optimization engine has changed at each version, and that could, in some edge cases, cause...

I get T-rex poo and SQL profiler (I know Grant is going to bite on this one - i'll put money on the next words out of his mouth are...