Pragmatic Works Blog

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

10 Characteristics of a Gangsta Geek

On May 21, 2015 by Devon Stiles

Every year on May 25, geeks worldwide come together in celebration of Geek Pride Day. Originally celebrated in 2006, the holiday has quickly gained international popularity largely in part due to the Internet. 

Here at Pragmatic Works, not only are we geeks, we're Gangsta Geeks. And we're not afraid to show it! 

So what exactly is a Gangsta Geek? Gangsta Geeks are smart, resourceful, fun, knowledgeable and passionate individuals who are proud to be Gangsta Geeks. They're so geeky, it's gangsta. No shame in their geek game!

Read More »
13 Comment

Tagged With: Geek Pride

Types of Testing in the Data-Centric World

On May 19, 2015 by Robert Cain

Testing has long been accepted in the software development world as the key to quality. Testing ensures code behaves as designed, delivers the expected results even after subsequent changes to the original code base occur and that code changes from one developer do not adversely affect the existing code base. Done correctly, it also verifies that the code handles an appropriate range of input data and manages exceptions and invalid data correctly.

Read More »

Tagged With: Products

May Employee Spotlight on Mitchell Pearson

On May 14, 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 who often goes above and beyond the call of duty as a small way of saying thank you. Mitchell Pearson, a BI Consultant, is May's Employee Spotlight!

Read More »

Tagged With: Company Info

SSAS Tabular vs. SSAS Multidimensional – Part III – Complex Business Problems

On May 12, 2015 by Alan Faulkner


In Part I of the SSAS Tabular vs. SSAS Multidimensional series, we began to set the stage for looking at 5 high level considerations to help determine which you should choose to use. In Part II, we explored the Scalability and Performance considerations between the two technologies. In this post, we'll contemplate the Complex Business Problem aspects by comparing and contrasting SSAS Tabular and SSAS Multidimensional in terms of characteristics of the data, the model required to deliver the analytics and the reporting required.

Read More »

Tagged With: SSAS

We're Coming to the Big Apple for SQLSaturday NYC

On May 11, 2015 by Liz Hamilton

We may have just wrapped up SQLSaturday Jacksonville, but we're already planning for SQLSaturday New York City! Several of our consultants will be presenting on topics ranging from Azure to Performance Tuning in the Big Apple in just a couple of weeks. 

SQLSaturday New York City Details

When: Saturday, May 30, 2015

Where: 11 Times Square, Microsoft New York Metro District Office, New York, NY 10036.

Additional precon sessions will be held at the Times Square Microsoft Office on Friday, May 29, 2015.

Read More »

Tagged With: Company Info, SQLSaturday

May the 4th Be With You

On May 04, 2015 by Liz Hamilton

In case you weren't aware, today is Star Wars Day! Also known as May the 4th Be With You, it's arguably the best geek holiday of the year. I'm Liz and I'm the marketing manger at Pragmatic Works and a life-long Stars Wars enthusiast. As a Star Wars lover, I'm so excited that I work for a company which allows me to share how my love of all things Stars Wars was passed on to me.

Read More »

Tagged With: Company Info

May Free Training Schedule

On May 01, 2015 by Devon Stiles

This month, our experts will be covering a variety of topics from assembling a data team to consumption based BI and more. Notice something different? Based on feedback we've received, we made a few changes to our training sessions to make them more efficient and increase value. Our webinar format has been modified to allow for more question and answer time during each webinar. We have also reduced the number of session to allow our experts more time to develop their sessions and come up with new topics.

Read More »

Tagged With: Virtual Training

Table Partitioning in SQL Server – Partition Switching

On Apr 29, 2015 by Cathrine Wilhelmsen

Inserts, updates and deletes on large tables can be very slow and expensive, cause locking and blocking, and even fill up the transaction log. One of the main benefits of table partitioning is that you can speed up loading and archiving of data by using partition switching.

Read More »

Tagged With: SQL Server

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

Some of our clients