Articles filed in category 'SQL Server 2000'

Developing Database Agnostic Applications with Entity Framework

By: Sergey Barskiy (Tyler Technologies)

Last updated: Wednesday, August 31, 2022

Published in: CODE Magazine: 2010 - March/April

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.

• C#
• Design Patterns
• Entity Framework
• Oracle
• SQL Server
• SQL Server 2000
• SQL Server 2005
• SQL Server 2008

Using the Amazon Web Service SDK for .NET

By: Rod Paddock

Last updated: Wednesday, August 31, 2022

Published in: CODE Magazine: 2010 - March/April

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).

• C#
• Cloud Computing
• REST
• SQL Server
• SQL Server 2000
• SQL Server 2005
• SQL Server 2008
• VB.NET
• Web Services

The Baker's Dozen: 13 Productivity Tips for Database Development Using Transact-SQL

By: Kevin Goff

Last updated: Tuesday, February 19, 2019

Published in: CODE Magazine: 2005 - March/April

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.

• Data
• SQL Server
• SQL Server 2000
• Tips

Testing SQL Server 2000: Inspecting Configuration Information

By: Talmage, Ron

Last updated: Wednesday, February 20, 2019

Published in: CODE Magazine: 2002 - March/April

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.

• Data
• SQL Server
• SQL Server 2000

XPath Queries in SQL Server 2000

By: Vandersypen, Travis

Last updated: Wednesday, December 8, 2021

Published in: CODE Magazine: 2001 - Issue 1

Imagine the potential of accessing your database without needing to know any specifics about how that data is stored.Imagine the possibility of allowing your DBA the freedom to change the database structure without affecting your software code. Impossible? Not with XPath Queries and XDR Schemas. Using these two methods, practically any developer can write a program to access data in SQL Server 2000, just by knowing the structure of the XML documents returned by the server.

• Data
• SQL Server
• SQL Server 2000
• XML