In a previous tip, you learned how to add custom properties to objects. Today, we want to show you how to add custom methods and also give an...
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 WindowsPowerShellAdding Custom Properties
You may have heard that PowerShell can add custom properties to objects. While we are not going into much detail about this here, we'd like to...
CSV-Files With Culture
In a previous tip, you learned that CSV files use different separators, depending on your culture. While you were unable to select a separator in...
CSVs with Alternative Delimiters
In PowerShell V1, creating CSVs wasn't very flexible because PowerShell was limited to the comma as separator. In many cultures, different...
Persisting Objects with XML
In the previous tip, you learned that Export/Import-CSV does not persist property types. Instead, all properties are converted to string. To...
Import-CSV and Types
Export-CSV and Import-CSV are great ways of persisting data in a structured way. There are some limitations, though. Take a look. This line saves a...
PowerShell ISE uses Unicode
If you start experimenting with PowerShell V2 ISE (editor), you may notice that all scripts you create are saved in Unicode by default. This was...
Finding Alias Names in V2
Alias names are shortcuts for other commands, and you probably know that. In PowerShell V1, the only way to retrieve all aliases for a given target...
Storing Cmd-Results in PowerShell Variables
You can run classic cmd commands from within PowerShell and store the results in variables. All you need to do is invoke cmd.exe with the /c switch...
Using Classic Shell Inside of PowerShell
Since both PowerShell and the classic cmd.exe are console-based, it is very easy to switch between both of them. If you must use a classic shell...
Deleting Characters in the Console
Moving the cursor in long input lines is not very convenient. You cannot use the mouse and have to use arrow keys to move backwards and forward....
Why isn’t my console background blue?
Maybe you have noticed that some PowerShell consoles have a nice blueish background while others default to black. Actually, the blueish background...
Download Consolas Font For PowerShell
Well, ok, Consolas wasn't specifically designed for PowerShell but rather as an enhancement for all consoles. It is a new Microsoft font that...
Better Fonts And Larger Buffer
Each PowerShell console has a small icon at the left of its title bar, and when you right-click this icon and choose Properties, you open the...
Autocompleting the Console Way
There are many autocompletion tricks built into PowerShell, and you probably know that pressing TAB is always a good idea to save typing. There is...
Clear Command List
There are actually two places where your commands get stored: One is maintained by PowerShell (Get-History, Invoke-History). The other one is...
Selecting Previous Commands
In our last tip, you learned that F7 opens a dialog with your command history. To select a command, you had to use the arrow keys to move to the...
Open Console History
Did you know that the PowerShell console shares some key shortcuts with classic cmd consoles? For example, press F7 to open a menu with your command...
Docking PowerShell in Windows 7
If you happen to run Windows 7 already, not only will you get PowerShell V2. In addition, with the new "Superbar", you can create your...
Does a Folder contain a specific file?
Test-Path supports wildcards so if you'd like to know whether there are any PowerShell script files located in your home folder, try this:...
File Or Folder? Find Out!
Test-Path can check whether a file or folder exists, but this does not tell you whether the path specified was actually a file or a folder. If...
Test-Path Can Check More Than Files
Test-Path is your friend whenever you want to check whether a file or folder exists: Test-Path C:autoexec.batTest-Path C:windows Test-Path can check...
Creating A HTML Font List
With just a couple of lines of code, you can create a HTML document listing each installed type face on your computer which you then can print out...
Converting Objects Into Text
PowerShell internally always works with objects, and this can cause confusion when you mix object and string technologies. In a previous example,...
Listing All Installed Font Families
To get a list of all available font families on your system, you can load the .NET drawing library and then ask the InstalledFontCollection for all...
Finding Empty Folders
To find out all folders that contain no files, you can use this line: dir -recurse | Where-Object { $_.PSIsContainer } | Where-Object {...
List All Folders and Subfolders
Ever wanted to create a list of all folders and subfolders? It just takes one line: dir -recurse | Where-Object { $_.PSIsContainer } |...
List Hidden Files
Did you notice that Dir, ls or Get-ChildItem do not return hidden files? To see hidden files, you need to specify the -force parameter: Dir...
Converting FileSystem To NTFS
When you buy a new external USB drive, most of the time it is preformatted with the old FAT32 file system for compatibility reasons. You could...
Reading and Writing Drive Labels
Drive Labels are the names attached to logical disks. Using WMI, you can both read and write (change) drive labels. To read the existing drive...