Sys. center DPM 2019 ID 104 Details: Windows cannot verify the digital signature for this file
Hello everyone, who has encountered this problem Everything was working fine until now Recovery point creation jobs for SQL Server 2008 database have been failing. The number of failed recovery point creation jobs = 1. If the data source protected has…
How can not find a record of my Microsoft certifications in learning
I earned my MCP in 2004 and MCTS in 2012. How am I able to see these certifications? My employer is requesting I 'connect' these certifications with their system and I do not see the certifications listed in my Microsoft account. This has been most…
![](https://techprofile.blob.core.windows.net/images/rnwqhQqer0-oefliFOISMA.png?8DC41C)
Resource Governor questions.
https://www.sqlshack.com/sql-server-2014-resource-governor/ Greetings. I'm using the link above to configure Resource Governor. I run some queries to max out the RAM usage but my PerfMon counters dont elevate the way theirs do. I can see RAM usage…
Server is detected with Weak SSL/TLS Key Exchange on Port 1433 which is used by application SQLSRVR.EXE
The server is detected with Weak SSL/TLS Key Exchange on Port 1433 which is used by application SQLSRVR.EXE This is with reference to the compliance request – 198121 regarding the Vulnerability 38863 - Weak SSL/TLS Key Exchange. Qualys is detecting…
Custom Job schedule - every first Friday after 15 of the month - is it possible?
Good morning, Is it possible to create a job that runs only on first Friday after 15th of each month? I'm trying the following but the option seems to imply it would run every 15th month, not on the first Friday after day 15th:
Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
How to install ms sql server on Windows 11 arm?
Hi all, I have a macbook so I installed Parallels and Windows 11 pro (arm). But I have a problem to install MS SQL Server on it. It seems to be imposible. Can you help me with this? Thanks a lot.
How to fix The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.
I am new to SQL and was trying to copy a database for a project. However, the commands didn't execute accounting to the error 'The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.' How do I…
DPM 2022 installation: "SQL Server Management Tools not installed on this machine" error during install
Hy! I am deploying a DPM 2022 evironment. A have a separate SQL server and a DPM server. The SQL server has SSMS 19.0.1 (latest). I have installed this SSMS version on DPM server before install the DPM 2022. THE DPM installation show the following error…
Database access in Microsoft SQL Server
I am using HAS_DBACCESS function to check if user has access to the database present in sys.databases. Customer is claiming that they have given access to all the database present in server but while check it using HAS_DBACCESS it is returning 0 (zero)…
SQL Server installation error.
When im trying to install SQL Server 2022 (developer 16.x) error occurs related to setup.exe I already tried to disable UAC, Windows Firewall and defender, fully uninstall SQL Server, clean registry and reinstall but got the same error. When im trying…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Error while trying to update Always Encrypted column using a stored procedure
In our development environment, one dedicated machine is set as SQL Server Database server. All other development machines are connected to this server as clients using SQL Server Management Studio. Facing some issues after implementing "Always…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
After migrating to Windows 11 - Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied)
I just moved to a Windows 11 PC and now when using SSMS and I try to do a Bulk Insert into a SQL 2017 database, I get this error. Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied) I can do the same…
How to Retrieve SQL Server Instance Details from SQL IaaS Agent Extension Using Azure CLI
Hello Azure Community, I am working with SQL Virtual Machines in Azure and using the SQL Server IaaS Agent Extension to manage my SQL Server instances. In the Azure portal, under the "SQL Virtual Machine" service, I can view detailed SQL Server…
Bacpac file won't restore due to columnstore indexes on columns with specific data types.
Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…
SQL Server 2022 - Launchpad - how to eliminate errors in the logs "Failed to delete directory..."
Hi, I'm unable to find a solution to this anywhere and I'm desperate. Perhaps someone faced a similar issue and managed to find a solution. I'm running out of hairs on my head to pull them out. I got installed SQL Server 2022 with latest CU on Windows…
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
What logs does a full database backup contain?
When restoring a full database backup, restore can use the no_log parameter to not restore logs (although this parameter is officially disabled), and then rebuild the ldf by replacing the mdf with a new library. This can avoid the excessive time required…
Query stuck with HTDELETE for hours eventually timing out
We have an Azure SQL Database to manage our Customer data. I have a reasonably complicated query that has been getting stuck with an HTDELETE wait. Most recently it timed out after 4 hours. This was in our QA environment. The same query finishes in less…
![](https://techprofile.blob.core.windows.net/images/Lv74wIBLAQAAAAAAAAAAAA.png?8D8BCF)
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)