Firewall Settings for Connecting to Azure SQL Databases from an Azure VM

This post describes an issue a client experienced connecting to an Azure SQL Database from an Azure VM through a third-party firewall.

by Frank Gill Jun 26, 2020

Why Migrate SQL Server to Azure

When making the decision to move SQL Server workloads to Azure, there are a series of questions that need to be answered.

• Why are you migrating to Azure?
• What are you going to migrate to Azure?
• Where will you migrate in Azure?
• How will migrate to Azure?
• When will you migrate to Azure?

The answer to the first of these questions is extremely important to answering the others.  In my experience, it is often neglected.

by Frank Gill Jan 3, 2020

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.

by Paul Harris Nov 27, 2019

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.

by Frank Gill Sep 17, 2019

Restore an Availability Group Database with PowerShell

This post contains a script that automates the restore of a SQL Server  Availability Group database

by Frank Gill Sep 9, 2019

Power BI vs SSRS

A detailed description of the differences between Power BI and SSRS

by Zed Dietrich Jul 31, 2019

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.

by Dalton Smith Jul 24, 2019

PASS SQL Saturday April 8, 2017

Thank you to PASS for organizing Madison's SQL Saturday event!
http://www.pass.org/

by Nick Adams Apr 12, 2017

Understanding NoSQL

A quick and basic understanding of what NoSQL is.

by Nick Adams Mar 9, 2017

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.

by Nick Adams Feb 22, 2017