How to Fix SQL Server Data Tools (SSDT) 2017 Installation Error - Setup Failed: Incorrect function (0x80070001) October 4, 2021 4 min read Continue reading
SQL Server - User Can Only Connect with Sysadmin Permission: Login Failed for User, Reason: Login-Based Server Access Validation Failed with an Infrastructure Error February 5, 2020 2 min read Continue reading
SQL Server Configuration Manager Disappeared - How to Restore the Shortcut December 23, 2019 1 min read Continue reading
SQL Server - String or Binary Data Would Be Truncated: What It Is, How to Identify the Root Cause and How to Fix It December 3, 2019 8 min read Continue reading
SQL Server - Statements Could Not Be Prepared: Case Expressions May Only Be Nested to Level 10 July 6, 2019 2 min read Continue reading
SQL Server - The Activated Proc dbo.sp_syspolicy_events_reader Running on Queue msdb.dbo.syspolicy_event_queue December 9, 2018 4 min read Continue reading
SQL Server + AD Authentication - Kerberos + NTLM = Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' December 1, 2018 4 min read Continue reading
SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters May 2, 2018 3 min read Continue reading
SQL Server - How to create error and exception monitoring in your database using Extended Events (XE) October 15, 2017 9 min read Continue reading
SQL Server - Msg 443: Invalid Use of a Side-Effecting Operator RAND Within a Function December 26, 2016 3 min read Continue reading
SQL Server - How to encrypt and decrypt passwords (with Salt) using CLR (C#) December 2, 2016 4 min read Continue reading
Login failed for user error when connecting to SQL Server from a .NET (C#) application November 23, 2016 6 min read Continue reading
SQL Server - Session Running for a Long Time with the SpreadRequest / DatabaseMail Command October 31, 2016 3 min read Continue reading
SQL Server - The Data Types Datetime and Time Are Incompatible in the Add Operator July 16, 2016 3 min read Continue reading
SQL Server - The Server May Be Running Out of Resources or the Assembly May Not Be Trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE June 16, 2016 2 min read Continue reading
SQL Server - Error Using OPENROWSET: Access to the Remote Server Is Denied Because No Login-Mapping Exists May 28, 2016 3 min read Continue reading
SQL Server - Cannot resolve the collation conflict between ... in the equal to operation. May 25, 2016 6 min read Continue reading
SQL Server - Heterogeneous Queries Require the ANSI_NULLS and ANSI_WARNINGS Options to Be Set for the Connection May 22, 2016 3 min read Continue reading
SQL Server - The Database Owner SID Recorded in the Master Database Differs from the Database Owner SID Recorded in Database April 21, 2016 3 min read Continue reading
CLR - Solving the System.Security.Permissions.FileIOPermission problem in SQL Server March 30, 2016 2 min read Continue reading
Solving .NET Framework DLL Assembly signature problems in SQL Server September 10, 2015 1 min read Continue reading
SQL Server - Timeout When Executing a Query on a Linked Server May 8, 2015 1 min read Continue reading
Arithmetic Overflow in the SQL Server 2008 sys.syscolumns catalog view February 8, 2015 3 min read Continue reading