If the database fits in memory and the load is adequate, where locks and page splitting is not an issue, then GUIDs is not necessarily a practical problem, just a...

Using the wrong technical terms ie A "technical" architect who interchanges the term mirroring and replication because they generally do the same thing.

It is *the* one reason why I wouldn't go to the USA. Like Gary pointed out the UK has 8 days bank holiday, typical 25 days paid leave, various companies...

Where?? pass

But the simpler question as 'As what?' then the answer becomes: a jaded cynic, with all the optimism of IT getting better buried by the ever increasing list of...

djackson 22568 (2/17/2015).............

Also, I doubt most breaches are reported. At a conference I attended on security, about 1% of the people in the room thought it necessary to contact...

Over the years I have tried to lock the databases/servers down. Results have been mixed and the path difficult. Comments thrown at me: "Not your responsibility", "Not our responsibility for...

First time I heard some say this in an argument I had to leave...

It is easy to be simplistic and create simplistic solutions .

It is harder to create a simple solution.

The worst case was a 1600+ line script (including very cryptic comments) that...

Yep, spend time learning. Then its trying to apply it to the real world.

If the management are too stuck in the ways then all the new improved stuff will...

Actually it depends:-P

Nice example of your ANSI settings affecting the results:

If you define your table as:

CREATE TABLE mytable ( myid INT null, mychar VARCHAR(10) );

Or

set ansi_defaults ON

CREATE TABLE mytable...

One of our clients (not hosted, but we look after their environment for their LOB) uses NAS replication to copy the backups to our site for "off site" backups. Blissfully...

I was told that any idiot could install clustering by using google and this was 5 minutes before someone unplugged network cable to the san and corrupted all the luns.

TDE...

Fully auditing the data changes to the end of the cooling off period is one of the more robust ways of fixing the data. Also it can give you the...

Some companies are ok with a DBA doing a few tests keeping scripts having a rollback plan, and even plan a release.

Others seem to have the view that: its a...

A good manager filters out the unwanted distractions going both ways through the food chain.

I may have a great idea but the Director shouldn't be distracted if the manager is...