20121003200545.jpg

T-SQL Tuesday #75: Jump into Power BI

Posted on

So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it yet, is Microsoft’s analytics and visualization solution. This month I challenged everyone to create their own Power BI report and share it with the world via […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]