By Vyas Kondreddi – This article discusses the security model of Microsoft SQL Server 7.0/2000 and security best practices to help you secure your data. Special thanks to my friend Divya Kalra for her valuable input and content review.

This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server. The steps described in this article assume that you will not move the master , model , tempdb , or msdb system databases. The steps pr

by Anil Desai – You don’t have to be a DBA for a worldwide organization to pass this test, but you’d better know all the ins and outs of large database administration.

Web-based SQL Server 2000 Enterprise Manager. Create, add, edit, delete, and administer all aspects of your SQL Server databases online. Creates completes ASP Insert and Update codes for your tables. Builds Stored Procedure Search Engine automatically.

By Itzik Ben-Gan – Next time someone tells you to think outside the box, try this rectangular technique.

By Shelley Doll – A nontechnical development manager puts a huge amount of trust in his or her team. When the team misses a deadline, or functionality doesn’t work as expected, it can be hard to know why if you don’t understand the lingo. How can you tell if your trust is being taken advantage of, w

In this article, Alexander Chigrik shows you how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL Server supports and what is the advantage and disadvantage of using indexes in a particular situation.

by Vyas Kondreddi – Recently, someone asked in a Microsoft public SQL Server newsgroup how can you sort characters within a string? For example, a string contains ‘CBA’, and he wanted to sort the characters within the string and make it ‘ABC’. Instead of going for a procedural solution, just for fun

The SQLFulltextsearch.exe file contains the SQL Server 2000 Full-Text Search Deployment white paper.

Get the latest update to SQLXML with new security features and performance enhancements.