Last month, Microsoft announced SQL Server 2014 Service Pack 1 and it had issues with SSIS catalog. Microsoft has once again released SQL Server 2014 Service Pack 1 earlier today and it is now available to download. I hope all the issue with earlier version has been taken care and the version is reliable to apply to production server. I strongly suggest that one should wait for a while before going ahead and applying the service pack. It is a good idea to wait and see if the version which we are installing is stable and there are not bugs. I always install, service packs on my development server before I install them on production servers.
Here are the links to download SQL Server 2014 Service pack 1
Earlier this month, Microsoft has released quite a few SQL Server related tools, add-ons, and upgrades. I have listed a few of them here for a quick reference. The descriptions are of each downloads are from Microsoft download pages.
Microsoft Azure, Cloud and Enterprise Symbol / Icon Set for Visio, PowerPoint, PNG This package contains a set of symbols/icons to visually represent features of and systems that use Microsoft Cloud and Enterprise products (Microsoft Azure, Windows Server, SQL Server) and related technologies. The symbols are in Microsoft Visio Stencil and Portable Network Graphics (PNG) formats. Instructions on using the PNG symbols in PowerPoint are provided.
Microsoft JDBC Drivers 4.1 and 4.0 for SQL Server
Download the Microsoft JDBC Driver 4.1or 4.0 for SQL Server, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5,6 and 7.
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:
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.
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.
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.
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.
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.
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
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.
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.
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