Setup error 0x800F0831 broke an in-place upgrade from SQL Server 2014 to SQL Server 2016. It is the hex form of exit code -2146498511. The CBS log showed store corruption with a missing package, and installing that package fixed the upgrade.
How to Set ARITHABORT ON for .NET Applications
A query that runs fast in Management Studio and slow in a .NET application often runs under two different plans, because the two connections use different ARITHABORT settings. This post shows both plans in the plan cache, measures the cost, and explains how to set ARITHABORT ON for all connections through the server’s default connection options.
SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085
Clients sometimes send files made with Results To File in SSMS. Kevin shows how to convert standard SSMS file results to delimited data you can load.
SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080
In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.
Table-Valued Parameters: Sending Thousands of Rows in One Call
Send thousands of rows in one call with table-valued parameters, compare round trips, and handle missing column statistics accurately.
Parameter Types From .NET: Stopping Implicit Conversions at the Source
Match parameter types from .NET to SQL Server columns, avoid implicit conversions, and inspect cached plans for mismatched strings.