Orhan AKDOĞAN > Haber

Microsoft SQL Server 2008 Service Pack 3

Microsoft SQL Server 2008 Service Pack 3 ‘ü
http://www.microsoft.com/download/en/details.aspx?id=27594

adresinden download edebilirsiniz.

Detaylar:
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.

SQL Server 2008 R2 Güncellemeleri

SQL Server 2008 R2 güncelleştirmelerine önem vermenizi tavsiye ediyorum,
yaşanan pek çok sorunu güncelleştirme ile çözebilirsiniz.

SELECT @@Version

Sorgusu ile mevcut MSSQL versiyonunuzu öğrenebilirsiniz.

Aşağıdaki tabloda 13 Nisan itibari ile tüm build ler bulunmaktadır.

Build KB Article Release Tarihi Açıklama
10.50.1765.0 2489376  21 Şubat 2011 SQL Server 2008 R2 Cumulative Update 6
10.50.1753.0 2438347  20 Aralık 2010 SQL Server 2008 R2 Cumulative Update 5
10.50.1746.0 2345451  18 Ekim 2010 SQL Server 2008 R2 Cumulative Update 4
10.50.1734.0 2261464  16 Ağustos 2010 SQL Server 2008 R2 Cumulative Update 3
10.50.1720.0 2072493  21 Temmuz 2010 SQL Server 2008 R2 Cumulative Update 2
10.50.1702.0 981355  17 Mayıs 2010 SQL Server 2008 R2 Cumulative Update 1
10.50.1600.1 RTM   SQL Server 2008 R2 RTM
10.50.1450.3 RC0   SQL Server 2008 R2 Release Candidate 0

 

 

Build 10.50.1765.0 (cumulative update 6 )  –   http://support.microsoft.com/kb/2489376

Build 10.50.1753.0 (cumulative update 5 )  –   http://support.microsoft.com/kb/2438347

Build 10.50.1746.0 (cumulative update 4 )  –   http://support.microsoft.com/kb/2345451

Build 10.50.1734.0 (cumulative update 3 )  –   http://support.microsoft.com/kb/2261464

Build 10.50.1720.0 (cumulative update 2 )  –   http://support.microsoft.com/kb/2072493

Build 10.50.1702.0 (cumulative update 1 )  –   http://support.microsoft.com/kb/981355

Kaynak : http://support.microsoft.com/kb/981356

SQL SERVER 2011

Microsoft SQL Server 2011 olarak çıkması beklenen,
SQL Server’ın kod adı “Denali” olan yeni sürümünün
CTP 1 (Community Technology Preview 1) versiyonu indirebilir durumda.

Download Linki:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9

Detaylar:
http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx

Books Online:
http://msdn.microsoft.com/en-us/library/ms130214(v=SQL.110).aspx

SQLPASS

SQL Server Günlüğüm Orhan AKDOĞAN, En iyi SQL Server Community lerinden olan SQLPASS Blog listesine girmiştir.

Teşekkürler SQLPASS.

SQL Server 2008 R2, e-Book

Microsoft Press, SQL Server 2008 R2 sürümü için ücretsiz bir eBook yayınladı.

Introducing Microsoft SQL Server 2008 R2 (Ross Mistry, Stacia Misner)

Kitap 10 Bölüm ve 216 sayfadan oluşuyor.

İçerik:

PART I   Database Administration

1.Bölüm   SQL Server 2008 R2 Editions and Enhancements
2.Bölüm   Multi-Server Administration
3.Bölüm   Data-Tier Applications
4.Bölüm   High Availability and Virtualization Enhancements
5.Bölüm   Consolidation and Monitoring

PART II   Business Intelligence Development

6.Bölüm   Scalable Data Warehousing
7.Bölüm   Master Data Services
8.Bölüm   Complex Event Processing with StreamInsight
9.Bölüm   Reporting Services Enhancements
10.Bölüm   Self-Service Analysis with PowerPivot

Aşağıdaki linklerden e-Book’u indirebilirsiniz.

PDF Formatı

XPS Formatı

Kaynak:

http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

.