SQL SERVER – 2014 CTP1 Available for Download – SQL SERVER 2014 Community Technology Preview 1

Microsoft announced that SQL Server 2014 CTP 1 available to download at TechEd Europe.

You can download SQL Server 2014 CTP1 from here. Additionally, there is in depth documentation of the product in the Product Guide over here.

In this blog post I have in depth discussed what are the salient features which I was looking forward in the new version.

  • Always On supports now 8 secondaries instead of 4
  • Online Indexing at partition level – this is a good thing as now index rebuilding can be done at a partition level
  • Statistics at the partition level – this will be a huge improvement in performance
  • In-Memory OLTP works by providing in-application memory storage for the most often used tables in SQL Server.
  • Columnstore Index can be updated – I just can’t wait for this feature (Columnstore Index)
  • Resource Governor can control IO along with CPU and Memory
  • Increase performance by extending SQL Server in-memory buffer pool to SSDs
  • Backup to Azure Storage

You can read about the new features of the SQL Server 2014 in the following links:

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQL SERVER – A List of Various SQL Server RTM and Service Pack Number

A common question I receive is that how do user know which version user is using and what is the latest version available for the product. Here is something at this beginning of the year, check with your production server. See if you are using the latest version of the product or if you need to upgrade. If you need to upgrade you might want to plan it with your entire team. As I get this question often here is something I have already built and kept it with me. As soon as I receive an email with the question about the version, I right away send it to them.

Now onwards as I have blogged about this subject, in future question, I will like to this blog post. Please feel free to add more details if I have missed any.

Here are two of the methods, you can use to identify your SQL Server version:

Open SSMS and in a New Query Window run following T-SQL code.

1) SELECT@@version

2) SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The above query will return the version details of installed SQL Server.

Here is the list of the all the available RTM and Service Pack Numbers.

SQL Server 2012 Versions

Release Product Version
SQL Server 2012 Service Pack 1 11.00.3000.00
SQL Server 2012 RTM 11.00.2100.60

SQL Server 2008 R2 Versions

Release Product Version
SQL Server 2008 R2 Service Pack 1 10.50.2500.0
SQL Server 2008 R2 RTM 10.50.1600.1

SQL Server 2008 Versions

Release Product Version
SQL Server 2008 Service Pack 3 10.00.5500.00
SQL Server 2008 Service Pack 2 10.00.4000.00
SQL Server 2008 Service Pack 1 10.00.2531.00
SQL Server 2008 RTM 10.00.1600.22

SQL Server 2005 Versions

Release Product version
SQL Server 2005 Service Pack 4 9.00.5000.00
SQL Server 2005 Service Pack 3 9.00.4035
SQL Server 2005 Service Pack 2 9.00.3042
SQL Server 2005 Service Pack 1 9.00.2047
SQL Server 2005 RTM 9.00.1399

SQL Server 2000 Versions

Release Product version
SQL Server 2000 Service Pack 4 8.00.2039
SQL Server 2000 Service Pack 3 8.00.760
SQL Server 2000 Service Pack 3 8.00.760
SQL Server 2000 Service Pack 2 8.00.534
SQL Server 2000 Service Pack 1 8.00.384
SQL Server 2000 RTM 8.00.194

This method will help us find edition of the relational database. In future blog posts we will see the methods to identify the version of the Business Intelligence Services.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many different tools and features available in pack, which can be very handy and can solve issues.

Microsoft ADOMD.NET
Microsoft Core XML Services (MSXML) 6.0
Microsoft OLEDB Provider for DB2
Microsoft SQL Server Management Pack for MOM 2005
Microsoft SQL Server 2000 PivotTable Services
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
Microsoft SQL Server 2005 Backward Compatibility Components
Microsoft SQL Server 2005 Command Line Query Utility
Microsoft SQL Server 2005 Datamining Viewer Controls
Microsoft SQL Server 2005 JDBC Driver
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Compact Edition
Microsoft SQL Server 2005 Notification Services Client Components
Microsoft SQL Server 2005 Upgrade Advisor
Microsoft .NET Data Provider for mySAP Business Suite, Preview Version
Reporting Add-In for Microsoft Visual Web Developer 2005 Express
Microsoft Exception Message Box
Data Mining Managed Plug-in Algorithm API for SQL Server 2005
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
SQL Server 2005 Performance Dashboard Reports
SQL Server 2005 Best Practices Analyzer

Download Feature Pack for Microsoft SQL Server 2005 SP4

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Microsoft SQL Server 2005 Service Pack 4 RTM

Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 .

Download Microsoft SQL Server 2005 Service Pack 4 RTM

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Vote for SQL Server 2005 Service Pack 4 – Vote for SQL Server 2008 Service Pack 2

It has been long time since Microsoft has released SQL Server 2005 SP3 and SQL Server 2008 SP1. It is the time when the new SPs should be released.

SQL Server 2005 Service Pack 4

SQL Server 2008 Service Pack 2

Many thanks to Steve Jones of SQLServerCentral.com for this excellent initiative.

I voted there, have you voted?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Download – Cumulative Update Package for SQL Server 2008

SQL Server 2008 has been out for over two years and now a very significant Cumulative Update has been released. If you are using SQL Server 2008 then you must certainly install it to fix the various bugs.

Cumulative Update 3 for SP1: http://support.microsoft.com/kb/971491

Cumulative Update 6 for RTM: http://support.microsoft.com/kb/971490

I heavily recommend this update.

Feel free to talk to me if you want more information on it.

Reference : Pinal Dave (http://blog.sqlauthority.com)

SQL SERVER – Order of Hotfix and Service Pack

On an average once a week I receive a question from my readers regarding what should be the sequence of hotfix and service pack. Not long ago, one of my regular readers who is using SQL Server 2000 asked me how can he improve the installation speed as he has to install 4 Service Packs to upgrade his server to SQL Server SP4 version. All these questions from my readers have prompted me to write down this small note.  I hope this will clear some of the common doubts they have about this subject and they no longer would have to ponder over such issues

You do not need to install all Service Packs to upgrade your server version to the latest versions. Just install Latest Service Pack and Hotfix and you are done!

This might be the smallest tip I have given so far on my blog but I am just curious to know from you all if you already knew about the solution or came to know about it through my blog today. Based on your feedback, I will come up with small articles like this in future and solve your day-to-day queries.

All Microsoft Service Packs are listed here.

Reference : Pinal Dave (http://blog.SQLAuthority.com)