Tag: SQL Server

Microsoft R – SQL 2016 – Notes

“R is a free software environment for statistical computing and graphics” – source click here.

Useful links:

 

Quick notes:

  • You need Windows Server 2012 R2
  • JDK needs to be installed before running the SQL 2016 setup program
  • Enable TCP/IP and restart your SQL 2016 instance.
  • Connect to the instance.
  • Run:Exec sp_configure ‘external scripts enabled’, 1;reconfigure;
  • Restart all services, SDE, SSA, Polybase, Launchpad service.
  • Note. If you don’t restart the Launchpad service, you will get below error message.
  • Msg 39011, Level 16, State 1, Line 8
    SQL Server was unable to communicate with the LaunchPad service. Please verify the configuration of the service.
    Msg 11536, Level 16, State 1, Line 8
    EXECUTE statement failed because its WITH RESULT SETS clause specified 1 result set(s), but the statement only sent 0 result set(s) at run time.

r1 f2

SQL – Server ‘MYSQLSERVER′ is not configured for RPC

Below is an error that showed up while trying to execute a stored procedure on instance X from SQL server instance y. MYSERVER here represents the name of SQL Server instance X

Msg 7411, Level 16, State 1, Line 1

Server ‘MYSQLSERVER′ is not configured for RPC.

Solution to this was to set RPC in/out to true. Below are the T-SQL commands used.

exec sp_serveroption @server=’MYSQLSERVER′, @optname=’rpc’, @optvalue=’true’

exec sp_serveroption @server=’MYSQLSERVER′, @optname=’rpc out’, @optvalue=’true’

Below shows how to do this graphically , using SSMS – SQL Server Management Studio.

Capture_linked.

 

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.

Deprecated Database Features: SQL 2005 – SQL 2014 Links

Below are reference links to Microsoft documentation web pages listing deprecated database features from SQL 2005 to SQL 2014….  

2005   http://msdn.microsoft.com/en-us/library/ms143729(v=sql.90).aspx  

2008   http://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx  

2012  http://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx

2014   http://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx