In our last tip we explained how you can hide parameters from IntelliSense. This has a cool side effect that we’d like to point you to today!...
Hiding Common Parameters
read more
database-tools
Turning Objects into Hash Tables
In one of the previous tips we examined how Get-Member can retrieve the property names for an object. Here is another use case that takes any...
Introducing the 2018-2019 Class of IDERA ACEs!
Introducing the 2018-2019 Class of IDERA ACEs! We are excited to introduce our 2018-2019 class of IDERA ACEs! This program helps active members of...
Hiding Parameters
In the previous tip we explained how you can dump all the legal values for a PowerShell attribute. Today we’ll take a look at the [Parameter()]...
Aqua Data Studio's Powerful Data Grid
One of the most overlooked powerful features in Aqua Data Studio is the Data Grid. The data grid can double your productivity with Data Management....
Exploring PowerShell Attribute Values
As you might know, you can add attributes to variables and parameters to more specifically define them. For example, the line below defines a...
November #SQLChat – Let’s Talk About Data Analysis!
A solid data analysis process and capable tools are key components of a strong data professional's skill set. Join IDERA (@Idera_Software) and...
Learn more about SQL Server statistics
Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are...
Reverse Engineer SnowFlake from IDERA ER/Studio
Howdy! In this short and concise blog post, I am really excited to be sharing on how to reverse engineer from ER/Studio via ODBC. Step 1 -->...
Using Dynamic Parameters
Most PowerShell functions use static parameters. They are defined in a param() block and are always present. A little-known fact is that you can...
Accessing Website Content
Typically, it is trivial for PowerShell to retrieve raw HTML website content by using Invoke-WebRequest. A script can then take the HTML content and...
Accepting Different Parameter Types
Occasionally, you might want to create a function that accepts different parameter types. Let’s say you want the user to be able to either submit an...
Data Architecture: The Foundation for Enterprise Architecture and Governance
"Data modeling is all about understanding the data within our organizations and then representing this data in a precise visual (the...
Translating VBScript to PowerShell
Most old VBS scripts can be easily translated to PowerShell. The key command in VBS is “CreateObject” which lets you access system libraries....
Invoking Excel Macros from PowerShell
PowerShell can invoke Microsoft Excel sheets and start contained macros. While this would work with an invisible Excel application window, it is a...
How to balance database security versus database performance
The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database...
Programmatically listing any Cmdlet or Function Parameters
Ever wondered how you can list all properties exposed by a function or cmdlet? Here is how: Get-Help Get-Service -Parameter * | Select-Object...
How to Find and Fix SQL Server Deadlocks
Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...
Examining Object Properties Programmatically
Whether you import a CSV list into PowerShell using Import-Csv, or deal with any other type of objects: how can you automatically determine the...
Data Modeling Still Important in a Big Data, Analytics World
As more organizations embrace big data and analytics to gain insight from extremely large data sets the tools and systems that we use to manage data...
Accessing Hidden (Private) Member
[System.Management.Automation.ModuleIntrinsics _i="0" _address="0.0.0.0" theme_builder_area="post_content"...
GDPR vs CCPA – A Quick Look
On June 28th, 2018, California enacted the California Consumer Privacy Act (CCPA). It will go into effect on January 1, 2020. Guidelines must...
Performance (Part 3): Faster Pipeline Functions
In previous tips we illustrated how you can improve loops and especially pipeline operations. To transfer this knowledge to functions, take a look...
Performance (Part 2): From 2 sec to 200ms
In the previous tip we added considerable speed to a common script pattern. Now, let’s squeeze out even more performance with a pretty unusual...