Author: Data Team

6 Practical Data Protection Features in SQL Server (Pros & Cons)

Here's how we use the data protection features within SQL Server to protect confidential data and make it available to only those authorized to see it.

Realtime and Near-Realtime Data Sources and Data Integrity

We dig into Realtime dataset options (including Pushed, Streaming and PubNub). storage approaches for high-volume/velocity data, and cloud-based data integrity.

“The Other Realtime”: Low-Latency Data Processing via DirectQuery

When neither Realtime nor Near-Realtime data processing meets your needs, there is a third option. This low-latency option is ideal for transactional data.

Realtime vs Near-Realtime Data: Pros and Cons

What factors go into handling these data sources? How do we process them? How do we provide data visualizations based on those sources to meet business needs?

Machine Monitoring IoT Solution with Azure Services and Power BI

We custom-made an IoT framework with Azure components and Power BI to implement a scalable solution to source, stream and show machine performance in real-time.

When Low Quality Data Strikes, Can Fuzzy Logic Save the Day?

When low-quality data strikes, Fuzzy Logic can simplify matching, deduplication and data cleansing. With this tool, you can ensure big data can be clean data.

Fuzzy Lookup for Business Users: Excel Add-In Makes It Possible

Depending on your use case, and especially for simple matching scenarios, the Fuzzy Lookup Excel Add-In can be used to help solve your fuzzy lookup problems.

The Business Value of Data Visualization

Data “in the wild” is often raw and insights can be lost. But data visualization makes the data more consumable, easier to understand, faster to act upon.

How to Dynamically Scale an Azure SQL Database

By designing and implementing a dynamic scaling plan for your Azure solution, you can get the resources you need while reducing cost at the same time.

Haven’t I Seen You Before? Fuzzy Grouping Your Datasets for Data Deduplication

Learn about Fuzzy Grouping and its similarities to Fuzzy Lookups, as well as how you can use the Grouping transformation to perform data deduplication.