CLR – Check if enabled, enable it.. etc – SQL Server

“The common language runtime (CLR) integration feature is off by default, and must be enabled in order to use objects that are implemented using CLR integration. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure in SQL Server Management Studio:”  ….  Microsoft

Essential commands:

–check
SELECT * FROM sys.configurations
WHERE name = ‘clr enabled’

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
–enable it
sp_configure ‘clr enabled’, 1;
GO
RECONFIGURE;
GO

–disable it
sp_configure ‘clr enabled’, 0;
GO
RECONFIGURE;
GO

SELECT * FROM sys.configurations
WHERE name = ‘clr enabled’

Diskspd – SQLIO Replacement

Diskspd Utility application. This is a new robust storage Testing Tool (superseding SQLIO).
“”A feature-rich and versatile storage testing tool, Diskspd  combines robust and granular IO workload definition with flexible runtime and output options, creating an ideal tool for synthetic storage subsystem testing and validation.””

Click here for the download link.

Sample output from a run on a basic PC hard drive.

d3 d2 d1

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.