By Russ Whitney – You might not realize it, but the .NET shift is going to be a major seismic event. Use this overview to recognize the shift’s leading indicators and prepare for the changes it will bring.

In this article, Alexander Chigrik shows you how to view the transaction log in SQL Server 6.5and 7.0. It’s not the complete transaction log but it does help you debug problems.

By Vyas Kondreddi – This article shows you how to process hierarchical/tree structured data in T-SQL and provides you with resources and advanced techniques for managing hierarchies in SQL Server.

By Baya Pavliashvili – The easiest and oldest way to maintain indexes is to drop and recreate them. If your application has hundreds or even thousands of tables with a few indexes on each it would be quite a task to go through each one of them and recreate the indexes. The larger the table the longe

I have a Microsoft Access 2000 application that is populated by a back-end SQL Server 2000 database. To prevent Access users from viewing all the data in a SQL Server 2000 table, I want to use a view that displays only the data rows the user has been authorized to see. Can I create a view that limit

By Dennis Fisher – Microsoft Corp. issued a patch for three critical vulnerabilities in one of its .Net servers, the Microsoft Content Management Server 2001 (MCMS). Potentially the most serious of the three is a SQL injection vulnerability in a function that responds to requests for images a

by Brad M. McGehee – SQL Server includes many built-in tools for the DBA, database designer, and database developer. Enterprise Manager, Query Analyzer, DTS, and other tools provide a wide array of functionality. If you are a beginner, you may find these tools a little overwhelming, but as you gain

To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney (who used Ron Soukup’s fantastic first edition as a starting point) explains how SQL Server 2000 works at a le

From SQLTeam – In this article I show you how to create a DTS Package that can be used to automate a file download/import process. It’s a little longer than the other articles I have written for SQLTeam and will require some work on your part if you want to implement it, but I think you will find it

by Joe Chang – Learn about the various chipsets, and their pros and cons, available for your SQL Server.