Question of the day: what is the medical term for someone who picks at their scars or scabs? #qotd
SSMS Copy Column Headers
Needing some sort of variation or at least a break from my certification studies I decided to revisit a title I purchased a while back: "Beginning SQL Server 2008 for Developers" from @Apress written by Robin Dewson. Truly glad I did because one of the problems I have when illustrating data related issues to clients is having to piece together a bloody spreadsheet. I typically would query the tables then query the INFORMATION_SCHEMA.COLUMNS or sys.columns to get the column names to use as headers. Then I would copy and paste them into the predetermined rows.
Well not any more because page 42-43 of this awesome book had life changing screenshots of the Options dialog. Big deal right? Well a big deal for me at least! Following the path of Query Results --> SQL Server --> Results to Grid lead me to a sudden state of euphoria. There I saw it as the lights of heaven filled my home, blurring everything around me as if a spotlight and magnify focused in on the wonderful words that read: "Include column headers when copying or saving the results". Was it really true, are my days of querying sys.columns or the INFORMATION_SCHEMA.COLUMNS finally over? In a way, maybe, not really, but at the very least delivering requested spreadsheets to clients will be a bit faster. I was so excited I tried this on MSSQL 2005 and sure enough it is there!
What you need to do is:
Step 1 - Go to Tools --> Options
Step 2 - Expand Query Results --> SQL Server --> Results to Grid
Then check the box titled: Include column headers when copying or saving the results
Step 3 - Copy some cells
If you have tabs opened already, open a new query window and try it. You should see the menu item "Copy with Headers" as a right click option
Step 4 - Then paste your results into the spreadsheet
Just a side note, if you are dealing with datetime data types you should consider making the predetermined columns in the spreadsheet as a text category by formatting the cells, under the Number tab select the "Text" category.
Cover image taken from Apress.
Hide Tagged Photos & Videos on Facebook
A few friends of mine asked me how to hide tagged photos and videos of them on facebook. Well there is a way, but it does not necessarily hide the photos of you entirely. It just hide them from the people who are visiting your profile who happen to be looking through your photos. However if someone else (a friend or stalker) has a photo of you in one of their albums and they tag you then that photo will still visible to the friends of the person who tagged you. Also depending on their privacy settings your photo can be available to nearly anyone for that matter. Yea... instant FAME! Unless it is a non-flatter picture of course. So in short you are only hiding them from being viewed on your profile. With that said if you still want to "pseudo" hide them, then this is how you would do it.
Step 1 - Go to Privacy Settings
Step 2 - Go to Profile Information
Step 3 - Go to Photos and Videos of me
Step 4 - Select the appropriate permission level
sweet search results about #PowerShell http://bit.ly/9RIVvy from Windows
PowerShell Blog at http://bit.ly/cMggLy
Heartfelt drunken impediments: You're worthless and never seem to amaze me =
You're priceless and never cease to amaze me.
Thinking it is time to plan a mini getaway. Haven't been to Vegas in a
minute. Time to use up some points. #vegas
I am diggin' the new look & feel of #Camtasia Studio 7 from @TechSmith.
Looks like I'll be upgrading!
Ah man... washing/drying just got hi-tech. Might need to get certified
to operate these bad boys. http://ping.fm/gExI3
#sqlsaturday is in full force today. We got #sqlsat44 (SoCal), #sqlsat39 (NYC) & #sqlsat41 (ATL) #sqlsat #sql
Morning is kicking off to a good start. Grab a bowl of cereal, went to
take a bite & realized I grabbed a fork! #fail
so need to wean myself off the battery acid, caffeine, caf�, caf� au
lait, caf� noir, cappuccino, espresso, forty weight, jamocha, java,
joe
Its a clear sign that you're drinking way to much coffee when your urine gives off a dark roast aroma!
Man for some strange reason (can't imagine why) no one seems to trust me with the responsibility of holding their coffee. #Fail
You know you have a reputation when your 3yr old shouts "don't eat it" from across the room as you approach her side of the table.
What a great day! Back at home & everyone is exhausted. Its a regular snore fest in here! Might as well join in on the symphony.
calling it a night. got an event filled morning planned tomorrow
starting in about (oh crap) 5 and half hours.
I must have a personality disorder because I seem to care about other peoples feelings. #SelfDiagnosed
I must be overlooking something somewhere. This is why I try to automate steps as much as possible. #uniformity
they either aerated the park or a ton of small dogs used it as their restroom. Looks like a bunch of lil turds
WTH! These intermittent network issues are frustrating. Totally crushing my productivity and progress.
OH: "Things have changed. You have to face the facts I am not the same
person I once was. I am on twitter now."
My little girl was asked, "what are u eating?" I happen to groan from
across the room piece of crap & guess how she answers? #BadDadAward
Thinking that I need to make a run to Coldestone Creamery for the�new
Double Stuf OREO Ice Cream Sandwiches
Microsoft changes the Windows license - http://bit.ly/d4oA9R would
this change your perspective? #zdnet
I am beginning to suspect the reason why one gold fish is much, much
larger than the rest is because he ate the others
I thought this network security course would be difficult and I was
right. Glad it is almost over. g'nite folks
To be 100% honest I think I watch the Spanish channel to brush up on my, well... Spanish. I mean I barely notice the half naked women!
Thank goodness I was able to update the os on my blackberry, even
after the tmo folks said I needed a replacement. Now to authorize
Looks like as soon as I return home I might need to repack and head to Huntsville next week, the Chicago the following #FlierMiles
Wild Ahi Sliders
The Wild Ahi Sliders from True food kitchen come with wasabi, radishes, cucumber and a sesame brioche. Don't be mislead, the wasabi is merely a nice little portion which gives you a perfect essence, no epic nasal burns here. I ordered mine with the sweet potato hash which was absolutely awesome and the Green Arnie (Matcha Green Tea & Honey Lemonade) for my drink which was very refreshing. If you get the opportunity to stop in and look for Nate he the cool guy at the bar. True Food Kitchen is a cool place, great atmosphere, and awesome people. Highly recommended.
Anyone know of any salsa merengue clubs in the southeast valley? Gilbert, Chandler, Tempe, Mesa or Ahwatukee?
Taxes filed. Turns out uncle Sam owes me 1 billion dollars in back taxes for bringing sexy back. #gully
Subscribe to:
Posts (Atom)
