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

Operate Your Own PowerShell Gallery

With PowerShellGet, you can easily share PowerShell code. Go to www.powershellgallery.com and download the MSI installer to install PowerShellGet if...

Identifying Special Characters

If you must ensure that a string contains only a given set of characters, try this: $text = 'tobias.weltner' $hasOtherCharacters = $text...

Inserting Text into String

Use Insert() to insert new text into an existing string at a given position. Here is an example: $text = "Server failed" 1..100 |...

Dealing With Long File Names

The Windows file system often has issues with file paths longer than 256 characters. Provided you followed our tips and installed PowerShellGet, you...

Colorizing PowerShell Console

In PowerShell 5.0, when you enter code into the PowerShell console, the tokens get colorized, much similar to the PowerShell ISE interactive...

Check PowerShell Gallery Code

In the previous tip we introduced the PowerShell Gallery and showed how to download content (scripts and modules). Since the PowerShell Gallery is a...

Using PowerShell Gallery

The PowerShell Gallery is a public repository for PowerShell scripts and modules. It is entirely managed by cmdlets. Before you can use the...

Nested PowerShell Transcripts

In previous versions of PowerShell, session logging (transcripts) were supported only in the PowerShell console, and there could only be one...

Logging PowerShell Sessions

PowerShell always supported session logging in the PowerShell console. Simply enter Start-Transcript to log all input and output to a text file....

Ad-hoc Debugging in PowerShell ISE

Beginning with PowerShell 5.0, you can break into the debugger any time (in the PowerShell ISE). Simply press CTRL+B to invoke the debugger while a...

Revealing Function Source Code

Many of the PowerShell commands are made out of functions. Here is how you can peek into the source code of any function: (Get-Command...

Finding Useful .NET Types

You may have heard about "type accelerators": they are shortcuts for the long .NET type name: PS> [XML] IsPublic IsSerial Name BaseType...

Automatic Unrolling Can Fail

Beginning with PowerShell 3.0, there is a new feature called "Automatic Unrolling": when you specify a property or method on an array, then the...

New Where-Syntax

In PowerShell 4.0 and better, there is a new alternative to the Where-Object cmdlet: $all = Get-Service $all | Where-Object { $_.Status -eq...

Create New XML Item Programmatically

In a previous tip we explained how you can clone an existing XML item to add a new item. This works only when there are already some items in the...

Remove an Item from an XML Document

Removing items from an XML document is almost trivial: you use XPath to identify the node you want to remove, then remove it. Once you save the XML...

Adding New Nodes to an XML Document

If you need to add new items to an XML document that already contains such items, the easiest way is to search for an existing item, then clone it....

Updating XML Content Using XPath

You can use Select-Xml to select content from an XML file, and then change or update its values. This is very powerful. You just need to get...

Updating XML Content

If you need to make changes to an existing XML document, for example to update inventory data, the easiest way is to load the document into an XML...

Reading XML Content

Reading XML formatted text is easy when you use an XML object for it. With its method Load(), you can read in content from a file path or a URL. In...

Designing XML Documents

Today we start a little mini series about XML. To create sample data to play with, you will first create a well-formed XML. While you can create XML...

Finding Out UTC Time

When you work in a global environment, it sometimes becomes necessary to translate the local time to UTC (Universal Time). The conversion is done by...

Fast String Operations

String concatenation is a frequent thing in scripts but when you use the "+=" operator to append text to a string, this slows down your...

Parse an Exact Date

If you need to parse a date or time information out of raw text, and if the date and time format does not adhere to the standards of your operating...

Faster Array Manipulations

The "+=" operator is pretty convenient and can add new elements to an array. If you need this more than once, for example in a loop, then...

Copy Command History to a Script

Sometimes you may have played around with the interactive PowerShell and suddenly realized that some of the commands you played with were pretty...

Compare Versions

Ever wanted to compare software versions? If you do it like this, the result is off: PS> '3.12.11.100' -gt '11.1.22.91' True...

Cleverly Aborting Endless Loop

In a previous tip you have seen how an endless loop can be used to continuously monitor things - until PowerShell is closed, or a user presses...

1 35 36 37 38 39 95