About Powershell

There are two main reasons I use Powershell:

• Get information about many objects (like people, computers, groups, etc) at once.  With a GUI you can usually only work with one person or computer.
• Run scripts on device remotely to gather information or make chagnes to devices.
• 
  

Powershell is an object-oriented language.  The commands are called cmdlets and have a verb-noun format, e.g. Select-Object.  

Example syntx:

    Select-Object [[-Property] <System.Object[]>] [-ExcludeProperty <System.String[]>] 

    [-ExpandProperty <System.String>] [-First <System.Int32>] [-InputObject 

    <System.Management.Automation.PSObject>] [-Last <System.Int32>] [-Skip <System.Int32>] 

    [-Unique] [-Wait] [<CommonParameters>] 

• - <  required parameter name > < required .NET type > 
• [ - <optional parameter name > ] [ <optional type> ]  e.g. [-ExpandProperty <System.String>] 
• [ - <optional parameter name >] <required type>, e.g. [Skip <System.Int32>] 
• Switches – parameters that don’t take input, like [-Unique] 
• The parameters appear in positional order, can omit them and just put in the values  

Symbols in Syntax: 

• Hyphen (  -  ): indicates a parameter name, e.g. -name 
• Angle brakets <  >  : placeholder text, you input the needed data.  The placeholder identifies the .NET type expected, e.g. <system.Int32> 
• Brackets [  ]: around a parameter indicates the parameter is optional.  Brackets appended to a .NET type indicates the parameter can accept one or more of that type. E.g. [-property <system.object [ ] > ] , means that –Property can take more than one object.   
• Select-Object –Property name, CPU, ID 
• Braces { } : indicates a set of valid values for a parameter e.g. New-Alias –Options { None | ReadOnly | Constant | Private } 

Use Get-Help to look up the parameters and syntax of a Cmdlet.  Get-Command is used to find out what parameters and methods a cmdlet has.  

More to come

More to come

SQL 

SELECT table_name

FROM INFORMATION_SCHEMA.TABLES

WHERE table_type = 'Base Table'

To filter for a table name add,

AND table_name LIKE '%<  >%'

We offer a variety of flooring options, including hardwood, tile, laminate, and vinyl, with professional installation and repair services.

Our deck building services include design, planning, and construction of custom decks, using high-quality materials to ensure longevity.

We provide window replacement services, including energy-efficient options and custom sizing for a perfect fit.

We offer roofing repair and replacement services, including shingle replacement, leak repair, and new roof installation.