Search results matching tags 'denali', 'sql improvements', and 'sql'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=denali,sql+improvements,sql&orTags=0Search results matching tags 'denali', 'sql improvements', and 'sql'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Sometimes it’s the little things...http://sqlblog.com/blogs/rob_farley/archive/2011/08/30/sometimes-it-s-the-little-things.aspxTue, 30 Aug 2011 11:10:43 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:38154rob_farley<p>The easiest way to convince someone to use SSMS 2008 over SSMS 2005 was to right-click on a results grid. They’d see “Copy with Headers” in the context menu and be sold immediately. I’d happily show them that they could configure this option in SSMS 2005, but to have it immediately available in SSMS 2008 was enough to convince many people to install the newer tools right away.</p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_30E963A6.png" width="179" height="137" /></p> <p>The new version (<a href="https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/" target="_blank">Denali CTP3</a>) of Management Studio has a few little things that I don’t mind, even though none of them are quite as compelling as the “Copy with Headers” option.</p> <p>I’m going to pick three:</p> <p><strong>Cycle Clipboard Ring</strong></p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_28490B1A.png" width="274" height="143" /></p> <p>This is handy stuff. I copy &amp; paste far too often when writing queries. I’ll be refactoring as I go, that kind of thing, looking at plans, copying out of the plan properties into comments, and so on. Invariably, I’ll think I have something on the clipboard, and find myself having to find it again because I will have replaced my clipboard with something else. So now I should be able to use Ctrl+Shift+V to get back to something which used to be in the clipboard. Brilliant. :)</p> <p>Bear in mind, it’s in the Edit menu, but not in the Context menu (so you don’t see it if you right-click in the query pane).</p> <p><strong>Zoom</strong></p> <p>This is handy, but doesn’t go quite far enough for me. At the bottom of the query window, above the results, to the left of the horizontal scrollbar, it says “100%”</p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_4A14E3AB.png" width="186" height="113" /></p> <p>It’s a zoom function, so that I can make the text of my query bigger or smaller. This is great. I normally write queries in a surprisingly large font, and this means that when it’s just me looking at the screen, I can easily zoom out more and see what’s at the end of the longer lines.</p> <p>I only wish that it would zoom the results too. Maybe that’s so we can tell our clients “Trust me – those results are correct”</p> <p>Plus, it feels ironically small. Fortunately, you can use <a href="http://technet.microsoft.com/en-us/sysinternals/bb897434" target="_blank">ZoomIt</a> to make the Zoom button bigger.</p> <p><strong>Highlighting</strong></p> <p>Compare the following images:</p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_6F7ED719.png" width="355" height="190" />&#160;<img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_114AAFAB.png" width="360" height="184" />&#160;</p> <p>In the interest of readability, I like to colour selected text in yellow, not blue or grey or whatever. It was a tip I picked up from <a href="http://blogs.msdn.com/b/acoat/" target="_blank">Andrew Coates</a> many years ago.</p> <p>See if you can spot the difference between the SSMS 2008 Options dialog and the Denali one.</p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_6F4253E4.png" width="450" height="240" />&#160;<img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_31956C28.png" width="453" height="265" /></p> <p>The Denali one is on the right, and you might notice that “Item foreground” is disabled. In SSMS 2008, it wasn’t. And we ended up with all the selected text being black on yellow.</p> <p>In Denali, they’ve changed that. The yellow is made fainter (not sure why, but it is – this is as yellow as I can make it), and the text stays the colour that it was before we selected it. Useful stuff.</p> <p>But I’m disappointed with this feature.</p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_2CFF616E.png" width="264" height="209" /></p> <p>Notice – this line is commented out, but I can run it by selecting the commented text and hitting one of the many Execute buttons. The selected text is coloured green, because that’s what colour it was before it was selected.</p> <p>But I can run it. Wouldn’t it be useful to have it coloured based on what’s selected? That way, you’d have a better idea about the parts of a selection were still commented out, and what you were actually about to run. This is particularly handy when you use the Alt-select option. It had always frustrated me that selected text was all the one colour, and I’m really glad they have fixed this – now I just want them to take it one step further.</p> <p>Like this:</p> <p><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_20DDE747.png" width="421" height="199" />&#160;<img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="" border="0" alt="" src="http://sqlblog.com/blogs/rob_farley/image_54F2869A.png" width="421" height="199" /></p> <p>Am I asking too much?</p> <p><a href="http://twitter.com/rob_farley" target="_blank">@rob_farley</a></p>Denali’s Management Studio for CTP3 playing nice with others (almost)http://sqlblog.com/blogs/rob_farley/archive/2011/08/29/denali-s-management-studio-for-ctp3-playing-nice-with-others-almost.aspxMon, 29 Aug 2011 06:40:24 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:38105rob_farley<p>Until recently, I’d only done stuff with Denali on a dedicated box. But this weekend, I took the plunge and installed SSMS on a machine that has older versions of SQL Server installed on it. You can download Denali from <a href="https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/" target="_blank">this link</a>.</p> <p>I’ve only installed the tools – I haven’t installed the Database Engine, Analysis Services, and so on. It’s more that I want to get using Denali’s tools on a more regular basis, and figure that for writing queries, demonstrating things, and so on, it should be useful to use the latest tool set. I’ve been an advocate of this approach for a long time, but had been nervous about installing a pre-“release candidate” version on a box that I wouldn’t be entirely thrilled about blowing away.</p> <p><img style="background-image:none;border-right-width:0px;margin:5px;padding-left:0px;padding-right:0px;display:inline;float:right;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;padding-top:0px;" title="image" border="0" alt="image" align="right" src="http://sqlblog.com/blogs/rob_farley/image_50B8240B.png" width="361" height="242" /></p> <p>Anyway – so far I haven’t noticed any problems. I can happily use the new SSMS to connect to my other boxes, and it seems to play just fine.</p> <p>For the most part, Denali’s SSMS feels very similar to older versions, even though the splash screen shows that it’s “Powered by Visual Studio”. Let’s face it, there were clearly things in older SSMS versions that made it clear it was using a Visual Studio shell of sorts, such as the way that panels and menus were handled.</p> <p>But in Denali, they’re admitting it in an even stronger case, particularly in regard to shortcuts.</p> <p>The biggest frustration I have with Denali SSMS is that it prompts you about whether you’d rather use traditional shortcuts or use the default Visual Studio ones. Straight away, I picture going into clients and feeling clumsy as I hit shortcuts that don’t do the right thing. </p> <p><strong>This scares me – the idea that I might hit a shortcut and have it do something wrong.</strong></p> <p>I haven’t gone into the shortcuts completely yet – but I’m already dreading it. People’s data is very important to them, and therefore to me as well. I will not risk it. I’ve learned <a href="http://sqlblog.com/blogs/rob_farley/archive/2011/08/10/how-failure-can-be-useful.aspx" target="_blank">that lesson before</a>, and I hope to never have to learn it again. I do not want to ever use a particular shortcut that I’m supposedly familiar with, and find it does something different to what I expect.</p> <p>Luckily, settings are stored in a file, so you can take that file with you. Also, that file is local to your own Windows profile, so you should be able to tweak stuff without affecting other people too much.</p> <p>On my machine, the settings file is in: C:\Users\Rob\Documents\SQL Server Management Studio\Settings\SQL Server Management Studio</p> <p><img style="background-image:none;border-right-width:0px;margin:5px;padding-left:0px;padding-right:0px;display:inline;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;padding-top:0px;" title="image" border="0" alt="image" src="http://sqlblog.com/blogs/rob_farley/image_04A065F7.png" width="660" height="97" /></p> <p>This means you should be able to make sure that the shortcuts you use are the ones you’re used to, not the ones that someone else prefers. I’d recommend to everyone to have their .vssettings file stored somewhere accessible (USB key, <a href="http://skydrive.live.com" target="_blank">SkyDrive</a>, whatever).</p> <p>I’m already tweaking a few things, because despite the fact that I chose the option to use settings from my previous version, <a href="http://connect.microsoft.com/SQLServer/feedback/details/685924" target="_blank">it didn’t bring them all across</a>. Things like my default font size, which I generally have quite large because of the amount of presenting I do, and also the amount of working alongside clients (where it’s easier to have a large font so they can see what I’m doing). So now I’m going to be taking my .vssettings file along with me, for those times when I find things don’t quite work the way I’d like.</p> <p><a href="http://twitter.com/rob_farley" target="_blank">@rob_farley</a></p>