Microsoft Azure Portal Preview looks promising !

This is one of those posts which is pending for a very long time. I was pretty excited when Azure...

Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!

SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...

Data Collector in SQLServer 2014 – What’s New !

Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...

SQL Server 2014 Install – Step by Step

Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh...

Folks,Know your Outbound Data Transfer Costs – Windows Azure

The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.
Yes, when I...

Rollback DBCC CHECKDB REPAIR !

I learned something new today while I was listening to one of the courses on corruption authored by the master,...

One error which you don’t want to see while doing upgrades – Missing MSI !

The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...

Setting up the Min and Max Memory options on the fly – Word of caution !

Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...

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...