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

Announcing the Release of Our High Availability Course!

Posted Oct 13, 2016 by Pragmatic Works

Today we released a new course called SQL Server High Availability! This course has been designed so you have the tools you need when something goes wrong with your SQL Server.

This Week In Data - Mastering the Tech Interview

Posted Oct 12, 2016 by Pragmatic Works

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week's episode, we'll tell you how to master a technical interview.

Power BI Performance Tips and Techniques - Updated!

Posted Oct 10, 2016 by Rachael Martino

Power BI Performance Tips and Techniques update:

Back in March of this year I created an article and a webinar for the Pragmatic Works Blog.

The original concepts still hold, Power BI and Excel Power Query are very powerful tools for building data models and sharing data discovery and visualizations. As you move from initial prototyping to a more mature model you may find that performance can be bogged down if you don't manage the structure of your reporting information. This talk provides Tips and Techniques to manage this information (link to updated slides).

High Availability - A Bird's Eye View

Posted Oct 06, 2016 by Dan Taylor

High Availability, just mentioning these words brings fear to some and delight to others. Gartner describes High Availability “As business operations' dependency on IT infrastructure continues to increase in response to the need for faster and leaner business processes, the need for these systems to be highly available also increases. Not only do high-availability designs focus on automatically detecting and reacting to failures, but, more importantly, they also focus on mitigating the downtime required for standard maintenance tasks. This Reference Architecture template outlines the approach and architecture to achieve high-availability of IT service infrastructure.”

Power BI Custom Visuals - Chiclet Slicer

Posted Oct 06, 2016 by Devin Knight

In this module, you will learn how to use the Chiclet Slicer Power BI Custom Visual.  The Chiclet Slicer is similar to a Slicer filter natively available in Power BI but has a lot more flexibility and includes the ability to use images instead of text as filters.

This Week In Data - The Importance of Data Testing

Posted Oct 05, 2016 by Pragmatic Works

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week's episode, guest host Tim Moolic discusses the importance of data testing with Adam and Devin.

Tips on Keeping Your Data Safe

Posted Oct 04, 2016 by Dan Taylor

Do you Yahoo? Well if you do, your personal information could now be in the hands of folks up to no good. Yahoo began releasing information to the media that at least 500 million user accounts have been compromised. According to reports, data gathered by the hackers was Personally Identifiable Information (PII), not financial data.  Hackers are going to find ways to bypass our security measures put in place. Even knowing that our information could be compromised, it is in our best interest to do all we can to protect our data.

SQL Server 2016 – Data Masking and Always Encrypted

Posted Oct 03, 2016 by Sean Werick

What Dynamic Data Masking Is

Dynamic data masking limits (DDM) sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application.The purpose of dynamic data masking is to limit exposure of sensitive data, preventing users who should not have access to the data from viewing it. Dynamic data masking does not aim to prevent database users from connecting directly to the database and running exhaustive queries that expose pieces of the sensitive data.

Power BI Custom Visuals - Steam Graph

Posted Sep 29, 2016 by Devin Knight

In this module, you will learn how to use the Stream Graph chart Power BI Custom Visual.  The Stream Graph is similar to a Stacked Area Chart, but has more of a fluid look and feel to it. You’ll find this visual often useful when displaying data across time.

This Week In Data - Why Companies are Choosing Power BI

Posted Sep 28, 2016 by Pragmatic Works

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week's episode, we're going to discuss the top 5 reasons why companies are adopting Power BI. 

Subscribe to Blog Updates