Microsoft OLE DB Driver for Sql Server 18.7.2 x86 installer fails with unsupported operating system error on Windows 10
x64 works, but x86 gives me this message on multiple Windows 10 computers:
Preview Error Adding Extension Assembly to SSRS RDL Report in VS2022
I am using Visual Studio 2022 with the Microsoft Reporting Services Projects extension. I've created a Reporting Services project and added a simple report. In this report, I included a textbox with the expression =User!Language and successfully…
Powershell from SSIS - Empty environment variable
I'm running a script in an SSIS package and I specify an account to run the package in SQL Server Agent. When it runs, I am unable to get the value of $ENV:LOCALAPPDATA Here's my code along with writing out the LOCALAPPDATA value Start-Transcript…
Log Shipping on SQL Server 2019 on Linux
I am attempting to set up log shipping in docker containers. I was able to set up the samba share and get everything setup and jobs deployed to both primary and secondary servers where the logs will be shipped. I think I have narrowed down the issue to…
How to fix XamlReader.RewrapException(ex, xamlLineInfo, baseUri);
Here is the error System.Windows.Markup.XamlParseException: "'The invocation of the constructor on type 'DentistryOOP.View.MainWindow' that matches the specified binding constraints threw an exception.' Line number '6' and line position…
How to contact Microsoft for technical support
We are running 2017 SQL enterprise and standard version. How to contact Micrsoft for technical support?
Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server
In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…
Does PolyBase support JOIN PUSHDOWN to Oracle Data Source
From my testing PolyBase on SQL 2019 does not push JOIN to the data source, even though the data source is setup with PUSH DOWN on. The documentation it states JOINS can be pushed down to…
Locking comparison SQL Server 2017 versus SQL Server 2022
We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…
Azure Data Share to Share data from Azure Managed Instance SQL Server
As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server. I need to share the source data which is in Azure MI SQL Server…
MSSql 2k16 cannot switch version
running an express edition of 2k16, that reached file size limit, on a w10/64 OS. All OS updates done. SMSS v 20.1 Purchased serial with 20 cals. Started the "2k16 install center" --> Maintenance --> Edition upgrade type in the serial.…
How to fix Database Engine Services Failure during SQL server 2022 installation
I was trying to install SQL Server 2022 on my windows virtual machine and got the following error: Unable to install SQL Server(setup.exe) I have attached the summary file too.Summary.txt
How to enable support for Unicode characters with command prompt
Hello Microsoft Support, We are facing an issue when using bcp.exe command on Windows server to bulk load data to SQL Server. The BCP command is not working when the file name contains non-english characters. We wanted to enable Unicode support for…
How to fix XamlReader.RewrapException(ex, xamlLineInfo, baseUri);
System.Windows.Markup.XamlParseException: "'The invocation of the constructor on type 'DentistryOOP.View.MainWindow' that matches the specified binding constraints threw an exception.' Line number '6' and line position '9'."
Access Blob Storage from Azure SQL Server using a Managed Identity
Greetings, As the title suggests I am trying to bulk insert data from a file in Blob Storage in an Azure SQL database using an external data source with a credential using a managed identity. However the bulk insert fails saying the sql server doesn't…
SQL Server Express 2022 Reinstall
Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL…
Issue with Bulk import using BCP with data file name consisting non-English character
I attempted to bulk import data using BCP from a file with non-English characters in its name. Both files were accessible, yet the import failed. Renaming the file to "order.txt" and "order.txt.format" resolved the issue, allowing…
Convert xlsx files to csv via automated script?
Hello, we have .xlsx files (not xls) and would like to convert them into csv files (so we can import into SQL Server) via some type of automated script to avoid manually doing each day. (Tried different methods via Import Wizard and OPENROWSET and got…
How to handle Azure SQL Virtual Machine discovery and cost together with Azure DevOps Server?
Hello, I am looking for answers for the scenario when we install Azure DevOps Server on Azure Virtual Machine. In this scenario we have VS Enterprise licenses so we have Azure DevOps Server license with SQL Standard license covered. However Azure came…
Tail log backup
Are tail log backups supported only in Full Recovery model?