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

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