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

Enabling PowerShell V.2 Remotely

Setting up the brand new PowerShell v.2 remotely in a domain environment is easy: simply run Set-WSManQuickConfig As long as you have proper...

Add New Properties To Your Objects

You can use Select-Object to add new properties to an existing object. In PowerShell v.2, Select-Object accepts a wildcard, which in turn adds all...

Calculating Time Differences

Use New-Timespan and submit a date if you'd like to know how long it is until next Christmas. New-Timespan automatically compares this date to the...

Analyze Parameter Binding

You probably know that PowerShell is pretty flexible when it comes to parameters you want to submit to cmdlets and functions. You can name them...

Why is my PowerShell console not blue?

When launching powershell.exe directly, you get a console with black background and only 300 lines of buffer text. When you launch PowerShell from...

Don’t be surprised by the Help bug

Get-Help is great for discovering cmdlet and function syntax but sometimes it fails on PowerShell v.2. Take a look at this: Get-Help...

Making Comment-Based Help Compatible

In a previous tip, you learned how to add Comment-Based Help information to your own functions so that Get-Help can auto-document the usage....

Using Comment-Based Help

PowerShell v.2 allows your functions to seamlessly integrate with the built-in PowerShell Help system. All you need to do is a Comment-Based- Help...

Using Block Comments

Another new feature in PowerShell v.2 is the introduction of a new block comment. Basically, anything you place between <# and #> will be...

Creating Custom Objects

PowerShell v.2 has a new trick for creating your very own objects that you can then pass to other cmdlets. It is a two-step process. First, create a...

Finding Hidden Parameter Shortcuts

Many cmdlet parameters have built-in alias names that you can use instead of the full parameter name. So instead of "dir -ErrorAction...

Shortcuts for Cmdlet Parameters

You can shorten parameter names since cmdlet parameters are sometimes long and hard to type in. You will only need to enter as much of a parameter...

Listing Cmdlet Parameters

Use this line if you need to get a quick list of all parameters that a given cmdlet supports along with a short description: Get-Help dir -para * |...

Finding Cmdlet Parameter Positions

You can find out which cmdlet parameters are positional by using this line: get-help dir -parameter * | Where-Object { $_.Position -as [Int] } |...

Using Positional Cmdlet Parameters

Cmdlets typically support a lot of parameters. For convenience, the most important ones have an assigned "position" so you can specify...

Network Segment Scan

In a previous tip, we created a Check-Online filter to eliminate offline systems from a list of IP addresses and computer names. Now, find out what...

Create Hardware Inventory

If you need to collect hardware and/or software information from a bunch of remote systems, you should take advantage of the Check-Online filter...

Filter Out Unavailable Servers

Even PowerShell v.1 has remarkable remoting capabilities--as long as you can make sure the target systems are online. Otherwise, you run into...

Finding Unused Drives

You can use a cmdlet called Test-Path to test whether a given path exists. However, existing drives not currently in use, such as a CD-ROM drive,...

Find Next Available Drive Letter

What if you needed to map network drives during log-on? You could use fixed drive letters, but what if those drive letters are already in use? Here...

Exporting Certificate With Private Key

Certificates are digital identities, and when you already own the private key to a certificate, you own this identity. You can then use these...

Exporting Certificate

PowerShell has a cert: drive that lets you explore all certificates installed on your system. Once you locate a certificate, you can then export it...

Listing Official PowerShell Verbs

As you probably know, PowerShell cmdlets adhere to a strict verb-noun syntax. You cannot choose just any verb when you compile your own cmdlets in a...

Asynchronous Downloads with BITS

In a previous tip, you learned how to use BITS on Windows 7 to download files in the background. One issue with this approach is that the download...

Download Files With BITS

Windows 7 comes with a new module called BitsTransfer. This allows you to schedule downloads so they can download in the background using the BITS...

Listing Cmdlets by Snap-In

While Get-Command delivers a list of available cmdlets, sometimes you'd like to find out which new cmdlets come from a specific snap-in....

Exploring Cmdlets Added by Snap-ins

You will find cmdlets available in PowerShell can come from two sources: PowerShell-SnapIns and (new in v.2) modules. Try this to see which cmdlets...

How Module Import Works

It is a good idea to check out how PowerShell v.2 automatically detects and loads all available system modules. Simply look at the definition of the...

1 85 86 87 88 89 95