SQL Homework – December 2021 – Changing collation
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-10 (first published: 2021-12-02)
306 reads
Blog Posts
Understanding VMWare Components
Last Updated on January 9, 2022 by John Morehouse Recently I was looking to install VMWare components in my local network of things so that I could gain additional...
2021-12-10
15 reads
Daily Coping 9 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-09
19 reads
SQL Managed Instance – Failover Groups Quick Tips
Lets summarise some important learnings about SQL MI and failover groups. when you add a database to a failover group the secondary database has the same edition / compute...
2021-12-09
131 reads
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
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
6 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)
330 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
23 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers