Scalar function string replacement

Moving Away From MySQL

A developer has some harsh things to see as he leaves the MySQL team. Is he right?

Virtual Events Are Here To Stay

This week was the MVP Summit. As was the case for the last couple of years, the event was entirely virtual. We were shown a bunch of new and interesting things by Microsoft. We were able to talk to each other and to the engineers at Microsoft. I'm honored that I've been an MVP and […]

Cloud Computing Basics - Achieving High Availability

Learn about high availability in the cloud at a conceptual level.

Create a Free Azure Account

Learn how to get started in Azure with a free account.

Data and database management in everchanging technology landscape

This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.

Another look at table variables

Becoming overly enthusiastic about a new SQL Server feature can backfire if you don’t do some testing. One example is the table variable introduced with SQL Server 2000. At the time, there was a myth that table variables would always perform better than temp tables with the reasoning that, by definition, variables are stored in […]

Using Azure File and Blob Storage with Azure VMs – Step by Step

Learn how to use Azure File and Blob storage with your applications.

Log File Architecture

SQL Log File Too Big

Is your SQL database log file too big? Maybe it is. But maybe it’s not. When log files keep growing and appear to be too big some might suggest switching to Simple recovery, shrinking the log file, and switching back to Full recovery. While this will work to shrink the file and free up disk […]