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

Finding Maximum Values

Numeric types can store numbers in certain ranges. A byte for example stores values in the range 0-255. But do you know just what the range is for...

Finding Days in Month

If you need to determine the days in a given month, you can use the static DaysInMonth() function provided by the DateTime type. As you can see, the...

Finding Leap Years

You will find that the DateTime type supports a number of static methods to check dates. For example, you can check whether a year is a leap year...

Getting Short Dates

Objects contain useful methods to access the object data. For example, DateTime objects support methods to display the date and time in various...

Getting Alphabetical Listings

Unfortunately, PowerShells special ".." operator only supports numeric ranges: 1..10 You can use type conversion to get a range of...

Counting Special Characters

Type conversion can help you count special characters in a text. For example, if you'd like to find out the number of tab characters in a text,...

Chaining Type Conversions

In PowerShell, you can do multiple sequential type conversions. For example, you should first convert the string into a character array and then...

Accessing Event Logs via Conversion

You will find that type conversion can do amazing things. For example, the next line accesses a system log by converting the log name to an EventLog...

Finding WMI Instance Path Names

In a previous tip, you learned about how to access WMI instances directly using their individual instance path. Here is how you can find that path...

Type Accelerators

PowerShell has a few shortcuts for popular .NET types like [WMI], [ADSI] or [Int]. You should read the FullName property if you'd like to know...

Comparing Versions

When you compare version strings, PowerShell will use alphanumeric algorithms, which may lead to confusing results: '3.4.22.12' -gt...

View Object Inheritance

A hidden object property called "PSTypeNames" will tell you the object type as well as the inherited chain: (Get-WMIObject...

Using Scripts to Validate Input

For tricky validation checks, you should use arbitrary PowerShell code to validate. The function Copy-OldFiles will only accept files (no folders)...

Restrict Input to Numeric Ranges

Let's say you'd like to set the PowerShell console cursor size. This size must be a number between 0 and 100. The following template will...

Converting Object Types

Once you know the name of an object type, you can use that type for conversion. The next line converts a string into a date-time type: [DateTime]...

Limiting String Input Length

If a function parameter should receive a string of a given length only, you should use the following validation attribute. In the example, it limits...

Limiting Number of Arguments

Function parameters can receive multiple values when they accept arrays. You should use this template to limit the number of values acceptable:...

Defining Alias Properties

Your functions can have properties with built-in alias names. The user can then either use the descriptive "long" name or its short and...

Validate Set of Inputs

If you need to limit a function parameter to only a set of allowed choices, you should use the next example: function Get-24hEventLogEntries...

Finding Cmdlets With a Given Parameter

Finding cmdlets by name is easy: Get-Command *service* -commandType Cmdlet But how can you list all cmdlets that support a given parameter? If...

Listing Internet Explorer Cookies

Have you ever wanted to find out who stored your information while you were surfing the Web? Check out your cookies folder: Dir...

Remove Recents Folder

Windows uses the special recents folder to remember which files you have opened. You can have a look to check what Windows has stored: Dir...

Bulk-Changing File Extensions

Changing file extensions can be a quick one-line operation. The next line renames all ps1 PowerShell script files found in your user profile and...

Displaying Hex Dumps

PowerShell can read plain text, but it can also read binary content. Here is a little function that creates a "hex dump" of any binary...

Reading File "Magic Number"

File types are not entirely dependent on file extension. Rather, binary files have internal ID numbers called "magic numbers" that tell...

Working with Path Names

The .NET System.IO.Path class has a number of very useful static methods that you can use to extract file extensions. Here is how you can get a list...

1 78 79 80 81 82 95