Monthly Archives: March 2018

SSMS Insufficient memory to continue the execution of the program

This blog provides one of the ways to resolve the error “Cannot execute script: Insufficient memory to continue the execution of the program” when you are using SQL Server Management Studio. Both of my SQL Server 2014 and SQL Server … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Servers | Tagged , , | Leave a comment

Windows Server search file contents grey

This post shows you one of the possibilities to enable the Files contents search in Windows Server. As you can see from the below picture the File contents is grey. Go to Server Manager in Windows Server. Click Add Roles … Continue reading

Posted in .Net, Community, Computers and Internet, Operating System | Tagged , | Leave a comment

Control Internet bandwidth for Windows 10 update

In the past Windows 10 will take up whatever bandwidth you have for Windows 10. In version 1709 you can set how much bandwidth you want to allocate for Windows 10 update. This blog post shows you how to control … Continue reading

Posted in .Net, Community, Computers and Internet, Operating System | Tagged , | Leave a comment

SSIS On Error Resume Next

This post shows you how to do On Error Resume Next in SSIS. Create an OnError event handler. I add a Script Task to write a log file utilizing the built in ErrorCode and ErrorDescription variable. Set the ForceExectionResult to … Continue reading

Posted in .Net, Community, Computers and Internet | Tagged , , | 1 Comment

Windows 10 stop major update

This post shows you one of the tougher topic in Windows 10. A lot of people need a security update but not major version update. Let me purpose one method for you to try here. People do not want to … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Operating System | Tagged , , , | Leave a comment

SSIS retrieves all record from Oracle even with “where” clause

This post gives you a possibility that when you retrieve an Oracle data from Oracle table using SSIS OLE DB Source it retrieves everything even with a where clause. I have the follow SQL statement. select se.gkey from service_events se, … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , | Leave a comment