StupidProgrammer.com

I just brought up a new Windows 2008 server and installed SQL Server 2005 (I know… should have loaded 2008).

After my new SQL Server was up and running… I tried to connect remotely to the SQL Server.

Error…

Oh yeah… I remember… The good ole’ Surface Area Configuration tool.

Applied my change, and restarted SQL.

Remote connections still would not connect.

Hum… Ah… Must be Firewall…

In case you have not seen the Windows 2008 Firewall settings… it’s kinda intimidating

I found this DOS command to run on the server that corrected my connection issue. I hope it saves you some time if you encounter this in the future…

netsh firewall set portopening TCP 1433 "SQLServer"

That fixed me right up.

(I found the answer on ServerFault.com)

How many times in a .NET classes have you written public properties like this?

class Testing
{
    private string m_subject;
    private string m_message;

    public string Subject
    {
        get { return m_subject; }
        set { m_subject = value; }
    }

    public string Message
    {
        get { return m_message; }
        set { m_message = value; }
    }
}

.NET has the ability to make that section of code a lot cleaner and easier to read through the use of Auto-Properties.

class Testing
{
    public string Subject { get; set; }
    public string Message { get; set; }
}

You can read a little more over at Michael Sync’s blog.

Have you ever had a time when you needed to move a SQL database to a new server… made your backup… restored to new server… Go to setup the SQL user with permissions and get this…

Create failed for User ‘myuser’. (Microsoft.SqlServer.Smo)
User, group, or role ‘myuser’ already exists in the current database. (Microsoft SQL Server, Error 15023)

Huh… User already exist in database???

This is because the user in the database is orphaned. This means that there is no SQL login id or password associated with the database user.

This is really easy to correct in SQL 2000 SP3 or greater.

First, make sure that this is the problem. This will lists the orphaned users:

EXEC sp_change_users_login 'Report'

If you already have a login id and password for this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user'

If you want to create a new login id and password for this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'

(HT: FileFormat.info)

What happens when a database team is moving databases and the development team puts up a maintenance page to the company while the move occurs…

That’s right… they put me under the bus!

Just a little Friday humor… BTW… This really happened yesterday.

Very simple…

SQL 2000

USE master
GO

SELECT catalog_name
FROM information_schema.schemata
WHERE DATABASEPROPERTYEX(catalog_name,'RECOVERY') = 'SIMPLE' ;

SQL 2005-2008

USE master
GO

SELECT name
FROM sys.databases
WHERE recovery_model_desc = 'SIMPLE'

How does one UPDATE a field in a table where the key provided is in another table?

It is actually pretty simple:

UPDATE alias1
SET alias1.MyField = 'NEWDATA'
FROM tblTable1 alias1
INNER JOIN tblTable2 alias2
    ON alias1.ProductId = alias2.ProductId
WHERE alias2.PresentationId = '911'

I hope this makes sense. It is easy to test before running the update by simply replacing the UPDATE with a SELECT for testing to make sure the query is returning the correct data.

SELECT *
FROM tblTable1 alias1
INNER JOIN tblTable2 alias2
    ON alias1.ProductId = alias2.ProductId
WHERE alias2.PresentationId = '911'

If you know a better way to accomplish this, please leave me a comment on this post.

Tuesday, November 11th, 2008

Topic: Open Spaces – Bring your questions and ideas!

Tonight is our next meeting of the Pee Dee Area .NET User Group. 

Open Spaces is the chance for you to discuss topics with your peers.  Any developer topic is fair game and welcome!  This is your chance to gain valuable insight from your peers, so come equipped with your ideas or problems!  This meeting is a general open conversation and there will be no presenters.  See you there!

Here is the tentative schedule:
6:00 PM – 6:20 PM Socializing / Free Dinner
6:20 PM – 6:30 PM Introduction, Sponsor Time, and News.
6:30 PM – 8:00 PM Open Spaces

Today wraps up my twitter series. Over the past five days, we have discussed the following topics: Twitter – What is it?, How to Get Started and Use it, Definitions and Best Practices, and txt Messages and Twitter., and Twitter Tools.

