Initialize a Transactional Replication from a Database Backup

During the last days I'm working on Replication – especially with Transactional Replication.
The main idea of Transactional Replication is that you...

SQL Server 2008 Diagnostic Information Queries (August 2012)

Here is the August 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...

SQL Server : List Login's Database and Server Level Role Permission

In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...

Getting to the next level in your SQL Server career

Jen McCown (Blog | Twitter) wrote about an interesting topic on the different levels of database professionals. In her article, Jen...

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