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
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In yesterday’s post I talked about Using Breakpoints. One of the points I stressed was that breakpoints only exist in the Control Flow and not in the Data Flow. Today, I’m going to show you that I’m a liar. But not really. … Continue reading 31 Days of SSIS – Data Flow Breakpoints?! (3/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Today’s post is going to deal with one of the pieces within SSIS that is often overlooked with troubleshooting SSIS packages. This is the ability to set Breakpoints in SSIS packages. Much like running projects in other languages through Visual Studio, you … Continue reading 31 Days of SSIS – Using Breakpoints (2/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a SSIS file format that I was unaware of until just over a year ago. As the title already gives away - this file format is the raw file format. And it is awesome! You’ve heard … Continue reading 31 Days of SSIS – Raw Files Are Awesome (1/31)
Update: You can now purchase this content as a Kindle book here - 31 Days of SSIS with SQL Server 2008 R2 Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A Day. Since then there have been two other series that followed a similar concept - … Continue reading 31 Days of SSIS – The Introduction
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
We’re up to the seventh post on the in the plan cache series. This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element. StmtSimple, commonly referred to as statement simple, can contain the plan information for a query plan, a store procedure, or a user … Continue reading Can You Dig It? – StmtSimple Element
If you are in Minnesota and are looking for a new job, Digineer is hiring. Heck you can even be one of those that has been thinking – “I would love to move to Minnesota because I love the thought of their frigid winters” – and need that job to get that move started, Digineer … Continue reading Digineer Is Hiring
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
Strate SQL 