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:
This is typically from the folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn (but depends upon your installation path)
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
Updated documentation is now available at
If you have been linking to the old documentation web page, please update your links to point to these new URLs.
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.
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
I'll probably cut off new entries around the end of April.