2018-05-04
148 reads
Editorials
Reasons to Upgrade
There are always reasons to upgrade or avoid upgrading to a new version. Steve Jones has a few thoughts.
2018-05-03
72 reads
Would You Move to Linux for Price?
There's a sale on the price of SQL Server for Linux and Steve wonders if people will move.
2018-05-02
68 reads
Auto-Deleting Data
Steve likes that idea of auto deleting data, especially with legislation increasing.
2018-05-01
100 reads
2018-04-30
66 reads
Taking Shortcuts
We don't mean to introduce security issues, but sometimes we do because we give in to pressure.
2018-04-30
53 reads
The CDO
Does your company have a Chief Data Officer? Steve Jones doesn't think you need one to use data wisely.
2018-04-27
61 reads
2018-04-26
193 reads
Stairway to Advanced T-SQL Crossword
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
2018-04-25
311 reads
Cloud Snake Oil
The Cloud isn't always what it seems and Steve notes that paying attention to finances might be the most important thing.
2018-04-24
113 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