Reading Excel, a reader got Msg 15281: SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’. Enabling Ad Hoc Distributed Queries fixes it.
SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components
My SQL Server 2017 install got stuck at Offline Installation of Microsoft Machine Learning Server Components. Here is why it happens and how to move forward.
SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Uninstalling SQL Server from the command line, I got: The syntax of argument “/ACTION” is incorrect. Here is what the error means and how to fix the command.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
My machine crashed mid-install, and uninstalling SQL Server 2017 then failed with: Index was outside the bounds of the array. This is how I cleaned it up.
SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied
OPENROWSET on an Excel file gave: The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” reported an error. Access denied. Here is the fix.
SQL SERVER – Small Backup for Large Database
A client’s 900 GB database made a backup of under 300 MB, and they feared data was missing. Here is what explained the small backup for a large database.
How to Start Database in a Single User Mode? – Interview Question of the Week #202
How do you start a database in a single user mode when there is corruption? Here are simple steps in SQL Server Configuration Manager, one by one.