Close

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 […]

Read More

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 […]

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