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
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to re-cap so that leaves this post fairly open ended. At some point a couple years ago I read an article about not publicizing your resolutions to help keep you on track. Now, though, since I don’t … Continue reading Wrapping Up 2010
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
Want to learn some stuff about SSIS? Want to do it from the couch and not have to get up for the whole morning? If so or if the two opening questions intrigued you enough to get this far – then I have the answer for you. SSWUG is offering a half day virtual conference … Continue reading SSWUG Free SSIS Expo
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of those people submitting a session. I’m not going to be a pot calling the kettle black. Below are the two sessions that I submitted. Hopefully they will appeal to enough people that I’ll get a … Continue reading SQLRally Session Submissions
Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the upcoming SQLRally! Some details if you are on the unawares – SQLRally is a 3-day SQL Server conference that will occur in Orlando, FL. Unlike the PASS Summit, SQLRally will be capped to 500 people. … Continue reading Last Call SQLRally Call for Presenters
Strate SQL 