Browser for SQL Server 2017 and 2019
Hello, my question is the following. Despite having the latest updates released for SQL Server 2019 and 2017, I notice that SQL Server Browser does not change versions, remaining in the versions mentioned below. I would like to know if they are in fact the latest versions of SQL Server Browser released in the 2017 and 2019 packages. If the versions below are correct, if they really have not been updated. Browser for SQL Server 2017 14.0.1000.169 Browser for SQL Server 2019 15.0.2000.5
SQL Server audit logs incorrect info on column object_name
Hi, during an audit check on database events, i have noticed that sometimes on DDL events, when temp tables are mentioned, sql server 2017 logs incorrect information on columns schema_name and object_name and the statement column proves this: Moreover, on the two columns the info for the object on which the DDL was applied, is taken randomly, it may show the first table, or the second, making this difficult to prove the actions in case of audits: Sadly, i haven't found this reported anywhere..
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, ChapUsing 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.Performance 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.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.WCF 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
