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 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 ...

I’m heading out to Microsoft and their Redmond campus next week, Feb 15–18.  Feel free to contact me if you want to get together.  I’m not sure on how much time I’ll have, but I’ll try to fit everything in.  No, it isn’t for an interview or anything like that.  I’ve got some free time ...

Michael Otey has an article in the Feb. 2006 SQL Server Magazine called LINQ to the Future along with an online editorial LINQ—The Missing Piece of Database Development where he continually uses the term LINQ, instead of the correct term DLINQ, which will just make things more confusing for the SQL Developer.  Let’s set ...

Melissa announced that the NJSQL group has been accepted as an Offical PASS Chapter, and got some really cool goodies to give away at the next couple meetings.  She is still waiting to hear back from INETA, but I don't really expect any problems there. It also looks like Proclarity  will be presenting at the ...

Here’s an update on my .Net Community Contest.  I’ve decided what I’m doing with my three MSDN Universal subscriptions, and I’m going to give them away to people in the NJ .Net Community that have stepped up to the cause and tried to help grow our little community.  I’ve talked to some other folks that were ...