Question: How to Shrink All the Log Files for SQL Server? Here is the script, plus why you should shrink only log files and never data files.
Msg 15281: Ad Hoc Distributed Queries Blocked in SQL Server
Msg 15281 appears when OPENROWSET or OPENDATASOURCE runs while Ad Hoc Distributed Queries is turned off. A reader hit it while reading an Excel file. Two sp_configure calls turned the component on, and the query worked.
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.