SQL SERVER – SQL Server 2008 R2 Service Pack 3 – Download

It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack  3and its feature pack. SQL Server 2008 R2 SP3 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 R2 Service Pack 2 up to and including Cumulative Update 13.

I have personally switched to SQL Server 2014 few months ago and I am happy with its performance and robust behavior. Many of the customer and clients are still using SQL Server 2012. However, if you are using SQL Server 2008 R2, I suggest that you look at upgrading to the latest version of SQL Server or at least update your software with latest service pack.

You can download SQL Server 2008 R2 Service Pack from following link:

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

About these ads

SQL Authority News – Download and Install Adventure Works 2014 Sample Databases

If you are using SQL Server there are good chances that you are familiar with AdventureWorks. AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks have replaced Northwind and Pubs from the sample database in SQL Server 2005. The Microsoft team keeps updating the sample database as they release new versions. I use the AdventureWorks database for most of my example, as it is easy to use sample database which is accessible for most of the people out there.

Every new version  of SQL Server should have its own Adventureworks database. The reason is that SQL Server comes up with new features with every version and most of the new features need a new dataset sample to demonstrate the capabilities of the features. This is the why every version of SQL Server has its own AdventureWorks database.

SQL Server 2014 has many new features and to support that Microsoft has released new Advetureworks 2014 Sample Database.

You can download Adventure Works 2014 Sample Databases from here.

Here is a quick tutorial how one can install the AdventureWorks database on your server.

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

SQL SERVER – Microsoft SQL Server Migration Assistant V6.0 Released

Every company makes a different decision about the database when they start, but as they move forward they mature and make the decision which is based on their experience and best interest of the organization. Similarly, quite a many organizations make different decisions on database, like Sybase, MySQL, Oracle or Access and as time passes by they learn that now they want to move to a different platform. Microsoft makes it easy for SQL Server professional by releasing various Migration Assistant tools. Last week, Microsoft released Microsoft SQL Server Migration Assistant v6.0.

Here are different tools released earlier last week to migrate various product to SQL Server.

Microsoft SQL Server Migration Assistant v6.0 for Sybase
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase Adaptive Server Enterprise (ASE) to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.

Microsoft SQL Server Migration Assistant v6.0 for MySQL
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from MySQL to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.

Microsoft SQL Server Migration Assistant v6.0 for Oracle
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Oracle to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.

Microsoft SQL Server Migration Assistant v6.0 for Access
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server and Azure SQL DB, and then migrates data from Microsoft Access to SQL Server and Azure SQL DB.

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

SQLAuthority News – Two Whitepapers on Performance Tuning and Enhancements

The best part of being in the technology domain is that I get a lot of opportunity to talk and write at different places. I travel quite a bit in lengths to deliver some of my learnings with audiences around the world. These learnings and writings as in this blog have influenced and encouraged a number of others to also jump into the blogging or writing habit. I cherish and love doing these outside of this site too. Recently, I wrote a couple of whitepapers and thought it was worth a call here over this blog too. What are these whitepapers all about?

Beginning Performance Tuning

If you want to learn a new competency, where would you start? One cannot wake up on a warm sunny day and start driving on their own. There is a process, steps and most importantly a learning part from an expert to get them started. And over a period of time this practice will make them expert too. The analogy hold good even here. There is no silver bullet to performance tuning and there is no “it depends” to performance tuning.

The facts and the process to learn is what gets discussed in this whitepaper. The best person to start performance testing are the developers and DBAs of the application itself. They exactly know the architecture, workload, dependencies and how access happens in the system. In this whitepaper I talk about this fundamental process first and then delve into some of the simplest techniques I have used for ages to do performance testing.

You can read the Whitepaper: Beginning Performance Tuning with SQL Server 2014 here.

Performance Enhancements with SQL Server 2014

Second in series that I wrote was around Performance Enhancements with SQL Server 2014. The need to upgrade to the latest stack always has its own challenges and administrators are constantly looking at the need to understand the new features so that it can help them at work. This constant struggle and need to learn, implement and troubleshoot the latest and greatest is a challenge in itself.

In this whitepaper, I take my random 4 picks of performance enhancements with SQL Server 2014 which I personally felt are worth a mention. Some of them include ColumnStore Index, Managed Lock Priority, Buffer Pool Extensions and more. I take an introduction to each of these enhancements and what these features bring to the table for an administrator / developer. In reality, each of these topics warrant a whole whitepaper but I am sure the future blogs will contain some of these for sure. Stay tuned on that.

You can read the Whitepaper: Performance Enhancements made with SQL Server 2014 here.

I am sure you will enjoy these whitepapers and the best part is they are absolutely FREE. So do download them and let me know your thoughts. Would love to incorporate some of them in my future writing on this blog or papers I write.

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

SQLAuthority News – SQL Server 2012 Service Pack 2 is Available

Microsoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all editions of SQL Server 2012. This service pack contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9). Here is the list of the bugs which are fixed in SQL Server 2012 SP2.

If you are facing any of the following issues and have not installed any of the cumulative updates, you should indeed update to SQL Server 2012 SP2. On my personal development server, I have upgraded this SP2 and after a week’s testing, I am planning to roll it out to my production server.

