Close

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

SQL Server Fixed Server Role Permissions

SQL Server Fixed Server Role Permissions – run – sp_srvrolepermission ServerRole Permission bulkadmin Add member to bulkadmin bulkadmin BULK INSERT dbcreator Add member to dbcreator dbcreator ALTER DATABASE dbcreator CREATE DATABASE dbcreator DROP DATABASE dbcreator Extend database dbcreator RESTORE DATABASE dbcreator RESTORE LOG dbcreator sp_renamedb diskadmin Add member to diskadmin diskadmin DISK INIT diskadmin sp_addumpdevice […]

Read More

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