Storage options & Disk Types in GCP
Want to learn and use Google Cloud Storage?
What is Cloud Storage & Bucket?
Type of Disk avilable in Cloud Storage?
Lets Start! Continue reading ?
2021-12-09
27 reads
Blog Posts
Amazon RDS Custom for SQL Server – A new beginning
Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL...
2021-12-08
5 reads
Building a pacemaker cluster to deploy a SQL Server availability group in Azure
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node...
2021-12-08 (first published: 2021-12-01)
275 reads
Daily Coping 8 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-08
8 reads
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Dynamic Data Masking is a feature that provides...
2021-12-08 (first published: 2021-11-29)
329 reads
Your next step in the cloud
Over the last nine months I’ve presented (virtually) eleven times on a variety of topics relating to SQL Server and the Microsoft Data Platform. Long-time readers will know I...
2021-12-08
22 reads
Daily Coping 7 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-07
13 reads
Finding the NTFS Allocation Unit Size for Mount Points
The 64Kb Allocation Unit size is one of the easiest SQL Server best practice items to complete during your new builds, but from time to time, I still see...
2021-12-07
803 reads
The less you hear from or about the DBAs the better they are doing their job.
Something I’ve been thinking about recently is that DBAs are best when they are invisible. Now, this is also true ... Continue reading
2021-12-07
5 reads
3-2-1 Backup Rule for Data Protection in SQL – What Is It & Is It Relevant?
In the event of a disaster leading to database unavailability, restoring backups is the first step to ensure business continuity. However, situations may arise when attempts to restore the...
2021-12-06 (first published: 2021-11-25)
622 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers