Everyone once in a while I'll run across a requirement for me to generate a bunch of junk data for the sole purpose of performance testing or benchmarking. There are plenty of ways that I could generate my test data, including clever TSQL scripts or a Data Flow Script Component as a source. And those methods work well, but are somewhat limited if I need to generate Unicode string data for testing. But that's where Task Factory comes in. Included in the latest release of Task Factory is the Place...
Read More
In the last few months, I've been giving a preview on some of the new advanced SSIS tasks and transforms being released in the coming version of Task Factory. Well Task Factory 3.0 has finally been released last month, and its packed with a ton of really cool tasks and transforms that are going to make SSIS development easier and will increase the performance of your packages. One of the newest SSIS tasks released in Task Factory 3.0 is the Advanced Execute Package task. The really cool part abo...
So what is the difference between NON EMPTY and Nonempty()? I've had this question asked several times and have been meaning to blog it for a little while but here's me just getting around to it. So let's jump right in. We have two queries we're going to take a look at it in order for us to better understand the difference between NON EMPTY and Nonempty(). Behold our first very boring query: SELECT ([Date].[Calendar Year].&[2005]) ON 0, NON EMPTY ([Date].[Calendar Quarter of Year].members) O...