Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,396 questions
1 answer
Best Practice For Database Access In Blazor MAUI Hybrid App
I'm porting a project from MVC into a Blazor MAUI Hybrid app with the intent to share common components and data. I have a Razor Class Library which does this, but was wondering if I should also put my SQL Server data access in here as well or keep that…
asked 2024-04-30T17:24:11.6166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 68%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Daniel Kovach
0
Reputation points
answered 2024-04-30T18:30:11.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
56,686
Reputation points
1 answer
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…
asked 2024-04-25T08:00:03.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Milan
61
Reputation points
commented 2024-04-30T17:39:42.87+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
23,496
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
Opening sql files opens new instance of SSMS 18.
Hi, I installed SSMS 18.7.1 in my new laptop and every time I open a new .sql file via double click on it, it opens a new SSMS instance. Its very frustrating. I have repaired SSMS and tried to reinstall again but nothing helped! But if someone had…
asked 2020-12-08T10:06:35.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vishal Mittal
36
Reputation points
commented 2024-04-30T13:52:43.05+00:00
Marc Scirri
21
Reputation points
4 answers
Will I need to purchase an additional SQL license after performing a Datto bare metal restore ?
Will the restored backup use the SQL license I've already purchased? Thanks for any help you can give!!
asked 2022-08-08T14:52:13.437+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 80%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ryan Menard
1
Reputation point
commented 2024-04-30T10:57:41.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 16%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Hitalkumar Chheda
0
Reputation points
1 answer
SSIS task through SQL Agent showing OLEDB 16.0 not registered after install
Hi all, we're currently having issues trying to have a job run on a schedule via SQL Agent using the OLEDB 16.0 64-bit connector using an excel file. The job runs fine locally in Visual Studio, where I have the 64-bit OLEDB 16.0 installed. However when…
asked 2024-04-30T09:09:43.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
20
Reputation points
commented 2024-04-30T09:41:46.65+00:00
Thomas Davies
20
Reputation points
1 answer
SCOM 2022 upgrade issue with SQL broker
We recently upgraded from SCOM 2019 to SCOM 2022 (clean install on new servers) and now SQL broker appears to have stopped working. Following Microsoft's suggestion, I tried rebuilding it, but SQL Profiler still shows no conversation. Health reset…
asked 2024-04-29T12:02:47.7066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 99%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Filla Rulf
0
Reputation points
answered 2024-04-30T08:38:16.5266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
XinGuo-MSFT
14,536
Reputation points
2 answers
One of the answers was accepted by the question author.
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies
20
Reputation points
commented 2024-04-30T08:34:46.6166667+00:00
Thomas Davies
20
Reputation points
1 answer
How to create a baseline using counters to analyze server performance?
I am currently working on creating a baseline for our server, using various counters to analyze performance. The server exclusively hosts SQL Server. Could anyone here share their experiences or methodologies on how to create such a baseline and use it…
asked 2024-04-29T11:16:26.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 67%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
test code
1
Reputation point
answered 2024-04-30T08:30:07.53+00:00
MikeyQiao-MSFT
560
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
SQL SERVER IMPORT AND EXPORT WIZARD
I clicked on the next button to import my data from excel and it brings me this error message; TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not…
asked 2024-04-24T13:50:36.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mariam Wasiu
20
Reputation points
commented 2024-04-30T07:27:50.48+00:00
Mariam Wasiu
20
Reputation points
1 answer
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
asked 2024-04-25T17:10:02.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Juwairiyyah Ahmed
0
Reputation points
commented 2024-04-30T05:41:46.11+00:00
LucyChen-MSFT
1,045
Reputation points Microsoft Vendor
3 answers
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…
asked 2024-04-25T18:11:39.8466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 57.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP8%3C/text%3E%3C/svg%3E)
Pepe-8078
0
Reputation points
commented 2024-04-30T05:41:02.4333333+00:00
LucyChen-MSFT
1,045
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
how to fix oops unable to install sql
i keep receiving this popup each time i try to install sql.
asked 2024-04-29T16:45:15.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 5%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Raphael Legbedze
20
Reputation points
answered 2024-04-29T21:13:01.19+00:00
Erland Sommarskog
101.4K
Reputation points MVP
1 answer
External tables: Why create statistics?
The documentation for Polybase says that creating statistics for External Tables will help getting better execution plans. This question is about when the External Data source is another SQL Server. I guess the better execution plan is on the…
asked 2022-08-23T08:57:26.147+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 44%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Anuw Malik
1
Reputation point
commented 2024-04-29T18:54:29.4166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 4%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mihaela
1
Reputation point
3 answers
SSIS Unexpected Termination While running a packages through SQL Job
Hi Everyone, support required for the below error My SSIS package execution failed with unexpected termination while running through SQL jobs. Package Purpose: To Load multiple .xlsx files to SQL tables using Foreach Loop Container. Sometime job gets…
asked 2024-03-21T16:09:58.2766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 64%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Raj Kumar A
6
Reputation points
edited an answer 2024-04-29T18:10:11.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESO%3C/text%3E%3C/svg%3E)
Ssis operator
0
Reputation points
0 answers
How do I upgrade SQL server from 2016 to 2019
The current version is showing as SQL server 13.0.5893.48 after I thought I had upgraded it to 2019.
asked 2024-04-29T12:54:12.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 6%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Billy Barber
0
Reputation points
commented 2024-04-29T17:56:55.8166667+00:00
Billy Barber
0
Reputation points
3 answers
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.…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 84%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
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:
asked 2024-04-26T14:24:11.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 35%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Erik Schlorholtz
20
Reputation points
accepted 2024-04-29T14:20:45.9633333+00:00
Erik Schlorholtz
20
Reputation points
1 answer
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…
4 answers
One of the answers was accepted by the question author.
SQL Authentication
when logging into sql manangement studio via windows authentication, i used to be able to drop down to select the server i wanted to log into. Now, it only saves the last one i logged into, with no option to see the others i logged into previously. It…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
1 answer
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 69%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)