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

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

Consolidating Email Accounts

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...

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

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

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

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish...

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not...