There are many ways to create custom objects. Here's a creative solution that can be useful in many scenarios: create a text-based...
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 WindowsPowerShellFinding Scripts by Keyword
With an increasing number of PowerShell scripts on your hard drive, it can become hard to find the script you are looking for. Here's a helper...
Setting Monitor Brightness
If your display driver supports WMI, then you can change the display brightness using PowerShell - event on remote machines! Here's the...
Check Monitor Brightness
If you want to check your current display brightness (preferably on notebooks, of course), here's a quick function: function...
Creating Symbolic Links
Symbolic links work very similar to "regular" link files (*.lnk): they can point to virtually any file or folder and even UNC paths....
Testing Administrator Privileges
To test whether a script is run by an Administrator with full privileges (UAC elevated), here is an unusual approach that illustrates the enormous...
Creating Hard Links
Hard links are file "phantoms" in the NTFS file system. They make one file visible in multiple file system locations (within one volume)....
Showing Hidden Files in File Explorer
PowerShell can easily read and write to the Registry, the central store for Windows settings. Here's a function that can turn the display of...
Verbose Output for PowerShell Functions
To add on-demand verbose output to your PowerShell functions, make sure your functions support the common parameters by adding the CmdletBinding...
Copying Results to Clipboard
To easily copy cmdlet results to other applications, simply pipe them to clip.exe. Next, paste the results into whatever application you want:...
Turn Out-GridView into Selection Dialog
Finally, in PowerShell 3.0, Out-GridView can turn into a versatile selection dialog - just add the new parameter -PassThru and watch: $Title =...
Three Most Useful ISE Tricks
If you use PowerShell 3.0 and the ISE editor, then here are the three most useful tricks you should know: 1. Press CTRL+J to open a list of...
Vertical Grid View
You can always pipe objects to Out-GridView and get a nice extra window with all of the object properties lined up as table. That's useful if...
Go to Function Definition on F12
If you are into writing long and complex PowerShell code with a lot of functions, then this one is for you. In other development environments, when...
Adding New Type Accelerators in Powershell
If you find yourself using certain .NET types frequently, you may want to make your life easier and implement shortcuts. For example, there is a...
Finding Type Accelerators
PowerShell maintains a list of shortcuts for .NET types to make coding more convenient for you. For example, to convert a string to a DateTime type,...
Returning Multiple Values
A PowerShell function can return multiple values. To receive them, simply assign the result to multiple variables: function Get-DateTimeInfo { #...
Get Quotes From the Webservices
There are plenty of free webservices around, and provided you have direct Internet access (no proxy), you can use New-WebServiceProxy to access...
Using Safe Cmdlets Only
Let's assume you want to set up a restricted PowerShell v3 console that just provides access to Microsoft cmdlets with the verb Get. One way to...
Check Installed Server Roles and Features
Beginning with Server 2008 R2, there is a PowerShell module called ServerManager that you can use to manage server features and optional components....
Finding Published Printers
Finding printers that have been published in your Active Directory becomes trivial with Windows 8 or Server 2012. PS> Get-Printer -ComputerName...
Calculating Time Differences Using Custom Formats
Calculating time differences is easy - provided you can convert the date and time information into a DateTime type. If the date is in a custom...
Get CPU Load
To get the average total CPU load for your local system or a remote system, use Get-Counter. The example below returns the average total CPU load...
Calling WMI Methods with CIM Cmdlets
It can be very useful to call WMI methods, for example to create new shares, but in PowerShell v2 you had to know the names and exact order of...
Temporarily Activate High Performance Power Plan
It may be useful to automatically and temporarily switch to a "high performance" power plan from inside a script. Maybe you know that a...
Listing Power Plans
There is a somewhat hidden WMI namespace that holds WMI classes you can use to manage power plans. The code below lists all power plans on your...
Mixing DCOM and WSMan in WMI Queries
Using the new CIM cmdlets in PowerShell v3, you can run remote WMI queries against multiple computers using multiple remoting protocols. The sample...
New Operator -In
In PowerShell v3, you can use a new simplified syntax for Where-Object. Both lines below list all files in your Windows folder that are larger than...
Removing Leading "0" in IP Addresses
Leading "0" in IP addresses can cause confusion because many network commands interpret octets with leading "0" as octal...
CIM-Cmdlets Work Against Old Windows Boxes
The new CIM cmdlets require PowerShell v3, but you can still remotely target older boxes without PowerShell v3 or PowerShell at all. By default, CIM...