Blog Posts

PASS HA/DR Open Q&A Extravaganza Dec 10

• by kleegeek

• Technobabble by Klee from @kleegeek

As leader of the PASS High Availability and Disaster Recovery virtual chapter, I invite you to bring your questions for a mega open Q&A session on Tuesday, December 10th,...

2019-12-04

16 reads

The XML data type is not immutable

• by Randolph West

• Born SQL with Randolph West

Immutability In many programming languages, strings of text are immutable, meaning they don’t change. When you modify a string, a new string is created in memory by copying the...

2019-12-04

59 reads

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

• by Anthony Nocentino

• Anthony Nocentino's Blog

Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use...

2019-12-04 (first published: 2019-11-21)

188 reads

Azure SQL vs Azure Table Storage

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a...

2019-12-03

90 reads

Inspector V2.00 now available

• by davidfowler-42596

• SQL Undercover

The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The...

2019-12-03

27 reads

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

• by Devin-Knight

• Devin Knight

Welcome back to my Power Platform Quick Tips series! In this second episode we look how to return back a dynamic header or title for

2019-12-03 (first published: 2019-11-21)

269 reads

SQL , Lift up your heads for the cloud - Azure SQL

• by kruti15ars

• Kruti's SQL Blog

In my journey with Azure SQL Server I am often asked.1) Why should I move to cloud ?2) Which model should I go for ?3) What do I need...

2019-12-03 (first published: 2019-11-23)

460 reads

Troubleshooting Resource Semaphore and Memory Grants

• by davidfowler-42596

• SQL Undercover

Memory grants, now here’s a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you’re going to notice is...

2019-12-03

63 reads

A Quick Look at Travel

• by Steve Jones

• The Voice of the DBA

I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...

2019-12-02

24 reads

Data Masker Reads Column Classificiations

• by Steve Jones

• The Voice of the DBA

One of the newer features in Data Masker for SQL Server is the ability to read column classifications and suggest rules to clean the data. I decided to give...

2019-12-02 (first published: 2019-11-22)

219 reads