The XML data type is not immutable
Immutability In many programming languages, strings of text are immutable, meaning they don’t change. When you modify a string, a new string is created in memory by copying the...
2019-12-04
120 reads
Born SQL with Randolph West
Is it true that editing a single row in Management Studio empties and reloads the entire table?
TL;DR: No. A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the edit feature, that the...
2019-11-27
8 reads
Installing SQL Server on Windows? Don’t forget these two useful switches
A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author for a Microsoft Press...
2019-11-20
59 reads
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned out. All the content...
2019-11-13
40 reads
SQL Server 2019 is here
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I presented this year at...
2019-11-06
9 reads
When security and news collide
Behold! There’s a scary monster called skip-2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to any MSSQL account by...
2019-10-30
13 reads
Speaking at SQL Saturday Oregon
SQL Saturday Oregon — in the city of Portland — is taking place next weekend on Saturday November 2nd, 2019, and I’ll be presenting a revised edition of my...
2019-10-23
7 reads
Using indexed views? What is an imprecise or non-deterministic convert?
After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting side-road into deterministic values,...
2019-10-16
45 reads
Using indexed views? Don’t forget this important tip.
Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome in the right context!),...
2019-10-09
46 reads
How to read documentation
I was thinking about a comment I made to my intern last week. She has been studiously attending to all the different things I do in my day (what...
2019-10-02
32 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
KONTAK BCA KCU SCBD Telp:08218154392
WA CS (08218154392) Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
BCA KCU GADING SERPONG Telp:08218154392
WA CS (08218154392) Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia...
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
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