Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...
2024-05-27 (first published: 2024-05-10)
710 reads
I did a post last month titled RTO and RPO are myths unless you've tested recovery, but I only briefly covered what RPO and RTO are. This post goes...
2024-05-31 (first published: 2024-05-10)
511 reads
ioia – n.the wish that you could see statistics overlaid on every person you encounter – checking the signal strength of their compatibility, a measure of their trustworthiness. I...
2024-05-10
40 reads
I love Chicago. I went to visit three times in 2023: a Redgate event, a volleyball tournament, and a wedding. Each time was a lot of fun and I...
2024-05-08
69 reads
I have found that non-functional requirements (NFRs) can be hard to define for a given solution. I’ve seen teams struggle with NFRs. However, to ensure I’m speaking the same...
2025-01-01 (first published: 2024-05-08)
673 reads
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on github.
The post Techorama 2024 – Slides first appeared on Under the kover of business intelligence.
2024-05-08
59 reads
Can we normalize a couple of things? 1 – Trade Schools. Back in the 80’s trade classes in high school and post high school were frowned upon, or looked...
2024-05-08
41 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers to questions that can drive your business forward. To unlock this potential, you need the...
2024-05-27 (first published: 2024-05-07)
385 reads
When I look at a system and think about its security model, the first thing I start poking around at is where I think security is weakest. For instance,...
2024-05-06
61 reads
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about Microsoft Fabric (at 6PM UTC).Abstract: Microsoft Fabric is the new all-encompassing data platform of Microsoft....
2024-05-06
66 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
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