AlwaysON issue v2
Hello! There are two newly installed SQL Server 2022 Standard servers installed from the same ISO(say SQL1 and SQL2), OS = WinServer 2022 Standard (for both servers, same ISO), both added to the domain with the single domain controller named DC1. Here's…
Azure Resource Graph Explorer - Retrieving DTU Percentage
I am trying to use Azure Resource Graph Explorer to obtain a list of databases along with their DTU percentage. However, my query returns NULL for the DTU_percentage column. Is it possible to retrieve this information? Thanks in advance
SQL backup failing every night
Hello All, SQL backup is failing every night with different error. As i am new to DPM, Unfortunatelly i could not understand why it is failing. Could someone help me, how to fix it ? Error: The replica of SQL Server 2017 database…
AlwaysON issue
Hello! There are two newly installed SQL Server 2022 Standard Edition servers (say SQL1 and SQL2), both installed from the same iso, with the OS also installed from the same ISO (Windows Server 2022 Standard), both are member of the domain with the…
Transparent Data Encryption (TDE) on AlwaysON Availability Group
I’ve been tasked with securing SQL Server data and log files (MDF and LDF) using Transparent Data Encryption (TDE) across all SQL Servers in our environment, which consists of over 85 instances. This is a significant undertaking, and I’m concerned about…
Stack Dump on SQL Server
Hi expert, Stack dump has been generated as attached when failover AOG enforcement occurred... any suggestion to getting solution with this information? great appreciation for all reply regards, UrBel SQLDump0052.txt
Unable to install SQL server
Detail.txt Summary.txt I couldnt make out the log file, Could you help me figure out what i should do to install this server, I will try to install a 2019 server and try again, but any help is appriciated, Thanks
How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method, preferably using Python?
I am looking for a way to achieve this using Python. Please suggest any tools, libraries, or approaches that can facilitate this, such as using REST APIs or handling XMLA directly. A step-by-step explanation or references would be greatly appreciated.
Reading SQL Transaction log
Hi Expert, I've added new *LDF file, but I would like old *LDF can't be used anymore\inactive, so all transaction will be recorded into new *LDF i've just created... then, how to know transaction recorded into new *LDF? thanks for all respond great…
Unable to restore database in ssms
Getting below error while i am trying to restore a database in SSMS. TITLE: Microsoft SQL Server Management Studio An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ADDITIONAL…
i am getting this error
please give me some solution for SqlConnection, SqlCommand and Clear ()
Application getting logout frequently - ASP.NET session has expired or could not be found - Microsoft.ReportViewer.WebForms
Dear all, we are getting below error frequently from few days without any deployment on production environment, unable to find the solution. even after increasing session time out and tried various suggestions on internet still facing the same issue.…
Migrating Publication database in Transaction Replication to another server
Hi. We need to migrate Publication database (SQL 2017) in Transaction Replication from old server (windows 2016) to new server (windows 2019). Please let me know if below approach works. Setup log shopping to migrate Publisher database from old server…
Finding the Next Appointment Record
Hello everyone and thanks for the help in advance. I need to develop a report for a physician's office that tracks how many patients made follow up appointments after a first appointment. In other words, lets say a patient had an appointment today and…
Not able to connect to a database in SSMS 19.1
TITLE: Connect to Server Cannot connect to WTIN05700927L. ADDITIONAL INFORMATION: 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…
Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?
My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…
Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?
My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…
Database schema change of result in query sql server
How we can get database schema change result in query sql server? Is there any tool ? Suppose we do any change in schema. I want the result of that change in query.
How to fix an error System.TypeLoadException: in an swagger api project ?
System.TypeLoadException: Method 'get_LockReleaseBehavior' in type 'MySql.EntityFrameworkCore.Migrations.Internal.MySQLHistoryRepository' from assembly 'MySql.EntityFrameworkCore, Version=0.0.0.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' does…
Customized ODBC permission registry setting lost
Hi engineer, We find that this “Authenticated Users” setting in the ODBC.INI permission is lost We upgraded those PC OS to Windows 10 Prof 22H2 a few months ago. Do you know if OS upgrade to Windows 10 Prof 22H2 will reset ODBC this registry settings?