November 2009 - Posts

Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements. Those who have used the ROW_NUMBER() , RANK() , DENSE_RANK() , and NTILE() functions on SQL 2005 and 2008, you Read More...

I just received confirmation from Maryland that their vouchers are going quickly as well. The MD Dept. of Labor, Licensing and Regulation reports that their vouchers are being distributed at a very rapid pace and in some distribution channels they have Read More...

Just got confirmation from Missouri on their portion of the "Elevate America" program ( http://www.microsoft.com/About/CorporateCitizenship/us/CommunityInvestment/participatingstatesmap.aspx ). Missouri started passing out vouchers through their Dept. Read More...

Microsoft is partnering with states to distribute 1 million vouchers for training and certification across the country. The program is called "Elevate America" ( http://www.microsoft.com/About/CorporateCitizenship/us/CommunityInvestment/elevateamerica.aspx Read More...

We all know the economy is tough right now. A lot of our fellow professionals are between jobs, or looking for a change. One of the best ways to find good jobs is to network with your peers, and on that note we've started a LinkedIn group -- NYC/North Read More...

Many people have complained about the space tradeoff involved in storing international characters in the database (using nvarchar instead of varchar data types, for instance). A lot of folks decided to go ahead and forego the ability to store international Read More...