framework realated question
what is frame in framework for .net applicatons like .net framework 3.5 and what it indicates for frames
Could you please suggest the list of software needed to register and use a custom component in data tools tool box using VS2019 in x64
Issue Description: Facing issue in setting up and running SSIS in debug mode in VS2015 that can recognize 64-Bit C# custom components in Data Tools Tool box. Created MyCustomComponent.dll by referencing below dlls. Took the dlls from…
Execution Plan Parallel Deadlock Issue Persisting in SQL Server 2022
Hi Msft team! I hope this message finds you well. I am writing to report a persistent issue with execution plan parallel deadlocks that still exists in SQL Server 2022. Despite updates and patches, this bug appears to remain unresolved, and I have been…
How to install SQL Server but got an error message
I'm trying to install SQL server but I am getting an error message that SQL server cannot be found and I should try install again, may I get help with the error?
Regarding Compliance of SQL Developer
SQL Developer right now can be consider as free if not used as production environment. But there still something missing information, consider i read the EULA for how SQLDev work. (…
How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11
Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…
Deploying the tabular cube failed with a timerunot error
Hello everyone, I'm encountering an issue while deploying the cube. It's failing, as shown in the image below. Can anyone help me with this?
Request for high CPU machine with 48 and 96 GB RAM for production DB load on Linux
Our organization requires a high CPU machine with an AMD64 processor to install MSSQL on Ubuntu 20.04. We are considering two options, D48ls_v5 and D48pls_v5, and need to know if these machines use AMD64 and which one is the best fit. Any other…
query taking long time to match
Hi Team, how to split the query to check data missmatch fint.eabl column if there multiple left joint and taking time to match it query attachedcheck.txt
SSRS Report Viewer windows forms - The request failed with an empty response
Dear all, we use the following component in our Windows Form (.net 4.7.2 application): Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1620.0 Since we migrated our server on a new domain, we are getting sometimes the following execption in…
Question on DB_datawrite role
I need to make sure a user account is SQL can add & remove data in a table but not drop a table or DB. The db_datawriter role should do this correct?
extract centre Point from polygon
Hello I am trying to extract the x,y coordinates in british national grid (27700) for the centre of each polygon from the OS_NGD_LUS_FTS_SITE.SHAPE and export them as the fields x_coord and y_coord. My code is below, but not sure where to start so any…
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
Virtual Machine Windows Server 2019 Licensing / SQL Server Licensing
Greetings, I am trying to build a new infrastructure with 3 VMs for Application Server, SQL Server and a Test-Dev Server. In many discussions with different providers I did not get the answers that I really need. These 3 VMs must be licensed with Windows…
Exception problem
Hi, I've got issue due to this line below. reader = cmd.ExecuteReader(); Can it be owing to no record returned?
Licensing SQL server at a host level (2016 -2019)
Hello We have a 10 host on premise VMWare cluster, mostly running Windows VMs. We are looking to license all our SQL virtual machines (versions 2016 through to 2019) using the core based model and would like to license at the physical host level. My…
Switching from SQL Server/CAL based licensing to core based licensing model for all SQL servers
We are using Server+CAL licensing model for all SQL servers in our organization. Due to the limitation of number of cores supported by CAL based license, we are planning to switch to core based license. Upon checking with client, he informed, "Under…
"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition
Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…
sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled
I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…
Hi , I have created one Azure SQL database with Basic pricing tier. I am not able to take it offline or pause the database.
when i go to Settings -> Properties, I can see an option Status ->online for that database but I can not change it to Offline/Pause. Please help since this effect my billing.