SqlServer Begin's

Using xp_serviceControl , Parameter1 excepts the following           Start           Stop           Pause           Continue           Querystats   Parameter 2 can be any service name           print 'checking MSSQL service'      exec master .. xp_servicecontrol 'QueryState' , 'MSSQL'      print 'checking SQLAgent service'      exec master .. xp_servicecontrol 'QueryState' , 'SQLAgent'      print 'checking MSFTESQL service'      exec master .. xp_servicecontrol 'QueryState' , 'MSFTESQL'      print 'checking   msdtc service'      exec xp_servicecontrol N'querystate' , N'msdtc'      print 'checking Sql Browser service'      exec xp_servicecontrol N'querystate' , N'sqlBrowser' This function can be easily used to start ,stop ,pause and check the status of   different services in Sql Server. Enjoy

Tips and tricks for a dev DBA                 The dev DBA role has become a very critical role in organizations that the success of the role speaks much tons for its self.  Depending on company(product area) you work, the priority of the responsibility  may change  but the core responsibilities will not have significant diversification.                   I have been a dev DBA for approximately for four year and over the years I have collected a few tips and tricks that I think have assisted me to progress well in this capacity. What can we do as DBA’s to turn things a round                 o     Don’t be a blocking issue                                 This is the most important aspects of been a dev DBA. If you don’t find a win win situation you will be considered a blocking issue and this does not go well with the product owners. I have been personally held responsible for attempting to chock a release because of suggesting significant changes late in the release cycle.