I was recently asked when does the actual Auto Update Stats trigger and while I know its during query compile I wasn’t exactly sure what the thresholds were […]
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 […]
How to export a database from Windows azure?
Glad to announce that we have a new video on YouTube explaining how to export a database hosted in SQL Azure into a BLOB storage account and then […]
Datawarehouse and Plastic Bags ….
I was recently having a discussion about the role of default values in the fact table. The example being discussed had to do with a retail business who […]
administration / Azure / MSSQL
MS SQL Server 2014 to 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 easily be able to […]