Hi both,

Firstly, thanks for taking the time to reply.

It's definitely not every time and seems very sporadic as to when it does happen. I've checked via the recorded playback...

An excellent and well thought out article, especially relevant now that Microsoft have changed the Enterprise licensing model to make the use of AGs that much more costly and difficult...

Hi WendellB,

Know this was yesterday, but as a thought have you checked through all of the config tool settings around the protocols and the ports? I recall having a...

Thank you Gila, that's exactly what I was needing to do.

SQL Code included below in case anyone else every stumbles on this and would like an example! ...

Ooo snap on the link 🙂

Thanks both.

I'm not one for just blindly making indexes based on the recommendations of the system as I much prefer to build them based on what I think...

Thank you very much for your help, that syntax was exactly what I needed!

Kind regards

I do have this old script kicking around that I used for scripting Indexes and Constraints that may be of use alongside Flo's excellent post. It was only a...

I've not personally used it, but I have heard good rumblings about the SQL Doc tool that you get from Red-Gate.

http://www.red-gate.com/products/SQL_Doc/index.htm

It is a tough one as you have to manage security vs practicality. You need your systems secure, but you cannot make it so secure as you cannot function...

We have a couple of apparent MCDBAs working within our MI team and I am constantly astounded by the lack of understanding they have with the systems they use. ...

My wife will have been away twice this year without me as I cannot get the length of time off from my new job and any odd days I do...