How to set SQL Server from “Windows Authentication mode” to “SQL Server and Windows Authentication mode”
Right click on the server name and select properties; Select security tab; Enable the SQL Server and Windows Authentication mode; Restart the SQL Server service.
How to send email via Office 365 in Python
Pyhton 3. Complete info: https://www.aventistech.com/2016/03/07/python-send-email-via-office-365-tls/
How to unzip a file using Python
How to set single Azure AD user’s password to never expire
You must be an global admin or password administrator to perform these steps. Run these command in PowerShell Check if the target user’s password is set to “never expired” Set the target user’s password to “Never Expire” Full article in https://docs.microsoft.com/en-us/microsoft-365/admin/add-users/set-password-to-never-expire?view=o365-worldwide
How to: Solve “the requested OLE DB provider MSOLAP.7 not registered”
Download the latest Microsoft® Analysis Server® Feature Pack: Google search “Microsoft® Analysis Server® Feature Pack” or as of 11/13/2020 https://www.microsoft.com/en-us/download/details.aspx?id=55264 Download ad run SQL_AS_OLEDB.msi
How to use T-SQL to scale Azure SQL Server
You can use T-SQL to scale up/down Azure SQL Server: To check the DB scaling progress, you can use T-SQL in Master DB: With the T-SQL Alter database command, you can use SQL agent to easily schedule your database scale up/down.
How to: Make Excel charts responding to events
This Excel VBA code is to enable events on Excel embedded charts.
How to: Send Python request with client side certificate
This is part of a Python web download project. It is to scrape a https web site that will check client side digital certificate.
How to: use OpenSSL to convert digital certificate from .pfx to .pem in Windows
This is part of a Python project to download data from a secured web site using digital certificate.