SQL Server 2008 Release Candidate 0

June 17, 2008

Download SQL Server 2008 Release Candidate - Here

SQL Server 2008 RC0 will automatically expire after 180 days.


SQL Server 2008 - A Quick Overview

March 16, 2008

SQL Server 2008 Overview

SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place any time. So before we discuss more about SQL Server 2008 new features, let’s talk about what is Microsoft Data Platform Vision?

Microsoft Data Platform Vision

Today we live in the world of information explosion where in we come across many types of data on a day to day basis. We store, retrieve and transact data into different types such as images, video, audio, digital information, sensor information from RFID tags and the list goes on. As we now know that organizations have become considerably large with the global presence and due to this the need to make data more secure and regulatory compliance has become mandatory. Also the data stored should be available Any Where - Any Time.

Today the user and application has become completely mobile and we want our data/information to be viewed on any device -any time - anywhere. So the question here is how to deal with this kind of complexities and manage the information explosion in an effective and efficient way.

The answer to the above challenges is Microsoft Data Platform Vision. It helps organization to overcome the challenges of information explosion by providing a solution that organization can use to store many types of data, including the following

  1. XML
  2. e-mail
  3. time/calendar
  4. File
  5. Documents and Geospatial

SQL Server 2008 provides reach set of services to interact with the data , query the data , performing data analysis , reporting, integration and robust synchronization. Above all , users can access information on any device.

What SQL Server 2008 Delivers?

SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents such as images, music, documents directly within the database.

Top New Features

  • Use Resource Governor to manage concurrent workloads
  • Enforce policy compliance consistently across the enterprise with the Policy-Based Management
  • Reduce storage requirements and increase query performance with data compression and Sparse Columns
  • Protect sensitive data with Transparent Data Encryption and advanced auditing
  • Troubleshoot, tune, and monitor SQL Server 2008 instances across the enterprise with Performance System Analysis
  • Build high performance analysis solutions with scalability, performance, data mining and user interface enhancements in SQL Server Analysis Services
  • Take advantage of improved performance, usability, visualization, and integration with the 2007 Microsoft Office system in SQL Server Reporting Services
  • Integrate location-enabled applications through support for spatial data 

 

Top New Security Features

· Use the Declarative Management Framework to help enforce security polices for data services across the enterprise.

· Encrypt data without modifying applications, using Transparent Data Encryption.

· Employ enterprise-wide encryption solutions with Extensible Key Management and Hardware Security Modules.

· Audit all actions with the new Audit object.

Top New High Availability Features

  • Recover corrupt data pages from a mirror server with enhanced database mirroring features. Watch the short demo.
  • Take advantage of failover clustering enhancements in Windows Server 2008.
  • Add new nodes to a peer-to-peer replication solution without taking replication offline.
  • Improve restore times, and reduce backup volumes with new support for backup compression.
  • Improve concurrency with locking enhancements.
  • Reduce downtime for hardware maintenance with hot-add CPU capabilities.
  • Use Resource Governor to proactively control workload prioritization.

Top New Performance and Scalability Features

  • Take control of resource allocation with Resource Governor.
  • Troubleshoot, tune, and monitor SQL Server 2008 instances across the enterprise with Performance Data Collector.
  • Build high-performance analysis solutions with scalability and performance enhancements in SQL Server Analysis Services.  Take advantage of on-demand processing and better performance with the re-engineered reporting engine for SQL Server Reporting Services.
  • Increase extract, transform, and load (ETL) performance in SQL Server Integration Services with scalable lookup tasks.

Happy Learning…..I will be sharing few more information in my next article.

Harsh Shah
(Sr. Consultant)


Download SQL Server 2008 and SQL Server 2005 Sample Database

March 14, 2008

SQL Server 2008 Sample Database for SQL Server 2008 February CTP

Following is the link to the CodePlex (CodePlex is Microsoft’s open source project hosting web site) site from where you can download the examples

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=10901

SQL Server 2005 Sample Database - For SQL Server 2005 SP2a

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004


Visual Studio 2005 for SQL Server 2008

March 8, 2008

This CTP enables developers to use Visual Studio 2005 for SQL Server 2008 CTP5.

Please note the following:

Please test in a test environment only

This CTP addresses the following issue:

“This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.”
This CTP addresses this issue, and enables the following Visual Studio functionality for SQL Server 2008 CTP5 :

  • Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release.
  • SQL CLR projects that target SQL Server 2008 CTP5 can be created and deployed to the server.
  • T-SQL and SQL CLR debugging are now enabled for SQL Server 2008 CTP5.
  • Data binding features in Client and Web Projects are enabled.

This CTP does not support the following features for SQL Server 2008 Nov CTP:

  • Creating and editing table schemas in Table Designer or Database Diagrams. The table designer feature in SQL Server Management Studio 2008 can be used to edit table schemas in SQL Server 2008 CTP5.

For more information please visit the following link.

http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en


Download the latest SQL Server 2008 CTP -February 2008

March 8, 2008

Download the latest SQL Server 2008 February 2008 CTP. This CTP is valid for 180 days as per the information available at the below link.

Download: http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx


Microsoft is Positioned Leader in Gartner’s Business Intelligence Top Ranking

March 8, 2008

Microsoft Is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing.

This is indeed a great news for all of us. The Magic Quadrant is an esteemed evaluative model established by Gartner. It positions vendors according to their ability to execute and completeness of vision. For more information please visit the following links.

Microsoft Is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing
http://www.microsoft.com/presspass/press/2007/oct07/10-12DWMQPR.mspx

Magic Quadrant for Business Intelligence Platforms, 1Q07
http://mediaproducts.gartner.com/reprints/oracle/145507.html


TOP 10 Microsoft Business Intelligence Benefits

March 8, 2008
  1. Connect people to information efficiently and effectively.
  2. Empower employees.
  3. Simplify collaboration and sharing.
  4. Analyze and gain insight.
  5. Improve alignment.
  6. Harness the power of the 2007 Microsoft Office system.
  7. Deliver business intelligence to your entire organization.
  8. Reduce training needs
  9. Deliver sophisticated analysis and reporting.
  10. Deliver enterprise-grade business intelligence.

(Source : office.microsoft.com)


SQL SERVER: Editions and Components of SQL Server 2008

February 9, 2008

The below link provides the detail information about the various editions of SQL Server 2008.

http://msdn2.microsoft.com/en-us/library/ms144275(SQL.100).aspx

Happy Learning


SQL Server: Download SQL Server 2008 November CTP

February 9, 2008

You can download the SQL SERVER 2008 November CTP from the below link. However, I would suggest you to go through the Hardware Requirements page first before you proceed with the SQL SERVER 2008 installation. You can find the

Hardware Requirements:
http://msdn2.microsoft.com/en-us/library/ms143506(SQL.100).aspx

Download Nov CTP
http://msdn2.microsoft.com/hi-in/sqlserver/bb851668(en-us).aspx

Happy Learning