PowerShell can read RSS feeds in just a couple of lines of code. Many radio broadcasters maintain RSS feeds with information about speed traps and...
posts-powershell
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Tags
Administration agent-based monitoring Agentless Monitoring alert responses alert thresholds alerting Alerts Amazon Aurora Amazon EC2 Amazon RDS Amazon RDS / Aurora Amazon RDS for SQL Server Amazon Redshift Amazon S3 Amazon Web Services (AWS) Analytics application monitoring Aqua Data Studio automation availability Azure Azure SQL Database azure sql managed instance Azure VM backup Backup and recovery backup and restore backup compression backup status Backup Strategy backups big data Blocking bug fixes business architecture business data objects business intelligence business process modeling business process models capacity planning change management cloud cloud database cloud database monitoring cloud infrastructure cloud migration cloud providers Cloud Readiness Cloud Services cloud storage cloud virtual machine cloud VM clusters code completion collaboration compliance compliance audit compliance audits compliance manager compliance reporting conference configuration connect to database cpu Cross Platform custom counters Custom Views customer survey customer testimonials Dark Theme dashboards data analysis Data Analytics data architect data architecture data breaches Data Collector data governance data lakes data lineage data management data model data modeler data modeling data models data privacy data protection data security data security measures data sources data visualization data warehouse database database administration database administrator database automation database backup database backups database capacity database changes database community database connection database design database developer database developers database development database diversity Database Engine Tuning Advisor database fragmentation database GUI database IDE database indexes database inventory management database locks database management database migration database monitoring database navigation database optimization database performance Database Permissions database platforms database profiling database queries database recovery database replication database restore database schema database security database support database synchronization database tools database transactions database tuning database-as-a-service databases DB Change Manager DB Optimizer DB PowerStudio DB2 DBA DBaaS DBArtisan dBase DBMS DDL Debugging defragmentation Demo diagnostic manager diagnostics dimensional modeling disaster recovery Download drills embedded database Encryption End-user Experience entity-relationship model ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events execution plans free tools galera cluster GDPR Getting Started Git GitHub Google Cloud Hadoop Healthcare high availability HIPAA Hive hybrid clouds Hyper-V IDERA IDERA ACE Index Analyzer index optimization infrastructure as a service (IaaS) infrastructure monitoring installation Integrated Development Environment interbase Inventory Manager IT infrastructure Java JD Edwards JSON licensing load test load testing logical data model macOS macros managed cloud database managed cloud databases MariaDB memory memorystorage memoryusage metadata metric baselines metric thresholds Microsoft Azure Microsoft Azure SQL Database Microsoft PowerShell Microsoft SQL Server Microsoft Windows MongoDB monitoring Monitoring Tools Monyog multiple platforms MySQL news newsletter NoSQL Notifications odbc optimization Oracle PeopleSoft performance Performance Dashboards performance metrics performance monitoring performance schema performance tuning personally identifiable information physical data model Platform platform as a service (PaaS) PostgreSQL Precise Precise for Databases Precise for Oracle Precise for SQL Server Precise Management Database (PMDB) product updates Project Migration public clouds Query Analyzer query builder query monitor query optimization query performance Query Store query tool query tuning query-level waits Rapid SQL rdbms real time monitoring Real User Monitoring recovery regulations relational databases Releases Reporting Reports repository Restore reverse engineering Roadmap sample SAP Scalability Security Policy Security Practices server monitoring Server performance server-level waits Service Level Agreement SkySQL slow query SNMP snowflake source control SQL SQL Admin Toolset SQL CM SQL code SQL coding SQL Compliance Manager SQL Defrag Manager sql development SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager Pro SQL DM SQL Doctor SQL Enterprise Job Manager SQl IM SQL Inventory Manager SQL Management Suite SQL Monitoring SQL Performance SQL Quality SQL query SQL Query Tuner SQL Safe Backup SQL script SQL Secure SQL Security Suite SQL Server sql server alert SQL Server Migration SQL Server Performance SQL Server Recommendations SQL Server Security SQL statement history SQL tuning SQL Virtual Database sqlmemory sqlserver SQLyog Storage Storage Performance structured data Subversion Support tempdb tempdb data temporal data Tips and Tricks troubleshooting universal data models universal mapping unstructured data Uptime Infrastructure Monitor user experience user permissions Virtual Machine (VM) web services webinar What-if analysis WindowsPowerShellText-to-Speech
Here is a fun function that converts text to speech. It even has a switch parameter called -Drunk to change the voice accordingly: function Out-Text...
Latest Process Activity
To find out whether a computer is idling for a long time or actually doing something, here is a function that returns the last process that was...
Getting NIC IP addresses and MAC addresses
WMI can return network information such as your current IP address and MAC address. Here is a sample how PowerShell can utilize and beautify the...
Checking Windows Updates Remotely
In a previous tip you learned how to list installed Windows Updates. Unfortunately, this only works for local machines. Provided you have enabled...
Controlling PSComputerName in Remoting Data
Whenever you use Invoke-Command to remotely execute code, you will notice that PowerShell automatically adds the column PSComputerName to your...
Listing Windows Updates
There is a not widely known COM object that you can use to list all the installed Windows Updates on a machine. Here is the code: $Session =...
Determine Functions Pipeline Position
Assume your function wanted to know whether it is the last element in a pipeline or operating in the middle of it. Here is a way for a function to...
Displaying Balloon Tip
Let's assume your script wants to share status information via a balloon message in the system tray area. Here is a sample:...
Saving History to Script
PowerShell is all about trial and error, and when you want to save your interactive input to a script file, this is how it could be done:...
Forwarding Selected Parameters
In a previous tip you learned how you can forward function parameters to cmdlets. But what if you just want to forward some of the parameters? Here...
Clean your TEMP folder!
When disk space gets low, you may want to clean up your temporary folder. The code deletes all files that are older than 30 days to make sure...
Filtering Files or Folders
To filter folder content by file or folder, check whether the Length property is present. It is present for files and missing in folders: Dir...
Office365 Cmdlets
Office365 comes with a complete set of PowerShell cmdlets. To review the cmdlets and what you can do with them, visit this URL:...
Forwarding Parameters
To forward function parameters to a cmdlet, use $psboundparameters automatic variable and splatting. Here is a sample: function...
How Long Has Shell Been Running?
To find out how long your PowerShell session has been running, try this code snippet: ((((Get-Date)-(Get-Process -id $pid).starttime) -as [string])...
Enabling Remote WMI and DCOM
Many cmdlets have a built-in -ComputerName parameter that will allow for remote access without using the new PowerShell remoting. For this to work,...
Creating Local Admins (Part 2)
In a previous tip, we showed you how to create a new local admin account using ADSI. On Windows 7 and Server 2008, it is much easier to use net.exe...
Creating Local Admins
Here is a piece of code that will create a local user account and put it into the local Administrators group: $computername = $env:computername #...
Adding Members to Local Group
To manage local groups, you can think about using net.exe. It may be much easier than using COM interfaces. The next line will add a local user...
Bulk Renaming Files
Rename-Item can rename hundreds of files in one step. Have a look: $global:i = 1 dir c:\test1\ -Filter cover*.jpg | Rename-Item -NewName {...
Monitoring Folder Content
You can use a FileSystemWatcher object to monitor a folder and write a log for all newly created files. For example, this can be used as an...
Renaming Computers
PowerShell can also rename computers. The next example will read the serial number from the system enclosure class and rename the computer...
Returning Array in One Chunk
In a previous tip, we showed you how adding a single comma can change the way functions return arrays. With this trick, you can force a PowerShell...
Return Arrays
Normally, PowerShell will not preserve the type of an array returned by a function. It is always reduced to Object[]: function test {...
Put a PowerShell Shortcut on Your Desktop
Here is how you can create new shortcuts, such as a desktop shortcut to PowerShell: $shell = New-Object -ComObject WScript.Shell $lnk =...
Validating Function Parameters
You can use Regular Expression patterns to validate function parameters: function Get-ZIPCode { param( [ValidatePattern('^\d{5}$')] [String]...
Re-Encoding ISE-Scripts in UTF8
PowerShell ISE by default saves .PS1 scripts in a highly unusual big endian Unicode encoding. For example, you cannot digitally sign such files.....
Solving Problems with Parenthesis
You use parenthesis in PowerShell to control an execution order. However, some language keywords are not legal inside parenthesis, like try and...
Removing CSV Headers
Try this to remove column headers from a CSV file: $result = get-process | ConvertTo-Csv -Delimiter ";" $count = $result.Count -1...