PowerShell uses execution policy to determine which scripts to run. There are in fact five scopes where execution policy can be defined, and to see...
database-tools
Highlights: Become better at monitoring MySQL & MariaDB using Monyog
Thank you everyone who attended our Webinar on "Become better at monitoring MySQL & MariaDB using Monyog". The webinar witnessed...
Checking Execution Policy
Execution policy determines what kind of scripts PowerShell will execute. You need to set execution policy to something other than Undefined,...
Let’s Discuss Migrating to the Cloud!
It’s that time again! Our next #SQLChat will take place Wednesday, March 15 at 11 AM CT with Mike Fal. Mike will be leading a discussion on...
Classes (Static Members – Part 6)
Classes can define so-called “static” members. Static members (properties and methods) can be invoked by the class itself and do not...
Using Classes (Constructors – Part 5)
Classes can have so-called constructors. Constructors are methods that initialize a new object. Constructors are simply methods that share the name...
Using Classes (Overloading – Part 4)
Methods in classes can be overloaded: you can define multiple methods with the same name but different parameters. This works similar to parameter...
Using Classes (Adding Methods – Part 3)
One of the great advantages of classes vs. [PSCustomObject] is their ability to also define methods (commands). Here is an example that implements a...
Webinar: Become better at monitoring MySQL & MariaDB using Monyog
Thu, Feb 9, 2017 11:00 AM - 12:00 PM PST Come and listen to Shree Nair, Product Manager at Webyog, discuss how DBAs can avoid the visibility gap...
Using Classes (Initializing Properties – Part 2)
Class properties can be assigned a mandatory type and a default value. When you instantiate an object from a class, the properties are pre-populated...
Using Classes (Creating Objects – Part 1)
Beginning in PowerShell 5, there is a new keyword called “class”. It creates new classes for you. You can use classes as a blue print...
Using “Using Namespace”
Working with .NET type names can be tiring because these names can be long. Here is an example: #requires -Version 2.0 Add-Type -AssemblyName...
Determining Person Age
How do you calculate the age of a person, based on birthday? You can subtract the current time delivered by Get-Date from the birthday, but the...
Speeding Up New-Object Synthesizer
New-Object creates new instances of objects, and you have seen one example in the past “Speech Week”: PowerShell was able to create a...
Become a Community Member to Score a New Duck!
Still don’t have a Hippie Duck? They are back for a limited time only! The first 100 people to make a new account on the IDERA community will...
Speech-Week: Using Advanced Speech Synthesizer Options Synthesizer
The .NET speech engine accepts more than just plain text. If you use SpeakSsml() instead of Speak(), you can use XML to switch languages, speak...
I/O Efficiency – Storage Performance Optimization
In a typical business application, data builds over time as sales are recorded. Data is stored in blocks for tables and leaf pages for indices....
Speech-Week: Recording Voice to File Synthesizer
The built-in Microsoft text to speech engine can save audio to a file. This way, you can auto-generate WAV files. Here is an example: it creates a...
Precise Upgrade – Release Cadence 2X per year | It pays to stay current
Precise is on a release cadence of twice per year. Precise version 9.7.0's theme is infrastructure modernization. The release notes...
Precise Detects Problem In VMware Storage
Our demo environment had a storage hardware outage. Here is the timeline and how the issue appeared in Precise for SQL Server. 1/9/17- Data Center...
Speech-Week: Using Different Voices with Speech Synthesizer
In the previous tip we showed how you can tap into the text to speech converter and speak out text. Here is a way to find out the installed...
erwin Announces DM 9.7 – Why All the Fanfare?
You may have seen erwin's recent press release contents announcing DM 9.7 on January 23rd, containing a number of new (to erwin)...
Speech-Week: Using a Speech Synthesizer
When you add the assembly “System.Speech” to PowerShell, there is a new type called “SpeechSynthesizer” which can be used to...
Adding and Removing Backslashes
For path components, it is often necessary to “normalize” paths and, for example, make sure they all end with a backslash. Some try code...