F5 Debug…

Building & Debugging the Technology!!!

Archive for the ‘SQL Server 2008’ Category

SQL Server 2008 R2 Update for Developers Training Kit (May 2011 Update)

Posted by Karthikeyan Anbarasan on June 12, 2011

This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It contains a rich set of presentations, demos, hands-on labs and videos that are perfect for self-paced learning or for conducting your own training.

The easiest way to get started with the training kit is to download it, install it, open default.htm and browse the kit for the content that you are most interested in. Many of the presentations and demos in the training kit include a video that you can watch to familiarize yourself with the content. When you are ready for some hands-on experience, try installing one of the demos or hands-on labs. Each of them includes a configuration wizard that simplifies installation.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

The training kit is divided into four sections:

  • Getting Started (for Web and BI developers who are new to SQL Server)
  • SQL Server 2008 (for experienced SQL Server developers who want to understand what’s new in 2008)
  • SQL Server 2008 R2 (for experienced SQL Server developers who want to understand what’s new in 2008 R2)
  • Office 2010 (for experienced BI developers who want to understand what’s new in 2008 R2 and Office 2010)

Posted in SQL Server 2008 | Tagged: , , | Leave a Comment »

Microsoft SQL Server 2008 R2 SP1 CTP

Posted by Karthikeyan Anbarasan on May 30, 2011

Microsoft SQL Server 2008 R2 Service Pack 1 CTP is ready to download using the below link.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bd200f8e-ba8a-45e3-af59-e28a9e2d17df&displaylang=en

We can use these packages to upgrade any of the following SQL Server 2008 R2 editions:

(1) SQL Server 2008 R2 Parallel Computing Edition
(2) SQL Server 2008 R2 Datacenter Edition
(3) SQL Server 2008 R2 Enterprise Edition and Developer Edition
(4) SQL Server 2008 R2 Standard Edition
(5) SQL Server 2008 R2 Web Edition
(6) SQL Server 2008 R2 Workgroup Edition
(7) SQL Server 2008 R2 Express Edition

New Features in this service pack 1 are as follows

  1. Dynamic Management Views for increased supportability
  2. ForceSeek for improved querying performance
  3. Data-tier Application Component Framework (DAC Fx) for improved database upgrades
  4. Disk space control for PowerPivot

Note : These packages are available for testing purposes only in a non-production environment. To upgrade SQL Server 2008 R2 Express Edition, obtain the SP1 version of Express Edition or Express Edition with Advanced Services.

 

 

Posted in SQL Server 2008 | Tagged: , | Leave a Comment »

Top 10 Features for SQL Server Development

Posted by Karthikeyan Anbarasan on April 20, 2011

This blog shows on the latest top 10 features of SQL Server development

  1. Hosted CommonLanguage Runtime
  2. Native XML Support
  3. ADO.NET version 2.0
  4. Security Enhancements
  5. Transact-SQL Enhancements
  6. Reliable Messaging for Asynchronous Applications
  7. Visual Studio Integration
  8. Web Services
  9. Embedded Reports
  10. Full-Text Search Enhancements

Posted in SQL Server 2008 | Leave a Comment »

List of top new features of sql server 2008

Posted by Karthikeyan Anbarasan on April 18, 2011

List of 28 new features of Microsoft SQL Server 2008.

  1. Transparent Data Encryption
  2. Extensible Key Management
  3. Auditing
  4. Enhanced Database Mirroring
  5. Automatic Recovery of Data Pages
  6. Log Stream Compression
  7. Resource Governor
  8. Predictable Query Performance
  9. Data Compression
  10. Hot Add CPU
  11. Policy-Based Management
  12. Streamlined Installation
  13. Performance Data Collection
  14. Language Integrated Query (LINQ)
  15. ADO.NET Data Services
  16. DATE/TIME
  17. HIERARCHY ID
  18. FILESTREAM Data
  19. Integrated Full Text Search
  20. Sparse Columns
  21. Large User-Defined Types
  22. Spatial Data Types
  23. Backup Compression
  24. Partitioned Table Parallelism
  25. Star Join Query Optimizations
  26. Grouping Sets
  27. Change Data Capture
  28. MERGE SQL Statement

Posted in SQL Server 2008 | 1 Comment »