SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”

Background Wanted to quickly go over an error that is easy to self trigger when working with SQL Server Data Tools ( SSDT ).   Triggering Point A few days ago I was working with SSDT, and I was informed that one of the plugins is running slow and prompted if I want to disable … Continue reading SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”

Error :- “Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=13.0.0.0, Culture=neutral”

Background Running SQL Server Tools, but run into an exception. Error Error Image Error Text Trouble Shooting The cited assembly is Microsoft.ReportViewer.WinForm and the version is 13.0.0.0. 13.0.0.0 maps to SQL Server 2016. Remediation Outline Artifacts Please access the corresponding SQL Server Feature Pack Again 13.0.0.0 maps to SQL Server 2016 The web link for … Continue reading Error :- “Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=13.0.0.0, Culture=neutral”

Pastor Paul LeBoutillier :- Priscilla, Aquila, Apollo, and Paul

Background Pastor Paul LeBoutillier delivers a power sermon on how the church needs worker such as Priscilla, Aquila, Apollo, and Paul. Scripture Acts 18:24-27 Link Meanwhile a Jew named Apollos, a native of Alexandria, came to Ephesus. He was a learned man, with a thorough knowledge of the Scriptures. He had been instructed in the … Continue reading Pastor Paul LeBoutillier :- Priscilla, Aquila, Apollo, and Paul

Sid Roth – 2019/Summer

  Background Each of us is in one ministry or another. There is a timing to it. Time to shut in, time to be released in to it. God lets us go, and then he calls us in.   Videos Ian and Rosemary Andrews Profile In this Sid Roth's It's Supernatural! Classic episode from 2002: … Continue reading Sid Roth – 2019/Summer

SQL Server Agent on AWS/RDS

Background There is quite a bit of SQL Server management surface area that is not available when running on AWS/RDS.   Surface Area For instance with SQL Server Agent :- SQL Server Agent Category Add new category API sp_add_category Error Msg 229, Level 14, State 5, Procedure msdb.dbo.sp_add_category The EXECUTE permission was denied on the … Continue reading SQL Server Agent on AWS/RDS

Github – Warning – “… this is larger than GitHub’s recommended maximum file size of 50.00 MB”

Background In our last post tried uploading Microsoft's office Excel Viewer to github, but ran into a familiar error\warning. Referenced Posts Here are referenced posts :- Microsoft Office Files Viewer Link   Error Error Image Error Text Remediation Git Large File Storage Outline Please peruse Git Large File Storage instruction on how to incorporate Git … Continue reading Github – Warning – “… this is larger than GitHub’s recommended maximum file size of 50.00 MB”

Transact SQL :- Error – Msg 15138 – “The database principal owns a schema in the database, and cannot be dropped”

Background Cleaning up a database as we move it from Development to Production. Recreate Drop User SQL Error Msg 15138 Error Text Error Image   Troubleshoot Metadata sys.schemas SQL Output Explanation Schema db_datareader The owner for the db_datareader schema has been assigned to a database account, other than itself Remediate Change Schema Owner ALTER AUTHORIZATION … Continue reading Transact SQL :- Error – Msg 15138 – “The database principal owns a schema in the database, and cannot be dropped”