Great article,

I've had to use READ UNCOMMITTED to fix so many locking and blocking issues (it's not a fix all and should be used only by experienced adults under supervision)

It's...

I'll give it a go... It's still new to me, but I love learning.

ive only just finished my last article and I'm at SQL in the summit being...

I'll give it a go... It's still new to me, but I love learning.

ive only just finished my last article and I'm at SQL in the summit being interviewed by...

this is where mirroring with a witness used to be a great tool....I don't really know AG that much, but i'm guessing there is some DNS trickery  that you could...

ha - corporate policy, i'm not allowed to plug in any usb device unless it's encrypted or approved and purchased by the network team... even my USB stick containing keys...

Thank you very much for your much appreciated answers!

I've read the article and feel I understand parameterizing better now. I'm going to  experiment with the examples and try a...

just out of interest.... does anyone miss having a dvd drive in their laptop?

I'm travelling now, and I have a Netflix subscription, but no signal - I used to take...

see this resource

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

looks like it might be that the web control is trying to protect against HTML injection and forcing you to double escape the backslash

it's fairly common

very similar to the concept...

run a dbcc opentran() command against your source database - this might point you in the right direction

if you have one uncommitted transaction in that database then anything that uses...

I think you misunderstood me

if you go...

Not on my server

never has on any server i've ever had

not used that one before.. Does it include the instance name?... That's the kicker.

@@servername is normally the way to go, but it depends on how you refresh your environment

I worked with a company who cloned all of their EPOS systems in 400 stores,...

damnit... I use these almost every day and I still got it wrong (I don't cheat and run the code)

we use persisted computed columns in so many areas - one...