Vote now for the Exceptional DBA of 2009
The voting has begun to find 2009's Exceptional DBA - Tell us who you think should be taking home the award this year!
2009-08-10
43 reads
The voting has begun to find 2009's Exceptional DBA - Tell us who you think should be taking home the award this year!
2009-08-10
43 reads
Let's say it is a late Monday morning, because something always comes up before you are required at your vocation,...
2009-08-10
5,608 reads
Learn the difference between push and pull subscriptions and how to determine the best placement for SQL Server replication's Distribution Agent
2009-08-10
3,198 reads
Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).
2009-08-10
9,037 reads
James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)
2009-08-07 (first published: 2008-07-14)
20,768 reads
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
600 reads
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
579 reads
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
70 reads
Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing. Richard Stallman isn't like that. Richard (rms) is one of the great brains behind Linux distros, as he wrote the GNU compilers and GNU debugger. He is driven by strong opinions about the nature of free software, and the restrictive nature of software copyright. We sent our intrepid reporter, Richard Morris, to find out if Richard Stallman really required journalists to read parts of the GNU philosophy before an interview, for "efficiency's sake".
2009-08-07
2,874 reads
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-07
3,559 reads
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Most embedding pipelines on AWS have the same shape: a job reads rows out...
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
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