SQL Server DBA, BI Analyst and Microsoft MVP

post.tags

error

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

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 - 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 - How to identify, monitor, and prevent overflow in IDENTITY and SEQUENCE columns of tables with many rows

February 8, 2017 6 min read

Continue reading

Reporting Services (SSRS) - Error when deleting mobile reports (Error invoking the authorization extension)

December 4, 2016 5 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 Reporting Services - Error Saving Report: System.InvalidOperationException - This Implementation Is Not Part of the Windows Platform FIPS Validated Cryptographic Algorithms

August 11, 2016 4 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

Analysis Services - Deserialization Failure: The 'AllowedRowsExpression' element in namespace

May 9, 2016 1 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

Visual Studio - Solving the sgen.exe / .NET Framework SDK Build Error

March 29, 2016 3 min read

Continue reading

How to Configure Your VM Network in Bridge Mode in VMware Player

August 23, 2015 3 min read

Continue reading

HTTP error redirection using .htaccess (Apache)

November 24, 2014 1 min read

Continue reading