FIX: DQS Won’t Work after upgrading to CU1 – SQL Exception 0x80131904

There are lots of reports of data quality services (DQS) not working after installing CU1 for SQL Server 2012. One symptom is that when trying to connect from the DQS client, you receive the following error: “System.Data.SqlClient.SqlException (0x80131904): An error occurred in the Microsoft .NET Framework while trying to load assembly id 65581”

After applying CU1, you need to execute:

dqsinstaller.exe -upgrade

This is typically from the folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn (but depends upon your installation path)

New updated maintenance plan scripts from Ola Hallengren

Great to see our buddy Ola Hallengren has created an updated version of his database maintenance scripts. Many people use these in place of the database maintenance plans that ship with SQL Server.

Here’s the updated info from Ola and the best part is that they continue to be free:

New Version Available

A new version of the SQL Server Maintenance Solution is now available. The new version supports SQL Server 2012.

One new feature in SQL Server 2012 is AlwaysOn Availability Groups. This feature supports multiple replicas of a database. You can back up any replica and define a preferred backup replica.

SQL Server 2012 also supports online rebuilding of indexes with varchar(max), nvarchar(max), varbinary(max), or XML data types or large CLR types. The new version of the SQL Server Maintenance Solution makes use of this capability.

You can read more about the most recent version of the solution at http://ola.hallengren.com/versions.html

or download it at

http://ola.hallengren.com/scripts/MaintenanceSolution.sql

New Documentation

Updated documentation is now available at

http://ola.hallengren.com/sql-server-backup.html

http://ola.hallengren.com/sql-server-integrity-check.html

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

If you have been linking to the old documentation web page, please update your links to point to these new URLs.

#SQLMug – Like a collectors set of 5 x geeky SQL Mugs?

Hi Folks,

For a while, I’ve been wanting to get some great SQL mugs printed for SQL Down Under but I need further inspiration so here’s your chance to get a collectors set of 5 SQL mugs:

Send me (greg @ sqldownunder . com) a great line to go onto the mugs, along with your country and a delivery address. I’ll pick the best 5 and get mugs printed with those sayings. If you’re one of the 5, I’ll send you a collectors set with one of each of the 5.

Simple enough?

Here are some ideas I’ve already received to get you started:

  • Chuck Norris gets NULL. Nothing compares to him either.
  • ALTER MUG  SET SINGLE_USER  WITH ROLLBACK IMMEDIATE;
  • DENY CONTROL  ON OBJECT::MUG  TO public;
  • knock knock who’s there? sp_ sp_who? spid 1, spid 2, spid 3, spid 4…
  • ALTER DATABASE CriticalDB
    SET ChuckNorrisMode = ON
    WITH NOWAIT;

I’ll probably cut off new entries around the end of April.