In the last post we discussed about the features of SQL Server Managed Backup to Windows Azure, how it is different from conventional backup schedules, how the backup and container gets named and based on what conditions SQL Server will initiate a Full\Transactional Log backup or skip it. What are the benefits of using [Read More]
SQL Server Managed backup is a new feature introduced in SQL Server 2014, this feature is simply outstanding – you don’t have to worry about the backup strategy anymore, this feature manages and automates the backup process. This feature uses sort of artificial intelligence – if you see at current scheduling features they just keep [Read More]
In last part we discussed the installation, configuration and usage of the SQL Server Backup to windows azure tool.
In this part we’ll discuss some internals of this tool and how to restore the backups which were moved to Azure storage.
As you know there are so many cool benefits of using Windows Azure Storage Account, everybody want to use it to get advantage. Last month i blogged about “SQL DB Backup to URL\Cloud” feature which was first introduced in SQL Server 2012 and later in SQL 2014 it was integrated completely in every aspect.
But what if you are still running old version of SQL Server and want to take advantage of Cloud?
Backup to URL is not new to SQL 2014, it was first introduced in SQL Server 2012 CU2, but you were allowed to use the URL in query only. Starting with SQL Server 2014 this feature has been totally integrated, now you can specify URL while taking Backup or doing Restore no matter if you are performing the task via Query, Backup\Restore GUI, Powershell cmdlets or using SMO.
Few months ago I started a series where I explained all about Execution Context & Context switching, you can use Execution context switching for many reasons but if you are auditing execution context can leave all your auditing meaningless. You’ve to plan in advance for such Execution context switching and the below mentioned Function can [Read More]
Migrating SQL Server jobs from one server to another is a critical task and there are many alternatives available for the same, the easiest one available is to script out each and every job and re-create them on the destination server. If there are a few jobs you can very well script out each and [Read More]
Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. There are many documented and undocumented trace flags. For example Trace Flag 1222 that can be used to get Deadlock Graph. In Trace Flag 1222 you get a detailed information about all the processes running and participating in [Read More]