CODE Magazine / Articles
SQL Server 2000
Articles filed under SQL Server 2000
Articles
Showing 1–5 of 5
-
Developing Database Agnostic Applications with Entity Framework
Microsoft released Entity Framework, an ORM (Object Relational Mapping) tool, in 2008.Entity Framework gives developers the ability to be abstracted from the underlying relational database management system and allows them to talk to a database using familiar LINQ-based syntax.
-
Using the Amazon Web Service SDK for .NET
Updated
The richest set of cloud computing services comes from a little e-commerce company known as Amazon.com. Developers can access the Amazon Web Services (AWS) platform using numerous tools including the .NET platform.Amazon.com is a major player in the cloud computing space and has numerous services available to developers. In late 2009, Amazon released the AWS SDK for .NET. This article will demonstrate using the AWS SDK to create a custom backup service using the Amazon Simple Storage Service (S3).
-
The Baker's Dozen: 13 Productivity Tips for Database Development Using Transact-SQL
Updated
Many application developers face the challenges of working with SQL Server 2000.These challenges include retrieving and grouping large amounts of data, building result sets, and tracking changes to data. All require professional strategies that hold water against a seemingly endless number of possibilities. This installment of "The Baker's Dozen" presents a variety of real-world database situations and how you can use Transact-SQL and SQL-92 to tackle these issues.
-
Testing SQL Server 2000: Inspecting Configuration Information
Updated
Testing SQL Server is an often-overlooked area of the software development process, because programmers primarily place testing focus on code residing in the middle tier or the client desktop, rather than the database. However, as SQL Server databases become a more important component of applications, they cannot be left out of the developer's testing process. An important place to start, to ensure your code works the way you want it to, is with SQL Server configuration.The focus of this column is to examine issues dealing with testing SQL Server 2000 databases using SQL Server's built in language, Transact-SQL, as the primary testing tool.
-
XPath Queries in SQL Server 2000
In this article, Travis Vandersypen explains how XPath Queries combined with XML-Data Reduced (XDR) Schemas enable developers to access and query SQL Server 2000 data without needing detailed knowledge of SQL or database structure. By defining XML schemas that map database tables and relationships, developers can retrieve and manipulate XML-formatted data directly via URLs using familiar XPath syntax. This approach shifts complexity to DBAs, allowing schema changes without impacting application code, and facilitates more flexible, XML-based data access and integration in SQL Server 2000 environments.