Most of us have found our lives turned upside down in recent weeks as we try to shelter in place, work from home, or care for our families. There are many ways to cope with the situation. On Facebook, I see my friends talk about cooking and baking, watching hours of streamed content, trying to … Read more
In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure, and solution space with Cassandra tables.… Read more
As organisations move to cloud platforms like Azure and AWS, understanding security is more important than ever. In this article, Vasanth Makam explains what companies need to know to make sure their data is secure.… Read more
Everyone has been impacted in some way from the Covid-19 pandemic, whether it is missing out on holiday travel and events, being isolated from loved ones, facing economic issues, or contracting the virus. In the best of scenarios, buying groceries and supplies has turned into a scavenger hunt, while, in the worst, people are truly … Read more
I’ve been working from home for several years, so I’m used to it. Many people who have never thought of doing this have found themselves working from home the past few weeks. Companies who have never given their employees a chance to work remotely are finding that it’s possible. Setting up remote workers is not … Read more
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source. … Read more
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
Despite some humorous examples of deployments gone wrong, failures are not funny. William Brewer explains why staging is so important and how it can help avoid the types of disasters he recalls in this article.… Read more
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
Many games today involve more than one player, but creating a multiplayer game is not easy. In this article, Lance Talbert show how the PUN plugin takes care of the difficult parts for you.… Read more
Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead. … Read more
You’ll need several tools in place to effectively work with SQL Server in Linux. In this article, Robert Cain explains how to install these tools in your Ubuntu virtual machine. … Read more
Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.… Read more
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
In the last editorial, I wrote about how it is obvious from what we see and read that Tech is not neutral nor apolitical, how this has lead to a narrowing of perspective, and that empathy is not enough to replace the authentic lived experience and therefore the knowledge of a diverse group of people. … Read more
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
As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.… Read more
Each year Redgate Software runs a survey to learn more about how organizations practice DevOps, especially when it relates to the database. This year, over 2000 individuals responded, and they are from diverse industries and company sizes. The key findings in the report are: Frequent database deployments are increasing: 49% of respondents now report they … Read more
One of the most critical things that a game must do is to save data like the preferences and score. In this article, Lance Talbert demonstrates two ways to save data when you create your game in Unity.… Read more
Since SQL Server now runs in Linux, more database professionals will begin to learn this operating system. In this article, Robert Cain demonstrates how to set up an Ubuntu virtual machine for learning.… Read more