O365, SharePoint, Android, C# , SQL , Software Development, Office Productivity, Visual Studio, Business Intelligence, Software Engineering , JavaScript , JQuery , Web Service, JS & .Net FW FUN!
Saturday, June 30, 2018
How to share Express VPN WIFI connection as Hotspot using Connectify Tip
1. Tweak the following Express VPN Settings
2. Close all
3. Open Express VPN, Connect
4. Ensure VPN Connection is working
5. Open Connectify select the ExpressVPN TapAdapter
*** this does NOT work on any Surface due MS dropping hostednetwork
Tuesday, June 26, 2018
Visual Studio 2012+ Improve Load Time, Performance, Build and Debugging Speed
http://jrdtechnologies.blogspot.com/2016/12/slow-visual-studio-debugging-experience.html
Union with tips from:
visual studio - Why is VS 2013 very slow? - Stack Overflow
https://stackoverflow.com/questions/19617670/why-is-vs-2013-very-slow
and
10 Tips to Improve Visual Studio Build Performance - CodeProject
https://www.codeproject.com/Tips/1042975/Tips-to-Improve-Visual-Studio-Build-Performance
I will compile shortly...
Settings to Maximize Battery Life, Minimize CPU Usage and Minimize HD Usage.
Device Manager and Power Settings to tweak to boost Battery/overall system longevity (I Hope):
Device Manager
Saturday, June 23, 2018
Visual Studio to .Net FW Compatibility and Visual Studio to DevsExpress Compatibility
Visual Studio to .Net:
Each version of Visual Studio prior to Visual Studio 2010 is tied to a specific .NET framework. (VS2008 –> .NET 3.5, VS2005 –> .NET 2.0, VS2003 –> .NET1.1) Visual Studio 2010+ allows targeting of older .Net FW, but can’t be used for future .Net FW. For .Net 4.5+ we must use VS2012+, see below tables showing dependency mapping.
References:
Install Links for all .Net FW : Developer and Distribution Package
MS VS and .Net Version and Dependency Guide Detail
.Net to Visual Studio to Windows Version History & Compatibility Summary
.NET Framework version | Desc | VS.NET | OS |
4.7.2 | -Crypto+Asp.Net. | N/A | 10,8.1,7; Svr: 2016, 2012, 2008R2Sp1 |
4.7.1 | SHA/TryParse. | N/A | 10,8.1,7; Svr: 2016, 2012, 2008R2Sp1 |
4.7 | JSON. | 10,8.1,7; Svr: 2016, 2012, 2008R2Sp1 | |
4.6.2 | - Cryptography enhancements, | 10,8.1,7; Svr: 2016, 2012, 2008R2Sp1 | |
4.6.1 | - Support for X509 certificates | + 10 | |
4.6 | - Compilation using .NET Native | 2015,. | 10,8.1,7,Vista; Svr: 2016, 2012, 2008R2Sp1 |
4.5.2 | Tx Support | - | 8.1,7; Svr: 2012, 2008R2Sp1 |
4.5.1 | - Support for Windows Phone Store apps | 2013 | 8.1,7, Vista; Svr: 2012, 2008R2Sp1 |
4.5 | - Support for Windows Store apps | 2012 | 8,7, Vista; Svr: 2012, 2008R2Sp1 |
4 | - Expanded base class libraries | 2010 | 8,7, Vista; Svr: 2012, 2008R2Sp1 |
3.5 | - AJAX- LINQ | 2008 | 8,7, Vista; Svr: 2012, 2008R2Sp1 |
3.0 | - WPF, WCF, WF | - | 8,7, Vista; Svr: 2012, 2008R2Sp1 |
2.0 | - Generics | 2005 | - |
1.1 | - ASP.NET and ADO.NET | 2003 | - |
1.0 | First version of the .NET Framework. | Visual Studio .NET | - |
Visual Studio to .Net FW 1-4
.
.NET Framework version | CLR version | VS IDE version | Description |
1.0 | 1.0 | Visual Studio .NET | Contained the first version of the CLR and the first version of the base class libraries. |
1.1 | 1.1 | VS2003 | Included updates to ASP.NET and ADO.NET.Has (SP1) and SP2. |
2.0, 3.0 | 2.0, 3.0 | VS2005 | generics, generic collections, Has SP1 and SP2. |
3.5 | 2.0 | VS2008 | AJAX-enabled Web sites LINQ. Has SP1 |
4 | 4 | Visual Studio 2010 | (MEF), (DLR), and code contracts. |
Windows OS to .Net FW 1-4
.NET Framework versions | Windows versions |
1.0, 1.1, and 2.0 | No OS |
3.0, 2.0SP2, 3.5 | Windows Vista and Windows Server 2008. |
3.5 SP1 | Windows 7. |
4 | Compat Windows XP, Windows Server 2003+ |
Visual Studio to SharePoint Solutions:
Dev Express to Visual Studio Dependencies:
Windows : Clean Up old files and folders automatically!
1. Create Windows Bat Files to Delete Files or Folders that are older than a certain age!
2. Save bat file to directory where you want to clean up files or sub folders
3. To automate, create a windows task that executes this bat file.
Delete Files
REM: Purge files
FORFILES /S /D -20 /C "cmd /c IF @isdir == FALSE del /F /Q @path"
Delete Folders
REM: Purge folders
FORFILES /S /D -30 /C "cmd /c IF @isdir == TRUE rd /S /Q @path"
Windows Firewall Block all Programs in a Folder
So..Say you want to block all internet connections for an exe(s) in a Windows folder, this bat file will Block All Internet connections save below cmds to a bat file, save to a folder with the exe(s) you want to block, and then Run this bat file. Voila!
@ setlocal enableextensions
@ cd /d "%~dp0"
for /R %%a in (*.exe) do (
netsh advfirewall firewall add rule name="Blocked with Batchfile %%a" dir=out program="%%a" action=block
)
Sunday, June 17, 2018
Friday, June 8, 2018
VLC + MPC + GOM Players Resize, Favorites and Bookmark settings
Compare VLC MPC and GOM Player settings and availability, Favs and Bookmarks are key when scrubbing videos in prep to edit, in other works marking videos to be used in Editing.
MPC
Disable Resize:
After r2637, check "Remember last window size" will automatically disable "Auto-zoom",ticket 865 was referring to revisions after that.
If you would like stick with your 1.4.2499.0, then you can check "Remember last window size", and uncheck "Auto-zoom" in Options->Playback at the same time.
Playlist:
"C:\Program Files (x86)\K-Lite Codec Pack\MPC-HC64\default.mpcpl"
Favortes:
there are two possibilities:
1) in the registry
look for "HKEY_CURRENT_USER\Software\Gabest\Media Player Classic\Favorites"
2) in the mplayerc.ini file
look for a section named "[Favorites\Files]"
GOM
Player Disable Resize
ry right-clicking on player, then video->use default screen size. Might have happened that you set something here.
Playlist
"P:\2018\20180525_Alberto\20180525_Alberto.GOM.asx"
Favs
Manage / Add Favs
Save to Playlist
or
Export to reg file
"C:\Users\DoyleJ\Documents\gomplayer_20180608.reg"
VLC
Disable Resize:
Default is OK
Select Tools ⇨ Preferences ⇨ Interface then uncheck the box Resize interface to video size.
Finally, restart VLC.
PlayList
"C:\Users\DoyleJ\Documents\VLC.PlayList.xspf"
favs:
None?
bookmarks Add
creates
Figures:
MPC:
Playlist ex:
MPCPLAYLIST
1,type,0
1,filename,P:\2018\20180525_Alberto\Video\SOLO0022.MP4
2,type,0
2,filename,P:\2018\20180525_Alberto\Video\SOLO0019.MP4
3,type,0
3,filename,P:\2018\20180525_Alberto\Video\SOLO0020.MP4
4,type,0
4,filename,P:\2018\20180525_Alberto\Video\SOLO0021.MP4
Favs:
[Favorites]
RelativeDrive=0
RememberPosition=1
[Favorites\Files]
Name0=MAH01588.MP4;72044246;0;P:\2018\20180525_Alberto\Video\videoThumbs\MAH01588.MP4
Name1=MAH01591.MP4;316151989;0;P:\2018\20180525_Alberto\Video\videoThumbs\MAH01591.MP4
Name2=SOLO0022.MP4;238979560;0;P:\2018\20180525_Alberto\Video\SOLO0022.MP4
GOM
Playlist examples:
<asx version = "3.0" >
<entry>
<title>SOLO0018.MP4</title>
<ref href = "P:\2018\20180525_Alberto\Video\SOLO0018.MP4" />
<duration value = "14" />
</entry>
<entry>
<title>SOLO0019.MP4</title>
<ref href = "P:\2018\20180525_Alberto\Video\SOLO0019.MP4" />
<duration value = "152" />
</entry>
<entry>
<title>SOLO0020.MP4</title>
<ref href = "P:\2018\20180525_Alberto\Video\SOLO0020.MP4" />
<duration value = "114" />
</entry>
<entry>
<title>SOLO0021.MP4</title>
<ref href = "P:\2018\20180525_Alberto\Video\SOLO0021.MP4" />
<duration value = "0" />
</entry>
<entry>
<title>SOLO0022.MP4</title>
<ref href = "P:\2018\20180525_Alberto\Video\SOLO0022.MP4" />
<duration value = "49" />
</entry>
</asx>
Bookmark
http://player.gomlab.com/guide.gom?tab=37&language=eng
right click the video playback area, select “Bookmark”
XML:
C:\Users\DoyleJ\AppData\Roaming\GRETECH\GOMPlayer\bookmark.xml
<BookMark>
<Target path="P:\2018\20180525_Alberto\Video\videoThumbs\MAH01589.MP4">
<Element pos="5.529" comment="Bookmark 0">
</Thumb>
</Element>
</Target>
</BookMark>
Export
"C:\Users\DoyleJ\Documents\GOMPlayer.Bookmarks.MAH01606.gbm"
[Bookmark]
0=5.697458 Bookmark 0 FFD8FFE000104A46494600010100000100010000FFDB00430006040506050406060506070706080A100A0A09090A140E0F0C1017141818171416161A1D251F1A1B231C1616202C20232627292A29191F2D302D283025282928FFDB0043010707070A080A130A0A13281A161A282828282828282828282828282828282828282828..
Favs:
Preferences | Export | Reg files |
"C:\Users\DoyleJ\Documents\gomplayer_20180608.reg"
"_FAVORITE000"="[F] SOLO0022.MP4||P:\2018\20180525_Alberto\Video\SOLO0022.MP4"
"_PSPRESET000"="(Default)
100 100 100 100"
VLC:
PlayList:
"C:\Users\DoyleJ\Documents\VLC.PlayList.xspf"
<trackList>
<track>
<location>file:///P:/2018/20180525_Alberto/Video/videoThumbs/MAH01595.MP4</location>
<duration>4504</duration>
<extension application="http://www.videolan.org/vlc/playlist/0">
<vlc:id>0</vlc:id>
</extension>
</track>
Tuesday, June 5, 2018
How does Powershell script connect to SharePoint OnPrem?
**some notes from Powershell setup and connectivity**
How will the PS script connect to SP?or
how I can access the PowerShell cmdlets from my client pc?
Everything I read assumes you're in front of the actual server. Is there anything like an RSAT module I can install on my client PC?
PS vs JS vs CS : Different Ways To Add Item In SharePoint 2013 List
https://www.c-sharpcorner.com/UploadFile/sagarp/different-ways-to-add-item-in-sharepoint-2013-list/
1) remote ps
PowerShell REMOTELY (not directly on the server)
On the SharePoint Servers:
Log onto the SharePoint Server(s) as the SharePoint Administrator
2) csom
rest: https://blog.vgrem.com/2014/04/15/consuming-the-sharepoint-2013-rest-api-from-powershell/
PowerShell and the Client Object Model to write code against SharePoint Online. It can be a little intimidating at first, given the complexity of the work required.
3) PnP
SharePoint Patterns and Practices (PnP) contains a library of PowerShell commands (PnP PowerShell) that allows you to perform complex provisioning and artifact management actions towards SharePoint. The commands use CSOM and can work against both SharePoint Online and SharePoint On-Premises. The advantage is code you have written can be simply replaced with one single commandlet.
Windows 10 + SurfaceBook 2 Performance Tweaks : Update UI & OS Settings, Remove Bloatware & MS Spyware, Tweak Network Adapter
Windows 10 Setup: Tweak UI to look more like Windows 7
Add personalization shortcut to desktop, see Figure 1 below
Add Classis Shell to Windows 10,restore the look and feel of Win7
Download Classic Shell here
Tweak Windows Explorer:
View Hidden, icons only ect per view menu
Tweak System UI Performance: System:
Change Computer name
Windows 10 Setup: Tweak OS to improve performance
** note ** Use of my computer is targeted towards development + some multimedia editing. So what works for gamers doesn’t work for me,
Tweak Services for Performance per Black Viper recommendations,.
[Optional] Tweak Paging File for performance,
If RAM > 8GB I keep defautl setting
If Ram <=8gb, SET TO RAM * 1.5
Disable startup applications
MsConfig
Task Scheduler (Hidden)
Disable system visual effects
Disable search indexing / Modify Indexing
https://www.howtogeek.com/howto/windows-vista/speed-up-or-disable-windows-search-indexing-in-vista/
Disable Diag track
sc config "DiagTrack" start= disabled sc stop "DiagTrack"
Disable
Get tips, tricks and suggestions as you use Windows.
See https://www.tenforums.com/tutorials/30869-turn-off-tip-trick-suggestion-notifications-windows-10-a.html
Disable Data Collection:
See https://www.majorgeeks.com/content/page/how_to_disable_diagnostics_tracking_(diagtrack)_or_connected_user_experiences_and_telemetry.html
and https://winaero.com/blog/how-to-disable-telemetry-and-data-collection-in-windows-10/
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\DataCollection
AllowTelemetry = 0
and
Diag Track Listener Disable
Windows 10: Remove Bloatware & MS Spyware
Overview:
1. Edit Scripts:
2. Run scripts in order
Open PowerShell as an Administrator
Type the command (without quotes): “Set-ExecutionPolicy Unrestricted” and press enter
3. Run Other Tools as needed
Debloat-Windows-10-master
Main debloater with several scripts to remove Win10 bloatware
Debloater GitHub Download Scripts here
Other Tools
WindowsAppsRemover_winxar_102
Remove/Disable pesky Windows 10 Apps
O&O ShutUp10
Disable Windows 10 useless features, O&O ShutUp10 means you have full control over which comfort functions under Windows 10
https://www.oo-software.com/en/shutup10
DisableWinTracking
Disable MS tracking!
http://www.softpedia.com/get/Tweak/System-Tweak/Windows-10-Tracking-Disable-Tool.shtml
SurfaceBook 2: Tweak Network Adapter for performance:
Boost Surface Book/ Pro Wi-Fi connectivity
The first thing you have to do is to open the registry as an administrator, simply type regedit in the taskbar search box, and hit Enter.
Navigate to the following path:
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\mrvlpcie8897
Find the item labeled “TXAMSDU”. Double tap and modify the value from 1 to 0.
Restart your Windows 10 PC to complete the workaround.
If everything works as expected, your slow connectivity should be resolved and you should now see an improved wireless connection.
Windows 10 Issues I ran into:
Mapped drives do not work in Windows 10.
Mapped Drives do not work after switching Wifi spots on same network:
Open Cmd ->
ipconfig /release
ipconfig /renew
Adobe After Effects and other apps have super tiny unreadable font.
And here is my manifest I used to fix Adobe After Effects
Figure 1
Clipped from: https://www.howtogeek.com/277448/how-to-make-windows-10-look-and-act-more-like-windows-7/
Easily Access the Classic Personalization Window
By default, when you right-click on the Windows 10 desktop and select Personalize, you are taken to the new Personalization section in PC Settings. However, the Personalization window from Windows 7 is still available in the Control Panel. You can add a shortcut to the desktop so you can quickly access the classic Personalization window if you prefer it.
Right-click on the desktop and select New > Folder from the popup menu.
Copy and paste the following text into the name of the folder and press Enter.
Personalization.{ED834ED6-4B5A-4bfe-8F11-A626DCB6A921}
The icon changes to the personalization icon and the name of the folder also changes to Personalization. Double-click this icon to access the classic Personalization window in the Control Panel.
Figure 2 : Other Links
scripts
https://community.spiceworks.com/scripts/show_download/3977-windows-10-decrapifier-version-2
https://github.com/W4RH4WK/Debloat-Windows-10
Utils
https://sourceforge.net/projects/windirstat/files/
https://filehippo.com/download_speccy
https://www.revouninstaller.com/revo_uninstaller_free_download.html
https://docs.microsoft.com/en-us/sysinternals/downloads/autoruns
Run all programs as Administrator on Windows
We have 3 options to run a program as Admin in Windows:
1) Shift Right Click , then run as admin
2) Shortcut –> Properties –> Advanced –> check “Run as Admin” check box
3) Default all apps to runas admin: Using UAC, we then can disable UAC thereby all apps run as Admin via reduced rights. This is OK for home use but prob. not corp use due to security and policies. If your home environment is secure via router / firewalls and a solid antivirus on the machine consider allow all APPS to runas Admin, this reduces the manual intervention on every app start, see below procedure
3.a
Danger! See here more info
Run gpedit.msc
to open the Local Group Policy Editor. Expand Computer Configuration, Windows Settings, Security Settings, Local Policies, and Security Options. Four settings need to be updated:
- Set "User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode" to Elevate without prompting.
- Set "User Account Control: Detect application installations and prompt for elevation" to Disabled.
- Set "User Account Control: Run all administrators in Admin Approval Mode" to Disabled.
- Set "User Account Control: Only elevate UIAccess applications that are installed in secure locations" to Disabled.
The LGPE automatically saves all changes, so exit it and reboot.
3.b
1 - Add User To Administrators Group And Remove From Users Group:
Log In As Administrator
Go To Run ( WinKey + R )
Type "control userpasswords2"
Select Your Account And Click On "Properties"
Select "Group Membership" Tab
Select "Administrators"
Click OK And OK
2 - Disable Approval Mode
Log In As Administrator
Go To Run ( WinKey + R )
Type "secpol.msc"
Go To Local Polices > Security Options
Find "User Account Control: Switch to the secure desktop when prompting for elevation"
Open It Click Disable It And Click Ok.
Restart Computer( Very Important Log Off Doesn't Work )
Now Every App Will Be Run As Administrator In All Administrator Users
Monday, June 4, 2018
Fix Adobe After Effects small font on menus or other windows apps with tiny fonts
See below reg file, use when font on UI is too small to read even though DPI is at normal level (100% or 125%)
1) Tell windows to prefer an external manifest file
--------------------------------------------------------------------------------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide]
"PreferExternalManifest"=dword:00000001
--------------------------------------------------------------------------------
2) Create and place the external manifest files
and then add this to program.manifest in PF dir of Adobe After Effects (or said app)
See also:
https://forums.adobe.com/thread/1692469
and
https://www.danantonielli.com/adobe-app-scaling-on-high-dpi-displays-fix/
for more info