Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there. … Read more
I hear from a lot of database administrators who are worried about being automated out of a job. These kinds of worries are not new. Over the course of my career, I’ve seen CTOs outsource large groups of IT jobs to different regions around the world to save money. IT has long been regarded as … Read more
In today’s world, some people do not need computers because they can do everything on their smartphones. Playing games is no different and is one of the most popular uses for the mobile devices (who makes phone calls, anymore?). In this article, Lance Talbert shows you how to create a game that will run on an Android device.… Read more
In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it. … Read more
Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations. … Read more
Filling out online forms is often tedious, but it's even more frustrating when the input is not checked until you click Submit. In this article, Dino Esposito shows how to create smart forms that validate the input as it's being entered.… Read more
In the past, I was very proud that I’d meticulously defended my projects against scope creep, but I was missing the point. The real reason organizations should undertake projects is to achieve value. What should be the priority, then, defending against scope creep or value-based delivery? The agile movement fundamentally understands this. Its core principles … Read more
Getting security right is always necessary but often not easy. In this article, Joydip Kanjilal describes policy-based authorization in ASP.NET Core used to create a reusable authorization model and simplify securing your applications.… Read more
GraphQL is an efficient and flexible query language. In this article, Julio Sampaio explains how to use GraphQL and walks you through building a simple application.… Read more
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git. … Read more
In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.… Read more
When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA and presents a case study.… Read more
Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security and protecting data, but planning and effort are required to properly implement them. In this article, the first of a series, Robert Sheldon reviews the many components available to secure and protect SQL Server databases. … Read more
In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration. … Read more
In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the DAX language. This second article in the series explains what measures are, and how you can use DAX to create measures within Power BI. The formulae in the article apply equally well to PowerPivot and Analysis Services Tabular Model. … Read more
You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.… Read more
If only there were a ‘single version of the truth’ in data and data analytics. Unfortunately, data and everything that derives from it is subjective: it cannot be disentangled from our cultural biases. We can only find the version of the truth that fits the evidence and our cognitive map of the world we live … Read more
The AWS Elastic Beanstalk feature is a web application provisioning service that allows you to automatically scale as needed. In this article, Gerald Bauer explains how to set up and configure Elastic Beanstalks through the AWS dashboard and Visual Studio. … Read more
IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how to be successful and give your customer a great experience.… Read more
Compliant Database DevOps
