Using SP Configure - SQL School Video
Learn how you can configure your SQL Server instance using T-SQL code and sp_configure. MVP Andy Warren hosts this SQL School video.
2009-07-28
5,009 reads
Articles
2009-07-28
514 reads
Checking SQL Server Agent jobs using Windows PowerShell
Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?
2009-07-28
3,655 reads
SQL Server 2008 Learning Guide
This guide provides an in-depth look at SQL Server 2008, with information on upgrading, overviews of the most important new features, and details on future releases.
2009-07-28
3,337 reads
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
2009-07-28
659 reads
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
2009-07-28
758 reads
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
2009-07-28
684 reads
Celko's Summer SQL Stumpers: Prime numbers
Our first Stumper sees Joe Celko providing a conundrum with a prize for anyone who can come up with a better solution than he can.
2009-07-27
3,245 reads
Exploring packages in code
This post builds on some of the previous code and shows how you can explore all objects inside a package. I took the sample Task Search application I’d written previously, and came up with a totally pointless little console application that just walks through the package and writes out the basic type and name of every object it finds, starting with the package itself e.g. Package – MyPackage .
2009-07-27
1,354 reads
Obtaining data changes with Change Tracking in SQL Server 2008
Yan Pan illustrates how to obtain data changes using the CHANGETABLE function and presents two algorithms that you can implement in your .NET application using Sync Services.
2009-07-27
2,432 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