One of the biggest changes to SQL Server 2012 is that is now uses the Visual Studio 2010 Shell. Knowing that now, here are a few tips and tricks for SQL Server Management Studio 2012

Blocked Selection

Sometimes you may only want to select and copy a column of text as opposed to the normal text selection done by holding down the Shift Key. To do Block selection, you can do SHIFT+ALT and drag your mouse to only select certain areas of your text in column fashion.

image

Cycle through Query Windows

I’ve known about ALT+TAB to cycle through programs (Windows). I’ve also known about CTRL+TAB to cycle through components within a given application. For example in Excel you could use CTRL+TAB to move between worksheets. I’ve never tried it in Management Studio, but it allows you to cycle through the Query Windows.

image

Also, CTRL + F6 will cycle through the actual tabs without the graphic switching display.

Status Bar

Most people should be familiar with the Status Bar at the bottom of the query window, but did you know you can customize it?

image

If you look under Tools –> Options –> Text Editor –> Editor Tab and Status Bar you will see a number of options that you can change.

Grouped Connections

You can go to View and select to show Registered Servers. Within Registered Servers you can create a group of SQL Servers. This then allows you to start a query that will be run against all of the servers within the group. This is where the Group Connection Color for the status bar comes into play.

image

This could be really handy if you need to execute items across multiple servers. The color of the status bar is there to help you realize that that query is a group query as opposed to a single server connection.

Keyboard Shortcuts

There are a ton of Keyboard shortcuts that you can use within Visual Studio. The default settings are based on Visual Studio 2010. Here is a list of those shortcuts. SQL Server Management Studio Keyboard Shortcuts

You can get to these through Tools -> Options -> Environment/Keyboard

image

 

I hope these are useful to you.

Advertisements

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

SQLServer2012You can now download all of the latest RTM editions of SQL Server 2012 if you have a currently active MSDN Subscription.

http://msdn.microsoft.com/subscriptions

You can read more about the new features in SQL Server 2012 here:
http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

SQL Server 2012 Express Edition

For those of you looking to download the Express edition, you can do so from this URL: http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Software Engineering

Web development

PowerShell, Programming and DevOps

Musings and mischief on PowerShell, Programming and DevOps.

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

STEFANROTH.NET

Things about cloud and management

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.

%d bloggers like this: