Azure Backup for SQL Server 2019

How to backup your important data stored in SQL is something on the minds of many IT professionals. Recently, Azure announced a new feature for backing up SQL servers running in VMs on Azure.

Paul Harris by Paul Harris

Resize a SQL Server Transaction Log File Using PowerShell

This post contains a PowerShell script that identifies SQL Server databases with a VLF count that exceeds the limit passed in.  It can output that list or resize log files identified to reduce the VLF count.

Frank Gill by Frank Gill

Power BI vs SSRS

A detailed description of the differences between Power BI and SSRS

Zed Dietrich by Zed Dietrich

Polymorphic Associations Using EF Core

"Polymorphic Associations" is an interesting SQL anti-pattern that is utilized often in Ruby on Rails code. This pattern isn't natively supported in Entity Framework Core; however, Polymorphic Associations can be implemented using existing EF Core features.

Dalton Smith by Dalton Smith

Understanding NoSQL

A quick and basic understanding of what NoSQL is.

Nick Adams by Nick Adams

Installing SQL Server on a Domain Controller: What You need to know

SQL Server can often be a very high strung application that has many requirements and best practices to follow.  Sometimes hosting several services on one server is necessary with smaller or very lean organizations.  Today, we look at the information you need to be aware of when concurrently running SQL Server on a Domain Controller.

Nick Adams by Nick Adams