Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.… Read more
As I write this, my mind is focused on my big holiday trip, just two days away. It’s a trip I’ve been planning for five years, and it includes our children, their spouses, and our grandchildren – eleven people in all. I’m still debating on whether to take a laptop along, but I’m leaning towards … Read more
R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.… Read more
At the center of all businesses is a company culture. This culture exists whether the leaders created it or not. If the leaders did not create the culture, then the loudest voices at the company define the culture. Business leaders need to stand up, define, implement and live their company culture. Some view company culture … Read more
T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.… Read more
Data breaches make the news on an almost daily basis. There is no turning back, however, as we are firmly entrenched in this digital way of life. Brian Kelley discusses some of the reasons data breaches occur and what we can do to prevent them.… Read more
The user interface, such as buttons and messages, in a game is very important. In this article, Lance Talbert shows how to create a working Tic-Tac-Toe game using Unity and C# consisting of user interface elements. … Read more
Power BI Desktop is the free tool from Microsoft for developing in Power BI. In this article, Robert Sheldon walks you through importing and manipulating data with the Query Editor in Power BI Desktop.… Read more
In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.… Read more
You may have noticed a recent flurry of activity in your email inbox as many companies sent out new privacy policies and, in some cases, asked you to opt-in to continue to receive communications from them. This coincides with the deadline to comply with the GDPR (General Data Protection Regulation). This regulation is meant to … Read more
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery.… Read more
Tapping the power of serverless computing via Lambda functions and cloud-native technologies allows us to extend the native capabilities that exist in open-source databases. David Yahalom demonstrates how to create a queue using Lambda that can be used to add queuing capabilities to MySQL.… Read more
Microsoft has introduced a new version of Razor with ASP.NET Core 2. Tom Fischer explains why it’s worth taking another look at this methodology, especially those who discounted it before. He walks you through creating a simple application, highlighting the benefits or Razor.… Read more
Typewriters have become rare over the past twenty years or so as we began to use computers more often at home and in the workplace. Correction tape, whiteout, and those typing erasers with a brush on the end have been replaced by the backspace and delete keys. Most people welcome this progress or have never … Read more
As more companies take advantage of the cloud, teams must learn to do the basics in new ways. In this article, Mircea Oprea demonstrates how to migrate an ASP.NET application to Azure and from on-premises SQL Server to Azure SQL Database. He also discusses how to troubleshoot issues you may find during the migration.… Read more
In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that are not supported, such as some data types, and Darko Martinović describes the issues and provides workarounds. He also has provided a tool to assist in migrating disk-based tables to In-Memory optimized tables.… Read more
Power BI has been available for a number of years, but new functionality is added regularly. In this new series from Robert Sheldon, you will learn about the latest developments or get started with Power BI if you are new to it. Robert provides an overview of Power BI, the services and tools available in this article. … Read more
Microsoft introduced native support for JSON in SQL Server in version 2016. In this article, Phil Factor shows how to import JSON documents into to SQL Server database tables, even if there is a bit of complexity in the original data.… Read more
I was recently asked about which tools I used back when I was a full-time SQL Server database administrator. I had a tool to compress backups and a monitoring tool with licenses for just a fraction of the servers I was responsible for. Over time, I figured out ways to gather information or automate processes … Read more
Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. In this article, Nicolas Prigent describes PoshUD, and how to use it to monitor your infrastructure using PowerShell.… Read more
