SQL Server 2017

This post explains you the latest features of SQL Server 2017.

Features,
1. Machine Learning - In Database
            a. R
            b. Python
2. Machine Learning - Standalone Server
3. Standalone Reporting Server

Check the other features in below video.


Comments

Post a Comment

Popular posts from this blog

Error Rule Same Architecture Installation Failed

I got the error message saying that “Rule Same architecture installation failed” while installing business intelligence tools for visual studio 2012. Then after few minutes of surfing I found the solution in online. The root cause of this error is, you probably selected add additional features to the existing instance. You need to change to new installation and do the installation steps and this time you won’t get any error.
Read more

SSIS BULK INSERT–“fetch a row from OLE DB provider "BULK"…”

Image
I created a simple SSIS Package using “Bulk Insert Task”, here am trying to upload the data from text file into my database. I have configured everything and ready to go, while execute the package, the error was thrown “[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information”. Then i checked the column delimiter and fixed the issue, If you are using comma separated value then use “Comma {,}” as column delimiter.
Read more

SSRS–Maximum request length exceeded

Image
My friend had an issue in deploying the report to report server. It is a dashboard so it has colourful charts and many thing. The size of the report is around 4 MB. When he deploy the report he got an error message “There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded." When we work around, we found that the default size of the file to upload is less, we need to increase the size manually in web xml config file. To find the web xml config file, go to C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer Open the Web file and add maxRequestLength="2097151" as below, then close the solution and open. Now deployed the report.
Read more