Logical CPU, Physical CPU and hyper threading
Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.
-- Hardware information from...
2011-10-30
11,552 reads
Blog Posts
DATABASE_OBJECT_CHANGE_GROUP do not audit SP or other object
Deepak Kumar (friend of mine and founder of http://www.sqlknowledge.com ) were chatting yesterday. We were discussing about audit feature in SQL...
2011-10-29
1,876 reads
Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-29
1,626 reads
Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,039 reads
Updatable Subscriptions Removed in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
2,005 reads
A Thought on Career Decisions
One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction...
2011-10-28
644 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2011-10-28
9,314 reads
Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two...
2011-10-28
1,044 reads
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,521 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,974 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 KCU SCBD Telp:08218154392
WA CS (08218154392) Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
BCA KCU GADING SERPONG Telp:08218154392
WA CS (08218154392) Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia...
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
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