Daily Coping 8 Oct 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-10-08
56 reads
Blog Posts
Setting Permissions on Files Inside a Container for SQL Server
This post will walk you through setting file permissions on database files copied into a container. The SQL Server process sqlservr running in containers runs as the non-privileged user...
2021-10-08 (first published: 2021-09-25)
276 reads
SQL Server on Physical Machine Best Practices
The intent of this post is a quick reference guide based on the recommendation made on Pure Storage Support page in the Microsoft Platform Guide . The target audience...
2021-10-08
64 reads
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure SQL Server when run in a Docker container. You can check out the full list...
2021-10-08 (first published: 2021-09-24)
507 reads
Crossing Borders
I’m about to cross a country border for the first time in almost two years. I last left the United States in December 2019. Today I’m flying to Belgium...
2021-10-07
50 reads
Daily Coping 7 Oct 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-10-07
55 reads
Dealing with foreign keys when deleting rows.
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of ... Continue reading
2021-10-07
96 reads
Restore to SQL Managed Instance
Now that we have a Managed Instance built, the next question is how do we get data across? I will break this up into separate posts but the lesson...
2021-10-07
144 reads
Daily Coping 6 Oct 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-10-06
20 reads
How to Design Backups in SQL Server?
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover....
2021-10-06 (first published: 2021-09-24)
737 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers