More CPU Means More Data
Faster CPUs allow us to perform more complex modeling and analysis of variables, and hopefully come up with better decisions. However that more complex analysis means more data.
2012-09-13
175 reads
Editorials
Creativity
What if you could stop all work for a month and have people find ways to improve the business? Would you take the chance?
2012-09-12
158 reads
Mining and Algorithms
The algorithms that you use to query or mine data are very important. Amazon knows their recommendations algorithms are important. Do you know what's important in your job?
2012-09-11
283 reads
A Cloudy Future
The future of employment in the technology industry means learning to do more with less.
2012-09-10
140 reads
Document First, Code Later
Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema.
2012-09-10
299 reads
The Dream Machine
This Friday Steve Jones has a fun poll. If your new boss told you to spec out a machine, what would you choose?
2012-09-07
147 reads
Privacy
Privacy is a big deal in the digital world, but it's also something companies don't handle well. Steve Jones notes that however things change in the future, the data professional will need to pay more attention to issues in this area.
2012-09-06
101 reads
Rogue Algorithms
As computers get more complex and automated, the chance for rogue algorithms grows. Steve Jones reminds us that we should be careful in how we code and that a little forethought from managers can help.
2012-09-05
207 reads
Ridiculous
Bad behavior at conferences hasn't been a problem at SQL Server events, but it has been elsewhere. Steve Jones thinks this is unacceptable.
2012-09-04
338 reads
2012-09-03
66 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
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