I have a dual screen arrangement at my home system. I love it because it’s very convenient. When I am working with SQL Server 2008 R2 or any earlier versions, I would want to use both of the Monitor so I open two separate SQL Server Management Studio and work along with it. I have no complaints with my system, at all. I am totally fine with it. However, sometimes I face small issues, like when I just want a small code open in a separate window but I do not want the windows to take over the whole of another window. But then again, I am already used to this current system.
Recently when I was working with SQL Server 2011 ‘Denali’ CTP1, I dragged one of the windows by accident, and suddenly it magically appeared out of its ‘Shell’ of SSMS and was appearing on a separate monitor. I played around a bit and figured out that SSMS now supports multi-monitor (or multi screen) support with single SSMS instance. We can now drag out and drag in any window and resize them at any size. Fantastic!
If you are multi-monitor user, I am sure you will like this feature.
This leads me to ask you question? Do you use multi-monitor system while working with SQL Server? Leave a quick comment.
Reference: Pinal Dave (https://blog.sqlauthority.com)
5 Comments. Leave new
The new SSMS is built on Visual Studio 2010, which has this capability.
You can emulate some of the functionality now by using VS2010 today, it has a server explorer, t-sql execution capabilities, and more.
Neat feature, I love dual monitors, really good for developers when you have multiple tasks going on.
I have 2 monitors at work, and I don’t have Denali installed …. just the normal Developer edition of SQL Server 2008…. and I have the different windows all over both screens WITHOUT having to open more than one copy of SSMS….. I haven’t found if there’s a switch to toggle between ODI and MDI, but all I did was install it and pull the windows all over the place – so the default might just be Multiple Document Interface…..
I’m looking forward to trying out Denali tho :) Sounds cool!
The main problem with the increasingly all servers on rent, is that you have reliable services. Hosting selection should be based on the reputation of the company.
Glad to see this functionality coming to SQL Server. At work I have dual monitors, but I mainly work from home with a 3-27″ monitors setup, And I’m always putting things across these 3 monitors