R Services and forecasting meet when a data scientist’s R script has to run next to the data. This guest post by Eduardo Castro shows how to enable external scripts, install packages and run a forecast with sp_execute_external_script.
SQL SERVER 2016 – InMemory OLTP LOB Datatype Enhancement
SQL Server 2016 brings InMemory OLTP LOB datatype support to memory-optimized tables and natively compiled procedures. Here is what I found exploring it.
SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion
SQL Server Agent would not start: the request failed or the service did not respond in a timely fashion. SQLAgent.OUT showed why. Here is the fix.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.
SQL SERVER – Unable to cast object of type ‘System.DBNull’ to type ‘System.String’. (Microsoft.SqlServer.Smo)
Creating a database in SSMS gave me ‘Unable to cast object of type System.DBNull to type System.String’. Here is how I tracked down the cause and fixed it.
SQL SERVER – Script level upgrade for database master failed because upgrade step sqlagent100_msdb_upgrade.sql encountered error
Another cause of ‘Script level upgrade for database master failed’, this time from sqlagent100_msdb_upgrade.sql, and how I fixed it for a client.
SQL SERVER – Error Fix: Msg 13601 Working with JSON Structure
Msg 13601 showed up while I was working with JSON output: a property cannot be generated due to a conflict with another column name. Here is the fix.