2015-10-30
340 reads
Editorials
Leave Developers Alone
Interruptions are the enemy of productivity for creative people, like software developers. Steve Jones talks today about the need for quiet time.
2015-10-29 (first published: 2011-07-25)
532 reads
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2015-10-28 (first published: 2008-03-07)
1,321 reads
From Great Idea to End Result
IT is too slow. That was a quote that inspired this piece from Steve Jones that talks about the need for IT to be more flexible and agile in their efforts. That includes the data professional in their modeling.
2015-10-27 (first published: 2011-05-24)
266 reads
SQL Safety Nets
Today we have a guest editorial from Andy Warren. Andy talks about the things that help us out when we forget to handle some aspect of server administration. These safety nets can be handy, but should they be there? Should we have more of them? Join the discussion.
2015-10-26 (first published: 2011-06-09)
258 reads
The Hot Jobs
This week Steve looks at the hot jobs that are going to have pay increases in the coming year.
2015-10-26
267 reads
Positive or Negative
Today Steve Jones wonders if the way you choose to design a database says something about you.
2015-10-23
191 reads
The Dangers of Travel
As data professionals, we might carry lots of information with us that relates to our organization. Will we get caught up in government issues as we cross borders?
2015-10-22
206 reads
An Out of Date CAP
The CAP Theorem talks about the properties of distributed systems, and how you can really only have two of them in any system.
2015-10-21
111 reads
On Learning from Experience and Misfortune
Phil Factor on learning from mistakes. Preferably other people's.
2015-10-19
144 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
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)...
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