The goal of this post is to share a few other things one can do with twitter.

Facebook Status Updates:

So many people use http://www.facebook.com. It is a great social networking tool! I may blog on it at a later date. But what I see by so many people is that they login to Facebook and update their status messages. Why not have twitter do that for you? Over the past couple of days, I have hopefully showed how easy it is to use twitter.

So, how do I setup Facebook to use my twitter account?

1. Install the Twitter application in your Facebook account: Twitter App For Facebook.
2. There will be a link Want Twitter to update your Facebook status? Click here!

That’s all ya have to do. There may be a slight delay while getting it setup. Now, when you tweet, your status on Facebook is updated.

By the way, if you are not already my friend on facebook, feel free to add me now.

TwitPic

Huh? What is TwitPic? TwitPic lets you share photos on Twitter. It is easy to use.

1. Visit http://twitpic.com
2. Login with your twitter username and password.
3. Click on Upload Photo
4. Select a picture you wish to share and click upload.
5. Once the picture is uploaded, it will provide a place to write your Tweet and post it.

Here is an example: Last night during our Halloween get together, I used my iPhone (most of the applications have built in functionality to use TwitPic) to post some pictures.

http://twitpic.com/j8za – Here is the scariest thing you will see tonight! Any night for that matter!

Notice the URL that TwitPic generated when I upload my beautiful picture

Badges/ Widgets

If you have a blog, you may want to consider using this. It’s a neat way to let visitors to your blog know what you’re up to at the moment: Display your latest Twitters there with a customized badge (aka, "widget"). Visit http://twitter.com/badges to get started. You can see an example of this on my blog. If viewing this through rss, visit http://ChrisReeder.com and look on the right side at section called “What I’m Doing…”

TwitterCounter.com

While we are talking blogs, twittercounter.com allows you to display you twitter Follower Count? It is easy.

1. Visit http://twittercounter.com
2. Type you twitter username in the box next to “Check Twitter Account @
3. Click the Show button
4. This will show your follower counts. There is a link near the bottom right to allow the adding for a Counter preview with a link for “Add TwitterCounter to your site”.
5. This will provide html (code) you can copy and  paste into your blog’s widget or HTML.

FriendOrFollow.com

FriendOrFollow.com helps you manage your Twitter contacts. Submit your Twitter username to find out who you’re following that’s not following you back, and who’s following you that you’re not following back. It’s that easy.

TweetBeep.com

This is a really cool site. http://TweetBeep.com can send emails alerts of twitter conversations that mention you, your products, your company, your church, your city, your website, or anything else! And it is a FREE marketing tool.

QurlyQ.com or/and TinyUrl.com

Remember that twitter only allows posts of 140 characters or less. What if I want to share one of these websites with someone through twitter?

http://3.141592653589793238462643383279502884197169399375105820974944592.com/

or

http://www.thelongestdomainnameintheworldandthensomeandthensomemoreandmore.com/

Either of those sites would use most if not all of the characters. Use one of these two sites to shrink the urls.

http://qurlyq.com/1m

or

http://tinyurl.com/in0l

Way shorter!

Twubble

If you are new to twitter, this site is a must! Visit http://www.crazybob.org/twubble/ and find some friends. It searches your friends and picks out people who you may like to follow.

ESV Bible Daily

Simply follow http://twitter.com/esvdaily for a verse of the day.

Fox News

Follow http://twitter.com/foxnews for the latest news!

Daily Weather

Visit http://www.accuweather.com/twitter/ and select your city. Then follow the twitter user for daily weather updates.

PicoBuzz

http://picobuzz.com shows the “buzz words” on twitter. Interesting stuff! Amazing… I was expecting to see Chris Reeder up there with McCain and Obama.

Twitter Fan Wiki

http://twitter.pbwiki.com is one awesome site to find just about anything about twitter.

