A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes… Continue reading How Many Bytes Per Character in SQL Server: a...
2019-12-04 (first published: 2019-11-22)
550 reads
I’ve been tinkering with SQL Server on Linux lately and noted a few things in regards to performance I thought I would share with you. SQL Server 2019 on...
2019-12-04
18 reads
Just wanted to make everyone aware of my latest presentations that I recently uploaded. Details below. I also have a list of all my presentations with slide decks here. Azure...
2019-12-04
18 reads
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
3 reads
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
11 reads
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)
177 reads
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
27 reads
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
25 reads
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)
266 reads
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)
440 reads
By Gerard
This is the fourth and final post in a series about modern Data Lake...
I love this error. Primarily because it demonstrates two very important things. Errors matter....
Comments posted to this topic are about the item From Source Control to Database...
Comments posted to this topic are about the item The Schema Name
Comments posted to this topic are about the item The Login Types, which is...
Ask SSC