Excel Within Management Studio

January 13, 2010 at 2:43 pm (SQL Server 2008) (, , , )

Aaron Bertrand has put in a Connect request for a feature whereby data returned as a grid from a query can just go right into an Excel spreadsheet. All in favor? Opposed? Motion passed. Go and vote this one up, up, up.

Permalink Leave a Comment

SQL Server 2008 Management Studio Trick

January 22, 2009 at 12:57 pm (SQL Server 2008, SQLServerPedia Syndication, Tools) (, , )

I just had a Tremors moment. “Everybody knows about ’em Earl, we just never told you.” Except that no one I showed it to has ever seen it before. So maybe this is something a little new.

I had a database selected in the Object Explorer window and I had the Object Explorer Details window open. I noticed a little icon at the bottom of the screen:

2008ms_icon

Then I saw that the bar above it was a moveable bar. So I moved it and saw this:

2008ms_db

Whoa! So then I tried a table, HumanResources.Department from AdventureWorks2008:

2008ms_table

Which caused me to check a procedure:

2008ms_proc

Each line has a little icon on the side that lets you copy it, line by line. It’s really just a way to display the basic properties about the object in a readily accessible format. It’s not going to change my life, or yours, but it sure is handy to know a quick way to access some basic information.

Permalink 7 Comments