Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server Management Studio
Monday, November 02, 2009 6:28 AM

Win7 – Install SQL Server Native or go Virtual PC?

I have Windows 7 on my laptop, and I also teach, demo and use SQL Server 2005 and SQL server 2008. Should I install this “native” on my outside operating system or use the Virtual PC (VPC) software that comes with Windows 7? Well, there are arguments
Posted by Buck Woody | 0 Comments
Wednesday, October 28, 2009 8:13 AM

Templates for New Query Window

When I’m in SQL Server Management Studio and I click the “New Query” button, my Query Window comes up like this: /* <ScriptFileName, SYSNAME, ScriptFileName>.sql Purpose: <Purpose, SYSNAME, Purpose> Author: <Author, SYSNAME, Buck Woody>
Posted by Buck Woody | 0 Comments
Monday, October 19, 2009 6:19 AM

Color Me Informed

I got a response via e-mail to my post on using color connections – and I wanted to share it here: “ I just read your tip for color coding your Mgmt Studio connection.  I wanted to point out a couple things.  If you connect to a server where
Posted by Buck Woody | 1 Comments
Wednesday, October 14, 2009 8:37 AM

Color Your Connections

In cyber-space, no one can hear you scream. Have you ever connected to a server, thought it was a testing or development system, and only a split second after you pressed “F5” to run that command, realized that it was the production server? Yeah….me neither
Posted by Buck Woody | 0 Comments
Tuesday, October 13, 2009 8:44 AM

Go To Find Combo

A friend of mine – Bill Ramos – showed me a little-used feature in Management Studio that I’ve been using ever since. It’s a combo box that works in the Query Window and it allows you to find text quickly in a script, but it also has a hidden benefit.
Posted by Buck Woody | 0 Comments
Wednesday, September 02, 2009 7:27 AM

T-SQL Prettifiers

OK, I don't think that's even a word, but the synonyms (can a non-word have a synonym?) are code beautifiers, sql formatters, etc. The basic idea is that it's a program that re-formats the text in a Transact-SQL statement using a standard set of rules.
Posted by Buck Woody | 0 Comments
Monday, August 31, 2009 7:10 AM

Directly Opening a Solution in SQL Server Management Studio

I use Solutions a lot in SQL Server Management Studio (SSMS), and you should be aware of this simple tip: If you want to open a Solution without having to open SSMS and then jumping through all the menus, just double-click the solution name in the Windows
Posted by Buck Woody | 0 Comments
Tuesday, August 04, 2009 8:06 AM

SQL Server Management Studio Projects and Solutions

Inside SQL Server Management Studio (SSMS), there's a feature I don't see used a great deal. It's called a "Project" and in effect it's just a way to bundle files, connections and scripts into a single package that you can navigate within SSMS.
Posted by Buck Woody | 0 Comments
Thursday, July 30, 2009 9:45 AM

Code Collapse and Expand Feature in SQL Server Management Studio 2008

In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath.
Posted by Buck Woody | 2 Comments
Thursday, July 23, 2009 6:29 AM

SQL Server Management Studio Tips and Tricks

Are you getting everything out of your SQL Server tools that you can? I’ve given you lots of tricks and tips here on my blog, but nothing beats an on-screen demonstration. My good friend and former teammate Bill Ramos did a session on SQL Server
Posted by Buck Woody | 0 Comments
Thursday, July 16, 2009 8:08 AM

Moving the "Debug" Button

We made a tremendous amount of improvements in SQL Server Management Studio (SSMS) for SQL Server 2008. Some of them you can see, such as being able to add different columns in Object Explorer Details, and others you can't, such as the speed improvements
Posted by Buck Woody | 1 Comments
Tuesday, June 16, 2009 8:44 AM

SQL Server Management Studio - Copy With Headers

I'm writing this on the train to Seattle to visit with a customer this morning - I'm thankful for Wireless! Although setting up a wireless network for a train is a really big thing, sometimes it's the smaller things that make us happy. In SQL Server Management
Posted by Buck Woody | 1 Comments
Wednesday, May 20, 2009 8:25 AM

A Template for Setting and Reading Extended Properties

In the SQLCMS project, I show an example of some "base tables" that you can create for the system. Whenever I create a database, or database object, I make use of a feature that's been around for quite awhile - Extended Properties. You can set and read
Posted by Buck Woody | 1 Comments
Monday, April 27, 2009 6:50 AM

Quickly Locate Text in a Query Window in SSMS

Wow - long title.   Anyway, my good friend Bill Ramos and I were chatting just the other day. He's a the guy at Microsoft that took my old responsibilities for SQL Server Management Studio (SSMS), and we were swapping tips and tricks. He showed me
Posted by Buck Woody | 4 Comments
Monday, April 20, 2009 7:54 AM

Listing the Central Management Servers Programmatically

I don't normally advocate hitting the system tables in any database with direct queries, preferring instead to use views or functions that the vendor provides. But so far I haven't been able to find the view or function that would return the list of servers
Posted by Buck Woody | 1 Comments
More Posts Next page »
 
Page view tracker