Can Azure Stack Reduce Software Development Costs?
Azure Stack provides a hybrid cloud infrastructure platform. Steve wonders if this really helps reduce software development costs.
2019-04-24
213 reads
Editorials
Changing Context and Data Reuse
We don't have strong data consent rules in the US, but Steve thinks we should.
2019-04-23
263 reads
Protecting Data Between Services
Microsoft is shutting down HealthVault, which means that customers need to manage their records. That's a challenge for many people.
2019-04-22
176 reads
The Evolving Skillset for Database Professionals
Aunt Kathi remembers all the SQL Server versions she has worked with over the years.
2019-04-20
400 reads
The Case for Considering Git
Today we have a guest editorial from Kendra Little that looks at choosing a version control system as you adopt a Database DevOps software development process.
2019-04-19
550 reads
Scary Data Collection
More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren't always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.
2019-04-18
332 reads
Securing Code Early
Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We've published the login so […]
2019-04-17
225 reads
Capturing the Application Time
Most of us work with the time in a variety of ways in our applications. Temporal tables use the time on the server,but Steve notes today that we might want to capture other types of time.
2019-04-16
335 reads
Building a Database Engine
Someone tried to build a database engine from scratch. While not something Steve wants to do, it's an interesting exercise.
2019-04-15
1,487 reads
2019-04-13
201 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