How does one go about buying a SQL license?
I know this sounds like it should be simple, but it's not. The marketplace goes nowhere, call MS, they don't call back. I assume I need to find a licensed partner, but that is also no response. Can anybody point me to somebody that I can give money to…
SQL Server | Other
I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?
I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?
SQL Server | Other
A Scalar UDF works consistently in SQL Server 2017, fails sporadically under 2019 and 2022.
You can try this at home! I use this udf to capture the number of cores available when my stored procedure runs in cloud. But, since I develop against my local on-prem database, I coded it to return a -1 when it's not running in the cloud. Here's the…
SQL Server | SQL Server Transact-SQL
SQL Server Developer Edition Installer can't identify an installed software it needs.
Hi! I'm having a problem installing Microsoft SQL Server Developer Edition. It says that a certain software is not installed, although it is indeed installed. Any idea how can I solve this issue? The following lines are copied from Details.txt…
SQL Server Database Engine
SSIS Data Flow has trouble when it has to return many fields
I have an SSIS project that calls stored procedures to create extract files via OLE DB Source & Flat File Destination. The stored procedure returns 150 fields and sometimes a few million records. This causes SSIS & Visual Studio 2019 to take a…
SQL Server Integration Services
how to resolve degraded sql performance since upgrading from sql 2016 to sql 2022
We have a sql instance ( on premise) that was running sql 2016. Query store was not enabled. We have a large workload that runs overnight, hundreds of stored procedures. We have upgraded to sql 2022, but had an approximately 10% increase of the duration…
SQL Server Database Engine
RedHat Linux 9.7 SQL Server 2025 CU2 Fails to write database backup to Linux NFS Share
Hello, I have a VMWare VM running RedHat Linux 9.7 and SQL Server 2022 CU 23. SQL Server 2022 can successfully write database backups and the mssql agent job text log file to the Linux NFS share. I successfully upgraded the VM to SQL Server 2025 CU2.…
SQL Server Database Engine
SQL Server 2025 Standard License
I have downloaded SQL server 2025 Standard iso from volume licensing portal and when trying to install it gives predefined license key in the setup but we also have key available in licensing portal which is different than the one embedded in the setup…
SQL Server | Other
STIntersection() hangs forever
Hello, when I execute this STIntersection() query for two valid polygons (in this case CurvePolygons), it will run forever and will cause (very) high CPU usage! The problem exists at least from SQL2016 to SQL2025 (with latest updates installed). See…
SQL Server Database Engine
ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering
We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…
SQL Server Reporting Services
How to Suppress Microsoft Sign-In Dialog in SSMS 22 for Automated Testing?
We are running automated UI tests against SSMS 22 inside a Vagrant-based VM environment. When SSMS launches, it consistently shows the Microsoft account sign-in dialog (the Visual Studio–style “Sign in to your account” window). This dialog blocks our…
SQL Server | Other
Problem with SQL server login
Screenshot 2026-02-14 120506 I am trying to connect to a local SQL Server instance (localhost;AdventureWorksDW2020) via Power BI Desktop and I am getting this specific error message ("We couldn't authenticate with the credentials provided. Please…
SQL Server | Other
License SQL Server Developer
Can I use SQL Server Developer license in a server for only tests and development?
SQL Server Database Engine
Database is disappearing
Every time I create a table, it stays for a while (as long as 24 hrs), and I see it gets dropped. I get resource not available. Why am I losing the database?
SQL Server Database Engine
TITLE: Error ------------------------------ 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 instance name is correct and that SQL Server
TITLE: Error 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 instance name is correct and that SQL Server is configured to allow remote…
SQL Server | Other
CDC change Data Capture on High availibility AlwaysOn 2019
Hello, I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…
SQL Server Database Engine
SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005)
SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005) We have an SSIS package that reads data from a file on a network share (UNC path). For example, the file is located at \\EXAMPLE_DOMAIN\SharedFolder\file.csv (domain…
SQL Server Integration Services
How to delete an orphan user from On premise Powerbi report server Site Setting using Powershell Script
In the On-Premise Power BI Report Server setup one user has been migrated from Corp to AHM domain. But in the On-Premise Power BI Report Server Site settings his username can be seen as Content Manager. Since the powerbi is not able to verify the old…
SQL Server Reporting Services
SQL Data Migration Assistant
Hi all, why DMA V5.8 tools has no choice for target Platform SQL server On Prem, only SQL Azure to select.. what's your solution for SQL Server On Prem Paltform? thanks for all reply regards, UrBel
SQL Server Migration Assistant
Migrating Large Size scale Database
Hi all, what is alternative method to migrating side by side large size Database thanks for all reply regards, Urbel