“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 […]
Microsoft SQL Server 2016 – Basic Installation in picture steps. Note the differences from SQL 2012/2014 installation. Also, SSMS [SQL Server management studio] 2016 is a separate installation which you can download from here, Links Hardware and software requirements Installation of SQL 2016 SSMS 2016
Click here for a good guide on Microsoft R Getting Started Guide – R was introduced with Microsoft SQL Server 2016 Click here for the documentation link, by Josee Martens.
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 […]
Highlights and useful links. SQL Server 2016 SQL Server on Linux Microsoft Data management and analytics
Good read – SQL related articles, l will post more as l find them: The Top 4 Job Tasks DBAs Forget
Click here for a link to these set of excellent useful posters by Microsoft on SQL Server Database Engine Permission Posters
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 […]
PASS Summit 2015 is the world’s largest conference for SQL Server and BI professionals. Click here for registration information
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.