SQL Server: Fix Msg 8630, Level 16, State 1, Line 1 – Internal Query Processor Error: The query processor encountered an unexpected error during execution (HRESULT = 0x80040e19).

This is going to be a quick reference for people encountering this error and to do the fix more than a blog post but I do show a small trick on how to do an UPDATE in chunks 😉 The Error: I ran into this error with (Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 … Continue reading SQL Server: Fix Msg 8630, Level 16, State 1, Line 1 – Internal Query Processor Error: The query processor encountered an unexpected error during execution (HRESULT = 0x80040e19).

PowerShell: Manipulating & Copying File Permissions In Windows

The Mystery Recently a folder within a SMB share on the Windows Server (network share) displayed only certain files but not others for a certain user. For an administrator, the share displayed all the files in the folder. Obviously, there is some difference in the permissions, but what? Examining the difference between the files (using … Continue reading PowerShell: Manipulating & Copying File Permissions In Windows

SQL Server: Fix – The server principal “elevated_user_login” is not able to access the database “my_database” under the current security context

The Error: This error wasted my morning. Although I have solved this issue before, it took a while to google and fix it again. So, this post is for my own edification and reference if for no other reason! --Proc [MyProcedureName] started AT:2020-10-13 09:49:43.4632735Msg 916, Level 14, State 1, Procedure MySchemaName.MyProcedureName, Line 31 [Batch Start … Continue reading SQL Server: Fix – The server principal “elevated_user_login” is not able to access the database “my_database” under the current security context

PowerShell: Recursion And Finding Loops In A Hierarchy With Active Directory Example

Recently, a friend of mine asked me about the best way to find loops in a hierarchy, specifically with Active Directory groups that may be nested (either by design or by mistake) thereby causing loops and this recursion based solution was my recommended answer for him. The Problem: Here is the example he gave me: … Continue reading PowerShell: Recursion And Finding Loops In A Hierarchy With Active Directory Example