First Look at SQL Server 2012 Management Studio

March 16, 2012

Last week, Microsoft released SQL Server 2012. With this release comes an update to SQL Server Management Studio (SSMS). Here is a quick glance of some of the new features…

New Font and New Color Scheme

If you take a look at the new SQL Server 2012 Management Studio, you will immediately notice the new color scheme  and that it looks just like Visual Studio 2010! That’s because it’s not built on the Visual Studio 2010 Shell. We will also notice that the default font is now ‘Consolas’.

image

Multi Monitor Support

SQL Server Management Studio now supports multiple monitors, just like Visual Studio 2010. You can drag each window to another monitor. This also means that each monitor can appear outside of the SSMS shell.

Code Snippets

Now there are lots of code snippets are available and you can that code snippets via right Click Query window-> Insert snippets like following.

image

Once you click Insert snippets it will open lots of built in snippets and create syntax for you directly.

You can also manage the Code Snippets from the Tools –> Code Snippets Manager… menu

image

Zoom Functionality

Now you can zoom the query editor window. There is a dropdown given in left bottom corner of the window and you can zoom the query editor windows as you need like following.

image

Improved IntelliSense

SQL Server 2008 added IntelliSense support. In SQL Server 2012, this only gets better and faster. It seems much more responsive, similar to what we see in Visual Studio 2010 IntelliSense.

image

A New Activity Monitor Window

image_thumb[3]

Additional features in SQL Server Management Studio:
http://msdn.microsoft.com/en-us/library/ms174219(v=sql.110).aspx

Advertisements

One Response to “First Look at SQL Server 2012 Management Studio”

  1. myror Says:

    I found your website while searching on http://theflyingmaverick.

    com/2012/03/16/first-look-at-sql-server-2012-management-studio/.
    How did you get displayed on http://theflyingmaverick.

    com/2012/03/16/first-look-at-sql-server-2012-management-studio/?
    I’ve been working away at it for a little bit but they still won’t
    take me. Thanks


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

toon vanhoutte

Blogging about connecting devices, systems and people! On-premises and in the cloud. Microsoft stack only.

Ken Cenerelli

My life in software development

scomfaq.wordpress.com/

Things about System Center and Cloud...

Build HoloLens

All about HoloLens

DevDays®

For web designers and cloud developers

Build Azure

All about the Microsoft Cloud

vishal patel

Software Developer, Windows 8 and Windows Phone Enthusiast

SQL with Manoj

SQL Server (TSQL) Programming, DB concepts, Tips & Tricks with >400 articles... comments welcome!!!

dragablz.wordpress.com/

Dragable, tearable, dockable WPF TabControl. Open source to boot.

Adrian Hall

Because Developers are Awesome

Ratish Philip's Blog

Another adventure in code...

codematrix

Application Architecture at it's best

One Unicorn

Thoughts from one member of the Entity Framework team...

Rachel Lim's Blog

Simplifying programming into something I can understand

.NET Developer's Blog

Software Development, Flying and Life

The Flying Maverick

Software Development, Flying and Life

Hiking Photography

Beautiful photos of hiking and other outdoor adventures.

paint.net blog

The best free image and photo editor. By Rick Brewster.

Learning by Shipping

products, development, management...

%d bloggers like this: