InfoQ

Topic/Tag specific view

All content and news on InfoQ about SQL Server 2000


Latest featured content about SQL Server 2000

Book Excerpt and Review: Hitchhiker's Guide to Visual Studio and SQL Server

Community
.NET
Topics
Data Access

With SQL Server 2000's hitting its end of life date next April, many shops that have been delaying the upgrade to SQL Server 2005 need to start looking at it seriously. This is why we have chosen to review the seventh edition of William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server.

News about SQL Server 2000

DbFit 1.0 With Enhanced Querying Capabilities and User Docs

Community
.NET,
Agile,
Java
Topics
Delivering Quality,
Unit Testing

Gojko Adzic has recently announced the version 1.0 release of DbFit, his popular FIT/FitNesse extension used for practicing TDD on database code.

Microsoft Ups Their Support for PHP

Community
.NET
Topics
Web Frameworks

PHP is a cornerstone of LAMP development. In an attempt to lure PHP developers off Linux and MySQL, Microsoft is beginning to offer deep support for PHP in IIS 7 and SQL Server.

SQL Server 2005 Best Practices Analyzer Preview

Community
.NET
Topics
Artifacts & Tools

A CTP of the SQL Server 2005 Best Practices Analyzer is now available. This tool can be thought of as FXCop for SQL Server.

Visual Studio for Database Professionals Released

Community
.NET
Topics
Unit Testing,
SQL Server,
Build systems

Microsoft has developed what they call "tools for building SQL databases in a managed project environment with support for versioning, deployment, unit testing, refactoring, and off-line SQL development." These tools, released under the name Visual Studio for Database Professionals, claim to offer a way to develop databases in the same off-line fashion as traditional applications.

SQL Server Hosting Toolkit CTP 1 Released

Community
.NET
Topics
Data Access

Microsoft has released the first CTP of its SQL Server Hosting Toolkit. This toolkit is designed to provide support for companies using a hosted SQL Server.

Upgrading SQL Server - xp_execresultset

Community
.NET
Topics
Data Access

SQL Server 2000 had a useful, though undocumented, function called xp_execresultset. Unfortunately for those currently using it, SQL Server 2005 has dropped this feature.

English Query Discontinued in VS 2005

Community
.NET
Topics
Data Access

English Query, a tool that translated queries written in English into SQL queries, has been discontinued.