Last Day to Register – Class starts July 1
SSIS Class – Online, 12 Hours/class sessions
Eric Johnson’s class starts July 1 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own shop. There is SO MUCH information packed into this course, it’s unbelievable. Take a look at the class sessions here.
If you’re working with SSIS, or considering it, you can’t go wrong.
Information: SSIS Class – Online, 12 Hours/class sessions
Featured Article(s)
Troubleshooting SQL Server 2008 views
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 views. He also tells how to resolve these problems.
CLR in the Real World
Some last thoughts and feedback on the discussion on the CLR – I did receive more positive than negative on the use of the CLR when it comes to "proper" application of it. So, building functions, doing some of the things we’ve talked about over the last couple of days. There seems to be some solid uses and benefits in those types of of uses. The big suggstion has been to make sure you’re using the right tool for the job. While that seems really obvious, it’s also clear that there are some cases where people didn’t take the time to figure out the right approach and tool.
I’ve also had a couple of notes about utility packs (software) that you can use with your SQL Server(s) that will provide some very cool added leverage for your application development. I have to admit, this was one I hadn’t expected. But in looking at some of these options, it’s worth reviewing. There can be some real help in time and cost savings if the toolsets offer utilities that plug into your work.
Ralph wrote "Not too long ago, I ventured into the use of CLR to develop UDF’s. There was a need to do some modifications of some data and, after listening to the description of the need, I decided to create a CLR UDF to apply a RegEx manipulation of the data. (I now have a small suite of RegEx UDF’s. 😉
There was a lot of "instructional" material on the web but I still had to play around a bit before I finally got everything set up right. Once I did, it was really easy and the follow-up CLR UDF’s I created have been really easy.
Essentially, while I love SQL, there are some things (especially in the area of string manipulations and validations) that it just doesn’t do as well as some other languages. I’ve never been bashful about using another tool if the one I am using isn’t able to do the job as well. Someone once said, "To a man with a hammer, every problem looks like a nail." I just don’t happen to believe that you only need a hammer. (Sometimes you need a screwdriver to keep from really screwing things up, so to speak. 😉
I have yet to venture into CLR Stored Procs, though."