This document provides guidelines for implementing an ADO.NET-based data access layer in a multi-tier .NET application. It focuses on a range of common data access tasks and scenarios and presents guidance to help you choose the most appropriate approaches and techniques.

BY: Eric B. Parizo – Thanks to a pair of new offerings from Microsoft, not only can applications built with Visual Studio.NET now connect natively to Oracle databases, but Java applications can also access Microsoft SQL Server databases. SearchVB spoke with AMR Research senior analyst Peter Urban ab

Take advantage of the SQL Server .NET data provider to access SQL Server data using ADO.NET, as it offers the best overall performance. It can be used to access both SQL Server 7.0 and SQL Server 2000 databases.Check out more tips!

By AjarnMark from SQLTeam – In Part 1, I introduced the basic options for upsizing a SQL Server from version 7.0 to 2000. One important part of that article was the list of what has to be moved. Here in part 2, I will take that list and explain how I accomplished all of this on 53 separate databases

By Frances Keeping – Did you know that your database can tell you how to increase your revenue and build customer loyalty? With Analysis Services, mining your data for gold is easy.

If you use an application based on Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Replication or Remote Data Access (RDA), you may receive an error message similar to the following when you use an invalid password for use with Microsoft Internet Information Server (IIS) servers that ar

By Brian McWilliams – An Internet worm that targets insecure Microsoft databases has quickly displaced forerunners Code Red and Nimda as the top source of computer attacks, experts said.

Book by Rahul Sharma – The name of this book is a little misleading. Based on its name, you might think that this book is only of interest to those who have used SQL Server 6.5 or 7.0, and who are moving to SQL Server 2000. This is not really the case. Although the book does place a lot of […]

Service packs are the means by which Microsoft distributes bug fixes. Service packs keep a product current. Service packs include updates and may include system administration tools, drivers, and additional components, which are conveniently bundled for easy downloading. Service packs are cumulative

By Alexander Chigrik – There are two security modes (authentication modes) in SQL Server 7.0:Windows NT AuthenticationMixedThe security mode is selected during SQL Server 7.0 installation and can be modified at any time. To change the security modes, you can do the following: