OT: Goodbye Dad
This is a bit of ramble.
At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with...
2011-11-21
854 reads
Blog Posts
OT: Goodbye Dad
This is a bit of ramble. At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with his Lord and Savior, Jesus Christ. I...
2011-11-21
12 reads
See if Auto Create Statistics is enabled using PBM
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. ...
2011-11-21
1,394 reads
SQL Family – an Update
At the beginning of the month, we had a Meme Monday on the topic of SQL Family. I had a...
2011-11-21
665 reads
SQL Family – an Update
At the beginning of the month, we had a Meme Monday on the topic of SQL Family. I had a few things to say about the SQL community back...
2011-11-21
9 reads
SQL Server 2012 RC0 Is Here
SQL Server 2012 Release Candidate 0, Time To Get Serious
With the release of RC0 Microsoft has signaled that the release...
2011-11-21
1,531 reads
SSAS Processing Mode (Lazy Aggregations)
Processing mode property of a partition/measure group determines how partitions will be available to users.
Processing mode has two possible options.
Regular....
2011-11-21
3,274 reads
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the...
2011-11-21
660 reads
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the sp_MStableSpace script. Not a lot more to be said...
2011-11-21
10 reads
An Informal Compendium of SSAS Errors, Part 6: Common Errors
This is the last in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-20
1,297 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