When your business outgrows your database systems, using globally unique identifier (GUID) values in Access and SQL Server can offer a timely solution.

by Brian Lockwood – Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures, you can ensure that your data can be accessed i

By Gary Zaika – Information about setting up server-requested SSL encryption in a clustered SQL Server environment is hard to come by. But these clear steps pave the way to a straightforward implementation.

By Joe McKendrick – They’re big, and they’re getting bigger. New statistics out of Winter Corporation – an analyst firm that tracks database size on an annual basis – find that databases are poised to hit the 100-terabyte mark within the next two years. Remarkable, considering that just a year ago,

Interview by Lee Thé – Find out about the future of SQL Server 2000 and extreme scaling from Microsoft’s resident expert in large databases.

By Vyas Kondreddi – Unfortunately, there is no built-in support for arrays in SQL Server’s T-SQL. This article provides 5 different techniques to simulate arrays in T-SQL, with working examples. It also provides you with links to additional information and books.