This article needs additional citations for verification .(March 2009) |
Microsoft SQL Server Data Engine (MSDE, also Microsoft Data Engine or Microsoft Desktop Engine) is a relational database management system developed by Microsoft. It is a scaled-down version of Microsoft SQL Server 7.0 or 2000 which is free for non-commercial use as well as certain limited commercial use. It was introduced at Microsoft TechEd in May 1999, [1] and was included as part of Microsoft Office 2000 Developer Edition. Its successor, SQL Server Express was released in November 2005. [2] Vendor support of MSDE ended on April 8, 2008. [3]
MSDE was initially designed by (then) Microsoft Program Manager Jeff Alger and later implemented by Peter Byrne (core), Ronald Martinsen (core/setup), and Mike Maringas (setup). Alger and Martinsen are the co-inventors who hold the patent. [4]
The initial release of MSDE is called the "Microsoft Desktop Engine", which is based on SQL Server 7.0 and was positioned as an alternative to using the Jet Database Engine used by Microsoft Access with a focus on its ability to operate as a client–server application instead of requiring direct access to the file system which the Jet database resided on. [5] Microsoft Access, the company's most popular database tool at the time, was expanded for its Office 2000 release to incorporate using Microsoft Desktop Engine as its back-end data store. This design was promoted by Microsoft as a solution for small workgroups that may eventually grow to require the full SQL Server product. [6] This initial release of MSDE also included the Data Transformation Services Wizard, which provided the ability to use OLE DB and ODBC data sources to transfer data between SQL Server 7.0 and MSDE. Supported operating systems at the time of its release included Windows 95, Windows 98, and Windows NT 4.0 Service Pack 4, and was available for both x86 and Alpha architectures. [7]
Microsoft Data Engine can be found in Microsoft Access 2000 and other Microsoft products. [8]
MSDE toolkit for Visual Studio 6.0 can be found in October 2000 MSDN DVD Office Test Platform and Development Tools, English Pack as MSDE for Visual Studio., [9] or in October 2000 MSDN CD Office Test Platform and Development Tools (English Pack, European Pack I, Japanese Pack, Latin American pack). [10]
It is based on SQL Server 2000. System requirement was changed to Windows 98. [11] [12]
MSDE could be distributed with commercial products by registering with Microsoft — in most cases this distribution is also free of charge.[ citation needed ] SQL Server's server licence includes right to distribute MSDE. [13]
MSDE 2000 includes following resource kits: MSDE 2000 Deployment Resource Kit, MSDE 2000 Web Resource Kit. [14]
MSDE 2000 is also found in various products, such as Microsoft Office XP (Professional, Developer), Visual Studio .NET 2002-2003. [15]
Compared with the full server editions of SQL Server 7.0 and 2000, MSDE has some restrictions: a limit of 2 GB databases, and has a workload governor which reduces its speed when eight or more concurrent workloads are running. [16] Microsoft has also stated that MSDE is not supported in Windows NT 6.0 operating systems such as Windows Vista. [17] No graphical user interface management tools were released for MSDE, but SQL Server 2000's Enterprise Manager (as well as later versions such as SQL Server Management Studio) can be used to connect to it. [18]
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.
The Microsoft Windows Script Host (WSH) is an automation technology for Microsoft Windows operating systems that provides scripting abilities comparable to batch files, but with a wider range of supported features. This tool was first provided on Windows 95 after Build 950a on the installation discs as an optional installation configurable and installable by means of the Control Panel, and then a standard component of Windows 98 and subsequent and Windows NT 4.0 Build 1381 and by means of Service Pack 4. The WSH is also a means of automation for Internet Explorer via the installed WSH engines from IE Version 3.0 onwards; at this time VBScript became means of automation for Microsoft Outlook 97. The WSH is also an optional install provided with a VBScript and JScript engine for Windows CE 3.0 and following and some third-party engines including Rexx and other forms of Basic are also available.
Microsoft Visual Studio Express was a set of integrated development environments (IDEs) that Microsoft developed and released free of charge. They are function-limited version of the non-free Visual Studio and require mandatory registration. Express editions started with Visual Studio 2005.
Microsoft Project is project management software product, developed and sold by Microsoft. It is designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.
The Access Database Engine is a database engine on which several Microsoft products have been built. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database.
Microsoft BizTalk Server is an inter-organizational middleware system (IOMS) that automates business processes through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.
Microsoft Data Access Components is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store. Its components include: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC). There have been several deprecated components as well, such as the Jet Database Engine, MSDASQL, and Remote Data Services (RDS). Some components have also become obsolete, such as the former Data Access Objects API and Remote Data Objects.
An IFilter is a plugin that allows Microsoft's search engines to index various file formats so that they become searchable. Without an appropriate IFilter, contents of a file cannot be parsed and indexed by the search engine.
SQL Server Notification Services is a platform developed by Microsoft for the development and deployment of notification applications based on SQL Server technology and the Microsoft .NET Framework. Notification Services offers a scalable server engine on which to run notification applications, with multi-server capability-providing flexibility and scalability for deploying applications.
Microsoft XML Core Services (MSXML) are set of services that allow applications written in JScript, VBScript, and Microsoft development tools to build Windows-native XML-based applications. It supports XML 1.0, DOM, SAX, an XSLT 1.0 processor, XML schema support including XSD and XDR, as well as other XML-related technologies.
Microsoft SQL Server Express is a version of Microsoft's SQL Server relational database management system that is free to download, distribute and use. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The "Express" branding has been used since the release of SQL Server 2005.
Resource Kit is a term used by Microsoft for a set of software resources and documentation released for their software products, but which is not part of that product. Resource kits offer supplementary resources such as technical guidance, compatibility and troubleshooting information, management, support, maintenance and deployment guides and multipurpose useful administrative utilities, which are available separately.
Microsoft SQL Server Compact is a discontinued relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.
Visual Studio is an integrated development environment (IDE) developed by Microsoft. It is used to develop computer programs including websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms including Windows API, Windows Forms, Windows Presentation Foundation (WPF), Windows Store and Microsoft Silverlight. It can produce both native code and managed code.
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
Microsoft Azure Dev Tools for Teaching or simply Azure Dev Tools for Teaching is a Microsoft program to provide students with Microsoft software design, Microsoft developer tools, Cloud Computing Access and learning resources. The program is available for university/college and K-12 students Azure for Student and Azure Dev Tools for teaching are available in more than 140 countries.
Windows Search is a content index and desktop search platform by Microsoft introduced in Windows Vista as a replacement for the previous Indexing Service of Windows 2000, Windows XP, and Windows Server 2003, designed to facilitate local and remote queries for files and non-file items in the Windows Shell and in compatible applications. It was developed after the postponement of WinFS and introduced to Windows several benefits of that platform.
Microsoft started development on the .NET Framework in the late 1990s originally under the name of Next Generation Windows Services (NGWS). By late 2001 the first beta versions of .NET Framework 1.0 were released. The first version of .NET Framework was released on 13 February 2002, bringing managed code to Windows NT 4.0, 98, 2000, ME and XP.
Embedded Visual Basic or eVB, is an implementation of Microsoft Visual Basic which is geared towards generating programmes for embedded systems such as PDAs, cellular telephones, pocket computers and other programmable electronic systems and devices, generally for use under Windows CE. The tools themselves run on desktop operating systems such as Windows 98, Windows NT, Windows XP and subsequent. The tools are also capable of compiling executables for Windows NT Embedded as well.
The history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the OS/2 operating system, released in 1989.