Error Handling Techniques In my opinion, Error handling is one of most important skills in enterprise level software. Often, handling errors is an afterthought, and is enhanced more often through need to debug code rather than a planned approach. I like to think of error handling with a few different dynamics. Managing the Proccess Flow Continue Processing Stop the process […]

Merge Comments Today I had a number of comments regarding an SQL merge process. Jason: If you do the update first you have X rows in the table that it has to evaluate to join on. Now when you delete you still have X rows to join on. I believe you said you do the insert after the update so […]

SSWUGtv With Stephen Wynkoop In this Special Edition, Leon Guzenda from Objectivity DB joins us to talk about Big Data, some real applications for it and the history behind this kind of massive data procession. Really interesting applications of this technology. Watch the Show Merge Feedback We had a couple responses from the Merge conversation raised in the newsletter yesterday. […]

SQL Merge One typical task of an SQL developer is to merge two sets of data. For example, you may have a data entry screen where users may modify existing data, delete rows, and insert rows into the same set. Then you wish to merge these modifications with the existing set of data in your relational database. There are a […]

Featured Article(s) Troubleshooting SQL Server 2008 performance counters problems In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2008 performance counters. He also tells how you can resolve these problems.SQL Server 2012 Release – Beginning to Understand the Changes SQL Server 2012 brings a while series of changes to the platform, from more crystalized […]