Pragmatic Works Blog

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

Introducing BI xPress Server

On Jan 26, 2015 by Liz Hamilton

We are exicted to announce the launch of BI xPress Server! BI xPress Server joins the DOC xPress Server in our Workbench Server line of products. Our line of server products gives your business and technical users access to your company's data, without requiring them to have a desktop installation. 

Read More »

Tagged With: Company Info, Products

Free Training on T’s – Tabular and PowerPivot Feature Limitations

On Jan 23, 2015 by Tammye Michau

On Thursday we hosted the Tabular and Power Pivot Feature Limitations webinar with Brad Schacht.  He took us through the various Tabular and Multidimensional differences, as well as a work around for features that are not supported in Tabular.  This webinar is sure to assist you in making an informed decision as to which product you want to use based on your needs to get the best information in your PowerPivot.

Read More »

Tagged With: Webinar, SSAS

Employee Spotlight-Brad Schacht

On Jan 21, 2015 by Liz Hamilton

Since Pragmatic Works has so many amazing employees we've decided to put them in the limelight. Our employees are what make Pragmatic Works successful and we wouldn't succeed without them. Each month we will be highlighting a stellar employee that often goes above and beyond the call of duty. It's a small way we can say thanks for everything they do. 

Read More »

Tagged With: SharePoint, ssis, Company Info

Flashback Friday-SSIS ETL for Beginners

On Jan 16, 2015 by Tammye Michau

Flashback-Friday-Banner-Animated-lg

I can’t connect my package…never fear Brad Schacht to the rescue!

So you want to connect your SSIS package to Excel, SQL Server, Oracle and some Flat Files but you just can’t seem to get it to work. No worries! Our superhero consultant, Brad Schacht, will help break things down and show you how to make these connections one by one. Brad will show some of his super powers in ways that will assist you with using SSIS to do a simple data dump, how to keep tables in sync, and how to do incremental loads. 

Read More »

Tagged With: SQL Server, ssis, ETL, Excel

Join Us at SQLSaturday Nashville

On Jan 15, 2015 by Liz Hamilton

We are so excited that SQLSaturday Nashville is this weekend! The event will be held Jan 17, 2015 at Lipscomb University; One University Park Drive, Nashville, TN 37204. SQLSaturday Nashville brings together SQL Server professional and those wanting to learn about SQL server togther.

Six of Pragmatic Works' consultants will be presenting on Saturday. Below is a list of their sessions and you can can receive more information about each one by clicking on the title.

Read More »

Tagged With: Company Info, SQLSaturday

Webinar Follow-Up: Intro to Data Factory

On Jan 13, 2015 by Steve Hughes

This is a follow up blog post based on the Intro to Data Factory session I gave on the Training on the T’s with Pragmatic Works. Find more free training from the past and upcoming here. I did my session on January 13, 2015.

In this session, I gave a simple introduction to new Azure Data Factory using a CopyActivity pipeline between Azure Blob Storage and Azure SQL Database. Below is a diagram illustrating the factory that is created in the demo.

Read More »

Tagged With: Azure

Webinar Follow-Up: Data Analytics & Distribution with Power BI

On Jan 12, 2015 by Ginger Grant

Thank you to all of the people who took the time to view my session on Data Analytics and Distribution with Power BI. I really enjoy getting the chance to decrease the confusion I hear regarding Power BI, and hope that you will find the question and answer section helpful if you are trying to learn more about the product.

Read More »

Tagged With: Power BI

Intro to Big Data Analytics Demo

On Jan 09, 2015 by Liz Hamilton

Back in December Pragmatic Works' BI Consultant, Alan Faulkner, did a presentation on Intro to Big Data AnalyticsIn this session he introduced the Hadoop-based services in Windows Azure and used PowerBI features to build a self-service BI Big Data solution. Now we are offering you an outline and demo to accompany his presentation.

Read More »

Tagged With: Big Data, Hive, HDInsight

January Free Training Schedule

On Jan 06, 2015 by Liz Hamilton

Every week Pragmatic Works hosts free webinars on a wide range of topics that include Power BI, Performance Tuning and many other SQL Server topics. Join our industry experts every Tuesday and Thursday (and sometimes other days) at 11 a.m. EST to expand your SQL Server knowledge!

Read More »

Tagged With: Webinar, Company Info

Flashback Friday-The T-SQL Golden Egg

On Jan 02, 2015 by Tammye Michau

Flashback-Friday-Banner-Animated-lg

Which comes first the Chicken or the Egg?

It doesn’t really matter which comes first in this instance, it’s more about the egg. In this particular webinar Kathy Kellenberger is going to tell us how to cook our egg, in a matter of speaking. Let’s just assume that the webinar, “Get Started with T-SQL SELECT Part 1” teaches about how to take care of the chicken to get her to lay an egg.  

Read More »

Tagged With: SQL Server, T-SQL

Some of our clients