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 » SSMS » sql server management studio   (RSS)
  • 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
  • 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
  • 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
  • Wizards are evil – wait, no they aren’t!

    SQL Server contains many “Wizards. Wizards are simply programs that collect information based on user choices. The Wizard’s screens explain each step and the choices on that screen. Based on those answers collected from the user, the Wizard performs some task. What could possibly be wrong with helping a user this way? Well, plenty. Wizards hide ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 14, 2009
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement