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

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

Until it happens to you, one doesn't really understand these oft-repeated mantras:

• have a career rather than job

• always be learning and get official recognition for your knowledge...

DBAs are often «cost-centres» and self-directed time is often neither understood nor appreciated by those above. It can be hard when one has to account for one's time in 15-minute...

Hotmail, MSN and Windows Live.

Hi Oliii

We are running two instances joined by replication at the moment. I have been told that I will be getting 3 blades for the cluster. One node must be...

I reckon that you'd have to read the terms & conditions for standard edition completely and I suspect that it won't be allowed.

However, have you considered several 2-node active/passive clusters...

@Syed Jahanzaib Bin hassan: I understand the logic of services being started on the chosen node on failover. I'm not clear about the definition of the shared disks. They must...