3 Types of Microsoft High Availability Technologies

Every now and then I get questions about how to implement load balancing with SQL Server databases. Because organizations want to maximize their IT investments, a standby server is almost always a red flag – it’s an idle asset. Hence, the questions about load balancing workloads on SQL Server databases to maximize the resource utilization on […]

Implementing Instant File Initialization on SQL Server with SMB File Share

We were taught early on that when you heat water to 212 F (100 C,) it starts to boil. Oh, those memorable science experiments we did in high school. We put a thermometer in a water-filled flask and light up a burner to heat the water in the flask. We watch as the thermometer records the temperature […]

TSQL Tuesday #77 – Favorite SQL Server Feature: SQL Server Logging

As I was going thru the list of possible laptops that I could buy as a backup machine, my youngest son pointed at the latest Microsoft Surface Pro 4 device. He was very happy with his Surface 3 – great graphics, lightweight, HD webcam, touch screen and a detachable keyboard. As he continued to brag about his […]