I know this is not a complete list, but it does show some really useful sites. If you have any other sites that you like to use, please leave a comment on this post so others can try them, as well.

I trust you learned something during this series on twitter. If you are not currently subscribed to this blog to get all the latest updates, please consider doing so by rss.

Over the past four days, we have discussed the following topics: Twitter – What is it?, How to Get Started and Use it, Definitions and Best Practices, and txt Messages and Twitter.

This post is about a few useful tools to better use twitter.

So, after all this discussion of twitter and how to use it, what is the best way to keep informed of people you follow? Let’s take a look at a few tools.

Twitter.com

The twitter.com website is a great place to update status, but I prefer a few other tools.

Twirl

This application can be downloaded for free at http://www.twhirl.org. It can be  run on Windows and Mac. (I think Linux as well). It has all the features built in like replies, direct messages, managing users, and lookups.

TweetDeck

This application has all the functionality displayed a little different. I like the simplistic design of Twirl, but I like the grouping feature of TweetDeck. It breaks out columns for all tweets, replies, direct messages, and any groups you create. This app can be downloaded free at http://www.tweetdeck.com

What about on Phones or other devices??? Glad you asked… Yesterday I shared about using txt Messaging from phones, but there are a few other nice applications available.

iPhone & iTouch

I use a free application called Twitterrific. It works really well including a feature for using twitpic. I will share about twitpic tomorrow.

Blackberry

My good friend Chris Elrod mentioned that he uses Twitterberry for his Crackberry. Can’t really say if it is good or not, just have to take his word for it!

Windows Mobile

I use to have a Windows Mobile phone but retired it when I got my iPhone. I asked good friend Chris Craft what application he uses on his phone. He recommended Tiny Twitter. Though he did say that there was really not any good ones. Maybe he should write one.

As with any of these apps, you will have to decide which application(s) you like and will use. You can find a few others at http://twitter.com/downloads and a TON OF THEM at http://twitter.pbwiki.com/Apps.

If you have any applications/tools that you use, I would love to hear about them. Please leave a comment for all to see, so they can try them out too.

Tomorrow’s post will be the final installment of this series (serious this time). Stay tuned…

Over the past three days, we have discuss the following topics: Twitter – What is it?, How to Get Started and Use it, and Definitions and Best Practices.

So, the question of the day is… Can I use txt messaging on my phone to send and receive tweets?

Yes you can!

Twitter allows its users to tweet by using txt messages; both sending & receiving tweets, replies and direct messages.

So, how do I set it up?

1. Login to twitter.com using your credentials.
2. Click Settings link, and then select the Devices tab. (see picture to right)
3. Enter your cell phone number in the box preceded with a “+” and country code. (example: +12125551212)
4. Select the check box to allow twitter to send txt messages to your phone and then click Save.
5. This will send a verification code in a txt message to your phone.
6. When the code arrives on your phone, txt the verification code to 40404 (Twitter).
7. All done.

What other options do I need to be aware of?

After your phone is setup, the device tab will look like the one to the right (my cell number blacked out for obvious reasons).

To use txt messaging to update twitter, send your text messages to 40404. Don’t forget that twitter has a 140 character limit.

Using this screen, you can turn the device updates on and off. ONE BIG SETTING is located on this screen. Notice the check box to turn off updates during these hours. This will automatically turn off the txt updates during the time of the day (or night) you select. This will prevent being awakened by a txt message in the middle of the night because someone tweets at 2:30 AM. (right Dean?)

Twitter allows more than an all or nothing setting for receiving txt messages. It allows filtering by individual followings (is that a word?).

It allows the ability to turn txt messages on and off at a person level. You can find & control this information by clicking on the link to see the people you follow.

Then simply turn device updates “On” for the people you desire to receive txt message updates on.

Don’t forget, standard txt message charges apply through your cell phone carrier. Twitter sending the txt messages does not cost anything. Be careful, if you follow a lot of people and they twitter a lot… the quantity of txt messages can add up quick.

Tomorrow’s post will be the final installment of this series (maybe). Stay tuned…