Facing issues for the mismatch definitions of some methods from SQLEditors.dll used in SSMS 21
I am trying to consume the SQLEditors.dll from SSMS 21 and SSMS20 in my C# code however getting the compilation issue due to incorrect format of library as error : D:\BuildAgentB\work\fb305f1670873990\VersionSpecific.CommonFiles\NewQueryWriter.cs(83,…
Wealth Snap Customer'S Care Number . 09172420532//9172420532 Call
Best way home from work tomorrow and see if I can get a package
On-prem MS SQL server 2016 migration to Azure SQL Server Managed database Instances path
Hi Team, We are currently planning to migrate our On-prem MS SQL Server 2016 to Azure SQL Server Managed Database Instances. The source will be our On-prem MS SQL Server 2016, and the target is the Azure SQL Server Managed Database Instances. I have a…
Retrieving Admin Credentials for SQL Server Database Backup
Connecting to a database from SQL Server Management Studio with normal authentication is not allowing backup operations. An ex-employee who was the admin did not provide any credentials. As a result, backup cannot be taken, and attempts to assign roles…
SQL Server timeout exception azure hyrbrid connection
We have web applications with Function apps, Web Apps and API management services. SQL database is located in an on-premise SQL database server. Function apps connect to the SQL database via an Azure Hybrid connection. Suddenly we received the following…
SQL Server timeout exception azure hyrbrid connection
We have a Web application with Azure functions, a web app and an API manager. SQL database is located on an on-premise SQL database server. Functions apps connecting on-premise database via Azure hybrid connection. Suddenly we got the following error…
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '<token-identified principal>'. The server is not currently configured to accept this token.'
Hi All, I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but…
How to Extend a drive on an Azure VM
Guys, we have a VM on azure that runs sql server. Recently I increased the disc size of F drive from 1TB to 2TB on the azure portal. When I went to extend the drive from Disc Managment tool - I get the message that says I will end up converting the disc…
Ensure that the server is running Period Analysis Services Processing
Hello, I have am getting below error while running a job.. I am able to connect the SSAS server with the jobowner, Source: Period Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End…
How to export data from SQL Server SSIS to Parquet file format and compress it using Snappy
the challenge is to export data from SQL Server SSIS to Parquet file format and compress it using Snappy. The expected list of tables to exported to Parquet file are 650.
Invalid output when trying to invoke stored-procedure returning output from entityframework core -
Hi gents, can you sort out the following for me. Let me explain the scenario in detail. I have a MSSQL stored procedure that returns me output value. The output value is of int type. Stored Procedure: CREATE procedure…
Connecting an On-Premises SQL Server Database with Azure OpenAI Services
Hello, We want to integrate our on-premises SQL Server database with Azure OpenAI services to enable a feature in our web application that allows querying the database using natural language (English). Could you please suggest any documentation or video…
Timeline for Release of NEXT GEN Feature for Managed Service in Azure
What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?
Must declare the scalar variable "@n"
Receive the above error generated by the code below. Dim objCommand As SqlCommand = New SqlCommand Dim Connection1 As New SqlConnection(ConnectionString) objCommand.CommandText = "UPDATE names " & "SET n.cc_date = @n.cc_date,…
How to Register 2 Iaas Sql Server Instances in an Always On Availability Group configuration to recovery services vault
I have 2 Azure VM's and installed SQL Server on both and create an Instance on in an Always On Availability Group. The 2 vm's are not clustered that it there is no WSFC so the failover process is a manual. I am configuring this Instance to backup to a…
Can I replicate a failover SQL cluster to Azure VMs?
I have a client who has 2 SQL Server VMs running as a failover cluster for SQL. We are looking for a way to continuously replicate this to Azure VMs. I read through this…
I have an application which sends table data from ibmias400 tables . How to collect messages and process it according to table names from messages and load it into delta parquet files/SQL tables and use it for reporting purposes?
I have an application which sends table data from ibmias400 tables . How to collect messages and process it according to table names from messages and load it into delta parquet files/SQL tables and use it for reporting purposes?
SSRS2022 Custom Header Problem
Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…