SQL Server DBA, BI Analyst and Microsoft MVP

post.tags

Errors

tag.total

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 - How to identify timeout or interrupted connections using Extended Events (XE) or SQL Profiler (Trace)

September 29, 2021 12 min read

Continue reading

Analysis Services - An error occurred while opening the model on the workspace database. Reason: An unexpected error occurred (file 'tmcachemanager.cpp', function 'TMCacheManager::CreateEmptyCollectionsForAllParents')

November 5, 2020 3 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 - I set Max Server Memory to 0 and now I cannot connect to the instance

December 23, 2019 3 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 - What Is the Difference Between @@ERROR and ERROR_NUMBER()?

January 1, 2019 4 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 - 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 - 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