SQL Tamagotchi! Mini-Servers as Database Pets
If you've ever stuffed SQL Server onto a Raspberry Pi 4 and given it a pet name, don't worry, you're not alone…
2019-08-24
298 reads
Editorials
Waits and Queues
This week Steve is wondering if you know how to use waits and queues for troubleshooting.
2019-08-23
666 reads
Don't Get On This Page
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
433 reads
2019-08-19
209 reads
Lots of data in RAM
I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]
2019-08-17
248 reads
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
427 reads
Demo Data for Everyone
Steve thinks having a known set of data for your system is one way to improve your software development process and make salespeople happy.
2019-08-14
589 reads
Organized Learning
Learning to become a DBA is often a winding and twisty road. Steve has a little advice today.
2019-08-13
255 reads
2019-08-12
278 reads
The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
704 reads
Blogs
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...
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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