Pragmatic Works

Recently I had a client that wanted to load an Excel File from a SQL query from an SSIS package. Since the Data Flows in SSIS are pretty rigid in terms of columns and data types it can not just add or delete columns on the fly. So I developed a script...

My blog and all of the other pragmatic works blogs have moved to http://blogs.pragmaticworks.com/ . My blog is at http://blogs.pragmaticworks.com/mike_davis/ .

We’ve had some major issues with our blog software and we’ve made the cut over to a new system. You can now catch me at http://blogs.pragmaticworks.com/Brian_Knight . My RSS feed has been moved to http://blogs.pragmaticworks.com/brian_knight/atom.xml...

Again we’ve learned that combining alcohol and SSIS training videos is a very bad combination. We’ve now launch a new series of fun videos that teach you SSIS in a very interesting way. Let us know what you think as we’re not sure we hit the mark with...

We’re looking for a number of product suggestions where you’d like to see our product grow into. Once your suggestion is made, it goes into the list to be voted on by the user community. If you’re one of the first 5 ideas to be accepted and we begin work...

Last night, I upgraded to Windows 7 from Windows Vista on my Dell Latitude D830. It was probably the easiest installation I’ve ever made. It asked me the license number and then a few hours later, it was upgraded. That said, the wizard did reject me a...

Jacksonville, Fla.—  Today, Pragmatic Works Software™, www.pragmaticworks.com provider of business intelligence solutions that complement Microsoft SQL Server announced today they have opened a new office in Haverhill, Massachusetts, as part of a...

BI xPress has now released tonight, which gives you all the benefits of a mature auditing, notification and SOX framework for your SSIS packages without having to code! This is a framework we’ve been working on more than a year and have implemented it...

I received a shipment of Thrive Cards to giveaway for SQL Saturday. A Thrive Card is a generous Microsoft card that gives you either a free certification test or a subscription to TechNet Direct for 1 year (includes pretty much all the software that Microsoft...

I’m excited the announce that the schedule for SQL Saturday #15 in Jacksonville has now been posted here . Thanks to all the great speakers who have volunteered their time to come to Jacksonville. You can register for SQL Saturday for free by going to...

Service Pack 1 for SQL Server 2008 has now officially released and can be downloaded here .  This is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported from the...

Recently I was working with client and they were discussing the pet peeves of some of the new intellisense features in SSMS. Now, Intellisense is a powerful tool to help developers be more efficient, but for professionals who haven’t had it for the last...

  The first Pragmatic Works Foundation class concluded today and I think it was a great success!  Each student did very well and I’m confident that each of them will be able to land their first IT job.  We only had one week to cram about...

The final reason to manually migrate DTS packages to SSIS. You can see the entire series by Dustin Ryan at Pragmatically Speaking .

:) Another cartoon in our series by Dustin Ryan at Pragmatically Speaking .