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
The ability to quickly spin up a virtual machine is one of the great things about Azure. In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module. … Read more
In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.… Read more
Docker continues to make improvements in their products running on Windows. In this article, Nicolas Prigent explains how to share data between Windows containers and the container host. As a bonus, he also shows how to run a Linux container on Windows Server 2016.… Read more
Bootstrap 4 has many features to make your life easier if you are a web developer. In this article, Dino Esposito explains the Bootstrap 4 media object which can dramatically decrease your use of inline CSS.… Read more
The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.… Read more
Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM. … Read more
The next step in learning how to create games in C# using Unity is to add extensions to get custom functionality. Lance Talbert shows you how to create an extension that changes the properties of many objects at once.… Read more
One big question for software developers and IT departments in small companies is always “should I hire a DBA?” The fact that one is asking this question demonstrates that there are some symptoms that need a deeper diagnosis than you can handle. This may be a concern about backup procedures, database slowness for users, or errors … Read more
Sharing and reusing large objects between components and services can save time and computing resources. Tom Fischer explains how to take advantage of the Memory Mapped Files feature of .NET to help boost performance.… Read more
With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.… Read more
Azure, Microsoft's cloud, provides dozens of services to make cloud development fast without the need to worry about infrastructure such as hardware. In this article, Jakub Kaczmarek explains the benefits and challenges of creating a bot using the Microsoft Bot Framework found on Azure. He also walks you through creating a simple bot.… Read more
One of the most important tools for query tuning is the ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection. … Read more
