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

Bulk Deleting Data from SalesForce.com Using SSIS and Task Factory

Posted Feb 25, 2016 by Brian Knight

One of the most frustrating things about SalesForce.com is the feeling of constantly looking over your shoulder to make sure you don't run out of space. Doing bulk deletion of records in SalesForce.com to fix this issue is done 200 rows at a time and takes a lot of time to setup. While there are many tools out there to help with this issue, the tend to cost quite a bit. This blog and video shows you a quick 4 minute solution to remove tons of rows from SalesForce using a free tool in Visual Studio, Task Factory and SSIS.

Using the Task Factory REST Source with GoToWebinar

Posted Feb 25, 2016 by Shawn Harrison

Today, I'm going to show you an easy way to use REST API calls to bring data into SSIS. Task Factory has a new REST Source that enables users to retrieve data from websites using the REST API. It's a rather powerful source component that can be used in a number of ways. I want to focus on general usage and how to split values into separate columns when retrieving data in JSON format.

Tales from Sales: How I Created My BI Solution and Why I Use Power BI

Posted Feb 22, 2016 by Jeremy Sirois

I am a sales professional - not a formally educated data professional. (I swear!!)

With that being said, my primary focus, here at Pragmatic Works, is to assist my team in generating top-line revenue. In my role, I need to make critical decisions that ensures our sales organization is set up for success – and, ideally, these decisions are supported by data. Fortunately, Pragmatic Works specializes in helping organizations leverage their data to make more informed, intelligent business decisions. To my benefit, I have access to some amazing training resources (the Pragmatic Works Power BI Desktop and Dashboards On-Demand class taught me everything I needed to get started) and talented B.I. professionals that work with data for a living. A virtual thank you to Devin Knight and the Pragmatic Works Virtual Mentoring Team for being available to help me work through this small project!

Top 5 Reasons to Consider HP’s Superdome X

Posted Feb 17, 2016 by Bradley Ball

Hello Dear Reader! Recently we hosted a webinar for Pragmatic Works, Mission Critical Applications SQL Server and Superdome X. The brilliant engineers over at HP invited Pragmatic Works to be the premier partner working with them to execute proof of concept (POC) engagements for clients. This has allowed us to take a close look at the hardware and see where it can really help people.

Performing Joins Within the Salesforce Source from Task Factory

Posted Feb 16, 2016 by Ken Wood

The question has been posed many times, “Is it possible to perform joins with Task Factory’s SalesForce Source component?” The answer is a resounding “YES!” Not only is it possible, but it’s actually very simple.

Why Your Employees Are Not Engaged With Training - The Solutions

Posted Feb 10, 2016 by Devin Knight

In my previous blog, we discussed some of the problems you may be facing that's causing your training efforts to fail. Now you're probably wondering what the solutions to those problems are. If society being easily distracted is the core problem for keeping people engaged, then what’s the solution? What is needed to have attendees leave a training class feeling excited about what they just learned? How can you make students leave feeling like they can actually use what they learned to solve real world problems?  

Let's take a look at ways you can make sure your training endeavors are successful.

Why Your Employees Are Not Engaged With Training – The Problems

Posted Feb 03, 2016 by Devin Knight

Attending a training class should be an exciting experience. You’re learning something new and hopefully something you can actually use. You’re sitting in a room full of people that likely are struggling with the same problems you are and have what should be an expert teaching you how to solve those problems. However, we often find ourselves distracted, bored or even put to sleep. 

Subscribe to Blog Updates