Securing the Root Keys for TDE
In this quick post we’re going to look at an additional step you should take to secure your TDE databases. This is a step you won’t find in any...
2023-01-09
48 reads
Help! My tempdb is full and I can’t access SQL Server!
I got a call saying the database server is inaccessible because tempdb is full. I get online and try to connect because I want to see the error for...
2023-01-18 (first published: 2023-01-06)
1,116 reads
Goals for 2023
This is the goal setting post for 2023. The previous ones were: 2022 2021 2020 2019 2018 As with previous years, I’ll break these into three categories: career, personal,...
2023-01-06
29 reads
Outlining Goals in 2023
Last year I set a bunch of goals, and I thought I did pretty good working on them. Not amazing, but pretty good. This year, I want to attack...
2023-01-06
25 reads
Setting up TDE
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In the previous posts we looked at what TDE is and how it...
2023-01-06
109 reads
Daily Coping 6 Jan 2023
Today’s coping tip is to do something outdoors today. Enjoy nature. I’m writing this a few days ahead, so I’m using an activity I did over the weekend. The...
2023-01-06
29 reads
Daily Coping 5 Jan 2023
Today’s coping tip is to set aside a regular time for the next month for an activity you love . This is a big month for me, with coaching...
2023-01-05
35 reads
Identify Unused Indexes across all Databases
I had a request regarding how to identify unused indexes across all databases on a SQL Server instance (rather than just the current one). I’ve written this script before...
2023-01-16 (first published: 2023-01-05)
933 reads
Power Automate: Sending Emails As A Different User
A common frustration when sending emails from Power Automate is how to force Power Automate to send your emails from a specific user. While there
2023-01-11 (first published: 2023-01-04)
503 reads
Installing Flyway Community on Windows
One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway...
2023-01-13 (first published: 2023-01-04)
219 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers