Category Archives: SQL Server DBA

Static and Dynamic port in sql server

Posted on February 5, 2010 by uday arumilli

Static and Dynamic port in sql server STATIC PORT ALLOCATION If you configure an instance of SQL Server to use a static port, and you restart the instance of SQL Server, the instance of SQL Server listens only on the … Continue reading →

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

Migrate Log shipping from SQL 2005 to 2008

Posted on January 15, 2010 by uday arumilli

Migrate Log shipping from SQL 2005 to 2008 This post helps us to Migrate Log shipping from SQL 2005 to 2008. LET’S upgrade the Log shipping from SQL SERVER 2005 TO SQL SERVER 2008 We have 3 different cases as follows: … Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , | Leave a comment

Dynamic Management Views in Sql Server

Posted on January 1, 2010 by uday arumilli

Dynamic Management Views in Sql Server Introduction: The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what’s going on inside SQL Server. They can provide information on what’s currently happening inside the … Continue reading →

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