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

SQL Server 2016 Polybase Setup

Posted Mar 31, 2016 by Ginger Grant

Thank you to everyone who attended my webinar last week! In that session, I went through all the steps to install SQL Server to be able to use Hadoop, but I thought it might also be a good idea to include them here so you don’t have to watch the video.

Checking for SSIS File Usage with Task Factory's File Properties Task

Posted Mar 30, 2016 by Shawn Harrison

Have you ever had an SSIS package fail because a source file it reads from was opened somewhere else? This can be especially frustrating if the package in question runs after hours or on weekends. In this post, I'll demonstrate how to avoid this issue with the Task Factory File Properties Task, the Task Factory Timer Task and a For Loop container.

Who is Ashley Dains?

Posted Mar 28, 2016 by Liz Hamilton

We're back with the next video in our popular "Who Is" series. If you missed any of the previous interviews, you can watch them here. This series takes an in-depth look at the people that keep Pragmatic Works running and customers happy. Each week, we sit down with a different Pragmatic Works' employee and ask them probing questions to help you get to know them better.

Tales from Sales: Hurdles with Salesforce Connectors in Power BI

Posted Mar 25, 2016 by Jeremy Sirois

In my previous blog post, I shared my initial experience with using Power BI to analyze some transaction trends by customer type. I fully anticipated building upon this solution based off of new questions that arose as I explored the transaction data. That plan has been temporarily delayed since a new analytical challenge was brought up by one of my peers who asked to see a breakdown of revenue by state over a period of time. This new question presented me with an opportunity to use a new visual type in Power BI Desktop, a filled map and slicers. I’m sure I’ll have the chance to get back to expanding the Transaction Size BI Solution, but for now I’m diving into this geography based solution. This kind of redirection or change in reporting priorities is probably very familiar to most data professionals.

Who is Kim Stinehour?

Posted Mar 22, 2016 by Liz Hamilton

We're back with the next video in our popular "Who Is" series. If you missed any of the previous interviews, you can watch them here. This series takes an in-depth look at the people that keep Pragmatic Works running and customers happy. Each week, we sit down with a different Pragmatic Works' employee and ask them probing questions to help you get to know them better.

How to Create a Successful Support Team

Posted Mar 17, 2016 by Haley McKinney

Have you ever worked in a restaurant, call center, or retail store? If so, you may know customer service jobs are not always the easiest. Although not easy, these and similar positions have the opportunity for extreme reward. Helping the customer achieve success, while receiving the best possible experience, is the main goal that our Support Team strives to meet each and every day.

Send Emails in SSIS Using Task Factory's Advanced Email and SMS Task

Posted Mar 16, 2016 by Ken Wood

The Advanced Email and SMS Task from Task Factory is more than just a tool used to send Emails and SMS Text Messages with SSIS. As the name suggests, it’s “Advanced”; of course we can do more with the Advanced Email and SMS Task

Who is Liz Hamilton?

Posted Mar 15, 2016 by Liz Hamilton

We're back with the third video in our "Who Is" series. If you missed the first two videos, you can watch them here. This series takes an in-depth look at the people that keep Pragmatic Works running and customers happy. Each week, we sit down with a different Pragmatic Works' employee and ask them probing questions to help you get to know them better.

Power BI Performance Tips and Techniques

Posted Mar 14, 2016 by Rachael Martino

This post reviews some of the tips and techniques that I covered in my webinar Performance Techniques for Power BI Data Models. To save blog space I have highlighted the first 5 tips from the presentation. There are more tips and techniques, along with expanded explanations and references in the presentation slides.

5 Resources for Women in Tech to Achieve Success

Posted Mar 11, 2016 by Devon Stiles

With only 25% of IT jobs being held by women in the United States, we believe in doing all we can to help pave the way for women in tech. There's a variety of resources, schools and free training programs available to women in tech - if you know where to look. We've compiled a list of some of our favorites for those interested in creating or furthering a career in IT: 

Who is Maggie Goodhart?

Posted Mar 09, 2016 by Liz Hamilton

We're back with the second video in our "Who Is" series. If you missed the first video where we sat down with Support Team Manager Haley McKinney, you can watch it here. This series takes an in-depth look at the people that keep Pragmatic Works running and customers happy. Each week, we sit down with a different Pragmatic Works' employee and ask them probing questions to help you get to know them better,.

Since it is Women in Tech month, we are once again highlighting an amazing woman from our team. In this video, Devin talked with Engagement Manager Maggie Goodhart. Maggie has been in project management for 4 years and is amazing at keeping our team and clients organized. Watch the video below to learn what Maggie has accomplished in her short time with Pragmatic Works, a troubling childhood experience and much more!

Using Task Factory’s REST API Source to Connect to Zendesk

Posted Mar 08, 2016 by Manuel Quintana

Greetings everyone! Today we are going to create an SSIS package using the REST API Source component from Task Factory. Specifically, we are going to use this source component to connect to Zendesk’s API service. When using the REST API Source to connect to any service you must be knowledgeable on how that particular API and what are valid API endpoints.

Who is Haley McKinney?

Posted Mar 03, 2016 by Liz Hamilton

Have you been curious about what employees at Pragmatic Works are really like? You often talk to our employees on the phone or see them in training sessions, but you really don't get to see their true personality. You may not even know what some look like. Never fear! In our latest video series hosted by Devin Knight, we sit down and have one-on-one conversations with the amazing individuals that make up the Pragmatic Works team. You'll get to hear about how they came to Pragmatic Works, their personal professional development tips and even some secret facts about what their life is like outside of Pragmatic Works.

Incrementally Loading Data from Salesforce

Posted Mar 02, 2016 by Brian Knight

As a business owner and someone who is responsible for sales, reporting in SalesForce.com is challenging to say the least. The reporting is tightly restricted to a few objects and the interface can't create the beautiful reports that those in the data industry are used to seeing. Most importantly, I can't merge the data with my existing data sources like data from accounting, HR or our other internal systems. This is why most people pull data from SalesForce.com into a central reporting database to do more advanced reporting. This blog shows you my method for pulling data into a single repository for further reporting.

Pragmatic Works Supports Women in Tech

Posted Mar 01, 2016 by Ashley Dains

It’s no secret that it’s a critical time for women in the tech space. In 2015, women still only make up just over a quarter (26.5%) of tech jobs in the U.S. While industry wide the numbers are, shall we say, disappointing…according to a new report from SmartAsset, there are cities that are showing positive trends of narrowing the gender gap. In fact, our home city of Jacksonville, FL was listed as a city where the gender gap is shrinking with 30.3% of tech jobs in our area are filled by women. How does your city rank?

Subscribe to Blog Updates