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...

A senior developer who recently left our company expressed the opinion to me that the DBAs should be in charge of the Data Access Layer.

He was very definite that we...

The horrifying thought is that Microsoft will start to include the coffee-factor into their licensing calculations. Enterprise Edition users are allowed unlimited cups of coffee and a better quality brew...

I had never thought so much that hardware was expensive, rather more that software licences and people were expensive. Microsoft play an expensive game.

In my experience, coding well is not...

I have two points, one is the argument of new versus old: if a technology works fine, what criteria must the new technology have in order for it to supercede...

A part of the problem is perception — in some companies and with some people, your status is measured by the number of meetings you have. One is obviously (ahem)...

I have a 45-minutes commute by bicycle from a town through the countryside into the industrial outer reaches of a small city.

I think about many things.

Sometimes I dream and think...