To understand the purpose of TEMPDB, why it can occasionally increase dramatically in size, it help to know what objects are allocated in TEMPDB during peak periods of growth. For...

The ubiquitous presence of devices is a blessing in many ways, but one consequence is that we generally spend less time deep thinking. I mean, twenty years ago those occasions...

I second the motion to use UPDATE with OUTPUT clause and thus avoid multiple statements and explicit batch transaction.

Using EXCEPT to isolate those handful of rows that are different, copy the results from both tables into WinMerge to do side by side flat text comparison.

I can see the potential for IoT devices in nature conservation and border enforcement. For example, IoT devices placed in remote woodland areas can leverage sound recognition technology to detect...

A hotel reservation system is certainly an application where you want to have each user accessing a central database. If it's important to have an operational fail-over mode, just in...

Our continuous integration process uses TeamCity / Octopus and our deployments run under the context of a domain based service account. I don't recall the password being persisted anywhere in...