SQL Server Memory Configuration, Determining MemToLeave Settings
Tweaking SQL Server memory settings to provide support for managed code.
2009-07-06
12,398 reads
Articles
Different ways to execute an SSIS package
In SQL Server 2005 and higher versions there are different ways in which one can execute an SSIS package. Let us go through each option one by one.
2009-07-06
4,591 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds of technical questions hiring managers can ask a prospective DBA candidate in order to determine their technical proficiency. While technical skills are...
2009-07-06
2,966 reads
Resources for Upgrading to SQL Server 2008
Use these resources as aids in upgrading to SQL Server 2008. These references are from the downloadable white paper:
2009-07-06
2,842 reads
Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
2009-07-05
471 reads
Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
2009-07-05
497 reads
A Generic Process to Convert XML Data - Part 1
Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.
2009-07-03 (first published: 2008-08-25)
16,836 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I "pay" for content. I said "no" at first, but wanted to follow up with more details. Since this was across Twitter , 140 characters...
2009-07-03
1,442 reads
Remote BLOB Store Provider Library Implementation Specification
This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.
2009-07-03
1,269 reads
Taking Advantage of Sample Reporting Services Reports
Recent installments of our series dedicated to SQL Server 2005 Express Edition have discussed the Reporting Services component. This article provides an overview of sample reports that you can take advantage of in order to familiarize yourself with the more advanced graphical designer features present in SQL Server 2005 Express Edition-based Reporting Services.
2009-07-03
2,764 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