Thanks for that, I was just about to post back to say, nailed it, its the Always on.

SSMS was showing the db as synchronised but whilst the secondary was sent...

Hi Sun,

This should do it for you.

--Change to the right db

USE [DBNAME]

GO

--Create a new role

CREATE ROLE [UnMasker] AUTHORIZATION [dbo]

GO

--Add a new user to the role

ALTER ROLE [UnMasker] ADD MEMBER [USEER]

GO

--Grant...

Hi,

So after some discussion it turns out that our documents are on average going to be about 5-10MB in size each, the Microsoft guidance is on File Stream is "Objects...

Thank you for the responses.

To pick up on Jeff's point, I agree usage is going to be key and I have a meeting with the project team to establish the...

Thanks for the response, its appreciated.

Always encrypted sounds interest, guess I've got some reading up and testing to do.

Thanks again.

Nic

Hi,

I dont know anything about appdynamics sorry so I couldn't comment on the best way to do it.

Why do you want appdynamics to do it? I'm curious.

I'm not sure how...

Hi,

Are these jobs all on the server?

All you need to do is;

1. Set up DB Mail on the SQL Server - so SQL can send you a mail
2. Create an...

Hi,

Yes don't worry the cursor is going, top of my list for this process that I've just inherited, sadly the TVP for the procedure wont work as its a 3rd...

Hi,

Perfect timing, I've just started to do some research into containers, kind of focussed on Docker to start with. Question though as a DBA with over 15 years experience of...

Hi,

So I came across this

https://docs.microsoft.com/en-gb/power-bi/report-server/get-started

So as I understand it, PowerBI Report server is different to SSRS. This makes things clearer.

Thanks to those who read this.

Nic

Hi,

Thank for you confirming that, I did indeed search but wanted to clarify and see if anyone had a workaround.

Sorry for troubling you.

Have a good day.

Thanks,

Nic

"He claims the new Nimble SAN can take VSS snapshots every 1/2 hour and be much easier to recover, even to point-in-time. ".

If he is willing to give you a...

Hi,

I can only speak for experience but I've seen it happen where the backup software/service freezes the IO mid transaction, its a case of bad time but if you try...

Hi,

Nice article, we actually do have SA and in 90% of our servers are on 2016 and we are rolling out 2017 in the coming weeks, as soon as 2019...

• This reply was modified 5 years, 7 months ago by  NicHopper.

Hi,

Thanks for the reply and when that is done (the trusting) will what I did work? Or do I need to do something else?

Thanks,

Nic