I am very excited about the bug fix of Poor Performance when using table variables, as I had just talked about during my last presentation in India.

  • Can’t connect to the server when you run a cube creation MDX query in SSAS 2012
  • Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 report
  • Text truncated when you use HPB renderer to view a report in SSRS 2012
  • SQL Server crashes when the log file of tempdb database is full in SQL Server 2012
  • SSRS 2012 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB
  • SSRS 2012 cannot export a report that is larger than 10 MB to Excel format
  • Rollback causes database to go to suspect mode in SQL Server 2012
  • Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012
  • New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2
  • New log files are not created when you restart the Reporting Services Windows Service in SSRS 2012 on January 1
  • No error message when log backup failed in SQL Server 2012
  • Visual Studio 2012 crashes because of access violation when the data source binding is completed in Report Viewer 2012 UI in local mode
  • File Share subscription doesn’t populate the description column in SSRS 2012
  • The “Name” drop-down list is empty when an SSRS 2012 report is specified
  • Event ID 22 or error 0xC1000016 will be logged when you use Discover command in SSAS 2012
  • Performance issues when you use SSISDB as your deployment store in SQL Server 2012
  • SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2
  • Poor performance when you use table variables in SQL Server 2012
  • Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012

You can download SQL SQL Server 2012 from this download link.

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

SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014

We all start somewhere when it is about database. There are different reasons, why we go for one database over another database. Usually the reason is cost and convenience. After a period of time when business is successful and traffic is growing, the same two reasons of cost and convenience start to become secondary goals. I have seen quite a lot of companies starting with free databases and after a while switching to another database as they want stability and service from the product company.

Microsoft has an excellent product which lets you migrate your database from the alternate database to SQL Server. It is called SQL Server Migration Assistant (SSMA) and earlier this week, it has been upgraded to support SQL Server 2014. Now you can migrate from your database to to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft.

Here is where you can download SSMA v5.3 for various databases.

Microsoft SQL Server Migration Assistant v5.3 for Access
Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server

Microsoft SQL Server Migration Assistant v5.3 for Oracle
Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database to SQL Server.

Microsoft SQL Server Migration Assistant v5.3 for Sybase
Microsoft SQL Server Migration Assistant (SSMA) for Sybase is a tool to automate migration from Sybase ASE database to SQL Server.

Microsoft SQL Server Migration Assistant v5.3 for MySQL
Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database to SQL Server.

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

SQL Authority News – Download Microsoft SQL Server 2014 Feature Pack and Microsoft SQL Server Developer’s Edition

Yesterday I attended the SQL Server Community Launch in Bangalore and presented on Performing an effective Presentation. It was a fun presentation and people very well received it. No matter on what subject, I present, I always end up talking about SQL. Here are two of the questions I had received during the event.

Q1) I want to install SQL Server on my development server, where can we get it for free or at an economical price (I do not have MSDN)?

A1) If you are not going to use your server in a production environment, you can just get SQL Server Developer’s Edition and you can read more about it over here.

Here is another favorite question which I keep on receiving it during the event.

Q2) I already have SQL Server installed on my machine, what are different feature pack should I install and where can I get them from.

A2) Just download and install Microsoft SQL Server 2014 Service Pack. Here is the link for downloading it.

The Microsoft SQL Server 2014 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server. It includes tool and components for Microsoft SQL Server 2014 and add-on providers for Microsoft SQL Server 2014. Here is the list of component this product contains:

  • Microsoft SQL Server Backup to Windows Azure Tool
  • Microsoft SQL Server Cloud Adapter
  • Microsoft Kerberos Configuration Manager for Microsoft SQL Server
  • Microsoft SQL Server 2014 Semantic Language Statistics
  • Microsoft SQL Server Data-Tier Application Framework
  • Microsoft SQL Server 2014 Transact-SQL Language Service
  • Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2014
  • Microsoft SQL Server 2014 Shared Management Objects
  • Microsoft Command Line Utilities 11 for Microsoft SQL Server
  • Microsoft ODBC Driver 11 for Microsoft SQL Server – Windows
  • Microsoft JDBC Driver 4.0 for Microsoft SQL Server
  • Microsoft Drivers 3.0 for PHP for Microsoft SQL Server
  • Microsoft SQL Server 2014 Transact-SQL ScriptDom
  • Microsoft SQL Server 2014 Transact-SQL Compiler Service
  • Microsoft System CLR Types for Microsoft SQL Server 2014
  • Microsoft SQL Server 2014 Remote Blob Store
  • SQL RBS codeplex samples page
  • SQL Server Remote Blob Store blogs
  • Microsoft SQL Server Service Broker External Activator for Microsoft SQL Server 2014
  • Microsoft OData Source for Microsoft SQL Server 2014
  • Microsoft Balanced Data Distributor for Microsoft SQL Server 2014
  • Microsoft Change Data Capture Designer and Service for Oracle by Attunity for Microsoft SQL Server 2014
  • Microsoft SQL Server 2014 Master Data Service Add-in for Microsoft Excel
  • Microsoft SQL Server StreamInsight
  • Microsoft Connector for SAP BW for Microsoft SQL Server 2014
  • Microsoft SQL Server Migration Assistant
  • Microsoft SQL Server 2014 Upgrade Advisor
  • Microsoft OLEDB Provider for DB2 v5.0 for Microsoft SQL Server 2014
  • Microsoft SQL Server 2014 PowerPivot for Microsoft SharePoint 2013
  • Microsoft SQL Server 2014 ADOMD.NET
  • Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2014
  • Microsoft SQL Server 2014 Analysis Management Objects
  • Microsoft SQL Server Report Builder for Microsoft SQL Server 2014
  • Microsoft SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint

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