SQL SERVER – Download RML Utilities for SQL Server

Microsoft RML Utilites are very helpful when analysing performance. It helps answering questions like

  • Do you know which databases are using the most resources on your server?
  • Do you know which applications are using the most resources on your server?
  • How will a service pack upgrade, configuration change or application change affect your production SQL Server?
  • Which application, database or login is using the most resources?
  • Which queries are responsible for high utilization of performance?
  • What queries are running slower in today’s workload?

I believe it is a good tool to give it a try.

Download RML Utilities for SQL Server

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

About these ads

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)

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)