MS SQL 2005 server SQL
in

Microsoft SQL 2005

MS SQL 2005 server

SQL

  • SQL Server 2008 R2

    What's New in R2

    With this new release, IT professionals, developers and business users will experience the following benefits:

    Capitalize on Hardware Innovation

    Increase in the number of logical processors supported from 64 up to 256.  This will provide customers with more choices for obtaining single system scalability with high performance.

    Optimize Hardware Resources

    Dashboard viewpoints provide insight into utilization and policy violations to help identify consolidation opportunities, maximize investments and maintain healthy systems.

    Manage Efficiently at Scale

    Through new extensions in SQL Server Management Studio, organizations will gain insights into their growing applications and databases and help ensure higher service levels through policies and dashboard viewpoints.

    Enhance Collaboration Across Development and IT

    Streamline Application Lifecycle Management through integration with Visual Studio. A new project type enables a single unit of management for packaging database schema with application requirements. This ensures higher quality application development while also accelerating deployments, moves, and changes over time.

    Improve the Quality of Your Data

    Centralized approach to defining, deploying, and managing master data can ensure reporting consistency across systems and deliver faster more accurate results across the enterprise.

    Manage User-Generated Analytical Applications

    Comprehensive management thru Microsoft SharePoint gives IT the ability to manage and secure all BI assets, thus freeing the original authors to focus on the priorities of the business.

    Report with Ease

    Decrease time and costs developing reports by giving users the ability to design their own queries, reports and charts through powerful and intuitive authoring and ad hoc reporting capabilities.

    Get More Out of Your Data

    New support for geospatial visualization can produce new insights and discoveries when geospatial data is combined with corporate data for reporting and analysis.

    Build Robust Analytical Applications

    With the in-memory analytics add-in for Microsoft Excel 2010, business users can quickly access, analyze and summarize vast amounts of data directly in Excel without the assistance of the IT department.

    Consolidate Your Data

    New “data mash up” capabilities will simplify time consuming data gathering and consolidation tasks.  Integrate data from multiple sources, including corporate databases and external sources, using powerful tools within Microsoft Excel. online backup

    Share and Collaborate with Confidence

    New collaboration tools make it easy to share analytic applications and reports through Microsoft Office SharePoint, where they are refreshed automatically, maintained, and made accessible to others.

    Posted jun 28 2009, 10:36 by admin with no comments

  • Microsoft SQL Server JDBC Driver 2.0

    In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 2.0 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000, SQL Server 2005, and SQL Server 2008 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.

    This release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or later. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, and JBoss.

    Note: In order to download the SQL Server JDBC Driver 2.0, you must agree to the End-User License Agreement (EULA). Start by clicking the Download button at the top of this page and the EULA will appear. Read the EULA and click the Accept link to download the package. Please print a copy online backup of the EULA for your records.

    Note: Peer-to-peer support is available in the SQL Server forums. To submit feedback on this JDBC Driver release, visit the SQL Server Feedback Center.
     
    http://www.microsoft.com/downloads/details.aspx?FamilyID=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en
    Posted apr 12 2009, 09:21 by admin with no comments

  • CTP for Service Pack 1 of SQL Server 2008 Available

     

    Today we are excited to announce the availability of our Community Technology Preview (CTP) for Service Pack 1 of SQL Server 2008. This scheduled servicing release addresses feedback received from many of you who have deployed SQL Server 2008 since our release back in August 2008.    

    We take every update to SQL Server very seriously and we are especially pleased that in reviewing the changes being made with this service pack that we have reinforced our confidence(and hopefully yours!) in the quality of the initial release of SQL Server 2008. We know that some of you wait for the first service pack of any new software product, and hopefully with this update you will have even more insight and confidence in our engineering and quality assurance practices. 

    We remain committed to keeping service packs contained, focusing on essential updates only, primarily a roll-up of Cumulative Update 1 to 3, Quick Fix Engineering (QFE) updates, as well as fixes to issues reported through the SQL Server community. While keeping product changes contained, we have made significant investments to ease deployment and management of service packs:

    • Slipstream – You are now able to integrate the base installation with service packs (or Hotfixes) and install in a single step.
    • Service Pack Uninstall – You are now able to uninstall only the service pack (without removing the whole instance)
    • Report Builder 2.0 Click Once capability

    We encourage you to try out SP1, and send us your feedback. We actively read all feedback and appreciate any thoughts that you might have to help us with product updates.  Please go to the Connect Feedback Center to provide feedback. Continue to watch this blog for more updates hosted exchange.

    With the upcoming general availability of SP1, it’s a good time for any of you that are still running SQL Server 2005 (or even SQL Server 2000) to take a look at the great enhancements and benefits that SQL Server 2008 provides. There are a lot of new capabilities that maybe you haven’t had a chance to explore such as Compression, Auditing, Policy Based Management, Resource Governor, Change Data Capture, Transparent Data Encryption and many more Database, Reporting, Warehousing and Analytics improvements that you can read about here.  

    Thanks and we look forward to releasing SP1 soon!

    Posted mar 17 2009, 06:49 by admin with no comments

  • WEB Hosting & Developer Roadshow

    Microsoft is proud to announce a new kind of event bringing together various elements from the web that converge more and more: PHP and Windows, SuSE and Hyper-V, Hosting and Developers, Demand and Supply.

    Based on current market trends Microsoft created an exciting agenda which is addressing different partner needs to better serve customers wishes. Microsoft will present its roadmap for the web of today and tomorrow showing how partners become more successful, packed with a clear guidance on how to start, a developer kit and an attractive promotion which will be offered exclusively to the attendees. Don’t miss it!

    This free WEB Hosting & Developer event is specifically created for Hosters in the morning (Session A) and Web Developers in the afternoon (Session B) with the possibility to meet each other during lunch. That means that you will have to possibility to register for the morning session for Hosting topics or for the afternoon session for Web Developers topics (or both sessions if you interested in). The ideal attendee profile is a Technical Decision Maker (TDM) or a Business Decision Maker (BDM) with a dedikerad server. The presentation language will be English. For a detailed agenda, please click here.

    The WEB Hosting & Developer Roadshow will be visiting your country soon!

    Click here for registration
    Posted dec 14 2008, 01:39 by admin with no comments

  • Unable to access/create maintenance plans after SQL 2005 SP2 upgrade in a cluster enviroment

    Installed the SP2 with no error.

    When trying to access/create maintenance plans  the folowing error i displayd

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
    ------------------------------
    ADDITIONAL INFORMATION:

     

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Invalid column name 'from_msx'.
    Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3257&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

     

     

     

    The resolution to this problem was to run the script sysdbupg.sql manually from the INSTALL folder.

     

    Dedikerad server
    Posted nov 02 2008, 07:50 by admin with no comments

  • Version and Edition Upgrades

    SQL Server 2008 Books Online (October 2008)
    Version and Edition Upgrades

    The following upgrade scenarios are supported in this release of SQL Server.

    Upgrade from Supported upgrade path

    SQL Server 2000 (32-Bit) MSDE SP41

    SQL Server 2008 Express

    SQL Server 2000 (32-Bit) Standard SP41,4

    SQL Server 2008 Standard

    SQL Server 2008 Enterprise

    SQL Server 2000 (32-Bit) Developer SP41,4

    SQL Server 2008 Developer

    SQL Server 2000 (32-Bit) Enterprise SP41,4

    SQL Server 2008 Enterprise

    SQL Server 2000 Enterprise Evaluation (32-bit, IA64)4,5

    No upgrade support.

    SQL Server 2000 (64-Bit) IA64 Developer SP43,4,5

    SQL Server 2008 (64-Bit) IA64 Developer

    SQL Server 2000 (64-Bit) IA64 Enterprise SP43,4,5

    SQL Server 2008 (64-Bit) IA64 Enterprise

    SQL Server 2000 (32-Bit) Personal SP4

    No upgrade support.

    SQL Server 2005 (32-Bit) Express1

    SQL Server 2008 Express

    SQL Server 2008 Express Tools

    SQL Server 2008 Express Advanced

    SQL Server 2008 Workgroup

    SQL Server 2005 (32-Bit) Express1 Advanced1

    SQL Server 2008 Express Advanced

    SQL Server 2008 Workgroup

    SQL Server 2005 (32-Bit) Workgroup1

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Enterprise

    SQL Server 2005 (32-Bit) Standard1

    SQL Server 2008 Standard

    SQL Server 2008 Enterprise

    SQL Server 2005 (32-Bit) Developer1

    SQL Server 2008 Developer

    SQL Server 2005 (32-Bit) Enterprise1

    SQL Server 2008 Enterprise

    SQL Server 2005 Enterprise Evaluation (32-bit, IA64, X64)

    No upgrade support.

    SQL Server 2005 IA64 (64-bit) Developer

    SQL Server 2008 IA64 (64-bit) Developer

    SQL Server 2005 IA64 (64-bit) Standard

    SQL Server 2008 IA64 (64-bit) Standard IA64 (64-bit) Enterprise

    SQL Server 2005 IA64 (64-bit) Enterprise

    SQL Server 2008 IA64 (64-bit) Enterprise

    SQL Server 2005 X64 (64-bit) Developer

    SQL Server 2008 X64 (64-bit) Developer

    SQL Server 2005 X64 (64-bit) Standard

    SQL Server 2008 X64 (64-bit) Standard

    SQL Server 2008 X64 (64-bit) Enterprise

    SQL Server 2005 X64 (64-bit) Enterprise

    SQL Server 2008 X64 (64-bit) Enterprise

    SQL Server 2008 Express1

    SQL Server 2008 Express

    SQL Server 2008 Express Tools

    SQL Server 2008 Express Advanced

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Developer

    SQL Server 2008 Enterprise

    SQL Server 2008 Express Tools

    SQL Server 2008 Express Tools

    SQL Server 2008 Express Advanced

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Developer

    SQL Server 2008 Enterprise

    SQL Server 2008 Express Advanced1

    SQL Server 2008 Express Advanced

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Developer

    SQL Server 2008 Enterprise

    SQL Server 2008 Express x64 (64-bit)

    SQL Server 2008 Express x64 (64-bit)

    SQL Server 2008 Express Tools x64 (64-bit)

    SQL Server 2008 Express Advanced x64 (64-bit)

    SQL Server 2008 Workgroup x64 (64-bit)

    SQL Server 2008 Standard x64 (64-bit)

    SQL Server 2008 Developer x64 (64-bit)

    SQL Server 2008 Enterprise x64 (64-bit)

    SQL Server 2008 Express Tools x64 (64-bit)

    SQL Server 2008 Express Tools x64 (64-bit)

    SQL Server 2008 Express Advanced x64 (64-bit)

    SQL Server 2008 Workgroup x64 (64-bit)

    SQL Server 2008 Standard x64 (64-bit)

    SQL Server 2008 Developer x64 (64-bit)

    SQL Server 2008 Enterprise x64 (64-bit)

    SQL Server 2008 Express Advanced x64 (64-bit)

    SQL Server 2008 Express Advanced x64 (64-bit)

    SQL Server 2008 Workgroup x64 (64-bit)

    SQL Server 2008 Standard x64 (64-bit)

    SQL Server 2008 Enterprise x64 (64-bit)

    SQL Server 2008 Workgroup1

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Enterprise

    SQL Server 2008 Web1

    SQL Server 2008 Web

    SQL Server 2008 Standard1,2

    SQL Server 2008 Standard

    SQL Server 2008 Enterprise

    SQL Server 2008 Developer1,2

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Developer

    SQL Server 2008 Enterprise

    SQL Server 2008 Enterprise1,2

    SQL Server 2008 Enterprise

    SQL Server 2008 Enterprise Evaluation2

    SQL Server 2008 Enterprise Evaluation

    SQL Server 2008 Web

    SQL Server 2008 Workgroup

    SQL Server 2008 Standard

    SQL Server 2008 Developer

    SQL Server 2008 Enterprise

    SQL Server 2008 IA64 (64-bit) Enterprise Evaluation2

    SQL Server 2008 IA64 (64-bit) Enterprise

    SQL Server 2008 IA64 (64-bit) Developer

    SQL Server 2008 IA64 (64-bit) Standard

    SQL Server 2008 IA64 (64-bit) Enterprise Evaluation

    SQL Server 2008 x64 (64-bit) Enterprise Evaluation2

    SQL Server 2008 Enterprise Evaluation

    SQL Server 2008 Web

    SQL Server 2008 Workgroup

    SQL Server 2008 x64 (64-bit) Standard

    SQL Server 2008 x64 (64-bit) Developer

    SQL Server 2008 x64 (64-bit) Enterprise

    SQL Server 2008 IA64 (64-bit) Developer2

    SQL Server 2008 IA64 (64-bit) Standard

    SQL Server 2008 IA64 (64-bit) Developer

    SQL Server 2008 IA64 (64-bit) Enterprise

    SQL Server 2008 Developer x64 (64-bit)2

    SQL Server 2008 Workgroup x64 (64-bit)

    SQL Server 2008 Standard x64 (64-bit)

    SQL Server 2008 Developer x64 (64-bit)

    SQL Server 2008 Enterprise x64 (64-bit)

    SQL Server 2008 IA64 (64-bit) Standard2

    SQL Server 2008 IA64 (64-bit) Enterprise

    SQL Server 2008 IA64 (64-bit) Standard

    SQL Server 2008 x64 (64-bit) Standard2

    SQL Server 2008 x64 (64-bit) Standard

    SQL Server 2008 x64 (64-bit) Enterprise

    SQL Server 2008 IA64 (64-bit) Enterprise2

    SQL Server 2008 IA64 (64-bit) Enterprise

    SQL Server 2008 x64 (64-bit) Enterprise2

    SQL Server 2008 x64 (64-bit) Enterprise

    1This SQL Server edition can be upgraded to SQL Server 2008 on the 32-bit subsystem (WOW64) of a 64-bit server.

    2Changing the edition of a SQL Server 2008 failover cluster is limited. The following edition downgrade scenarios are not supported for SQL Server 2008 failover clusters:

    • SQL Server 2008 Enterprise to SQL Server 2008 Developer, Standard, or Enterprise Evaluation.
    • SQL Server 2008 Developer to SQL Server 2008 Standard or Enterprise Evaluation.
    • SQL Server 2008 Standard to SQL Server 2008 Enterprise Evaluation.
    • SQL Server 2008 Enterprise Evaluation to SQL Server 2008 Standard.

    3Upgrade of SQL Server 2000 (64-Bit) IA64 failover clusters are not supported.

    4Upgrade of SQL Server 2000 Analysis Services to SQL Server 2008 is not supported on failover clusters.

    5Upgrade of SQL Server 2000 (64-Bit) will not install SQL Server 2008 Management Tools. To install Management Tools, you musr re-run Setup after the upgrade is complete.

    Upgrade Notes

    • Cross-version instances of SQL Server 2008 are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same in an instance of SQL Server 2008.
    • Before upgrading SQL Server, enable Windows Authentication for SQL Server Agent and verify the default configuration: that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
    • Before upgrading from one edition of SQL Server 2008 to another, verify that the functionality you are currently using is supported in the edition to which you are upgrading. For more information, see the section for your components in Features Supported by the Editions of SQL Server 2008.
    • Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit. However, you can upgrade a 32-bit instance of SQL Server to the WOW64: the 32-bit subsystem on a 64-bit server as noted in the table above. You can also back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to an instance of SQL Server (64-bit) if the databases are not published in replication. In this case, you must also re-create any logins and other user objects in master, msdb, and model system databases.
    • To upgrade to SQL Server 2008, you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server 2008.
    • Upgrade will be blocked if there is a pending restart.
    • Upgrade will be blocked if the Windows Installer service is not running.
    • Upgrade will be blocked if performance counters are corrupt.
    • To upgrade an instance of SQL Server to a SQL Server failover cluster, the instance being upgraded must be a failover cluster. To upgrade a stand-alone instance of SQL Server to a SQL Server failover cluster, install a new SQL Server failover cluster and then migrate user databases from the stand-alone instance by using the Copy Database Wizard. For more information about upgrade, see How to: Upgrade a SQL Server Failover Cluster Instance (Setup). For more information about database migration, see Using the Copy Database Wizard.

    You cannot add components to an existing installation of SQL Server at the time you upgrade to SQL Server 2008.After you upgrade an instance of SQL Server to SQL Server 2008, you can add features by using the SQL Server 2008 Installation Wizard: Setup.exe.

    • The English-language version of SQL Server is supported on all localized versions of supported operating systems.
    • Localized versions of SQL Server are supported on localized operating systems that are the same language as the localized SQL Server version.
    • Localized versions of SQL Server can be upgraded to localized versions of SQL Server 2008 of the same language.
    • Localized versions of SQL Server cannot be upgraded to the English-language version of SQL Server 2008.
    • Localized versions of SQL Server cannot be upgraded to localized SQL Server 2008 versions of a different localized language.
    • Localized versions of SQL Server are also supported on English-language versions of supported operating systems by using the Windows Multilingual User Interface Pack (MUI) settings. However, you must verify certain operating system settings before you install a localized version of SQL Server on a server that is running an English-language operating system with a non-English MUI setting. You must verify that the following operating system settings match the language of SQL Server to be installed:
      • The operating system user interface setting
      • The operating system user locale setting
      • The system locale setting
      If these operating system settings do not match the language of the localized SQL Server, you must correctly set these operating system settings before you install SQL Server 2008.

    Dedikerad server

    Posted nov 02 2008, 07:48 by admin with no comments

  • TechNet Flash: SQL Server 2008 released

    Note from the Editor

     
    The wait is over. SQL Server 2008 has been released and is ready to deliver a rich set of integrated services that enable you to do more with your data, such as query, search, synchronize, report, and analyze. Many of you have been evaluating the SQL Server 2008 betas, and may be ready to try out the RTM version. TechNet Plus subscribers can find RTM versions now available for download. Speaking of TechNet Plus, read Keith Combs’ Blahg for his take on the UI improvements for the newly revamped TechNet Plus Subscriber Downloads page.

    TechNet Magazine recently published an overview of the key changes and what you can expect from SQL Server 2008. You can also get a rundown of the various editions and components of SQL Server 2008 and take part in SQL Server 2008 tutorials.

    For more overview resources, check out:

    •

    		 SQL Server 2008 Videos
    • Webcasts: 24 Hours of SQL Server 2008 for IT Professionals
    • Webcasts: 24 Hours of SQL Server 2008 for Developers
    If you are looking for assistance with SQL Server 2008 planning and installation, here are some helpful links:

    •

    		 Planning a SQL Server Installation
    • Installing SQL Server 2008
    • Quick Start Installation
    • Installation How-to Topics
    • Locating Previous Versions of SQL Server for SQL Server 2008 migration using Microsoft Assessment and Planning Toolkit
    Once you’ve installed SQL Server 2008, these resources can help you optimize your database environment:

    •

    		 Configuring SQL Server 2008
    • Database Engine Tuning Advisor Overview
    • System and Sample Databases
    You can also find guidance for upgrading to SQL Server 2008 or migrating to SQL Server 2008. If you are upgrading, be sure to check out Using Upgrade Advisor to Prepare For Upgrades.

    From our partners, you can     find local partners offering SQL Server 2008 solutions or find training partners near you offering official Microsoft courses that will help you get certified on SQL Server 2008. In addition, you can search for local in-person events and online webcasts on SQL Server 2008.

    And finally, from the August edition of TechNet Magazine, Paul Randal answers your SQL Server questions, showing you how to perform consistency checks, how to handle an accidental upgrade, and more in the     SQL Q&A column.    Mitch Irsfeld
    Editor, TechNet Flash
    Posted aug 07 2008, 06:02 by admin with no comments

  • SQL Server 2008 Release Candidate 0

    Brief Description
    Download Microsoft SQL Server 2008 Release Candidate 0 (RC0) and preview the latest features of SQL Server 2008! The SQL Server development team uses your feedback to help refine and enhance product features. Evaluate SQL Server 2008 RC0 today and send your feedback.

     

    X86 DVD Image
    X64 DVD Image
    IA64 DVD Image

     

    Posted jul 13 2008, 08:43 by admin with no comments

  • The Microsoft Source Code Analyzer for SQL Injection tool is available to find SQL injection vulnerabilities in ASP code

    This article describes the Microsoft Source Code Analyzer for SQL Injection tool. You can use this static code analysis tool to find SQL injection vulnerabilities in ASP code

    http://support.microsoft.com/kb/954476

    Posted jul 02 2008, 06:57 by admin with no comments

  • SQL Server 2005 Features Comparison

    SQL Server 2005 Features Comparison

    Published: November 7, 2005 | Updated: May 22, 2006
    SQL Server 2005 Editions
    •

    Enterprise Edition

    •

    Standard Edition

    •

    Workgroup Edition

    •

    Express Edition

    •

    Developer Edition

    •

    Compact Edition

    At Microsoft, we believe that software should provide you with choices that let you find the solution best tailored to your business’ needs. To that end, we have redesigned the SQL Server 2005 product family to better meet the needs of each customer segment with four new editions: Express, Workgroup, Standard, and Enterprise. As a low-cost mainstream database, SQL Server 2005 will deliver unprecedented value and functionality compared with competitive solutions. The four new editions will offer a range of features, from high availability and robust scalability to advanced business intelligence tools, designed to empower the people across your organization through a more secure, reliable, and productive data management platform. Additionally, with the reduced application downtime, robust scalability and performance, and tight security controls, SQL Server 2005 represents a dramatic step forward in supporting the most demanding enterprise systems in the world. Because SQL Server is part of Windows Server System, you will also receive the added benefits of reduced total cost of ownership and faster development time through the increased manageability and integration that result from the common engineering strategy implemented across Windows Server System products. The table below presents details about each of the different editions.

    Notes: In the following table, the "Comments" column provides comments on the specified feature. Numbers next to check marks indicate footnotes that appear at the bottom of the page. SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.

    Feature Express Workgroup Standard Enterprise Comments

    Number of CPUs

     

    1

    2

    4

    No Limit

    Includes support for multicore processors.

    RAM

     

    1 gigabyte (GB)

    3 GB

    Operating system maximum

    Operating system maximum

    Memory limited to maximum supported by operating system.

    64-bit Support

     

    Windows on Windows (WOW)

    WOW

    checked

    checked

    *

    Database Size

     

    4 GB

    No Limit

    No Limit

    No Limit

    *

    Partitioning

     

    *

    *

    *

    checked

    Support for large-scale databases

    Parallel Index Operations

     

    *

    *

    *

    checked

    Parallel processing of indexing operations

    Indexed Views

     

    *

    *

    *

    checked

    Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition.

    High Availability
    Feature Express Workgroup Standard Enterprise Comments

    Database Mirroring

     

    *

    *

    checked1

    checked

    Advanced high availability solution that includes fast failover and automatic client redirection

    Failover Clustering

     

    *

    *

    checked2

    checked

    *

    Backup Log-shipping

     

    *

    checked

    checked

    checked

    Data backup and recovery solution

    Online System Changes

     

    checked

    checked

    checked

    checked

    Includes Hot Add Memory, dedicated administrative connection, and other online operations

    Online Indexing

     

    *

    *

    *

    checked

    *

    Online Restore

     

    *

    *

    *

    checked

    *

    Fast Recovery

     

    *

    *

    *

    checked

    Database available when undo operations begin

    1 Single REDO thread and the safety setting is always on.
    2 Supports only two nodes.
    Manageability
    Feature Express Workgroup Standard Enterprise Comments

    Auto Tuning

     

    checked

    checked

    checked

    checked

    Automatically tunes database for optimal performance.

    Profiler

     

    *1

    *2

    checked

    checked

    *

    SQL Server Management Studio Express

     

    See Comments

    checked

    checked

    checked

    Easy-to-use graphical management tool available as a separate download or included with the SQL Server Express w/Advanced Services download

    Management Studio

     

    *

    checked

    checked

    checked

    Full management platform for SQL Server; includes Business Intelligence (BI) Development Studio.

    Database Tuning Advisor

     

    *

    *

    checked

    checked

    Automatically suggests enhancements to your database architecture to improve performance.

    Serviceability Enhancements

     

    checked

    checked

    checked

    checked

    Dynamic management views and reporting enhancements.

    Full-text Search

     

    See comments

    checked

    checked

    checked

    Available for SQL Server Express in the SQL Server Express w/ Advanced Services download

    SQL Agent Job Scheduling Service

     

    *

    checked

    checked

    checked

    *

    1 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.
    2 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.
    Security
    Feature Express Workgroup Standard Enterprise Comments

    Advanced Auditing, Authentication, and Authorization

     

    checked

    checked

    checked

    checked

    *

    Data Encryption and Key Management

     

    checked

    checked

    checked

    checked

    Built-in data encryption for advanced data security.

    Integration with Microsoft Baseline Security Analyzer

     

    checked

    checked

    checked

    checked

    Scans your system to check for common security vulnerabilities.

    Integration with Microsoft Update

     

    checked

    checked

    checked

    checked

    *

    Programmability
    Feature Express Workgroup Standard Enterprise Comments

    Stored Procedures, Triggers, and Views

     

    checked

    checked

    checked

    checked

    *

    T-SQL Enhancements

     

    checked

    checked

    checked

    checked

    Includes exception handing, recursive queries, and support for new data types.

    Common Language Runtime and .NET Integration

     

    checked

    checked

    checked

    checked

    *

    User-defined Types

     

    checked

    checked

    checked

    checked

    Extend the server with your own custom data types.

    Native XML

     

    checked

    checked

    checked

    checked

    Includes XML indexing and full-text XML search.

    XQuery

     

    checked

    checked

    checked

    checked

    *

    Notification Services

     

    *

    *

    checked

    checked

    Allows the building of advanced subscription and publication applications.

    Service Broker

     

    See comments

    checked

    checked

    checked

    SQL Server Express can exchange messages with other editions. Messages between instances of SQL Server Express must be routed through another edition.

    Integration and Interoperability
    Feature Express Workgroup Standard Enterprise Comments

    Import/Export

     

    checked

    checked

    checked

    checked

    *

    Integration Services with Basic Transforms

     

    *

    *

    checked

    checked

    Provides graphical extract, transform, and load (ETL) capabilities.

    Integration Services Advanced Transforms

     

    *

    *

    *

    checked

    Includes data mining, text mining, and data cleansing.

    Merge Replication

     

    checked1

    checked2

    checked

    checked

    *

    Transactional Replication

     

    checked3

    checked4

    checked

    checked

    *

    Oracle Replication

     

    *

    *

    *

    checked

    Transactional replication with an Oracle database as a publisher

    Web Services (HTTP Endpoints)

     

    *

    *

    checked

    checked

    Support for native Web services, Web Services Description Language (WSDL), and Web authentication

    1 Subscriber only.
    2 Publish to up to 25 subscribers.
    3 Subscriber only.
    4 Publish to up to five subscribers.
    Business Intelligence
    Feature Express Workgroup Standard Enterprise Comments

    Report Server

     

    See Comments

    checked

    checked

    checked

    Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download.

    Report Builder

     

    *

    checked

    checked

    checked

    End-user reporting tool

    Reporting Data Sources

     

    1

    *

    checked

    checked

    checked

    *

    Scale Out Report Servers

     

    *

    *

    *

    checked

    *

    Data Driven Subscriptions

     

    *

    *

    *

    checked

    *

    Infinite Clickthrough

     

    *

    *

    *

    checked

    *

    Data Warehousing

     

    *

    *

    checked

    checked

    *

    Star Query Optimization

     

    checked

    checked

    checked

    checked

    *

    SQL Analytical Functions

     

    checked

    checked

    checked

    checked

    *

    BI Development Studio

     

    See Comments

    2

    checked3

    checked

    checked

    Integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions.

    Enterprise Management Tools

     

    *

    checked

    checked

    checked

    Integration with SQL Management Studio, SQL Server Profiler, SQL Server Agent, Backup/Restore.

    Native Support for Web Services
    (Service Oriented Architectures)

     

    checked4

    checked5

    checked

    checked

    Allows access to data from any device.

    Analysis Services

     

    *

    *

    checked

    checked

    Powerful analytics and data mining capabilities.

    Unified Dimensional Model (UDM)

     

    *

    *

    checked

    checked

    Enterprise business data model enables fast, interactive, ad hoc analysis of large data sets. Builds smarter reports that leverage centralized business logic and key performance indicators (KPIs), as well as the performance of UDM.

    Business Analytics

     

    *

    *

    checked

    checked

    Multidimensional Expression (MDX) scripts and MDX debugger, .NET stored procedures, Time Intelligence, KPI Framework.

    Advanced Business Analytics

     

    *

    *

    *

    checked

    Account intelligence, metadata translation, perspective and semi-additive measures.

    Proactive Caching

     

    *

    *

    *

    checked

    Provides automated caching for greater scalability and performance.

    Advanced Data Management

     

    *

    *

    *

    checked

    Partitioned cubes, parallel processing, server synchronization.

    Full Writeback Support

     

    *

    *

    *

    checked

    Dimension and cell writeback

    Data Mining

     

    *

    *

    checked

    checked

    Nine algorithms including decision and regression trees, clustering, logistic and linear regression, neural networks, naive bayes, association, sequence clustering, and time series. Build smarter reports that leverage centralized business logic and KPIs, as well as the performance of UDM.

    Advanced Performance Tuning

     

    *

    *

    *

    checked

    Additional options for tuning data mining models for the highest accuracy, performance, and scalability.

    SQL Server Integration Services Data Flow Integration

     

    *

    *

    *

    checked

    Perform data mining prediction and training operations directly in your operational data pipelines.

    Text Mining

     

    *

    *

    *

    checked

    Convert unstructured text data to structured data for analysis via reporting, online analytical processing (OLAP), or data mining.

    1 This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005.
    2 Report Designer only.
    3 Report Designer only.
    4 Reporting Services only.
    5 Reporting Services only.


    source www.mmicrosoft.com

    Posted maj 01 2008, 07:32 by admin with no comments

  • Microsoft SQL Server 2008 CTP, November 2007

    Brief Description
    Download the latest SQL Server 2008 Community Technology Preview (CTP) and try out the latest features of SQL Server 2008! The SQL Server development team uses your CTP feedback to help refine and enhance product features. Download it today and send your feedback.
     
     
    Posted nov 24 2007, 07:06 by admin with no comments

  • SQL Server 2005 Driver for PHP Community Technology Preview (October 2007)

    In its continued commitment to interoperability, Microsoft has released a new SQL Server 2005 Driver for PHP. The SQL Server 2005 Driver for PHP Community Technology Preview (CTP) download is available to all SQL Server users at no additional charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2000.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=85F99A70-5DF5-4558-991F-8AEE8506833C&displaylang=en

     

     

    Hosted Exchange

    Posted okt 25 2007, 01:54 by admin with no comments

  • Microsoft SQL Server 2005 JDBC Driver 1.2

     
    http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en  
    Brief Description
    Download the SQL Server 2005 JDBC Driver 1.2, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition).

    Overview

    In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver with SQL Server 2005. The SQL Server 2005 JDBC Driver 1.2 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition).

    This release of the JDBC Driver is JDBC 3.0 compliant and runs on the Java Development Kit (JDK) version 1.4 and higher. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, JBoss, and Sun.

    Note: In order to download the SQL Server 2005 JDBC Driver 1.2, you must agree to the End-User License Agreement (EULA). Start by clicking the Download button at the top of this page and the EULA will appear. Read the EULA and click the Accept link to download the package. Please print a copy of the EULA for your records.

     

    Hosted Exchange


    Posted okt 20 2007, 06:51 by admin with no comments

  • MSDN Webcast: Data Programmability and SQL Server 2008 (Level 200)

    Event Overview

    The comprehensive set of application development technologies from Microsoft enables developers to build data-centric solutions that target desktops, mobile devices, online Web servers and enterprise servers using a variety of products, programming frameworks, Web services and data connectivity technologies that work seamlessly together to access and manage data. In this webcast, we provide an overview of the new Microsoft data application development technologies and show how these technologies can benefit Microsoft SQL Server 2008 programmers.

    Presenters: Anthony Carrabino, Senior Product Manager, Microsoft Corporation, and David Sceppa, Program Manager, Microsoft Corporation

    Anthony Carrabino is a senior product manager for the Microsoft SQL Server team, and he has been involved with database technologies since 1990. Before joining Microsoft, Anthony owned and operated Vista Software, which created the popular VistaDB database engine for the Microsoft .NET Framework and the widely used Apollo Xbase data engine. Anthony also sold the Firefly data access components to Macromedia, which later became the Data Connectivity Kit for Flash.

    David Sceppa is a program manager on the Microsoft ADO.NET team, and he has been working with Microsoft data access technologies since the days of Microsoft FoxPro 2.x. David speaks frequently at developer conferences such as TechEd, and he is the author of three books from Microsoft Press, including Programming Microsoft ADO.NET 2.0.

    http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032347488&CountryCode=US

     

    Hosted Exchange
    Posted okt 13 2007, 08:12 by admin with no comments
More Posts
Powered by Community Server (Non-Commercial Edition), by Telligent Systems