March 2012 - Posts

• WCF Error when using “Match Data” function in MDS Excel AddIn

  If you’re using MDS and DQS with the Excel Integration you may get an error when trying to use the “Match Data” feature that uses DQS in order to help to identify duplicate data in your data set. The error is quite obscure and you have to enable WCF error Read More... Posted Thursday, March 29, 2012 10:46 AM by Davide Mauri | 0 Comments Filed under: SQL Server, MDS, Master Data Services, Data Quality, 2012, DQS

• REPLACENULL in SSIS 2012

  While preparing my slides e demos for the forthcoming SQL Server Conference 2012 in Italy , I’ve come across a nice addition to DTS Expression language which I never noticed before and that seems unknown also to the blogosphere: REPLACENULL. REPLACENULL Read More... Posted Wednesday, March 21, 2012 8:00 PM by Davide Mauri | 3 Comments Filed under: SSIS, 2012

• SQL Server 2012 RTM Available!

  SQL Server 2012 is available for download! http://www.microsoft.com/sqlserver/en/us/default.aspx The Evaluation version is available here: http://www.microsoft.com/download/en/details.aspx?id=29066 and along with the SQL Server 2012 RTM there’s also the Read More... Posted Wednesday, March 07, 2012 12:34 AM by Davide Mauri | 0 Comments Filed under: SQL Server, 2012