Printer Friendly
The Free Library
22,728,043 articles and books


Microsoft Corp. (NASDAQ NASDAQ
 in full National Association of Securities Dealers Automated Quotations

U.S. market for over-the-counter securities. Established in 1971 by the National Association of Securities Dealers (NASD), NASDAQ is an automated quotation system that reports on
:MSFT MSFT Microsoft (stock symbol)
MSFT Movimento Sociale Fiamma Tricolore (Italy)
MSFT Multi-Stage Fitness Test
MSFT Master of Science in Family Therapy
MSFT Macalester Students for Fair Trade
), Redmond, Wash., has announced it would add support for the AMD (Advanced Micro Devices, Inc., Sunnyvale, CA, A major manufacturer of semiconductor devices including x86-compatible CPUs, embedded processors, flash memories, programmable logic devices and networking chips.  Opteron(TM) with Direct Connect Architecture in Microsoft(R) SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. (TM) 2005, the next generation of Microsoft's flagship database product. The enhanced functionality provides customers and partners with simultaneous high-performance 32-and 64-bit computing, which gives them the technical and business flexibility to solve their unique problems in a way that best meets their needs. In addition, it supplies customers with a compelling and cost-effective alternative to UNIX-based solutions through 64-bit capabilities that deliver both high scalability and lower cost of ownership. By introducing AMD Extended System architecture in SQL Server 2005, Microsoft is adding a new offering complementing the high-performance 64-bit Intel Itanium support in SQL Server 2000.

"The AMD Opteron processor provides SQL Server 2005 Beta 2 testers with the investment protection of outstanding overall x86 performance in both 32-bit and 64-bit computing environments. As enterprises transition from 32- to 64-bit computing, they need the smooth migration path to 64-bit computing that AMD64 provides," said Marty Seyer, corporate vice president and general manager of the Microprocessor Business Unit, Computation Products Group at AMD. "We invite beta testers to experience for themselves how AMD64 with Direct Connect Architecture can help eliminate the bottlenecks inherent in a front-side bus and improve overall system performance and efficiency."

SQL Server 2005 Beta 2 Available Today

In addition to the added 64-bit components that are available today in SQL Server 2005 Beta 2, beta testers will see a large number of enhancements across the entire release that are geared toward enterprise data management, developer productivity and business intelligence. These capabilities include the following:

Enterprise Data Management

-- Management tools. SQL Server Management Studio SQL Server Management Studio is a tool included with SQL Server 2005 for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.  -- previously referred to as the SQL Server "workbench" -- will perhaps be the most visible new tool in SQL Server 2005. Management Studio combines the functionality of Enterprise Manager, Query Analyzer and Analysis Manager into one integrated tool, while adding new support for SQL Server Reporting Services SQL Server Reporting Services is a server based report generation environment developed by Microsoft. It can be used to deliver a variety of interactive and printed reports. It is administered via a web interface. , Notification Services, XML XML
 in full Extensible Markup Language.

Markup language developed to be a simplified and more structural version of SGML. It incorporates features of HTML (e.g., hypertext linking), but is designed to overcome some of HTML's limitations.
 and SQL Server 2005 Mobile Edition. SQL Server 2005 Beta 2 will simplify the management and administration of single or multiple SQL Server databases.

-- Scalability and availability advancements. SQL Server 2005 Beta 2 includes many performance, scalability and availability enhancements to key features such as Snapshot Isolation, Database Mirroring, Database Snapshots, partitioning and Service Broker to help customers deploy highly scalable, reliable applications.

-- Security. SQL Server 2005 Beta 2 also introduces database encryption. This important new feature will allow database administrators to protect the privacy of customer data.

-- SQL Server 2005 Express Edition. SQL Server Express Microsoft SQL Server Express is the freely-downloadable and distributable version of Microsoft's SQL Server relational database management system. It offers a database solution specifically targeted for embedded and smaller-scale applications. , the evolution of Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System.  2000 Desktop Engine (MSDE MSDE Maryland State Department of Education
MSDE Microsoft Data Engine
MSDE Microsoft SQL Desktop Edition
MSDE Microsoft Development Environment
MSDE Military Scenario Development Environment
MSDE Microsoft Sql Server Desktop Engine
MSDE Microsoft Database Engine
) for SQL Server 2005, provides a free, easily used, embeddable database designed for building simple data- driven applications.

-- Microsoft SQL Server 2005 Mobile Edition. SQL Server 2005 Mobile Edition, the next release of SQL Server Windows(R) CE Edition, provides a mobile database solution that expands support beyond Pocket PC to include Tablet PC and a future release of Windows Mobile(TM)-based Smartphone. Some key features include tool integration with SQL Server 2005 and Visual Studio(R) 2005, increased reliability, significant performance improvements and control over performance tuning.

Developer Productivity

-- Development tools. SQL Server 2005 Beta 2 will include significant enhancements to the business intelligence "workbench," which has been named the Business Intelligence Development Studio. The tool will provide a single development environment for Data Transformation Services Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools.  (DTS (1) (Digital Theatre Sound) A digital audio encoding system used in movie and home theaters. Popularized by the movie Jurassic Park, the six-channel (5. ), Reporting Services, Data Mining and Analysis Services to enable faster and more efficient development and debugging of business intelligence applications.

-- Visual Studio 2005 integration. SQL Server 2005 Beta 2 will include new technology such as cross-language debugging and enable Visual Studio 2005 to take advantage of business intelligence functionality, which will help increase developer productivity.

-- Programmability enhancements. In addition to developer productivity enhancements such as tight integration with Visual Studio and improved business intelligence development tools, SQL Server 2005 Beta 2 includes many new and enhanced features in database programmability such as improved T-SQL T-SQL Transact - Structured Query Language (Microsoft SQL Server)  exception handling, enhanced XML support, tighter integration with the Microsoft .NET Framework Common Language Runtime See CLR.  (CLR (Common Language Runtime) The runtime engine in Microsoft's .NET platform. The CLR compiles and executes programs in Microsoft Intermediate Language (MSIL). The counterpart to the CLR for the Common Language Infrastructure (CLI), ECMA's standard version of . ) and advanced messaging capabilities in Service Broker.

Business Intelligence

-- Analysis Services enhancements. Analysis Services is enhanced in SQL Server 2005 Beta 2 with additional MDX (MultiDimensional EXpressions) A multidimensional query language. MDX uses syntax similar to SQL, but whereas SQL is used to query relational tables, MDX is used to query multidimensional cubes (OLAP databases). See SQL and OLAP.  expressions and new MDX script capabilities designed to support some complex and advanced modeling needs. In addition, Analysis Services takes advantage of enhancements to Visual Studio 2005 and introduces an online mode that allows developers to develop their applications in real time.

-- Data mining algorithms. Data mining enhancements to SQL Server 2005 Beta 2 include a new Neural Network algorithm, a Text Mining feature, query enhancements and Reporting Services integration. The Neural Network and Text Mining features allow users to tackle the most complicated analytical problems containing nonlinear relationships and unstructured data. DMX See DMX512.  Query enhancements and Reporting Services integration allow developers to apply models against data from a new range of sources and deliver the results to users through a common front end.

-- DTS enhancements. SQL Server 2005 Beta 2 includes many enhancements to DTS. SQL Server 2005 DTS will provide developers and database administrators with enterprise-level extract, transform and load (ETL (Extract, Transform, Load) The functions performed when pulling data out of one database and placing it into another of a different type. ETL is used to migrate data, often from relational databases into decision support systems. ) capabilities out of the box. The new DTS architecture enables scalable, manageable and reliable ETL capabilities with remarkable ease of use and performance. Going beyond traditional ETL, DTS handles Web services and XML sources, along with data cleansing, data mining and text mining fully integrated into a single, manageable process.

SQL Server 2005 Beta 2 is available to Enterprise, Universal and Professional MSDN (MicroSoft Developer Network) A subscription service from Microsoft for software developers. It includes technical documentation and news, patches and fixes for existing products and beta copies of upcoming releases. (R) subscribers for download on the MSDN Subscriber Downloads site. MSDN is a set of online and offline services designed to help developers write applications using Microsoft products and technologies.

Information on subscribing to MSDN is available at

About Windows Server System

Microsoft Windows Server System(TM) is an integrated and interoperable server infrastructure that reduces IT complexity to enable IT professionals to deliver innovative solutions that meet the changing needs of business. With Windows Server(TM) 2003 at the foundation, Windows Server System is engineered from the ground up for XML Web services based on Microsoft .NET technologies to connect information, people, systems and devices. Based on a common software architecture that spans all facets of IT from design, development and deployment through ongoing management and usage, Windows Server System provides comprehensive IT infrastructure for operations (security, systems management, networked storage), applications (data management and analysis, e-business), and information work (messaging, communications and collaboration).

More information on Microsoft Windows Server System can be found at

For more information, call 425/638-7000 or visit
COPYRIGHT 2004 Worldwide Videotex
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion




Article Details
Printer friendly Cite/link Email Feedback
Publication:Online Product News
Geographic Code:1USA
Date:Oct 1, 2004

Related Articles
AMD Announces Continued Software Support for AMD Opteron Processor-Based Systems.
AMD announces IBM and Oracle support to further boost enterprise compatibility with AMD64.
AMD announces new 64-bit applications demonstrate performance increases up to 57 percent.
Appro ships 500-node Linux HyperBlade clusters to Staag Imaging to support reverse-time migration.
AMD's Recommendation for Multi-Core Software Licensing is Endorsed; AMD Applauds Microsoft's Decision to License Server Software by Processor, Not by...
AMD Announces Broad Enterprise Support for the AMD Opteron Processor.
AMD announces world's first 64-bit, X86 multi-core processors for servers and workstations.
Toshiba ships new Strata CIX pure IP telephony system.
RADVISION chosen by CESTEL to deliver video-enhanced services and contact centers.

Terms of use | Copyright © 2014 Farlex, Inc. | Feedback | For webmasters