THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql server management studio   (RSS)
Showing page 1 of 2 (12 total posts)
  • Linqpad – bring the power of LINQ to SQL Server development

    One of my biggest laments about being a SQL Server developer is that the tools provided by Microsoft to do our thang compare woefully to the feature rich, (largely) bug-free, “it-just-works” impression that one gets from seeing the tools available to “other” developers in the Microsoft ecosystem (I’m thinking of our appdev brethren here, the ones ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 20, 2013
  • Query window custom colouring now works properly [SSMS]

    SQL Server 2008 introduced a new feature that had the potential to be very useful, the ability to color colour-code a query window in SSMS to represent the server that was being connected to. This was configured using the properties of a server in the Registered Servers pane: Unfortunately this feature was made less than useful, dangerous ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 11, 2011
  • Thoughts on Nexus in SQL Server PDW

    I have been on a SQL Server Parallel Data Warehouse (aka PDW) training course this week and was interested to learn that you can't (yet) use SQL Server Management Studio (SSMS) against PDW, instead they ship a 3rd party tool called Nexus Chameleon. This was a bit of a disappointment at the beginning of the week (I'd prefer parity across SQL Server ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 17, 2011
  • SSMS in SQL Server Denali – “Insert snippet” and “Surround with”

    SQL Server Denali CTP1 has hit the streets! I’ve been lucky enough to have been playing with it for a couple of weeks (thank you to those responsible – you know who you are) and that means I can now start talking publicly about some of the cool stuff I’ve learnt about this next version of SQL Server. In this blog post I’m quickly going to cover ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 8, 2010
  • Recover Backed-up query files in SQL Server Management Studio

    This is a useful little tip that I discovered today. If SQL Server Management Studio (SSMS) ever crashes on you for whatever reason then there is a chance that you’ll lose whatever queries you had open at the time of the crash. Sometimes when you re-open SSMS it will ask you if you want to re-open any files that you recover but for some reason it ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 19, 2010
  • Backup Meta-Data

    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and modified it to this T-SQL Script. A few words here - you need ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 30, 2010
  • Multi-Monitor Support in SQl Server Management Studio 2008

    Did you notice that there are a lot of ''little'' things that were improved in SQL Server 2008? One of those was done by one of my favorite developers and deals with multi-monitor support. In previous versions of SQL Server Management Studio you could open the tool in multi-monitor and arrange the panes onto mulitple monitors. But when ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 4, 2010
  • Your work may not be lost

    One of the things that I found dissapointing in Management Studio 2008 is that in the event of a crash (and in addition to crashing in the first place), is that on a restart it doesn't show me a dialog with a list of auto-saved files, like my SSMS 2005 did. Yesterday as I was doing some houskeeping on my disk, I noticed a ...
    Posted to Roman Rehak (Weblog) by roman on January 28, 2010
  • Hovering Over the Titles in Activity Monitor

    I show this little-known feature in just about every perf tuning class I give, and it’s often a surprise to most of the folks there. It’s not earth-shattering or anything, but I do find it helpful. In SQL Server Management Studio 2008, start the new Activity Monitor. Open one of the “Bands”, such as “Processes”. Move your mouse cursor over one of ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 21, 2010
  • Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure. On the other hand I have several systems I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 18, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement