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

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