Don Xml's Grok This

I've always been a stickler about matters relating to building proper data access layers, and one of the areas that seems to get overlooked has been around proper creation of stored procedure parameters.  Back in .Net 1.0 and 1.1 I built a data access layer on top of the Data Access Application Block that handled the creation of stored ...

I finally got around to upgrading the NJSQL site from CommunityServer 1.1 to 2.1.  Melissa has been (rightfully) after me to clean up the site, and make it look a lot more professional (and a place the New Jersey SQL Server community can call home).  I also took the time to reskin the site (much, much easier in ...

I recently ran across a funky error when trying to upgrade one of my machines to SQL Server 2005 SP1.  KB article 918357 helped me resolve it, but it does require a little registry editing.  Seems as though, if you have both SQL Server 2005 and SQL Server 2005 Express edition installed on the same machine, and you happen to update ...

The NJ SQL Server User Group is hosting a very special user group meeting on August 15th, courtesy of INETA ...... Presentation:  "SQL Server 2005 CLR Executables" with Bill Vaughn. Bill Vaughn is an industry-recognized author, mentor and subject-matter expert on Visual Studio, SQL Server and data access interfaces.  The ...

If you are looking for Intellisense for your SQL statements, look no further then SQL Prompt by RedGate, and the folks at RedGate just announced that you will be able to download SQL Prompt free of charge until Sept. 1, 2006 (with no timebombs or restrictions).  SQL Prompt will work with Microsoft Query Analyzer, SQL Server 2005 ...

Disclaimer: I do not work for Microsoft, but I am a Microsoft MVP.  The following is all derived from public information, and any inferences or extrapolations are entirely the work of my imagination, and is not something that I know that Microsoft is working on.  If I knew Microsoft was working on things like this, it would be covered ...

I announced this about a week ago on the NJ Code Camp site, but I’ll put it up here to help get the word out. The next New Jersey Code Camp will be held on Saturday, June 3rd at the Microsoft office in Iselin, NJ (the same place as the first one). We are currently looking for presenters, so please send your abstracts (download the form ...

The NJ SQL Server User Group’s May meeting will be on May 16th, and features Kent Tegels (a SQL Server MVP, my friend, and a trainer with DevelopMentor).  His presentation is titled "10 Must Know Things About XML in SQL Server 2005"  (like I said he is a friend of mine, with a title like that, who could not ...

Hilary Cotter, the author of the book, A Guide to SQL Server 2000 Transactional and Snapshot Replication (and master of all things SQL Server replication) will be the presenter at the March 2006 NJSQL meeting, discussing, what else, SQL Server replication.  Hilary is a local NJ SQL Server Microsoft MVP, and knows a lot more than ...

Chris Webb has an older blog entry that I missed somehow, OLAP Jokes.  Here are a couple just to tempt you to read the rest: Q: Why did the dimension go to prison? A: Because it was degenerate   A cube walks into a bar, pops himself on a bar stool and says ''Whisky please''. ''Double?'' says the barman ''No thanks replies the ...