Pragmatic Works Blog

Company blog for some of our Pragmatic Works employee to write about company happenings and about the software business.

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

On 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.

Read More »

Tagged With: Webinar

Object Variable: How to Make Your Packages Dynamic in SSIS

On 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.

Read More »

Tagged With: ssis, Products

Learn About Data Factory at SQLSaturday Phoenix

On 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.

Read More »

Tagged With: SQLSaturday

Learn SSAS From the Ground-Up in Our Austin Workshop

On 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.

Read More »

Tagged With: SSAS

Flashback Friday-I don’t understand SharePoint!

On 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.
Read More »

Tagged With: SharePoint, Power BI

Licensing of Power BI Moves Away From Office 365

On 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. 

Read More »

Tagged With: Power BI

Why You Should Attend SQLSaturday Phoenix

On 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.

Read More »

Tagged With: SQLSaturday

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

On 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:

Read More »

Tagged With: Webinar, ssis, performance tuning

Download Emails & Email Attachments in SSIS

On 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!

Read More »

Tagged With: ssis, Products

Flashback Friday – SSRS, I don’t know where to begin!

On Jan 30, 2015 by Tammye Michau

Getting Started With SSRS 2012

What is SSRS? It almost sounds like a song from the Beatles but it’s not. If you are new to reporting, SQL Server Reporting Services (SSRS) can look complicated. You will find in this video that it’s actually one of the easiest pieces of the BI stack to learn. SSRS 2012 has made some substantial improvements which are covered in this webinar.

Read More »

Tagged With: SSRS

Some of our clients