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’ […]
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 […]
administration / Azure / Database / MSSQL
SQL 2014 Cloud Backups Part 5
With the credentials saved we are now ready to take a backup of the database. Below screenshot shows how to backup using the GUI or the script . […]
administration / Azure / Database / MSSQL
SQL 2014 Cloud Backups Part 4
Once the azure storage objects are created we need to configure a credential within SQL Server in order to allow SQL Server to securely access the cloud container. […]
administration / Azure / MSSQL
SQL 2014 Cloud Backups Part 2
Once the Blob Storage is created (consider blob storage to be cloud based USB Drive of almost infinite capacity) click the Manage access keys link at the bottom […]
administration / Azure / Database / MSSQL
SQL 2014 Cloud Backups Part 1
In this series of blog posts the focus is going to be on the MS SQL Server 2014 Cloud Backups feature. Most companies will be easily able to […]
administration / Azure / Database / MSSQL
SQL 2014 Cloud Backups Part 3
You should see the screen below Make sure you set the Access as Private to ensure that only those with the proper permissions have access. Once created you […]