WORK SMARTER USING TECHNOLOGY

Blog

I’m a Warrnambool based technology pofessional that works with business clients to deliver functional technology solutions.

How to set Office 365 password to never expire

on

First you need to make sure you have the Azure AD Module installed on the computer. If you do not have the the Azure AD Module installed you need to: Open PowerShell as administrator Run the command (get-item C:\Windows\System32\WindowsPowerShell\v1.0\Modules\MSOnline\Microsoft.Online.Administration.Automation.PSModule.dll).VersionInfo.FileVersion Then you need to run the following commands in powershell: $msolcred = get-credential connect-msolservice -credential $msolcred …

How to connect to Office 365 Exchange using Powershell

on

***Please note this article is out of date and no longer current** I use these commands to connect to Exchange Online in Office365. To do this you need to open powershell and run these command: $LiveCred = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange-ConnectionUri https://ps.outlook.com/powershell -Credential $LiveCred -Authentication Basic -AllowRedirection Import-PSSession $Session After the first line it …

Find a column from all tables in a database on SQL Server

on

I recently have needed to find a column but could not remember what table it was in the database. You can run this query on your SQL Server to find a specific column in the whole database: SELECT COLUMN_NAME,  TABLE_NAME FROM  INFORMATION_SCHEMA.COLUMNS WHERE  COLUMN_NAME LIKE’ %ColumnName%’ You will need to replace the ColumnName(that is in …

Introduction to network scanning with NMap

on

NMap(stands for network mapper) is a small utility that has both a command line option called NMap and also a graphical option called Zenmap. It is a free and open source program that is licensed under the GNU GPL(more details on the GNU GPL license can be found in my introduction to Linux). Why do …