New sample db: https://github.com/Microsoft/sql-server-samples/blob/jodebrui/samples/databases/wide-world-importers/documentation/root.md

Merge and peer replication do not have people writing to the same database. There isn't consistency, nor is there guarantees the writes will remain. In both those systems, you write...

I wouldn't necessarily throw an error, but you certainly could. I would tend to have an output or return param to indicate something.

I know RAISERROR is deprecated, but I doubt...

As mentioned, I wouldn't recommend this technique. It looks like you're trying to write one routine to get counts from any database. Or are you looking for any table? You...

This command exposes the API for freezing IO. Snap software for SANs uses this to stop IO and get a disk mark where they can start copying data. In talking...

manie (5/31/2016)

---

Please allow me to make one thing clear. My post was not to rant about the unfairness of the job market although I believe it might have sounded like...

Hope everyone had a good holiday weekend (those that had them). I had 3 days in Steamboat Springs, hiking and being mostly unwired. Then back to chores the last couple...

Agent jobs are per instance. Meaning that if you fail over, then you need to enable the jobs on the new instance and disable them on the old instance. This...

Terje Hermanseter (5/26/2016)

---

I'm not sure I fully understand the "choose the...

Would like to, and see you...

Ray K (5/26/2016)

---

Hey Threadizens . . .

The other day (inspired by a couple of SQL Saturday speakers), I started my own blog.

My most recent entry tackles the very-often-asked-here-on-SSC question, "how...

Take it, and thanks, David.

Mmm, tequila. Heading to Steamboat Springs tonight for the weekend. Half gallon packed

Ah, snaps are different. That's not a backup (usually), but a copy of the disk at a point in time. It should use the freeze to mark a stamp (somehow)...

Me, either. It was a surprise to read about it and try it.