Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !

I got motivated to write this post as there was a question on twitter which was like  -

The user was...

Memory Optimization Advisor – SQL Server 2014 CTP2

SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal...

Database Backup Encryption – SQLServer 2014 CTP2

SQL Server 2014 CTP2(All new,shiny shiny !) availability was announced yesterday at #SQLPASS Summit.

Native backup encryption is one of the key...

Microsoft + Oracle = New opportunity…Windows Azure is a happening place !

Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the...

Windows Azure Service Dashboard – Checkout the health of Azure Services

Windows Azure Service Dashboard is an excellent way to know the health/availability of your Windows Azure Services.

You might always want...

High Availability within Windows Azure VMs – An exciting opportunity !

Windows Azure Virtual Machines is a real game changer as it gives us ability to spin up VMs in no...

Backup your Windows Azure SQL Databases – Yes,you should !

Care about RPO’s and RTO’s?  Then you should be backing up your Windows AzureSQL Databases(Formerly SQLAzure).

Windows Azure SQL Database is...

Deleting a Storage Account from Windows Azure – The right way !

I like to clean up things after I’m done with my testing and this morning I decided to clean up...

Monitoring Memory Usage of Memory Optimized Objects – SQL Server 2014

Starting SQL 2014 monitoring memory usage of the memory optimized objects is super important to ensure that your instance don’t...

Checkout SQL Server 2014 CTP1 and Windows 2012 R2 preview up in the cloud

You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.
If...