Daily Coping 13 Sep 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-09-13
11 reads
Blog Posts
Divide the rows of a column in equals batches in grid format
I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...
2021-09-13 (first published: 2021-08-28)
513 reads
Rewriting The Query Tuning Book
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
33 reads
Rewriting The Query Tuning Book
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
2 reads
Single-cloud versus Multi-cloud
A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three...
2021-09-13 (first published: 2021-08-26)
343 reads
Matillion: strategic to modern at Connect for Health Colorado
As part of its ‘All Cloud’ push that began to take shape in 2019, Connect for Health Colorado (C4) selected Matillion ETL to be its cloud ETL/ELT tool. At...
2021-09-12
2 reads
Setting Trace Flags and Configuring SQL Server Containers
In this blog post, we will walk through a few examples of how to configure SQL Server in Docker Containers. First, we will configure a container at runtime by...
2021-09-12
155 reads
Setting Trace Flags and Configuring SQL Server in Kubernetes
In this blog post, we will walk through a few examples of configuring SQL Server in Kubernetes. First, we will create a Deployment for SQL Server, override the container’s...
2021-09-12
12 reads
My personal experience with a split-brain scenario in MSSQL Server
The split-brain scenario in a database environment is a situation whereby the communication link between two different sites is broken, as a result of this situation the production database...
2021-09-11
25 reads
AWS BYOC – Bring your own SQL Server cluster with AWS EC2 and SIOS
Originally posted on DataSteve: Introduction They are multiple options to implement HADR solution for SQL Server in AWS public cloud. The easiest way to do that is to use...
2021-09-10 (first published: 2021-08-25)
155 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers