Coping with No Column Names in the SSIS OLEDB Data Source Editor
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
New Isolation Levels Available in SQL Server 2005
One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.
SQL Server 2008 - Table Valued Parameters
In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.
Writing Outer Joins in T-SQL
Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
Ideas for SQLServerCentral.com
We're embarking upon a rebuild of the site and we're looking for input from those of you that use the site.
Snapshots - Part 1
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
Using the ReportViewer Control in a WebForm with Parameters
A short article by Darren Herbold, reporting services trainer and consultant that shows how you can easily use a Report Viewer on a web page.
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Blogs
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
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...
Forums
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...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
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