Close

SQL Server

SQL Server 2016 – DQS Error – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySession”:

Got this error below while attempting to run DQC – Data Quality Client – which previously worked on this SQL Server which had previously an ok/verified DQS – Data Quality Server installation. Error text: SQL Server Data Quality Services ——————————————————————————– Message Id: LogOnWindowFailedToConnect Cannot connect to <SERVER>. A .NET Framework error occurred during execution of […]

Read More

Microsoft R – SQL 2016 – Notes

“R is a free software environment for statistical computing and graphics” – source click here. Useful links: Getting Started with Microsoft R Client Microsoft R Installing DeployR for Microsoft R Server 2016 (8.0.5) on Windows Set up SQL Server R Services (In-Database) SQL Server 2016 R Services: Guide for Server Configuration   Quick notes: You […]

Read More

Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013

Click here for the download link for Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013  – this installs Microsoft SQL Server Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services that support Visual Studio 2013, SSIS 2012/2014 etc.

Read More