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 / MSSQL
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 […]
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 […]
administration / MSSQL / TSQL
sys.dm_exec_describe_first_result_set()
This DMV is probably one of the most useful DMVs for developers and Business intelligence users since it describes the data type and other columnar information of the […]
A new video on DB mirroring
Well it’s not new exactly it was created many years back and I somehow never uploaded it. Yesterday a former client came back asking about DB mirroring and […]
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 […]
Part 3 of 4: Video on Difference between partitioning and just multiple FGs
Sorry it took so long but here is the third video in our 4 part series on MS SQL Server partitioning. http://www.youtube.com/watch?v=GSNYGpNbidc I cover the difference between simple […]
Downloading the SQL 2014 product guide
Today we are going to do a quick post on where you can download the SQL 2104 product guide. http://www.microsoft.com/en-in/download/details.aspx?id=39269 The above link takes you directly to the […]
Installing SQL Server 2014
Today we are going to look at the different steps involved in installing SQL Server 2014. The important thing to keep in mind here is that while the […]