February 3, 2009
I am getting ready to upgrade an existing SQL 2005 application and have found the following SQL 2008 features worth more exploration:
INSERT (Transact-SQL Row Constructors) – Allows the ability to add one or more new rows to a table or a view. Seems novel but not sure how useful in practice.
MERGE Statement. This new Transact-SQL statement performs [...]
Read the full article →
February 3, 2009
How to Prepare for Certification Exams
Most people find it essential to establish some special time for learning. Be sure to set it for when you learn best … in the morning, early evening, etc., and stick to your schedule.
Use an effective method of study. Your own plan, if effective, is good. If yours didn’t work, [...]
Read the full article →