Ola Hallengren released a new version of SQL Server Maintenance Solution:

The new version has support for backup to Azure Blob Storage.

Here is how it works:

EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’,

@URL = ‘https://myaccount.blob.core.windows.net/mycontainer’,

@Credential = ‘MyCredential’,

@BackupType = ‘FULL’,

@Compress = ‘Y’

and with encryption:

EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’,

@URL = ‘https://myaccount.blob.core.windows.net/mycontainer’,

@Credential = ‘MyCredential’,

@BackupType = ‘FULL’,

@Compress = ‘Y’,

@Encrypt = ‘Y’,

@EncryptionAlgorithm = ‘AES_256’,

@ServerCertificate = ‘MyCertificate’,

@Verify = ‘Y’

Backup to Azure Blob Storage is available in SQL Server 2012 (SP1 CU2 and later) and SQL Server 2014.

The new version also has some minor bug fixes and improvements.

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server.

Are these the only options in life?

Are these the only options in life?

imageBetter late than never. Having discovered this wonderful resource on the Web, let me share it with you: Learn Version Control with Git is brought to us by the makers of Tower, a Git client for Mac.
This tutorial is available as an eBook or as a Webinar. It already has announced a series of videos, soon to become available.
If you’re a basic Git user or have no experience, this is a must read/watch.

Site: http://www.git-tower.com/learn/

I present this with no comment… NO COMMENT!

dbareactions:

When I let the developers use the SA login for their web app

HAHAHAHAHA!

dbareactions:

When I let the developers use the SA login for their web app

HAHAHAHAHA!

Finally: Non-interactive login support for Microsoft Organizational account with Add-AzureAccount -Credential.

For achieving daily full script automation, the login pop-up window every 24h wasn’t very nice.

I’ll be reviewing some of my stuff on github after reading this.