by Roman Rehak – Take advantage of undocumented stored procedures to output SQL Server table metadata your code can use.

By Russ Whitney – When you want to secure selected data, you have options other than Analysis Services. Here’s a customized, flexible way to manage dimension-level security.

There are not many books out there that deal with SQL Server security. Fortunately, Curlingstone recently published this book, which is entirely dedicated to SQL Server security.

By Vyas Kondreddi – By default SQL Server is case insensitive, and performing a case sensitive search is not very intuitive. This article shows you how to implement case sensitive searches in SQL Server, using different techniques like conversion to binary datatype, COLLATE clause, BINARY_CHECKSUM f

By Michael Otey – There are more ways to stop SQL Server than you might think.

Learn Microsoft’s Security Best Practices for the .NET Framework, Windows 2000 Advanced Server, IIS 5, and SQL Server 2000, from eWeek’s OpenHack IV Competition.

Try to perform backup at the local hard disk first, and copy backup file(s) to the tape later. Check out this tip and others.

Join Author Bill Pearson in an exploration of the MDX Data Model. In this article, we expose the syntax for the basic building blocks of the MDX query, tuples, sets, and axes, and set the stage for exploring more advanced components and syntax in subsequent articles.

A growing consciousness of security has brought Microsoft SQL Server database security into focus as never before. Planning for database security should begin early in the development process and there are important vulnerabilities that you need to prevent in your application’s SQL Server.

Chandu Thota explains how to design and implement a Web Service provisioning system using the .NET Framework and SQL Server 2000, and then outlines various scenarios for putting this system to work.