Automating Web App Deployments with SSIS

Posted on

This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar on Automating Web Application Deployments with SSIS. You can find the link on my Presentations page. If you missed the presentation you can view the recording of it here. The zip file includes a readme […]

Share

Pragmatic Tools: DTSxChange (Or DTS Must Die!)

Posted on

Ah DTS packages…they suck. Seriously, it’s 2011. It’s been over a decade and we still have SQL 2000 and DTS packages lingering around our shops…sitting there…taunting us…asking to be upgraded but HOW? There’s SO much work having to learn SSIS, figure out what the current DTS package even does, figure out what shiny new components […]

Share

Pragmatic Tools Week: Task Factory

Posted on

If you’ve ever spent any time doing SSIS development work, you’ll eventually come to a point when developing something and you think to yourself “there has GOT to be an easier way of doing this”. We at Pragmatic Works feel the same way so our team of developer monkey ninjas put together a nifty toolset […]

Share

Pragmatic Tools Week: BIxPress

Posted on

Much like Tim “The Toolman” Taylor had his themed weeks, we’re going to do something similar. This week we salute: (play fanfare music here) the Pragmatic Works BI toolset. Today we’re going to talk about BIxPress. I’ve previously posted on BIxPress and how it helps DBAs out, but the heart of this product is really […]

Share

SQL University: Precedence Constraints

Posted on

Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables between the two in order to complete a unit of work. In today’s class we’re going to continue exploring that data load package and take a look at another critical piece of SSIS that you […]

Share

SQL University: Parents Just Don’t Understand

Posted on

Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship between children and parents. Ever had communication issues with your kids when you ask them to complete a chore? When they’re done, wouldn’t it be nice if they always came back and let you know they […]

Share
Masters BIverse

Be the Master of your Data Warehouse Universe at SQLRally!

Posted on

Do you have a data warehouse initiative in your current organization and looking for a way to learn how to properly build and support it? Would you like to learn how to do this straight from the Masters of the BIverse themselves? Well you’re in luck! Next month at SQLRally there’s going to be a […]

Share

BIxPress 3.0: DBAs Welcome!

Posted on

Much like the USA Network here in the States welcomes characters, I’d like to formally let the world know that BIxPress also welcomes folks, and this time it’s looking at you DBAs out there! You may be thinking, “But Jorge, the product is called BIxpress, why as a DBA would I give a flip about […]

Share
Pragmatic Works logo

Pragmatic Works: The Transition

Posted on

So if you know me via Twitter or my blog you probably know that as of about a month or two ago I joined the fantastic team at Pragmatic Works. This transition was rather significant for me as I would be moving from the world of administration to the development side of SQL Server in being […]

Share

Ascending Mount BI Stack: Basecamp

Posted on

As some of you may know, I’ve recently transitioned over from the fabulous life of being a production DBA to joining the ranks of the BI developers with Pragmatic Works. In the years I’ve been a DBA I’ve often took a quick look and learned stuff from the BI stack here and there simply because […]

Share