The Best Days
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
2009-05-14
181 reads
Articles
The Best Days
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
2009-05-14
466 reads
What's a DBA
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job posting only to find that it's not what you do? Or asked for a DBA resume from a recruiter and gotten something other than what you expected? Or...
2009-05-14
1,999 reads
XML Data Modification Language Workbench
XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases, this is the most efficient way to modify elements in an XML column, yet the techniques of using XML-DML have not been well, or simply, described - up until now. Robert Sheldon presents a practical workbench to show the various modify methods
2009-05-14
1,420 reads
Setting up a SQL cluster under MS VS2005 R2 Part1
This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.
2009-05-13
5,161 reads
Cambridge SQL UG - SSIS and SSRS sponsored by Redgate
Come and join us for this great evening focusing on SQL Server Integration Services and Reporting Services in Cambridge, UK on Wed, May 20, 2009.
2009-05-13
1,313 reads
Rant: Is It an Effective Control or Not?
This is spurred on by a comment a pen tester made. He was referring to a particular technology and said something to the effect of, "What do you expect? It's 30 year-old technology." I was stunned when the comment was relayed to me. My response...
2009-05-13
2,363 reads
Report Design Tips and Tricks
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is frequently requested.
2009-05-13
4,606 reads
Swap column data due to inserting data into wrong columns for SQL Server table
This article is for newbies who have just started their career in SQL development. Everyone might have faced this problem when importing or inserting data into tables when they accidentally put the data in the wrong columns. The first thought would be to delete the data and start over, but in this tip we look at a simple solution to swap the data.
2009-05-13
2,356 reads
The Rights for Data
As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.
2009-05-13
751 reads
Blogs
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
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