The error which we observed was a failure of a rule – Patch Install Rule Error – Not clustered or the cluster service is up and online.
SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511
The solution of error Microsoft .NET Framework 4.0 installation has failed with exit code -2146498511 which was faced during SQL Server upgrade
SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications
SQL Server expert Tim Cartwright shares a way to set ARITHABORT ON for all connecting .Net applications, so they avoid the bad plans ARITHABORT OFF can cause.
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.