Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
2019-06-19
248 reads
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
1,257 reads
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
213 reads
2019-06-14 (first published: 2015-05-19)
598 reads
This week Steve Jones wonders if we work too much. Do we give more to our employers than they give to us?
2019-06-11 (first published: 2015-12-18)
1,041 reads
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
389 reads
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
232 reads
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
2019-06-07 (first published: 2015-04-27)
1,107 reads
There are a couple big changes that the cloud brings to us. Steve has a few comments today.
2019-06-06
458 reads
Comments in code can be tricky, but certainly some are better than others. What are your bad examples?
2019-06-05 (first published: 2015-03-13)
658 reads
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Most embedding pipelines on AWS have the same shape: a job reads rows out...
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
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