No State Based Deployments
Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.
2019-05-21 (first published: 2015-03-02)
303 reads
Editorials
What Limits Do You Want in 2019?
With SQL Server 2019 getting closer to release, Steve asks about the hardware limitations that we should have in Standard Edition.
2019-05-20
1,496 reads
The Other Jobs
This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.
2019-05-17
278 reads
2019-05-16
595 reads
Microsoft and Minecraft and Training Kids
Today we have a guest editorial from Andy Warren, looking at learning.
2019-05-15 (first published: 2015-02-23)
538 reads
Where Do You End Up as a DBA?
Steve Jones talks about careers, and where you might take your career over time.
2019-05-14 (first published: 2015-02-20)
727 reads
Communicate Smarter Not More
After installing Microsoft Teams, Steve has a bit of communication overload.
2019-05-13
211 reads
2019-05-11
128 reads
The Impediments to Change
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
254 reads
The Death of the GDPR
The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.
2019-05-09
508 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