A common question on the newsgroups is ''how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?'' I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks ago. I won’t get into the details, but the answers all pretty much say the same thing -- ...

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 already know how useful they are.  They simplify code and can improve performance ...

The NJSQL user group is hosting a one-day Saturday SQL Server event at the Microsoft Iselin offices.  On October 24th Jacob Sebastian, Robert Pearl and I will be presenting on the following SQL Server topics: * T-SQL Defensive coding and exception handling best practices* Database forensics in SQL Server (''Who did it and ran?'')* SQL Server ...