SQL Server Collation
Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
--To find...
2011-10-18
538 reads
Blog Posts
SQLInspireNYC Event - We're giving away SQL MVP Deep Dives Vol.2
Now the PASS has well passed, folks are setting their sites on our upcoming NYC SQLPeople event called SQLInspireNYC .
SQLPeople...
2011-10-18
939 reads
Understanding Kerberos, Part II
The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...
2011-10-18
4,062 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,482 reads
Extended Events Data
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,880 reads
Guest Appearance in DBA in Space
Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...
2011-10-17
1,444 reads
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,252 reads
PASS Summit 2011 recap
Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...
2011-10-17
1,461 reads
PASS Summit 2011: Wrap-Up
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,442 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,141 reads
Blogs
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...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
KONTAK BCA KCP Joyoboyo Telp:08218154392
WA CS (08218154392) Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125
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...
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