What are you doing? that’s a question that you are probably asked dozens of time a day. How many of you use the Facebook status function each day? How many of you use it more than once each day? Well, this year the North Region Jaycees are trying something new and we will be using a free service named Twitter to communicate all kinds of one line answers, event postings, random thoughts, and newsflashes about articles recently added to the Region’s website www.northregionjaycees.com. How can you and your chapter use Twitter? Twitter has many uses such as sending out help requests to all your members while you are already on site project day via a single text message from your cell phone. It could also be used for sending updates to your chapter website and my favorite- keeping members up-to-date with upcoming events. Once they read how much fun you are having, they may want to attend the next time-especially state and national conventions. Twitter’s popularity has exploded over the last year thanks in part to the 2008 Presidential race. Both parties used Twitter to communicate with hundreds of thousands of supporters. Last year, Dell showed that Twitter can be used as a source of income when they generated over a million dollars in sales from the service by posting items for sale.

So the other day my former team member call me asking for help. She had inserted the same data into a table three or more times and needed to get rid of them. For those of you with duplications and need to delete them here’s a little statement i came up with and gave her.

DELETE FROM TBL_Employees

WHERE     (EmpID IN

                          (SELECT     MAX(EmpID) AS Expr2

                            FROM          TBL_Employees

                            GROUP BY FirstName

Each year being in the Jaycees brings something exciting to do and well 2010 is no different. This year in addition to serving on my state’s board and the US Jaycees board I’ve decided to create my own personal challenge for myself. That is to be come a tenth degree Jaycee in the course of the year. The degree program is designed to build great leaders. It starts off at with the basics getting a person socially involved to develop the social and networking skills and then progress over time to the point of where the person is heading up committees, chapter, districts, and states. Most of the things identified in the degrees program I’ve done of the last three years but where I come from we didn’t participate in the degree program and we produce great leaders still.

From time to time i run into problems of where some new table appears on m  server and starts eating up all my space. Well i came across this blog posting a while back that does a great job of explaining how to determine the table sizes in a database in SQL 2000 it works in 2005 too.  check it out and let me know what you think.  http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx

Earlier this month i attended my first SQL meetup called SQL Saturday #31 i’m not sure why it’s numbered  31 cause i realized they don’t go in order. But yeah so it was hosted in Elk Grove so it wasn’t to far away. I knew it was going to be a awesome day when i met this guy in the registration line who reads my site and learned a couple SQL tricks from it. How sweet is that right? So SQL Saturday is put on by the Professional Association for SQL Server and ran by volunteers.

I got a request for a report the other day so I built this massive 90 line SQL statement to pull all the data requested. So I sent off a copy of the data report and the guy tells me that he needs the date formatted (YYYYMMDD) instead of (YYYY-MM-DD-HHMMSS) and then he was like is that going to be a problem and I was like ha not really. Give me a moment and I’ll send you a simple. Since I can’t remember the correct expression I did a quick Google search and came across this awesome page http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/ covering exactly what I was looking for.