One of the new features of SQL Server 2014 that have been introduced allow users to create mdf and ldf files in the Azure BLOB Storage containers and […]
Exception Message: The client could not finish the operation within specified timeout. Killing the lease on a file in Azure BLOB
Exception Message: The client could not finish the operation within specified timeout. When backing up a database to the cloud if the network connectivity is slow or if […]
Installing SQL 2014
Installing SQL 2014, if you have ever installed SQL you shouldn’t find anything surprising here.
Part 2 Buffer pool extension SQL 2014
In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it […]
Part 1 Buffer pool extension SQL 2014
In this series I am going to cover the feature Buffer pool extension in MS SQL Server. Now before we can discuss this feature it might be a […]
Indexes – F1 Crash Course
There are a million articles, blogs post etc. about indexes out there, I am guilty too of contributing to it. Here is my attempt at correcting the vast […]
Single Partition online rebuild in SQL 2014
If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful […]
Restoring the database using TSQL command and backup stored in URL
In this post we cover the T-SQL command used to restore the database from the backup URL RESTORE DATABASE madworks FROM URL = ‘https://ebsclouddbstore.blob.core…….madworks_backup.bak’ WITH CREDENTIAL = ‘Azureblobbackups’ […]
A Nonrecoverable I/O error occurred – when restoring the database from a Cloud URL in SQL 2014
When restoring the database from a cloud URL there is a chance you will encounter the below error. Msg 3271, Level 16, State 1, Line 1 A nonrecoverable […]
administration / Azure / Database / MSSQL
Best practices for Cloud backups
Continuing our discussion on how to backup databases to the cloud here are a few official and unofficial best practices. Use unique filename; better yet add timestamps to […]