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 The output shows the time taken to restore the database, a […]
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 […]
It’s gorGEOus what you can do with this data type
Had some spare time on my hand today and created the company logo in the MS SQL Server Geometry datatypes. The Geography and Geometry datatypes are one the […]
Proof that MS SQL Server is the better relational database
I am probably going to start a war with this one but I need to set the record straight. Often in my trainings I have a mix of […]