The SQL Internals Viewer
Danny Gould has written a very interesting piece of software that gives you a view into the storage of your data inside SQL Server. And it's FREE!!! He brings us a description of this software in this short article.
Accessing and Updating Data in ASP.NET 2.0: Accessing Database Data
This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.
SQL Server 2005 Express Edition - Part 4 - Surface Area Configration
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.
SQL 2005 Symmetric Encryption
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.
Ten Reasons to Attend the PASS Summit
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!
SQL Agent - A Job Scheduler Framework
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!
SqlCredit Part 6: Exploring EncryptByCert and DecryptByCert
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.
Getting Random Results
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.
13 disasters for production web sites and their solutions
Learn about 13 production disasters that can bring down your business
Building Wiki Web Sites with ASP.NET and SQL Server
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.
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers