There are several points being made here.

Firstly, the mindset of many a developer, especially those that learn by trial-and-error, is that the thing being built is never finished and errors...

I'm not a fan of the Cloud.

Ever since Edward Snowden confirmed my suspicions that the NSA and other spy agencies are trawling and capturing as much data as they possibly...

For me, the idea of a sabbatical concerns the learning of something new and returning back with a new skillset and outlook

I had more envisioned someone who had been working...

Idea for a sabbatical, if you can afford it, if you have the contacts and if you can, go work for a company someplace very different to where you are...

A lot of it depends on why the system is buggy in the first place and the relative strength of the DBA within the organisation.

It might be that the management...

My pet irk about the developers concerns indexes and stored procedures.

We have a system with about 200 SPs and it seems that the developers have followed SQL Server's suggestions for...

For me core tSQL are joins & nesting, understanding where clauses, the DML statements, the use of views and stored procedures, grouping as well as knowing how nulls work and...

Andy Hertzfeld (one of the programmers on the original Macintosh) has this story on shipping:

http://www.folklore.org/StoryView.py?story=Real_Artists_Ship.txt&characters=Andy%20Hertzfeld&detail=medium

On the one hand, I agree with the statement that 'good enough is the...

For me, the purpose of unions is to ensure that all workers are treated more or less than the same, that is, to prevent the decision-making classes (namely management) from...

Isn't certification to officially show management and your boss how much you know?

I have found that the people most impressed by certification are recruiters, HR and management in general. Certification...

Hi Steve,

Surely there are lots of topics for April Fool's for SQL Server. How good it is depends on how well it is written.

Just think of all the things that...

Source: http://www.dictionary.com

Cardinality: (of a set) the cardinal number indicating the number of elements in the set.

[http://dictionary.reference.com/browse/cardinality]

Schema: 1. • a diagram, plan, or scheme.

...

Hi Gail,

Many thanks for the prompt reply. I am surprised (and happy) to learn it and I look forward to trying it out on an Express-Instance.

Sean.

I find this very surprising, that one can restore a DB created on an Enterprise server onto a Standard server, even if both are at the exact same version and...

I have a couple of thoughts about DBAs and security.

1. Security is a theme that permeates a company at all levels. In our company, the application of patches, service packs...