Free/open-source alternatives to various softwares

Outlook PST viewer
Google: lightweight|simple free pst browser|explorer search|filter

Office suite that is free for commercial/business use

SoftMaker FreeOffice: it's completely free for both personal and commercial use.

LibreOffice: LibreOffice is free for use by everybody. You may take this copy of LibreOffice and install it on as many computers as you like, and use it for any purpose you like (including commercial, government, public administration and educational use).

Differences Between LibreOffice and FreeOffice: Best Free Office Suite July 9, 2020

Apache OpenOffice: You may use OpenOffice for any purpose without restriction: private, educational, public administration, commercial... Free, really free.

LibreOffice vs. OpenOffice: Which one is right for you? June 17, 2020

LibreOffice looks very much like a Microsoft Office app, down to the menu ribbon of buttons and options that line the top of your screen.

In contrast, OpenOffice is a bit drab and gray-looking and has smaller menu icons that line the top of its windows. But it does resemble Google Docs, so if you prefer the minimalist look of Google Docs and its straightforward menus, OpenOffice might be the best choice for you.

WPS Office is NOT free: No commercial entities or organizations are permitted to use the functionally restricted version of the Software.

WPS Office
How to remove ads in WPS Office
Note to self:
Buat rule firewall (inbound maupun outbound) utk block :
wpscloudsvr.exe
wpscenter.exe
ktpcntr.exe
How to "replace" watermark (comment section)
you just need to edit a image.
that would likely be be here....
C:\Users\User\AppData\Local\Kingsoft\WPS Office\10.1.0.5507\office6\mui\default\resource\authorization
It's named "trialwatermark" exiting in a .png format.
I did not try to delete it, as it might recreate the file (I do not know)
Instead, I edit it into a blank image by erasing it using Photo Shop.

WTF! WPS Office is adding watermark to the documents I print
WPS Office Free now adds watermark to all the documents we print
It's better to stick with Kingsoft Office if you want a true free version. Especially Kingsoft v9.1.0.4550 which even allows saving in .docx and .xlsx and is available at Filehippo. Or switching to Softmarker Office is the next best idea.
---

The 10 Best Free and Open Source CRM Software Solutions

Software/add-on to perform Analysis of Variance (ANOVA) without Excel:
ezANOVA
Related: Excel Add-ins for Multiple Comparisons Tests

Program untuk analisa statistik:
R: The R Project for Statistical Computing
(Video) Duncan's Multiple Range Test in R
...note: make sure .csv file is really using comma!
...if "library(agricolae)" command returns error, use Packages\Install Packages menu first
...commands used in video (and few more added by me):
 > potato<-read.csv(file.choose(),header=T)
 > potato
 > library(agricolae)
 > model<-aov(yld~trt,data=potato)
 > comparison<-duncan.test(model,"trt",main="whatever")
 > out<-duncan.test(model,"trt",alpha=0.01,console=TRUE)
 > write.csv(as.data.frame(out$statistics),file="d:\\temp\\statistics.csv")
 > write.csv(as.data.frame(out$means),file="d:\\temp\\means.csv")
 > write.csv(as.data.frame(out$groups),file="d:\\temp\\groups.csv")
R Tutorials (see "R Tutorials" on right pane)

Sticky note / Post-it:
Best Free Sticky Notes Utility

Software gratis untuk warnet:
CyberCafePro

Serif Plus product line as alternative to Corel Draw
Differences btn Free Starter Edition and full paid version

23 Photoshop alternatives in 2014

12 Free alternatives to Microsoft Office
KingSoft Office: Differences between Free and Professional Version of Office 2013
Related: disable auto update

Windows Explorer alternatives:
Multi Commander
- To open command prompt on current folder, just type 'cmd' on command line bar

Open source as alternative
The 10 Best Free Alternatives to Microsoft Visio — May 2019
The OpenOffice platform contains a free replacement for Visio. Called Draw, any ex-Visio user will find themselves right at home with Apache’s software.
The app features a user interface nearly identical to Microsoft Visio, helping any Office converts feel right at home within the platform, and best of all, you’ll never have to pay for the ability to use Draw.
www.osalt.com/visio
The best 9 alternatives to microsoft visio
draw.io (free, web based, no login required)
Related: Microsoft Visio (visio from time to time, including "Visio Online Plan 2 ")

Ghost alternative: Clonezilla
http://clonezilla.org/

Self experience
-------------------

Flowchart: https://app.diagrams.net/
Dia as Visio replacement:
- Truncated image when copy/paste to MS Word
- Export result to PNG/WMF is too small when inserted to MS Word
* Export back .dia to Visio: use VDX format (might need little fix)

SQL Server 2005 related

(SQL2014) See who currently use database : execute sp_who2

How to determine the version, edition, and update level of SQL Server and its components

Reset password 'sa' :
Use Master
Go
ALTER LOGIN [sa] WITH PASSWORD=N'StrongPassword'
Go

View disk usage using command (handy if report is too long)
Different ways to determine free space for SQL Server databases and database files
[Select database in question then run this query:]

SELECT DB_NAME() AS DbName, 
name AS FileName, 
size/128.0 AS CurrentSizeMB, 
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB 
FROM sys.database_files; 

A Seven-Step Process for Changing a Database's Collation - Follow this simple methodology to prevent problems

[General] Can we use timestamp column to display records in the order of insertion/creation time?
Short answer: WE CAN'T
Order by SQL timestamp
..TIMESTAMP datatype has nothing to do with a date and/or a time. But it is a sequentially increasing ..number (a ROWVERSION - that's it's new and more appropriate name), so ordering by it will order by ..the sequence of changes to the rows
Sort records by time inserted
[2000] Can SQL Server tell me which row was inserted most recently?
..Unlike Access and other file-based database platforms, a table in SQL Server is essentially an unordered ..heap. You can not assume that the last row inserted will be at the "end" of the table, mainly because tables ..in SQL Server don't have an "end." You need to tell SQL Server what you mean by "last" (using TOP with ..an ORDER BY, or aggregate functions like MAX)
Related:
In SQL server how do I order table rows by insertion order if primary key is GUID?

Memory Supported by the Editions of SQL Server 2005
[Some] edition of SQL Server 2005 [, STANDARD for instance,] will support the maximum memory supported by the operating system

Old publications of JW (not exist on WT Library)

Ongoing List of Public Domain PDF Books
(source webpage: PDF Library)

Transpose every 3 rows to single row

Example of data:
John Doe
Some street
1234567890
Joanna Doe
Sesame street
654321

Expected result:
John Doe    Some street    1234567890
Joanna Doe Sesame street 654321

Data on A1 to A6

Formula on B1:
=INDEX($A$1:$A$6;ROWS(A$2:A2)*3-3+COLUMNS($A2:A2))

.NET Framework related

Microsoft .NET Framework Repair Tool

This tool troubleshoots common issues with the setup of Microsoft .NET Framework or with updates to Microsoft .NET Framework setup installation. Additionally, this tool tries to resolve these issues by applying known fixes or by repairing the installed product. 

How to enable .NET Framework 3.5 on Windows 8 in Offline Mode
If it fails, probably because you've installed a language pack (as mentioned on comment by Benjamin Nolan here)
The solution is remove the language pack (control Panel \ Language) then try again

How to determine which versions and service pack levels of the Microsoft .NET Framework are installed

Registry key structure changes since version 4:
How to: Determine Which .NET Framework Versions Are Installed