Content
C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230921_143255
SQLServer_ERRORLOG_2023-09-21T14.35.02.txt SQLServer_ERRORLOG_2023-09-21T14.35.00.txt SQLServer_ERRORLOG_2023-09-21T14.35.02.txt

SQL : Send email via DB mail based on the row count mismatch.
Hi All - I have written a stored procedure and it sends out an email to users in the below format. Its basically the row count between three systems ( Oracle, STAGE, SDS). Currently, the email is sent every hour, but the user wants to get an email only…
Delete Ploybase dump files in SQL Server2019, is it affect Database or performance of sever
Hi Team, We have a Server 2019, includes SQL Server 2019 with 4 instances, in one instance C:\Program Files\Microsoft SQL Server\MSSQL15.SGSFAROOJ\MSSQL\Log\Polybase\dump have 500GB size. We are not using Polybase services. So if we delete those logs,…
Can we refresh/overwrite SQL Server Reporting databases.
Can we refresh SQL Server Reporting databases. We are in the process of the migration of reports from SQLServer 2016 to SQLServer 2019. Week back we copied the reporting databases to another server and configured the reporting services then released for…
Create assembly in SQL Server from C# dll
I write c# code with these references: using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Net; I build this in a dll file that I want to use to create a assembly in sql…
Deploy an asp.net core API on a Linux server with nginx
hi I followed your tutorial on deploying an asp.net core API and I followed the same logic to deploy my API on an ubuntu server with Nginx, it happens that locally I access the API from the development environment, and even from another machine on the…
left join to insert
hello, I would like to return all rows from "Logins" which are not present in "tbl_LoginIdCount" It's just that I run this once and insert into compute."tbl_LoginIdCount" but then when I run the same query again the select…
How to read SQL Trace(.trc) or Extended events file(.xel) for SQL server 2022 in c#.net
Hi Team, We need a help on parsing the data from SQL trace file(.trc) or Extended Events file (.xel) in C# application. Required for SQL server 2017 to SQL 2022 Could you please guide us how to do that? Regards, Deepak Rane

Private endpoint as cloud witness for clustering supported ?
Windows cluster in Azure , two VMS ( for now ) Storage account standard gen 2 with min TLS 1.0 ( just in case ) and network access cut ( only to be done via PE) Private endpoint lies in a nearby subnet of the source, auto approved, dns registered.…
How can I create a Complex View Like this one in WPF DataGridView C#?
I created this Example and Tried to make it as Simple as Possible so that you can Understand Clearly. I have SQL Server Database Named EmployeesDB that contains 4 Tables as following: 1. Employees Table which is the Parent Table in this Example. 2.…
How to fix "Unable to install SQL Server (setup.exe) Exit Code (Decimal): -2061893607Error description: Could not find the Database Engine startup handle."
Hi, I keep getting this problem when trying to install the SQL Server (Express Edition) through basic installation. Here are the Summary.txt and Detail.txt. Really need to get this fixed as soon as possible, I appreciate any help.
Unpivot result with null value
Referring to this post: pivot/unpivot my table. create table TableA( ECODE char(2) NULL, MEM1 int NULL, MEM2 int NULL, MEM3 int NULL); insert into TableA values ('AA',6234,null,2354), ('BB',null,3568,4564), ('CC',1023,3941,null); Suppose I want…
Power BI Report Server MSSQL server collation
What is the required MSSQL server collation for Power BI Report Server or SSRS?
Upgrade sql server 2012 Business Intelligence to SQL 2016
Hi All, We have SQL 2012 Business Intelligence instance and we are trying to upgrade SQL 2016 Enterprise as one of below link says suitable for as…
Differences Between CDC, Trigger, and Transaction Log Replication
Differences Between CDC, Trigger, and Transaction Log Replication Hello. While operating SQL SERVER, I'm currently researching CDC, Trigger, and Transaction Log Replication for data synchronization. All three methods are used for data synchronization,…
How to fix data convertion error from string value to int in ssis
Currently, I am working on a task where I am using the "SSIS Integration Toolkit for Microsoft Dynamics 365" to fetch data from online dynamic CRM source and populate this to on prem CRM database(just a copy activity). I am using dynamic crm…
After upgrading SQL Server and Reporting Services to 2019 the report viewer no longer displays on the web pages.
Morning After upgrading SQL Server and Reporting Services to 2019 the report viewer no longer displays on the web pages. It appears as thought the web pages no longer recognise the report viewer control. I have removed references to the old report…
How to upgrade sql server 2012 express edition to sql server 2017 standard edition
I order a sql server 2022 standard edition license. The license key should suppose to be used in sql server 2017 standard edition. I already have a sql server 2012sp4 express edition system. During upgrade from sql server 2012sp4 express edition to sql…
Why does connection to local server take so long?
When I use SSMS and bcp tool, if I want to connect to a network SQL Server, I can connect really fast. It doesn't matter if its windows auth or SQL Server auth. It all works really well. But when my server = (localdb)\MSSQLLocalDb and Windows auth, it…

For Database scenarios showing “Out of Memory” exception how to fix in sql server step by step? memory space also available
For Database scenarios showing “Out of Memory” exception how to fix in sql server step by step? memory space also available.
