Learn how to connect embedded devices to Enterprise information systems with Microsoft SQL Server 2000 Windows CE Edition 2.0 and the .NET Compact Framework.
Tag: sql server
Appropriate Uses of MSDE
Several Microsoft product licenses convey the right to use and redistribute the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) version 2.0. Review the information on this page to learn which product licenses or subscription services convey the redistribution rights you require. In all cases, y
Comparative Lab Report: Client Tools for Analysis Services
Analysis Services doesn’t include a client tool for querying, reporting, or analyzing data, so unless you write a custom client browser, you have to find a commercial application. But which one? This review will help you choose the right tool.
Preparing and Mining Data with Microsoft SQL Server 2000 and Analysis Services
Learn how to apply data mining to a real-world situation using SQL Server 2000, Microsoft SQL Server 2000 Analysis Services, and Microsoft Visual Basic® 6.0. Clean and prepare a real-world dataset for data mining, create data mining models from the cleaned data, and choose the best mining model for
HOWTO: Retrieve XML Data with an XPath Query in an ASP Client
This article demonstrates how to retrieve an eXtensible Markup Language (XML) data stream from a SQL Server 2000 mapping schema by using an XPath query for an Active Server Pages (ASP) client.The sample also allows you to test XPath queries against the mapping schema. Two methods are used to
Processor Performance
by Joe Chang – Learn how a server’s CPU can affects its performance.
Changing Times
By Itzik Ben-Gan – With many calendars in use and varying ways of expressing times and dates around the world, keeping everything straight in your calculations could be a nightmare—but it doesn’t have to be.
True DBA blooper #3: Wildcard runs wild
By Sara Cushman – Sometimes a simple plan to save time can really backfire. In Oracle DBA Ron Horjus’ case, a mistake he made while implementing a new file path naming standard was so memorable, and miserable, that the details are vivid more than a decade later. At the start, Horjus simply intended
Microsoft patches up SQL Server
By Joris Evers – MICROSOFT POSTED A cumulative patch for its SQL Server 7.0 and 2000 database software late Wednesday, also patching four new vulnerabilities.Also affected are Microsoft Data Engine (MSDE) 1.0 and MSDE 2000, products often used with SQL Server, Microsoft said in security bull
Creating a Consolidated Information System
by Walt Jordan – Multek is an international supplier of cell phone boards, backplanes and Internet servers, switches and hubs and other printed circuit board (PCB) technologies. With a global network of companies in The Americas, Europe, and Asia, it offers its customers a broad spectrum of PCB engi
