Archives: September 2009
So you’ve got some packages that regularly extract data to one or more text files, but you know that from time to time some of the queries will not return any data. However, you find in SSIS that, in a flat file export package, the output file is created regardless… Read more
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup transformation (a good review can be found here). In a nutshell, a comparison using the lookup transformation is case sensitive when using the default setting of Full Cache, even… Read more
It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest starting school this year, it was time to add another computer to our inventory. Since my son’s computer needs are relatively minimal at this point, I decided to buy a… Read more
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit the nail on the head with respect to taking charge of one’s own career. I won’t belabor the point by repeating their words here, but the message… Read more
I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. Last weekend, I made the leap to Windows 7 RTM. So far so good!
I was more than a little surprised to find out that there was no upgrade… Read more
In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence. For October, I have the pleasure of presenting for SQL Lunch, a new online learning series pioneered by Patrick LeBlanc. On October 12th, I’ll be discussing ways to leverage SQL Server… Read more
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given list of items (files in a directory, nodes in an XML file, static list of values, etc.) and will perform some operation for each of the items in the… Read more
The monthly North Texas SQL Server User Group (NTSSUG) meeting will be held this Thursday, September 17, at 7:00pm at the Microsoft campus in Irving, Texas. Our guest will be SQL Server MVP and consultant Geoff Hiten, who will be presenting “Bad SQL - Why Does This "Perfectly Good" T-SQL… Read more
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path as a database professional, including some notes from my own journey. In this final segment, I’ll share a few discrete tips that will hopefully be useful to those… Read more
Just a quick update on the SQL Saturday event we are planning for the Dallas area next year. Late last week our local event planning committee met to discuss the big stuff (venue, date, and advertising) and came away with a short but critical action list.
We’ve got a venue… Read more
I see a lot of questions on the forums about updating existing data in SSIS. When the update is dynamic and is based on elements within your data flow, a common mistake is to use the Ole DB Command within the data flow pane:
The above poorly designed update… Read more
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that it’s difficult to get better at what you do without periodic evaluations of your performances.
It’s only been a few years since I committed to start speaking publicly to share… Read more
At times it felt like a party, it had enough content to be a mini-conference, and we learned that some people get a little punchy after 24 straight hours of SQL Server. Regardless if you were a presenter, a casual observer, or stayed engaged for the whole event, the 24… Read more
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly staying away from the Twitter/LinkedIn/Facebook circles. We’ve had 3 of 4 family members who have fallen ill in the last week (myself included), and we’ve been prepping for the baby… Read more