The Google Containers
After my editorial on portable data centers, I had a number of people knock down the idea, saying it doesn’t...
2009-04-23
816 reads
Internal Outsourcing
We'll all heard about or lived with outsourcing, and hopefully we know it's good and bad. Outsourcing the janitorial services...
2009-04-22
978 reads
Day of DotNutNuke in Tampa on June 13, 2009
My friend Will Strohl is managing the Day of DNN on June 13, 2009 at the Microsoft office in Tampa....
2009-04-22
708 reads
Behind Every Great Restore is a Great Backup
Behind Every Great Restore is a Great Backup
I showed you how to do a database backup with powershell a few...
2009-04-22
2,515 reads
Thoughts on SSC Blog Site Improvement
I have been reading blogs from various sources, such as blogs on SSC, and on sqlblog.com etc. However on all...
2009-04-22
753 reads
Human Data Quality
Disclaimer: I read and speak one language, having failed pretty well at learning Latin, Spanish, and then Japanese in my...
2009-04-22
1,050 reads
Catalog View: sys.sql_logins
When it comes to logins to SQL Server, there are basically 3 types:
SQL Server-based loginsWindows user accountsWindows security groupsThe latter...
2009-04-22
6,934 reads
PASS Connector Editorial for April 22, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-22
569 reads
Brand <> Reputation?
I was reading a book recently and it equated brand with reputation. My first thought was "aha", that brand is...
2009-04-21
1,026 reads
SQLSaturday #14 in Pensacola Update
Karla just emailed that the schedule is set, details at http://www.sqlsaturday.com/schedule.aspx, but to save you time here are the speakers...
2009-04-21
625 reads
Blogs
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)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
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