Using My Favorite Tech Service –http://www.Google.Com.
I Found this Posting for a Proper case T-Sql User Defined Function on Jeff’s SQL Server Blog — Go to the post as it has an port to MySQL and a couple of other ‘ADVANCED’ examples in the comments.
From the original Blog :
I posted this one a long time ago and needed to use it today, so I thought I’d post it up here as well in case anyone finds it useful. This simply attempts to capitalize the first letter of each word for the string passed in. Use it to help clean up some pre-existing data, but don’t use it as a way of presenting your data that is stored improperly since it isn’t exact.�
Read more…
FROM Brian Knight @ pragmaticworks.com
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won’t want to miss out on this free “week of warehousing” webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works. You may attend all five sessions if you wish or register for the sessions independently. Audio is provided either via a phone or over your computer speakers (voice over IP).
In this week of warehousing, you’ll learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you’ll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox (some speakers will be announced next week).
SQLServerCentral.com’s last webinar series had nearly 15,000 registered so register quick for one the morning or afternoon session to claim your spot!
Read more…