<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Works Blog

Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.

Highlighting Women in Tech: March Free Training on the T's Webinars

Posted Feb 27, 2015 by Liz Hamilton

Every year in March, the National Women's History Project celebrates Women in History Month. This year's theme is focusing on weaving the stories of women's lives and the impact they've had individually and as a whole on our nation's history. For centuries, women have been contributors in technology, and they've made a significant impression on the field.

Ada Lovelace is attributed with creating what many consider to be the first computer program in 1840.  In 1946, Dr. Grace Hopper helped develop the Eniac, one of the first electronic digital computers. By the 1960s, women held 30 to 50% of programming jobs; however, that percentage has since decreased.

Today, women make up only 25% of the data technology field in totality. At Pragmatic Works, our staff consists of approximately 20% women  not unusual according to the book Women in Data.

Object Variable: How to Make Your Packages Dynamic in SSIS

Posted Feb 23, 2015 by Manuel Quintana

Greetings everyone, and thank you for taking the time to look at this blog. This is my first post and I hope I’m able to answer some of your questions about building packages in SSIS. In this post I will be showing you how to use the object variable to make packages dynamic while using Task Factory, a SSIS product by Pragmatic Works.

Learn About Data Factory at SQLSaturday Phoenix

Posted Feb 19, 2015 by Josh Luedeman

I have been speaking a lot over the past year. Much more than I have spoken in years past. I’ve moving from town to town like a ninja, speaking at SQLSaturdays. SQLSaturdays are free training events that are held internationally, where speakers like myself and others, come to town and speak on a multitude of subjects relating to SQL Server. On February 28th, 2015, I will be speaking at SQLSaturday #370 in Phoenix, AZ.

Learn SSAS From the Ground-Up in Our Austin Workshop

Posted Feb 18, 2015 by Liz Hamilton

Starting February 24th, Chris Albrektson & Devin Knight will be teaching an intro to SQL Server Analysis Services (SSAS) workshop. This two full day event it will be packed with both Multi-Dimensional and Tabular/PowerPivot demos and exercises.

It will be an in person workshop at the Microsoft office in Austin, Texas. The workshop is on February 24th & 25th and is available for only $399.

Flashback Friday-I don’t understand SharePoint!

Posted Feb 13, 2015 by Tammye Michau

Introduction to SharePoint BI

Feeling overwhelmed that you have data that you want to organize and share with others but you can’t? We have a solution for you!  Brad Schacht hosted a webinar called Introduction to SharePoint BI that will teach you how to install SharePoint 2010 and give you basic setup guidance for your farm.

Licensing of Power BI Moves Away From Office 365

Posted Feb 11, 2015 by Ginger Grant

The gap between Power BI and Excel keeps on getting wider. As there is conflicting information about the Excel/Power BI break-up on various places on the internet, I wanted to clarify some of the common discussion questions. 

Why You Should Attend SQLSaturday Phoenix

Posted Feb 05, 2015 by Ginger Grant

It can be very difficult to keep up with the increasing number of changes in technology. There are so many things changing with the move to the cloud, data storage and access, self-service visualization tools and not to mention the many enhancements Microsoft has made in the latest versions of SQL Server. One place where it is possible to drink from the fire hose, so to speak, is at SQLSaturday events. Being able to find things out from the people who literally wrote the book on SQL Server, well technically wrote a bunch of books, is a great opportunity to catch up on a lot of new technology.

Webinar Follow Up - Help, My SSIS packages need a performance tune up!

Posted Feb 04, 2015 by Tammye Michau

SSIS Performance Tuning Tips and Tricks

On Tuesday we hosted the SSIS Performance Tuning Tips and Tricks webinar with James Phillips.  He showed us how to tune up our SSIS packages to make them perform better, faster, and more efficiently. 

Through demonstrations, we were given insight on what to avoid when setting up packages.  James stated you could speed up the performance of your packages by avoiding:

Download Emails & Email Attachments in SSIS

Posted Feb 03, 2015 by Mitchell Pearson

Ever need to download emails and attachments using SSIS? If so you have come to right the place. Task Factory, a suite of custom SSIS components by Pragmatic Works has a component called the Email Source. This feature allows you to pull content directly from an email into a data flow.The component supports both POP3 and IMAP and is really easy to set up, so let’s get started!

Subscribe to Blog Updates