SentryOne Acquires Pragmatic Works Software
We have some exciting news to share with you! We want our loyal customers to be one of the first to know that Pragmatic Works...
Automating Your ETL - Creating a SQL Agent Job
The amount of data companies receive is growing larger all the time. Oftentimes, manual executing is just not efficient....
What's Going on in March?
The past few months have flown by and spring is right around the corner! Our busy team has kept the momentum going, offering a...
What's Going on in February?
February may be a short month, but it is jam-packed and full of events, including a new On-Demand Training course, multiple...
Quickly Import and Export Data from Any Web RESTful API Source
If you’re like most businesses, it’s become increasingly important to be able to get data from, or write data to, web RESTful...
Clean Up Your Client Address Database
One of the most valuable assets to your company is your customer database. Do you know that bad data in your client addresses...
Moving Files Between Folders in Your FTP Server
Downloading? Simple. Uploading? A cinch. Moving files between folders? Easy enough when I’m looking at it on the server, but...
How to Easily Declutter Your Inbox
We clean our rooms, we clean out the garage, we even have Spring cleaning, but how many of us can say that we keep a clean...
What's Going On in January?
Happy 2018! We're ringing in the new year with another half day virtual workshop, this time focusing on SSIS. Our virtual...
Getting More Done in Less Time with SSIS (MS SQL Server Integration Services)
In a blog post by Jason Brooks, he describes his love of Task Factory and its components that have helped him save time on...
Our SSIS Components Execute 3,000% Faster Than Yours!
Are you tired of the pitfalls and slow running of native SSIS components? Would you like to have your SSIS components execute...
What's Going On in December?
Happy Holidays to all! This month, we're in the spirit of saving. December kicks off with our On-Demand Training Sale, offering...
What's Going On in November?
We're kicking off the month exhibiting at PASS Summit 2017 in Seattle, WA and hosting our 6th annual SQL Karaoke event, often...
Easily Handle Transform and Load of SCD2 (Type 2 Slowly Changing Dimensions)
This blog post is about type two slowly changing dimensions (SCD2). This is when an attribute change in row 1 results in SSIS...
Easily Mark Deleted Source System Rows in a Data Warehouse Table
Even though many people think data warehouses ETLs (extract, transform and load) should contain insert data flows only, the...
Incorporate Information from Survey Monkey Using REST Source
If you use Survey Monkey, are you looking for an easier way to get and utilize that information for your business? Survey...
I Can Load a Data Warehouse 700x Faster Than You
Not only does our data analyst, Achara McNair-Tarfa, claim to upsert 700x faster, but she also claims that she can load a data...
I Can Upsert 700x Faster Than You!
Would you like to upsert (conditionally insert and update data) faster? How about 700x faster? Our data analyst, Achara...
My Data is Cleaner Than Yours!
Can you confidently claim that your data is clean? Our Data Analyst, Achara McNair-Tarfa, claims that her data is cleaner than...
Top 5 SSIS Tips
In a previous blog post, Pragmatic Works Data Analyst, Achara McNair-Tarfa, told us why she hates SSIS. She revisited with...
Leave a comment