SQL Server Operations and Management

All about operating and management SQL Server assets

SQL Server Operations and Management

  • The SQL Azure MP and Monitoring with Less Privileges

    Our guest columnist for today, Walter Myers III, presents an approach to using lower privileged accounts to monitor the health of SQL Azure database using the SQL Azure Management Pack. By using less privileged accounts for monitoring it increases the...
  • Where have all the databases gone, Part 2.

    So you've tried all the steps in http://blogs.technet.com/b/sqlserveroperations/archive/2012/02/21/where-have-all-the-databases-gone.aspx and still you can't find your SQL Azure databases. In fact, maybe even you can't get the "Set Monitoring and Discovery...
  • Where have all the databases gone?

    So, you excitedly grab the SQL Azure Management Pack CTP2 (see http://blogs.technet.com/b/sqlserveroperations/archive/2012/02/17/sql-azure-management-pack-is-now-available-as-a-public-ctp.aspx ), and run the Add Monitoring Wizard. While you can see the...
  • SQL Azure Management Pack is Now Available as a Public CTP!

    The first exciting news I have in the operations and manageability space is that there is now a management pack for monitoring SQL Azure based databases available as a public customer technology preview (CTP)! You can find the bits on the download center...
  • A brand new blog

    Welcome to the SQL Server Operations and Management blog! Here you and I get to discuss the best ways to operate and manage server and database assets as they relate to Microsoft SQL Server and related technologies. I'll be letting you in on exciting...