Chennai SQL Server User Group (CSSUG) meet

 Let me start with my sincere apologies first for not blogging consistently.
Primary reason is, my wife gave birth to our...

Protect Against SQL Injection Using Triggers

Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes...

SQL Server Quickie #2 – Extents

Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how...

SQL Server Quickie #2 - Extents

Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm
talking about Extents, and how SQL...

SQLSailor is exploring(Part6) – Understanding firewall concepts for SQLDatabase on Windows Azure

Security is one of the most discussed topics for any cloud deployment plans and no organisation would like to compromise...

Identity Insert and Table Variables – CONNECT issue

I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))

INSERT...

Who’s Responsible

This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I...

SQL Saturday US Map

Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...

SQLSailor is exploring(Part5) – SQLDatabase Dashboard on Windows Azure

Well, that is one impressive dashboard of Audi RS4! It gives huge amount of flexibility for the driver to control...

When Things That Are Supposed to Protect You Try to Kill You

This past week I was presented with a very unique issue.  A call came in with a production issue on...