The following applications can help you convert Access data into XML format: Access 2002, ADO 2.5, and SQLXML. Access 2002 (part of Microsoft Office XP) enables you to query or save a table in XML format. You might be able to automate this process. ADO 2.5 and later enables you to open the data into

Microsoft has updated Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) version 1.1 Service Pack 1 (SP1) to include support for Windows CE .NET devices. SQL Server CE 1.0 users must upgrade to SQL Server CE 1.1 before applying this service pack. Read SQL Server CE 1.1 SP1 Readme.txt Addi

Like many organizations, InCharge had a tangled web of spreadsheets all linked together that led to inefficiencies and data integrity issues, while increasing the burden placed on the finance department. If one link was wrong, there were significant delays. Critical operational data was being pulled

This KeyStone course teaches you to administer and troubleshoot information systems that incorporate the SQL Server™ 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, create SQL 2000 databases, manage, monitor and troubleshoot SQL 2000 databases, extract and transform da

by Brad M. McGehee – Learn what a SQL Server performance tuning expert has to say about performance tuning SQL Server.

By Barbara Darrow – WHEN IT comes to overall solution provider satisfaction with databases, a hotly contested category of late, Oracle and Microsoft shared top prize.While Microsoft bested Oracle in the technical criteria, Oracle edged out Microsoft in the channel areas. Given past allegatio

SQL Server 2000 Service Pack 2 (SP2) addresses specific issues that were discovered in SQL Server 2000 since its ship date. SP2 is available for download today in nine languages.

From SQLTeam – My assumption is that we’ll be able to write stored procedures, user-defined functions and possibly database level classes in languages such as C#, Visual Basic.NET, Perl, COBOL, Python, Ruby, J# (JScript?) and any other language that compiles to the Microsoft Intermediate Language (M

by Edward Whalen – Some of the most common SQL Server performance problems involve the I/O subsystem. Since SQL Server’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in SQL Server performance problems. M

By Wylie Wong – Rudder announced two new SQL Server products to make the database software more Web-services friendly. The company released the test version of SQL Server 2000 Notification Services, add-on software that allows businesses to send targeted messages to their customers based on t