I don't think you need to grant someone control. The issue is that both the nodes (or all the nodes) need to be able to open the DMK. Usually the...

Glad you like them. Since so many people use them, thought it would be good to get a little series on different aspects.

I have no idea whether most people read books or articles on phones, but I would guess articles as well. However, the Kindle created a whole ecosystem of people that...

If that's true, then how could they lose more than a day or two of data? Offline shouldn't be accessible remotely. A human would have to kill tapes.

The table has to do with licensing. If you have a factor of 2, then you need two licenses for that processor. This was added as processors grew and changed...

Fixed Agent Roles - https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-2017

Wow, crazy. They might not use offsite. Lots of companies have moved away from that. I think most assume that user errors are discovered quickly or failures wouldn't go back...

June, or end of May. I'll be at SQL Sats
- Brisbane
- Christchurch
- Melbourne

I like the "try to make it righter" approach. It's what we tend to do at Redgate. We try to build good code. We work quickly, but we constantly try...

I completely agree. While a hardware disaster might merely need 2-3 full backups, a subtle bug or malicious attack across a short time might need some from weeks ago. I...

This is almost always data related. You need to look at the .csv in a text editor like notepad++ that allows you to see characters that might not be visible....

The mobile phone usage, or overusage, is interesting in ways. On one hand, that access to information is amazing. On the other, this does mean we sometimes create new critical...

I wouldn't install office as this increases surface attack area and creates the need for patching here. Install Office on any other machine and let that machine do the work...

I'd say that perfection from the users' perspective is something different. I was writing more in terms of what we'd consider too software engineering or strong, robust architecture or development...