posts-powershell

Categories

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 WindowsPowerShell

Text-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...

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...

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 {...

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...

1 69 70 71 72 73 95