Daily Coping 18 Jan 2023
Today’s coping tip is to say positive things to the people you meet today. In general, I don’t encounter a lot of people on any day, but I do...
2023-01-18
22 reads
Daily Coping 17 Jan 2023
Today’s coping tip is to get moving. Ideally do something outside. Taking time to walk the dogs outside, heading to the dog park to get them, and me, some...
2023-01-18
30 reads
SQL Bits 2023
I’m honored to be heading back to SQL Bits 2023. I was selected to deliver one session, in the professional development track. With so many people submitting, I’m not...
2023-01-17
39 reads
Encryption, Comparing your Options in SQL Server
The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server. SQL...
2023-01-25 (first published: 2023-01-17)
475 reads
No Flyway Baseline No Migration
In my experiments with the Flyway CLI (fwcli), I’m finding some interesting behavior, some of which is catching my by surprise. This post looks at the baseline command and...
2023-01-16
44 reads
Daily Coping 16 Jan 2023
Today’s coping tip is to learn something new and share it with others. I do this all the time. It’s a part of my job, and I did this...
2023-01-16
31 reads
SQL Server Quickie #44 – SQL Server on Docker
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker.
2023-01-23 (first published: 2023-01-16)
243 reads
Misleading SSMS Connection
Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....
2023-01-16
27 reads
Updating Documents in Cosmos DB: A Step-by-Step Guide on Creating and Executing a Stored Procedure
Cosmos DB is a powerful, fully-managed, globally distributed, and multi-model database service provided by Microsoft Azure. One of its key features is the ability to create and execute stored...
2023-01-23 (first published: 2023-01-13)
12,104 reads
How Long Will it Take to Encrypt Your Existing Data with TDE?
As we’ve seen in previous posts, the process of turning TDE on for an empty database with no data is instantaneous. Most of the time though you’ll be applying...
2023-01-13
104 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers