What collation variables take on in T-SQL

I was asked an interesting question about collations in sql server recently about where variables in a script got their collation's from. I really wasn't too sure of the...

Off to London

Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3...

Wishing You a Very Happy Diwali

Wishing You a Very Happy Diwali…………….
KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA
CHAMAK HAAN DIL MAIN, UMEEDO KI...

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures....

DBAs - Step away from production

I have worked as a DBA and also as a Sql Server developer and in many roles had full access...

DBAs - Step away from production

I have worked as a DBA and also as a Sql Server developer and in many roles had full access...

DBAs - Step away from production

I have worked as a DBA and also as a Sql Server developer and in many roles had full access...

DBAs - Step away from production

I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what...

SQL Server Upgrade Preconference at PASS Summit 2014

Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd

If you are planning an...

Have You Contributed to “Argenis Without Borders”?

So, I’m a little behind the ball on all of this.  And others have already blogged about it:
Donate to Doctors...