On Hybrid Events
In my blog post last night on Days 1 and 2 of the PASS Summit, I included the following comment:
(Along with that, I think having "hybrid" events like our...
2022-12-02 (first published: 2022-11-16)
133 reads
Blog Posts
PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?
Very excited to take part in my third #PGSQLPhriday blogging event, even more so because it’s a topic that’s quite near and dear to my heart, community. To say...
2022-12-02
16 reads
SQLibrium SQL Server on VMware training now free
I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...
2022-12-02 (first published: 2022-11-15)
269 reads
Daily Coping 1 Dec 2022
Today’s coping tip is to discover your artistic side. Design a friendly greeting card. A fun one for me today. I saw this just after returning from the PASS...
2022-12-01
8 reads
Daily Coping 29 Nov 2022
Today’s coping tip is to make a meal using a recipe or ingredient you’ve not tried before. It’s the holidays, and my daughter is home. She’s GF, so I’m...
2022-11-30
7 reads
Daily Coping 30 Nov 2022
Today’s coping tip is to learn a new skill from a friend or share one of yours with them. I like learning, so in this case, I took advantage...
2022-11-30
5 reads
In SQL Server 2022, set your transaction log file autogrowth rate to 64 MB
A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...
2022-11-30 (first published: 2022-11-17)
560 reads
My adventures with speaking and what changed
I am writing this blog post as contribution to #NewStarNovember and what got me re-started as a tech speaker in 2020. I haven’t done a lot of tech speaking...
2022-11-30 (first published: 2022-11-29)
9 reads
PASS Summit 2022 - Day 2 In Pictures
Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...
2022-11-30 (first published: 2022-11-18)
202 reads
Query Store Hints in SQL Server 2022
Another neat little feature in SQL Server 2022 is Query Store Hints. This is the ability to apply a query hint through Query Store rather than having to modify...
2022-11-30
56 reads
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
Question of the Day
Backing up the Database Encryption Key
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers