by the way - all of it is on site. no data centre, we have our own greenlake/nimble san and a new beefy server for consolidating licences and removing linked...

the sync pair are within 2 meters of each other, the asycn is 400 meters away

(we have plenty of other DR policies in place - don't worry) - but the...

One thing I would add, I was really tempted to drop databases after the restore. but the number of times a developer needed to get some data back...

Even better... does anyone know a company that coaches in HA technology (UK based) ?

One thing I would add, I was really tempted to drop databases after the restore. but the number of times a developer needed to get some data back because they...

welcome to Nottinghamshire, linney are 16 miles north of the city centre

there is a great SQL meetup event (a few lectures and pizza)  soon near the train station

and SQL Data...

you'll love it there, Redgate has been listed as one of the top 100 employers in IT (as far as news articles go), but I think Linney's offices are nicer...

I'm on the same journey - we (meaning me) do restores from the latest backup once per month, split up throughout the month

we don't do DBCC checkdb on...

get rid of the sql agent jobs

they don't always disappear as you might expect

also - when you recreate everything your distributor is going to need passwords, get these in a...

• This reply was modified 6 years, 2 months ago by MVDBA (Mike Vessey).

I'm looking for some feedback from the community. I finally got permission to setup a server to do test restores. Yes, I know, you don't have backups until you...

I've just done a quick scout on the issue (I never use update in join, so it's a nice refresher)

Microsoft SQL Server does not permit updating fields in multiple database...

Updating a view isn't updating a join. In fact, I'm not sure how you update a join because you can't. Updating a view is using the fact that a...

no idea

the wording on the Microsoft website it ambiguous, I haven't checked your version number, but who doesn't win for a service pack?

I'm guessing that your company is using web...

question,  why update the view? - in the last example you only touch one table - keep it simple don't use unnecessary joins... even better - forget the view and...

web edition doesn't support it

QL Server 2016 (13.x) SP1 (or later), any edition. For SQL Server 2014 (12.x) and SQL Server 2016 (13.x) RTM (pre-SP1) you need Enterprise, Developer, or...