Pragmatic Works Blog

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

Come See Our Team at SQLSaturday Jacksonville

On Apr 23, 2015 by Liz Hamilton

SQLSaturday Jacksonville is right around the corner, and we are so excited for it! It seems that almost the entire Pragmatic Works' Jacksonville office will be participating in the conference, and they are presenting on some great topics.

SQLSaturday Jacksonville will be held Saturday, May 9, 2015, at the University of North Florida Campus, Main Campus, 1 UNF Drive, Jacksonville, FL 32224, Building 50. 

Additional precon sessions will be held at UNF on Friday, May 8, 2015.

Read More »

Tagged With: Company Info, SQLSaturday

Table Partitioning in SQL Server – The Basics

On Apr 21, 2015 by Cathrine Wilhelmsen

There are many benefits of partitioning large tables. You can speed up loading and archiving of data, you can perform maintenance operations on individual partitions instead of the whole table, and you may be able to improve query performance. However, implementing table partitioning is not a trivial task and you need a good understanding of how it works to implement and use it correctly.Table Partitioning is an Enterprise Edition feature only.

Read More »

Tagged With: SQL Server

Azure ML, SSIS and the Modern Data Warehouse

On Apr 17, 2015 by Ginger Grant

Recently I was afforded the opportunity to speak at several different events, all of which I thoroughly enjoyed. I was able to speak on Azure Machine Learning first at the Arizona SQL Server Users Group meeting. I really appreciate all who attended as we had quite a crowd. Since the meeting is held practically on Arizona State University’s Tempe Campus, it was great to see a number of students attending, most likely due to Ram’s continued marketing efforts on meetup.com. After talking to him about it, I was impressed at his success at improving attendance by promoting the event on Meetup, and wonder if many SQL Server User Groups have experienced the same benefits. If you have, please let me know. Thanks Joe for taking a picture of the event too.

Read More »

Tagged With: Azure, ssis, SQLSaturday, Data Warehouse

Creating a Simple Report with Power Query and Power View

On Apr 16, 2015 by Shawn Harrison

In this tutorial, I will show you how to pull data into Excel using Power Query and then put together a simple report with Power View. While you can get rather elaborate with these tools, this tutorial will begin with a simple focus. I am going to create a report that displays sales amounts from different countries over a period years.

Read More »

Tagged With: Power BI

Power Query – Controlling M Query Functions with User Driven Parameters

On Apr 08, 2015 by Devin Knight

Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in Excel to show the last years worth of data? All of that data brought across your network and then immediately filtered out. Or maybe Excel just can handle the amount of unfiltered data they’re trying to return.

Read More »

Tagged With: Power BI, Excel

SSAS Multidimensional vs Tabular - Part 2

On Apr 07, 2015 by Alan Faulkner

Introduction

In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the stage for looking at 5 high level considerations to answer this question. The considerations are:

  1. Scalability
  2. Performance
  3. Time to Develop
  4. Complex Business Problems
  5. Learning Curve

In this post, we will contemplate the Scalability and Performance aspects by comparing and contrasting SSAS Tabular and SSAS Multidimensional in these areas.

Read More »

Tagged With: SSAS

What is a Modern Data Warehouse?

On Apr 06, 2015 by Ginger Grant

As I was honored enough to be selected to give a PreCon on the Internals of the Modern Data Warehouse at SQLSaturday Huntington Beach, I thought that I would take the time to explain why I felt drawn to the topic. There are a lot of places that haven’t given much thought to the changes in technology which have happened over the last few years. The major feature upgrades to SQL Server in 2012 and 2014 have meant that they can use column store indexes which makes things faster and maybe better High Availability. While those things are certainly valuable improvements there is a lot more that you can do to derive value from your data and companies want more than just a well-organized, running data warehouse.

Read More »

Tagged With: SQLSaturday, Data Warehouse

April Employee Spotlight on Nick Slevoski

On Apr 02, 2015 by Liz Hamilton

Pragmatic Works believes that our employees are the key to our success. Our staff is made up of many extremely talented professionals who deserve to have their achievements and hard work recognized. Each month, we feature one of our stellar employees that often goes above and beyond the call of duty as a small way of saying thank you. This month we're highlighting Nick Slevoski, who is part of our amazing sales team. 

Read More »

Tagged With: Company Info

Power BI Focus for April's Training on the T's

On Mar 30, 2015 by Devon Stiles

Power BI is always a popular training topic at Pragmatic Works. The versatile platform brings together data so it can be analyzed in seconds across a multitude of devices. With the numerous recent updates and introduction of Power BI Designer, we’re focusing our free Training on the T’s webinars for April on Power BI.

This month’s free training will include sessions on leveraging Power Query, Power Map, Power Pivot and Excel Power Tools with leaders in the BI community including members of the Pragmatic Works team. We’re even featuring a bonus Power BI Panel to answer your top questions.

Read More »

Tagged With: Webinar, Power BI

SSAS Multidimensional vs Tabular - Part 1

On Mar 27, 2015 by Alan Faulkner

Have you been or are you currently working on a project where you are trying to determine which flavor of Analysis Services (Tabular or Multidimensional) you should have used or should use? Recently, I was doing a presentation on SSAS Multidimensional best practices and following the presentation one of the attendees asked a very good question, “When it comes to SSAS Tabular versus SSAS Multidimensional how do I know which one to choose?” We discussed some of the various aspects of each one, but during the conversation I realized I needed to put a presentation and ultimately a blog post together on this topic.

Read More »

Tagged With: SSAS

Some of our clients