Microsoft SQL Server 2017 Web Edition & Reporting Services 2017 Developer Edition error
Dear Community, I've setup a Microsoft SQL Server 2017 Web Edition and downloaded afterwards the Reporting Services 2017, because its no longer included in SQL Installation directly. During the setup of the Reporting Service 2017 Installation I had to choose the Edition and my choice was also there "Developer Edition". Now when I try to configure the Reporting Service I run into the following error message: "The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services." I added a print screen with the details. Does someone knows something about this error under Microsoft SQL Server 2017? Looking forward to every useful hint or input. Thanks and kind regards, JoëlPerformance impact of memory grants on data loads into Columnstore tables
First published on MSDN on Jun 02, 2017 Reviewed by: Dimitri Furman, Sanjay Mishra, Mike Weiner, Arvind Shyamsundar, Kun Cheng, Suresh Kandoth, John HoangBackgroundSome of the best practices when bulk inserting into a clustered Columnstore table are: Specifying a batch size close to 1048576 rows, or at least greater than 102400 rows, so that they land into compressed row groups directly.Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems
First published on MSDN on Oct 19, 2017 Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Nellie Gustafsson, Umachandar Jayachandran, Dimitri Furman (Microsoft)This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions.Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB
First published on MSDN on Apr 21, 2017 Authored by Arvind Shyamsundar and Shreya Verma Reviewed by Dimitri Furman, Joe Sack, Sanjay Mishra, Denzil Ribeiro, Mike Weiner, Rajesh SetlemGraphs are a very common way to represent networks and relationships between objects.
Moving SQL Server 2017 from GDR Path to CU Path
Hello everyone, I have been scouring the internet and am not able to find the answer I need so I turn to you for assistance. Here is the situation, we have an AG set up on SQL Server 2017. Currently both of those servers are on patch 14.0.2052.1 or 5029375 Security update for SQL Server 2017 GDR: October 10, 2023. I would like to change us to be on at least CU 15 (yes I know CU 31 is the latest but the issue requiring this change is CU 15), but there is nothing I can find about how to change from the GDR Path to the CU Path. The only option I can see is to roll EVERYTHING back to the 2017 RTM, then apply CU 31. That isn't a great option as this is a 24/7 application. So, how in the world do you change from GDR to CU? Thanks in advance, Chap
Struggling with Rich Text Field
Hello Community, I have a SQL table which has a column containing rich text field tags. I am trying for 2 days now to get rid of the tags but nothing is working for me. <div class="ExternalClass00D082CB77D043AC975C783B3BC9B418">PR approval process complete, currently with procurement. EU to provide the Scope and SSJ. Else Procurement with reject the PR.</div> Below is how the text appears while in the actual website, the data appears like this: The removal process cannot be hard-coded because every record tags are different from another. For example see the below example: <div class="ExternalClass156752DF6D8A4BBF84D75235021E4A45">Demand status updated to Under Tech. Procurement - Pending PR Creation <div class="ExternalClass1A849FEC18A44CCE90E425ED0F54A1A2"><html> <p>One time Support Request.<br></p></html></div> </div> *I have attached the actual output of this from website If anyone can help me on how to clean the characters with a SQL function or maybe a C# code that will be very helpful. I have tried the below links and they do not solve my problem. https://www.codeproject.com/Tips/821281/Convert-RTF-to-Plain-Text-Revised-Again https://social.msdn.microsoft.com/Forums/en-US/143abeb5-f98a-4b47-a746-dd141bdd6df7/sql-query-to-retrieve-a-rich-text-memo-field?forum=sqlgetstarted Any help on this issue will be very much appreciated.
Access Request Sharepoint Site
Hi Experts, I am looking for a SharePoint functionality to implement in our reporting project. I have a SQL server database table which has City Hierarchy data. Now I want to build a Reports Access Site which should have the City arranged in hierarchical order (Country->Region->State->City).In order to view the data for respective cities, the user need to go to this site and create an access request by selecting the cities/state/region/country he needs access to and then submit for approval. This request should then go through various approval levels and then store this request along with approval details/status in another database table in SQL SERVER so that it can be used by system to provide access. Is this doable and if yes then is there any links/videos which can guide me on how to do it. Thanks NiviWCF Service Hosted In IIS Unable to Connect to SQL Server and display In SharePoint Online External
Hello , I have Hosted a WCF service in IIS and I am using SharePoint designer 2013 to connect to BCS of SharePoint online. I am able to create the external content type and external content list but when I access the external list I am getting the below error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I have given all the required permission in SQL server to make it accessible and have checked it its accessible I have hosted the same WCF service which is hosted in IIS in Azure App Service and its working fine and the data is getting pulled and being displayed in External list below is my web config of WCF Service Can you please help me Thank you Syed Shadab Mohammed
