20 March 2020
20 March 2020

DevOps is Essential for Analytics

The term DevOps was coined in the early 2000s to improve the speed and resiliency of the delivery of features and applications and providing more value to customers. It’s not about any particular technology, methodology, or toolset, but automation of everything from unit testing to building environments to delivery is part of it. DevOps also … Read more
11 March 2020
11 March 2020

Virtual Reality

As a Star Trek: The Next Generation fan, I am intrigued with the idea of a Holodeck. The Holodeck on this and subsequent series is a place that the characters mostly go to for recreation or to relax. They can hang out with historical figures, view an earthly sunset, or be a part of their … Read more
21 February 2020
21 February 2020

SQL Server Machine Learning 2019: Working with Security Changes

SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it. … Read more
14 February 2020
14 February 2020

Beginner Guide to In-Memory Optimized Tables in SQL Server

Microsoft added the In-Memory OLTP (aka memory optimized tables) feature to SQL Server 2014. Operations to this type of table do not need locks, therefore eliminating blocking and deadlocking. In this Article, Monica Rathbun demonstrates how to get started using memory optimized tables.… Read more
14 February 2020
14 February 2020

Creating Time-Intelligence Functions in DAX

2
DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in this series, Andy Brown explains how to write measures using the range of date functions in DAX, and also explains how time-intelligence functions work behind the scenes. … Read more
2
10 February 2020
10 February 2020

Why Empathy is Not Enough in Tech

In 2020, my main personal goal is to reduce doing harm, and this has been mainly inspired by the work of Kim Crayton and the #causeascene Guiding Principles. Kim is a business strategist, tech leader coach, professional educator, and founder of the #causeascene movement. Tech is not neutral. Actually, it has never been neutral, nor … Read more