Contents tagged with SQL Server 2008

  • Microsoft SQL Server 2012 launch March 7th

    Posted by sumeethevans on January 25 2012, 3:17 AM. Posted in SQL Server 2008.

    On March 7th, 2012 this online event will allow you to immerse yourself in the exciting New World of Data with SQL Server 2012. Engage not only Microsoft product teams, but with our partners and our most ground breaking customers. SQL Server 2012 is part of the broadest Data Platforms in technology today. Discover how it enables mission critical confidence, blazing fast performance, and stunning interactive data visualizations.

    Join us on March 7, 2012 and be a part of the SQL Server 2012 Virtual Launch Event. You will have access to over 30+ sessions to learn about the new capabilities of SQL Server 2012 at your own pace, in your own schedule. This event brings together a who’s who of industry experts and executives to tell the SQL Server 2012 story in this unique online launch event. You will also “meet” with partners, experts, and peers in a virtual “Expo Hall” to discuss SQL Server 2012 one-on-one.

    Register Here

    Continue At Source

  • SQL Server 2008 Service Pack 3

    Posted by bink on October 7 2011, 1:17 PM. Posted in SQL Server 2008.

    Microsoft SQL Server 2008 Service Pack 3 (SP3) is now available for download. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. A few key enhancements for customers in Microsoft SQL Server 2008 Service Pack 3 are :

    • Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP3. In addition, we have increased the performance & reliability of the setup experience.
    • In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
    • Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
    • Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
    • Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor).
    • Superior user experience with Sequence Functions (e.g Row_Numbers()) in a Parallel execution plan.

    Microsoft SQL Server 2008 Service Pack 2 is not a prerequisite for installing SQL Server 2008 Service Pack3. These packages may be used to upgrade any of the following editions of SQL Server 2008:

    • Enterprise
    • Standard
    • Evaluation
    • Developer
    • Workgroup

    SQL Server 2008 SP3 contains the cumulative updates of SQL Server 2008 SP2 cumulative update package 1 to 4, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported through Windows Error Reporting.Note: To obtain SQL Server 2008 SP3 for Express Edition or Express Edition with Advanced Services, please go here.For a detailed list of new features and improvements that are included in SQL Server 2008 SP3, review the Release Notes

    MicrosoftSQLServer2008SP3Readme.htm 16 KB Download
    SQLServer2008SP3-KB2546951-IA64-ENU.exe 364.0 MB Download
    SQLServer2008SP3-KB2546951-x64-ENU.exe 371.0 MB Download
    SQLServer2008SP3-KB2546951-x86-ENU.exe 304.0 MB Download

  • Microsoft® SQL Server® code name 'Denali', Community Technology Preview 3 (CTP 3)

    Posted by sumeethevans on August 25 2011, 2:30 AM. Posted in SQL Server 2008.

    Microsoft SQL Server code name 'Denali' enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence.SQL Server code name 'Denali' enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence:

    • Deliver required uptime and data protection with AlwaysOn
    • Gain breakthrough & predictable performance with Project Apollo
    • Help enable security and compliance with new User-defined Roles and Default Schema for Groups
    • Enable rapid data discovery for deeper insights across the organization with Project Crescent
    • Ensure more credible, consistent data with SSIS improvements, a Master Data Services add-in for Excel, and new Data Quality Services
    • Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Developer Tools code name “Juneau” for a unified dev experience across database, BI, and cloud functions

    Download At Source

  • Microsoft® SQL Server® 2008 R2 Service Pack 1 Community Technology Preview

    Posted by sumeethevans on April 29 2011, 4:40 AM. Posted in SQL Server 2008.

    SQL Server 2008 R2 Service Pack 1(SP1) Customer Technology Preview (CTP) is now available for download. SQL Server 2008 R2 service packs are cumulative updates and upgrade all service levels of SQL Server 2008 R2 to SP1 CTP. This service pack contains the cumulative updates up to SQL Server 2008 R2 SP1 cumulative update packages 6. You can use these packages to upgrade any of the following SQL Server 2008 R2 editions:

    What’s New in SQL Server 2008 R2 Service Pack 1

  • Dynamic Management Views for increased supportability: sys.dm_exec_query_stats DMV is extended with additional columns to improve supportabilities over troubleshooting long-running queries. New DMVs and XEvents on select performance counters are introduced to monitor OS configurations and resource conditions related to the SQL Server instance.
  • ForceSeek for improved querying performance :Syntax for FORCESEEK index hint has been modified to take optional parameters allowing it to control the access method on the index even further. Using old style syntax for FORCESEEK remains unmodified and works as before. In addition to that, a new query hint, FORCESCAN has been added. It complements the FORCESEEK hint allowing specifying ‘scan’ as the access method to the index. No changes to applications are necessary if you do not plan to use this new functionality.
  • Data-tier Application Component Framework (DAC Fx) for improved database upgrades: The new Data-tier Application (DAC) Framework v1.1 and DAC upgrade wizard enable the new in-place upgrade service for database schema management. The new in-place upgrade service will upgrade the schema for an existing database in SQL Azure and the versions of SQL Server supported by DAC. A DAC is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.
  • Disk space control for PowerPivot: This update introduces two new configuration settings that let you determine how long cached data stays in the system. In the new Disk Cache section on the PowerPivot configuration page, you can specify how long an inactive database remains in memory before it is unloaded. You can also limit how long a cached file is kept on disk before it is deleted. For a detailed list of new features and improvements that are included in SQL Server 2008 R2 SP1, review the What's New Section in Release Notes.
  • Download At Source

  • SQL Server® 2008 R2 - PowerPivot for Excel 2010 CTP Nov

    Posted by bink on April 8 2010, 6:14 PM. Posted in Office, SQL Server 2008.

    Microsoft® PowerPivot for Microsoft® Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft® Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can:

    • Process millions of rows with about the same performance as few hundred rows using by leveraging PowerPivot in-memory engine and efficient compression algorithms
    • Integrate data from a multitude of sources, including corporate databases, spreadsheets, reports, text files, and Internet data feeds.
    • Go beyond standard Excel expressions and use PowerPivot’s Data Analysis Expressions (DAX) to perform powerful data manipulations. Follow relationships between tables as in a database and define sophisticated calculations using familiar and intuitive expressions.
    • •Interactively explore, analyze, and create reports without depending on expert knowledge and specialty training by using native Excel 2010 functionality such as PivotTables, slicers, and other familiar analysis features.
    Important Please note that the PowerPivot for Microsoft® Excel only works with the latest version of Microsoft® Office 2010. To download the Microsoft® Office 2010 BETA, please go here.

    We recommend you read the Microsoft® SQL Server® 2008 R2 Release Notes and Microsoft® SQL Server® 2008 R2 Readme before installing this Community Technology Preview. To install and use Microsoft® SQL Server® 2008 R2 - PowerPivot for Microsoft® Excel 2010, complete the following steps in this order:

    Download details Microsoft® SQL Server® 2008 R2 PowerPivot for Microsoft® Excel - NOV CTP
  • SQL Server 2008 R2 Enterprise Evaluation November Download

    Posted by bink on November 10 2009, 5:02 AM. Posted in SQL Server 2008.

    SQL Server 2008 R2 November CTP has numerous new and enhanced features. This document provides the information you need to fully take advantage of these features.

    For Analysis Services, numerous enhancements have been added to the PowerPivot field list. These include automatic relationship detection when columns from unrelated tables are used in a PivotTable; support for searching fields by name; and support for named sets. Targeted support for additional data sources has also been added.

    For the Database Engine, manageability enhancements have been made. These include the ability to connect to SQL Azure; data-tier application upgrades; enhanced functionality for SQL Server Utility features; and deprecation of the VIA protocol. For Reporting Services, SharePoint integration has several new features. Additional enhancements include shared datasets and cache refresh plans; new data visualization report items; enhancements to Reporting Services features that were included in previous releases of SQL Server 2008; Business Intelligence Development Studio support for SQL Server 2008 reports and report server objects; and a new Web Service endpoint that can support management operations of the report server in both native mode and SharePoint integrated mode.


    For Service Broker, you now have the option to turn poison message handling on and off. Master Data Services is a new component. You use Master Data Services to manage your organization's master data, and to maintain a record of that data.

    Download SQL Server 2008 R2

    Download details What's New in SQL Server 2008 R2 November Community Technology Preview (CTP)

  • Microsoft Preps New CTP for SQL Server 2008 R2

    Posted by sumeethevans on November 5 2009, 4:30 AM. Posted in SQL Server 2008.

    At the SQL PASS Conference this week in Seattle, Microsoft announced that it will soon deliver a third Community Technical Preview (CTP) pre-release version of its upcoming SQL Server 2008 R2 database server, then deliver the final version in the first half of 2010. The SQL Server 2008 CTP is due sometime in November, the company said.

    SQL Server 2008 R2 is an update to the well received SQL Server 2008 product, and it comes with numerous enhancements, including new platform support for Windows Server 2008 R2 that dramatically improves its scalability and performance. The SQL Server R2 release also includes new tools for developers and administrators, and integrates with Office 2010 and SharePoint 2010 to provide information workers with new business intelligence functionality.


  • Microsoft® SQL Server® StreamInsight CTP2

    Posted by sumeethevans on September 22 2009, 9:53 PM. Posted in SQL Server 2008.

    Microsoft® SQL Server® StreamInsight is a platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for timely and relevant processing of data. StreamInsight allows software developers to create innovative solutions in the domain of Complex Event Processing that satisfy these needs. It allows to monitor, mine, and develop insights from continuous unbounded data streams and correlate constantly changing events with rich payloads in near real time. Industry specific solution developers (ISVs) and developers of custom applications have the opportunity to innovate on and utilize proven, flexible, and familiar Microsoft technology and rely on existing development skills when using the StreamInsight platform. Some of the key feature areas are:

    • Derive meaningful and relevant information from data/events streams through complex patterns. These patterns can be defined using a declarative query paradigm based on well-defined streaming semantics with LINQ as query language.
    • For the development of applications, adapters, and analytics, the user can rely on well-established and powerful development frameworks and tools such as .NET, LINQ, and Microsoft Visual Studio.
    • The platform integrates with various data sources and sinks through input and output adapters. The framework to build domain-specific adapters utilizes a .NET API to make adoption of the platform easy. Independence between adapters and queries facilitates seamless integration of real-time and historical analysis.
    • The platform architecture supports a variety of deployment options, from scenarios with a low-footprint embedded option to high-end server deployments.
    • A rich set of manageability features such as a management interface, a diagnostic interface and a debugging tool are provided as part of the platform.

    Download at Source

  • Microsoft delivers test versions of SQL Server 2008 R2

    Posted by sumeethevans on August 11 2009, 10:48 PM. Posted in SQL Server 2008.

    The SQL Server team is unleashing the first widespread test builds of the next version of Microsoft’s database, a k a SQL Server 2008 R2 (codenamed “Kilimanjaro”).

    Earlier this year, Microsoft officials said to watch for a Community Technology Preview (CTP) test build of SQL Server 2008 R2 sometime this summer. On Twitter on August 10, Jason Coombes (databasejase), a SQL Server database administrator, tweeted:

    “SQL Server 2008 R2 Enterprise Evaluation & SQL Server 2008 R2 Express Edition CTP have just appeared on MSDN”

    Update: On the “Microsoft Data Platform Insider” blog, the Softies are saying the SQL Server 2008 R2 bits are downloadable by MSDN and TechNet subscribers. The public will get access to the test build on Wednesday, August 12, according to the Softies. And there’s more coming, according to the team. From that August 10 blog posting:

    Continue at All About Microsoft

  • SQL Server 2008 Service Pack 1

    Posted by bink on April 10 2009, 5:27 AM. Posted in SQL Server 2008.

    SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition. Note:We remain committed to our plans to keep 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

    For more information about SQL Server 2008 Service Pack 1, please review the Release Notes.


    Download here

  • Microsoft to bring full SQL Server database to cloud

    Posted by bink on February 27 2009, 8:10 PM. Posted in SQL Server 2008.

    Microsoft, which last year announced plans to bring a limited version of its SQL Server database online, now plans to offer a fully capable cloud version.

    It plans to incorporate as many features from its flagship database into SQL Data Services (SDS) before the cloud-computing platform upon which it will run, Windows Azure, is released, according to an article on The Register.

    Chief executive Steve Ballmer told Wall Street analysts earlier this week that Azure, currently in beta form, would be finalized by the time of Microsoft's Professional Developers Conference (PDC) in November. Microsoft could not immediately be reached for comment.

    In a follow-up posting at its SDS blog, Microsoft confirmed that at its MIX web developer show next month, it will be "unveiling some new [SDS] features that are going to knock your socks off".

    SDS was announced at MIX last spring. Still in beta, SDS was to offer a fraction of SQL Server's feature set and was aimed at developers at startups and smaller web-focused companies with limited database experience.

    This would be easier and cheaper to set up than a full, on-premise SQL Server, or even hosted version of SQL Server, which Microsoft already allowed its partners to sell.

    In that scenario, users often still need to manage - albeit remotely - a full SQL Server database, and usually also buy SQL Server licences and the underlying hardware.


  • Microsoft starts sharing details on SQL Server ‘Kilimanjaro’

    Posted by sumeethevans on October 8 2008, 9:01 PM. Posted in SQL Server 2008.

    Not every team at Microsoft is insisting on secrecy about futures. In fact, the SQL Server database team is taking a much different course than its Windows brethren.

    Just a couple of months after releasing to manufacturing SQL Server 2008, Microsoft is starting to offer details about its next release of its flagship database. That product, code-named “Killimanjaro,” will ship in the first half of 2010, according to Microsoft officials. The first tech preview test builds of Kilimanjaro are due in the first half of 2009, the Softies said.

    Microsoft shared information about Kilimanjaro at the company’s second annual Business Intelligence Conference, which kicked off on October 6 in Seattle.

    Kilimanjaro is set to include self-service analysis tools (codenamed “Gemini”) that Microsoft is saying will allow information workers to better “slice and dice data and create their own BI (business intelligence) applications and assets to share and collaborate on from within the familiar, everyday Microsoft Office productivity tools they already use.” Gemini will incorporate an update to SQL Server Analysis Services, plus some new in-memory components, some “splicers” and add-in exerpiences based on Excel, and deeper SharePoint integration, enbling users to share analyses they’ve created, Microsoft officials said.

    Continue At Source