Will you be in Edmonton today? How about near a computer connected to the inter-tubes? If so, you might be interested in joining the EDMPASS January user group meeting. Colin Stasiuk (Blog | @BenchmarkIT) invited me to join the meeting today. The details for the meeting are Start Time: Wednesday, Jan 26, 2011 6:00 PM … Continue reading Presenting on #SSIS to EDMPASS Today
One day at a time and we have reached the twenty-fifth post in the 31 Days of SSIS. If you enjoy this post, take a look at other posts in this series. They can be found through the introductory post. Yesterday’s post demonstrated an SSIS package that connected one package to unlimited databases. For today, … Continue reading 31 Days of SSIS – One Package, Unlimited Tables (25/31)
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert blog series. When working with the exist() method you may not always want to hardcode in the attribute values that you … Continue reading XQuery for the Non-Expert – @Variable Use
Week five and it seems like time is going by faster than I had expected it would. As I mentioned in the first post, I've already failed this exam once and am not really up for failing again. This week our MCM study group has decided to read the following items and discuss them at … Continue reading MCM Live Blog – Week January 10
If you are up in Edmonton around January 26th, you can hear my voice at the EDMPASS January user group meeting. Colin Stasiuk (Blog | @BenchmarkIT) invited me to join the meeting and I’ll be presenting on SSIS to their group. It seems to be good timing since I have the 31 Days of SSIS … Continue reading Speaking at EDMPASS This Month
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the value() method post of my XQuery for the Non-Expert series I discussed how to take element and attributes and return them as column values. Those methods works all fine and dandy for most data but when … Continue reading XQuery for the Non-Expert – Binary Values
Surprisingly it's now my fourth week of blogging about the things that I'm doing to study for the MCM exam. The holidays are finally over. Client deployments are theoretically over. Now I am hoping to button down and get to some real hardcore studying. As I mentioned in the first post, I've already failed this … Continue reading MCM Live Blog – Week January 3
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Within the value() and query() methods it is sometimes desirable to return a portion of a string. Similar to T-SQL, there is a substring function in XQuery that provides this functionality. In this XQuery for the Non-Expert post … Continue reading XQuery for the Non-Expert – Substring() Function
Time for the third week of blogging about the things that I'm doing to study for the MCM exam. Last week wasn't too spectacular - with the holidays and all I was pretty lazy on the studying. The formatting issues did get fixed, so if you see anything messed up send me a message. As … Continue reading MCM Live Blog – Week December 27
Time for the second week of blogging about the things that I'm doing to study for the MCM exam. It seemed to go pretty good last week except for the whole screwing up the TweetMeme and ShareThis plugins on my blog. As I mentioned in the first post, I've already failed this exam once and am … Continue reading MCM Live Blog – Week December 20
Strate SQL 