Online Color IQ Test
How well do you see color? Try the free online color IQ test to determine if you are 1 out of 255 women or 1 out of 12 men that have some form of color vision deficiency.
My score in case you were curious:
How to delete/drop/select all the tables from SQL Server Database?
I stumbled on a thread at MSDN titled “How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?” when trying to look for a way to drop all tables from a SQL server database.
Here are some of the nuggets from the thread:
1) How to drop all tables from the database
EXEC sp_MSforeachtable @command1 = “DROP TABLE ?”
2) How to delete all data from all the tables in the database
EXEC sp_MSforeachtable @command1 = “DELETE FROM ?”
3) How to truncate all data from all the tables in the database
EXEC sp_MSforeachtable @command1 = “TRUNCATE TABLE ?”
4) How to select all the rows from all the tables in the database
EXEC sp_MSforeachtable @command1 = “SELECT * FROM ?”
5) How to print the names and owners of all the tables in the database
EXEC sp_MSforeachtable @command1 = “PRINT ’?'” –Just print the tables names with owner(dbo)
Some caveats, like referential integrity rules and foreign keys references will have to be kept in mind when attempting to truncate data. Also, some of the changes can not be rolled back.
Facebook Chat with Pidgin
Earlier this month Facebook announced that their chat feature now supports XMPP (Extensible Messaging and Presence Protocol). What I truly appreciate about Facebook’s support for XMPP is how they have integrated the Friends Lists to selectively decide which friends show up online.
To connect to Facebook Chat from Pidgin follow the instructions below:
1) Create your Facebook username by going to http://www.facebook.com/username
2) Open Pidgin
3) Click Accounts
4) Click Manage Accounts and you should see the following appear:
5) Click Add
6) Set the following options under the Basic tab:
Protocol: XMPP
Username: Username you created in Step 1
Domain: chat.facebook.com
Password: Enter your password
6) Set the following options under the Advanced tab
Require SSL/TLS: Unchecked
Connect port: 5222
Connect server: chat.facebook.com
7) Click Save
Paddington Station Lansdowne
Paddington Station is now open!
Indeed, downtown Lansdowne now has a new antiques store. They still don’t have a website setup (perhaps I’ll drop them a line and offer my services) but in the mean time call (484) 461-7770 for store hours, or e-mail the store owners at paddingtonstation@rcn.com for more information, or stop by the store at 12 S. Lansdowne Ave. Lansdowne PA.
Windows 7 Admin Mode
A nice tip from Paul Thurrott regarding a hidden feature in Windows 7. In essence, following the instructions below provides you with an easy way to update a number of settings in Windows 7.
To enable it:
- Create a new folder on your desktop (i.e. Right-click and click on New Folder).
- Right-click on the folder and click on Rename
- Copy and paste the following as the file name:SuperAdmin.{ED7BA470-8E54-465E-825C-99712043E01C}
(As a side note, you can replace SuperAdmin with any other word of your choice)
- Double click on the folder and you should see the following list of choices:
Mansfield Brass Quintet
The Mansfield Brass Quintet will be playing its annual evening of traditional holiday music on Saturday, December 19, 2009 from 6:00 p.m. to 8:00 p.m.. Consisting of two trumpets, a trombone, a tuba, and a French horn, the group begins caroling at the corner of Mansfield and Madison Roads, proceeds down Madison, continues up Walsh to the Manor’s Christmas tree and finally down Mansfield to Madison ending its tour of the Gladstone Manor in the cul-de-sac at the intersection of East and West Windermere Terraces. The group stops to play under the Gladstone Manor’s historic street lights and at the Gladstone Manor Holiday tree. This year, as last, the Mansfield Brass will be joined by carolers.
Recent Comments