By Ken Spencer-Data-access code is usually the foundation to building any Web application. Developers typically write ADO code that uses either the Command or Recordset object and sets various properties. Then, the code either executes a SQL statement or calls a stored procedure. Creating this code

Database developers have long understood the importance of designing a database to scale appropriately to accommodate future requirements. When developing a Microsoft Access 2000 database, it’s important to consider which engine the database will use: Microsoft Jet 4.0 or Microsoft Data Engine (MSDE

Microsoft has released beta 1 versions of two new software development kits (SDKs) for its .NET suite. The .NET Framework and .NET Mobile Web SDKs are available for download at http://www.msdn.microsoft.com/downloads/default.asp.

SQL Server 7.0 specifically addresses these mobile-computing requirements. It provides scalability from laptop computers to Symmetric Multiprocessing (SMP) servers, enabling the same application to be deployed on the widest range of options available. SQL Server Desktop, which runs on Microsoft Wind

Microsoft has released a security patch to repair a flaw in an application programming interface (API) that works with extended stored procedures (XPs). A user exploiting this breach could execute foreign code or shut down the server.

by Karen Watterson, Bill Shadish, Garth Wells-How to get take complete advantage of your SQL Server database. SQL Server maven Karen Watterson is back with another invaluable batch of her trademark wisdom and expertise. Unlike other books that simply introduce database administrators and developers

This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code exa

Microsoft SQL Server 2000 Analysis Services Step by Step shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You'll discover why these services make it ea

Data and transaction security is of paramount importance in this age of rapidly expanding commercial and government computer networks and the emerging Internet economy. The inherent challenges of the security issue have become a top priority in every company that makes use of information technology.

Embarcadero Technologies, Inc., a provider of database lifecycle management solutions, announced that it has acquired privately held Engineering Performance, Inc. Engineering Performance is a developer of database performance analysis and testing software. Under the terms of the agreement, Embar