The Fediverse Files: ActivityPub Interview with Evan Prodromou
Doc Pop and Evan Prodromou discuss the past, present, and future of ActivityPub and the fediverse.
2024-08-09
41 reads
Don’t run CHKDSK while SQL Server is running
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...
2024-08-21 (first published: 2024-08-09)
380 reads
Reducing Meetings and Making Them More Productive
I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to...
2024-08-23 (first published: 2024-08-09)
377 reads
Service Broker Blocking
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...
2024-08-19 (first published: 2024-08-09)
181 reads
WHAT IS A SPV?
Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...
2024-08-09
35 reads
A New Word: Hiddled
hiddled – adj. feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....
2024-08-09
33 reads
DevOps Days Minneapolis–Best Practices for Database Deployments
Thanks to everyone who attended, though with one stage I had a fairly captive audience. I enjoyed the event and look forward to coming back to the Twin Cities...
2024-08-08
29 reads
Beyond Avatars: How Gravatar is Transforming Online Identity
Seven things every WordPress user should know about Gravatar
2024-08-08
39 reads
6 Best SQL Training Courses for Beginners (2024 Updated)
We all know that choosing the right basic SQL training is absolutely crucial if you want your SQL journey to be a success story, especially when you're starting from...
2024-08-08 (first published: 2024-08-07)
174 reads
T-SQL Tuesday 177: Managing database code
I am excited to host the T-SQL Tuesday blog party for August 2024. I’ve done this many times, but I always remember when I was new to the community...
2024-08-07
49 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers