Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the...
2018-02-21
337 reads
Born SQL with Randolph West
Why nested views are bad
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you...
2018-02-14
2,368 reads
Help the fight against cancer
Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community,...
2018-02-07
395 reads
Speaking at SQLSaturday 725 in Victoria
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It...
2018-01-31
524 reads
Speaking at SQLBits next month
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London,...
2018-01-24
331 reads
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major...
2018-01-17
336 reads
The cloud is not just someone else’s computer
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether...
2018-01-10
369 reads
Welcome to 2018
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of...
2018-01-03
309 reads
No moving parts, the story of persistent memory
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard...
2017-12-27
370 reads
Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
375 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 KCP Joyoboyo Telp:08218154392
WA CS (08218154392) Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125
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...
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