While in Orlando we drove from there to the Kennedy Space center and spent half a day there. It was pretty cool. They had tons of rockets and other space memorabilia along with Imax movies and a memorial to the brave astronauts who have lost their lives over the years in our exploration of space. This area is called the rocket garden and has samples of the many rockets used through out the years.
Have you ever wanted to have a row count as a column in sql output?
Well, I have for a number of different reasons and this is how I found to do it.
ROW_NUMBER() OVER(Order by ‘SomeColumn’) as seq
Earlier today my Blackberry Curve quit receiving any data services at all. The internet didn’t work, email didn’t work, nothing worked related to data. I thought at first maybe it was a Blackberry outage of some sort. After a couple of hours I figured it must be something else.
So, I did the first thing any good troubleshooter should do…reboot. I removed the battery and reset the phone. No luck, I can place phone calls, but no data services.
Ok, maybe some application is messed up and causing the problem. I go to the Blackberry options and under the security settings I wiped the phone, first without erasing third party applications and the second time I erased everything. No luck. Still no data services. I can’t activate the Blackberry on our enterprise server and nothing works except for making phone calls. I get an error message “service connection is unavailable” when trying to activate on the enterprise server.
I finally resorted to calling Alltel.
The girl on the phone says hit the green button.
I did it.
Do you see something that says line 2?
Yes I do, it says Line 2: 417 xxx xxxx (my phone number).
She says ok, scroll up and click where it says Line 2.
I do and then a list appears that says Line 1 and below it Line 2.
Select Line 1 she says.
As soon as I select Line 1 the up and down arrows start flashing and an email pops in. Sheesh. That’s all I needed to do?
The little 1XEV also popped up in the upper right of the screen by the bars indicating signal strength.
Kinda wierd, but at least now I know if it happens again!
I went to a Microsoft Tech-Ed conference in Orlando last week. We took some time and drove from Orlando down to the Florida keys out to Key West. It was an interesting drive. The sunset was great even though there were large clouds that the sun dipped behind.
I was recently in Atlanta, GA and took some time to visit the Georgia Aquarium. I didn’t lug my tripod around, but I did use my monopod and got a couple of interesting shots, nothing spectacular. The Georgia Aquarium is one huge place!
I managed to get the rest of the parts painted black, including the speaker panel.
Here is my son and brother-in-law playing Contra. Great game!
(Note: click the images for larger versions.)
You can’t really see them in this size, but if you click on the image below you will be able to see the LED lights just below the green and red buttons.
Stuff I still need to do:
Get the marquee printed at Kinko’s.
Get glass to server as bezel in front of the TV.
Design artwork for side of cabinet, front of drawer and glass bezel.
Install piece of trim across the front above the drawer.
Get glass to server as bezel in front of the TV.
Get a switch box so I can install an XBox 360 and PS2 and switch between them.
Make an opening on the front door to give easy access to consoles etc. inside.
Whatever else pops into my head! :)
Service Pack 3 for Windows XP included an update to the remote desktop client which appears to have broken the old command for connecting to the console session of another computer. For some of my users I will setup their remote desktop settings and save those to a rdp file that can then be used to jump into a remote desktop session. The rdp file that the remote desktop creates is just a text file with settings in it. You used to be able to edit the text file and add a line that read:
connect to console:i:1
This would cause the session to connect to the console instead of a standard terminal services session allowing the user to interact with the same session as if you were sitting in front of the computer. For some reason this week these rdp sessions quit connecting to the console session on my servers.
After some investigation I found that this setting no longer works and you have to use:
administrative session:i:1.
Just a minor change but with large consequences!
Related to this is the fact that running mstsc.exe /console no longer works.
I’ve read that mstsc.exe /admin achieves the same thing, but I haven’t tested it yet. The reason for this change is that running remote desktop and connecting to the console connects you to session 0 which runs with elevated privileges and therefore is a security risk.
