Microsoft SQL Server on Windows Azure Virtual Machines

The writers of this blog are a part of the Microsoft SQL Server team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server components on Windows Azure Virtual machines

Browse by Tags

Tagged Content List
  • Blog Post: Index rebuild on large database - SQL Agent Powershell job

    Index rebuild on a large database could take longer time. One of our customer was looking for a solution to rebuild index one by one when index fragmentation is greater than 30%. Related newsgroup thread: http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/thread/4faae7c8-3e58-4117-8538...
  • Blog Post: Automatic backups, one per day, and with different backup file names

    SQL Agent can be used to perform scheduled backup job to backup a database to a unique file name that is constructed based on the system date. To construct a unique file name, you can use SQL Agent’s token substitution mechanism. You can read more about token substitution at http://msdn.microsoft...
  • Blog Post: Sql Agent Quick Tip- Deleting History

    This is the first in several posts that will discuss quick tips and tricks for managing Sql Agent history. Today, I'm going to discuss one of the history management options which will let you delete history. There is an easy way to do this, but it has some limitations to be aware of, which I will point...
Page 1 of 1 (3 items)