SQL Server 2012 RTM(Trial) Released today:)

At laaast…..Microsoft released SQL 2012 RTM(Trial) today!! They also made Feature Pack(s) Available for download. Go ahead and Download and Install RTM along with desired feature packs and Brand new SQL Server Data Tools 🙂 Official RTM will be released in early April 2012!

SQL Server 2012 RTM (Eval) can be downloaded from




For Feature pack, visit


For Data Tools, visit


Have Fun testing RTM 🙂


How Intelligent is SQL 2012 IntelliSense??

I’m assuming whoever reading this post is already aware of SQL Server 2008 SSMS brand new Enhancement “IntelliSense”. Being said that, was “IntelliSense” really Intelligent enough upto SQL Server 2008R2? IMHO, It’s not really smart enough to read our minds! But WHY?? Because, It’s not smart enough to recognize a word in middle of your Object name! For Example, if you need information regarding DB Mirroring Endpoints, you’ve to actually start your typing with  “SYS.DATABASE_MIRRORING_*******”. With all the new hundreds and hundreds of DMO’s available, it’s really difficult to remember each and every starting word of a DMO. It would be really nice if SSMS is smart enough to return all the Objects if it finds a word anywhere in the Object name. I mean, in the above example It should display a list of all DMO’s even though we just type “SYS.MIRR” irrespective of where the word “MIRR” actually present.

You know what, with SQL 2012 that is how it works 🙂 This Simply Rocks!! It makes our DBA life so simple…Yeyyyyyy 🙂

See below Screenshots for better understanding what I meant in the above paragraph.

SSMS 2008R2:

As you can see in the above Screen cap, it’s no where close to Mirroring DMV’s 😦 In other words, I’ve to remember the actual starting words in that DMV!!

SSMS 2012:

Here you can see a list of all the DMO’s which contain a word “Mirr” any where in the Object! This is what I call it as really “Intelligent”. This is something which is really really Cooooooool!!!

SQL 2012RC0 Database(s) Properties from 2008R2 SSMS

This is one interesting thing which I’ve Observed recently connecting to SQL Server 2012 via SSMS 2008R2.

SSMS 2008R2 is not displaying Compatibility Levels of the 2012 databases! See below Screenshot for what I’m trying to explain.

See below screenshot for the same database properties from SSMS 2012.

As you can see, It is displaying Containment properties, additional File Stream properties…etc!  I think this is not an Issue with 2008R2 SSMS, but just something to be aware of!

SQL Server 2012 RC0 Released :)

Looks like the Most awaited 2012 RTM  is almost there. As per the trusted sources, Microsoft is targeting to release SQL 2012 RTM somewhere in between Q1-Q3 next year! Anyways….today MSFT has released SQL Server 2012 Release Candidate 0. I’m planning to download this tomorrow and will start playing around 🙂

You can download this from http://www.microsoft.com/download/en/details.aspx?id=28145

What’s new in SQL 2012 RC0?

Visit http://social.technet.microsoft.com/wiki/contents/articles/3783.aspx

Happy Testing SQL 2012 🙂