Close

General

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

SQL Server Replication Options

Common configuration notes/options. ============================== Snapshot publication: The Publisher sends a snapshot of the published data to Subscribers at scheduled intervals. Transactional publication: The Publisher streams transactions to the Subscribers after they receive an initial snapshot of the published data. Transactional publication with updatable subscriptions: The Publisher streams transactions to SQL Server Subscribers after they receive […]

Read More

SQL Server Reporting Services [SSRS] 2008 Problem: Maximum request length exceeded

SQL Server Reporting Services [SSRS] 2008 Problem: Maximum request length exceeded Error l get: ErrorĀ  : There was an exception running the extensions specified in the config file. —> Maximum request length exceeded. Click on image below for larger version. Solution: Edit the file web.config, found in: C$Program FilesMicrosoft SQL ServerMSRS10_50.RPTReporting ServicesReportServer Change line: <httpRuntime […]

Read More