CCPA Preparation
The California Consumer Privacy Act takes effect in a year and there is lots of work to be done. One firm is trying to help companies get ready.
2019-07-01
345 reads
Editorials
Over-thinking Database Build Scripts
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
341 reads
Organisations and Technical Apartheid
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
2019-06-28
294 reads
The Road to Better Data Handling
As data becomes more valuable and regulations require safer processing, it is important we become more careful in our daily work.
2019-06-27
234 reads
2019-06-26
181 reads
Spread the Word about Basic Security
This week we have a few back to the basics security comments from Steve.
2019-06-25
452 reads
Killing FTS
Steve wonders today if the Full-Text Search system in SQL Server is due for a replacement, perhaps with other technologies.
2019-06-24
256 reads
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
406 reads
Practice Those Scripts
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
2019-06-21
449 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
260 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