This article demonstrates how you can use Surface Area Configuration utility in order to modify some of the security-related settings that have been applied during installation of SQL Server 2005 Express Edition.
2007-08-27
1,878 reads
One of the more interesting new features with SQL Server 2005 is the native encryption built into the product. Expert SQL crpytographer, Michael Coles, brings us a look at the symmetric keys in SQL Server 2005 and how they can be used to encrypt data and be secured by a certificate.
2007-08-24 (first published: 2007-05-11)
54,575 reads
Not the ones you think, but all good reasons to come to Denver. Read on for a bit of humor and find out how to come to the SQLServerCentral.com party!
2007-08-24 (first published: 2007-08-08)
2,454 reads
An easy to use .NET solution for Job Scheduling, with pluggable actions, that runs on a Windows Service. Backup your SQL Server Express and much more!
2007-08-24
2,266 reads
SQL Server 2005 includes support for encrypting and decrypting data for storage using EncryptByCert. Let’s look at how to implement this in the SqlCredit database.
2007-08-24
2,450 reads
One common need that DBAs run into is building a report that returns data in some random order. Especially if you're doing some type of contest, like giving something away at your User Group meeting. Andy Warren brings us a short article on this with a look at the performance impact of randomly ordering results.
2007-08-23
4,349 reads
Learn about 13 production disasters that can bring down your business
2007-08-23
4,454 reads
You can easily build Wiki Web sites with ASP.NET and SQL Server and provide your teams with one of the most powerful ways of collaborating on the Web.
2007-08-23
4,125 reads
Continuing on with his series on XML in SQL Server 2005, Jacob Sebastian brings us more examples on how to delve into the values of XML data.
2007-08-22
10,109 reads
Builder AU interviewed Greg via e-mail before the start of Tech.Ed 06 to talk about beta software, free databases, and the future of database development.
2007-08-22
2,376 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers