How to verify if a backup "*.bak" is encrypted?
Is there a way to verify if the sql server backup file is encrypted or not? I have a script to turn off encryption before backup; however, I like to verify the backup file *.bak is in fact NOT encrypted before I send out to vendor.
Problem with FINDSTRING in SSIS Expression
Best regards. I have a problem when I am trying to use the FINDSTRING function in SSIS of Visual Studio 2022. It gives me the following error, even when I try to use the reference examples from the Microsoft page…
Unable to add a index hint to a simple query
I have a table with milions of records CREATE TABLE documents ( id bigint primary key, external_system nvarchar(50), external_docid nvarchar(50)) and non clustered filtered unique index CREATE UNIQUE INDEX documents_ix19 ON…
How to fix NT AUTHORITY\ANONYMOUS LOGON login failure during MS SQL Server installation
Hi - I'm trying to install MS SQL Server on Microsoft Windows Server 2022 Standard 10.0.20348 Build 20348. I've tried installing both MS SQL Server 2019 and 2022. The installation fails with: Detailed results: Feature: Database…
Is there any way to connect Hadoop to SSMS other than ODBC Driver.
We have jobs in SSMS. We are experiencing ODBC Error constantly when the job fails. but we could see other job which are running with same ODBC Driver its succeeding. To avoid this issue, we want to know is there any other way that we can connect Hadoop…
How do I transfer an on-premises license from one corporate user to another?
I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?
Using SSDT on a build server
I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…
Error creating SQL user accounts from external provider with Azure Arc
When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?
SQL connection to server error
After i installed Microsoft SQL server i face this problem while trying to connect 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…
Unable to install Microsoft SQL server 2022
Hi, Recently, I was trying to install Microsoft SQL Server, but the installation stops and this problem appeared I found a summery.txt file in this direction [C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log] and that's what was on it: …
Scripting out 'Create Merge Replication' does not include 'processing_order'
We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. When we want to setup or refresh a test environment, we will script out the 'Create Replication' script from our production environment, such…
Named Pipes Provider: Could not open a connection to SQL Server
Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja
Connect to Linked Server Database using Azure Data Factory
Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?
SQL Licensing for SQL Always ON Availability group
Hello Guys, I need to understand how many licenses i need to buy for SQL always on availability group, below is my requirement. As per my understanding only active cores should be licensed SQL always on cluster Primary site: Server 1 : Active copy …
sql query where with condition
Hi, I have a query same but only one of the where clauses differ. If (@accountID = 100) Begin select field1, field2 FROM table1 left outer join table 2 where status = 'x' and ISNULL(accountid, @accountID) = @accountID END Else select field1,…
how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process
We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…
How to set title of pdf in report builder
We have an issue with PDF files generated by SSRS for reports created in Report Builder. The files have weird looking names/titles when opened with the built-in PDF viewer in Chrome etc. Some searching returned a thread saying that Chrome displays the…
tại sao khi kết nối với máy chủ SQL 2022 Azure lại không có Restore Database
Khi tôi cài đặt Azure Data Studio kết nối với SQL bản 2022 và muốn restore advanturework 2022 để thực hành thì không có mục Restore dữ liệu khi nhấn chuột phải vào Database mà chỉ có mục Filter và Refesh. Làm thế nào để sửa lỗi này?
Tablediff using -strict option complains about different schema. But when scripting the schema's and doing a file compare it's equal.
Dear, When using tablediff -strict mode, I encounter a strange to me situation. When generating the export like this for the duplicate table: $TableExportoptions = New-DbaScriptingOption $TableExportoptions.ClusteredIndexes =…
SSIS Data Flow Task error - The version of the Flat File destination is not compatible with this version of the dataflow.
I am trying to edit an SSIS package and getting the error "The version of the Flat File destination is not compatible with this version of the dataflow." when trying to run it from a SQL Agent Job or when performing a validation on the SSIS…