Category Archives: SQL Server DBA

New features added in SQL Server 2012

Posted on August 3, 2011 by uday arumilli

New features added in SQL Server 2012 Time to Denali – SQL 2012 Now Code name Denali is ready with CTP3. Now here are the list of new features added in sql server 2012. Operating System Support & Prerequisites ü … Continue reading →

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 2 Comments

Truncate Table with Foreign Key constraint

Posted on June 28, 2011 by uday arumilli

Truncate Table with Foreign Key constraint This post helps you in automating the process of Truncate Table with Foreign Key constraint”. We recently working for a client on data migration project. There was a requirement for truncating tables. But we … Continue reading →

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , | 1 Comment

How to rebuild Master Database in SQL Server

Posted on May 16, 2011 by uday arumilli

How to rebuild Master Database in SQL Server We recently resolved a request from a client that he is not able to access a SQL machine. We have logged into the sql box and we cam to know that the … Continue reading →

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , | Leave a comment