Category Archives: sql server

What if you encounter Error number: 20598 with SQL Server replication ?

Posted on May 31, 2012 by rpillai

Today on one of the sql server I encountered an interesting scenario, one of the dbas accidentally deleted data from subscriber and then when he realized he turned around and delete the data from publisher. Crap ! is the diplomatic term … Continue reading →

Posted in database, sql server | Tagged , , , , , , , | Leave a comment

SQL Server 2012 Licensing model

Posted on April 1, 2012 by rpillai

With SQL Server 2012, Microsoft has changed its licensing model along with “consolidating” the different types of editions. Gone is the workgroup edition. The three mainstream editions Microsoft now offers  are Enterprise, Business Intelligence and Standard . The Web Edition … Continue reading →

Posted in database, how to, sql server | Tagged , , , , , , , , | Leave a comment

Denali is on its way !

Posted on February 25, 2012 by rpillai

Microsoft is coming out with a new version of SQL Server , codenamed ‘Denali’ a.k.a SQL Server 2012.  It boasts lot of new features.  I am not going to repeat all of them here now. Go to Microsoft to see all the … Continue reading →

Posted in database, sql server | Tagged , , , , , | Leave a comment

Stored Proc for SQL Server and DB2 UDB

Posted on December 22, 2011 by rpillai

We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a quick stored procedure that will take couple of input parameter and run the grant against the tables.  Just for the … Continue reading →

Posted in database, db2, sql server | Tagged , , , , , , , , , | Leave a comment