Configuring the database

During the postinstallation process, database configuration will be the next task. Think about database collation, because the R language is case-sensitive, and it matters what kind of data you will be feeding to SQL Server engine and pushing onward to Launchpad.Some languages differentiate the small from capital caps (for example, the Turkish language; the letter L in particular) and this might be an additional challenge when pairing SQL Server and R data types. In addition, based on your ecosystem, authentication should also play an important role in setting up the environment.

With real-time data scoring available with SQL Server 2016 and improved in SQL Server 2017, it is worth giving it a try. Also, for any extended use of Machine Learning Services, file database might be a very useful and powerful way to store graphs and results for later analysis, or results that can be exposed to Power BI, SSRS, or external applications. If you have a filestream included for tackling unstructured data in your business, this is also another service where the database configuration needs additional attention.