First of all, I agree with Grant. Internet-facing machines need to be treated with a level of paranoia. They must be patched as soon as possible and only kept online...

If the developers want to introduce the likes of MongoDB, someone will have to support and maintain it. We don't know MongoDB, but I would happy to put time...

Hi Eric,
 This approach has been recommended to me by more than one person and I have to spend a couple of wet weekends trying it out. I haven't created...

DP» All these systems are put together with the best and honourable intentions.

Are they? Really?
Or could it be that an order has come down from on high...

I bought a new computer for the family recently. The likes of Cryptolocker and Windows 10 convinced me that it is not a good thing to have a device connected...

My understanding of the term 'Big Data' is data of a scale wherein the inferences from which are important, rather than the day-to-day reporting. I understand that one applies complex...

I've mentioned it many times before but I'll say it again.
Products now are released too often and often with little in them to justify the hassle and cost of...

We have a reports server which is partly for that very purpose — a restore is made every morning on the reports server after the main backup from the production...

My understanding of it is that the primary division between Windows and Linux is the ability to legally see and alter the source code. The sort of person who wants...

SQL Server running in a container in Linux is a curiosity. As a DBA, I see only limitations.

Senior management of a company decide things like whether the company is a...

One reason for the spread of the popularity is the growing awareness of SQL and the availability of the Express edition of SQL Server.

There those who would have used FileMaker...

At its fastest, that is, when the will from upper management is there, our sysadmins can have a server environment ready for us within a few hours.

Normally it takes a...

Why bother with a trigger?

Why not use OUTPUT DELETED.* INTO «audit table» as a part of your delete, update or merge statement?

create table dbo.a( a int identity not null primary...