Aqua Data Studio simplifies data-centric tasks by working on data sources without exposure to complex technical elements, detailed technical skills,...
database-tools
Checking Battery Wear and Quality
Publishing on – Wed Feb 08 If you run a laptop you can easily ask WMI for battery status such as charging status. With a little bit more work,...
Using Enums to Decipher Code IDs
Publishing on Mon Feb 06 WMI is a great and simple way of gathering information about computers. For example, it’s a snap to determine the type of...
Manage data with Aqua Data Studio
Aqua Data Studio is the industry-leading, multiple-platform, integrated development environment (IDE) for data. It provides many benefits to a...
Using PowerShell Scripts as Commands (Part 2)
Publishing on Feruary 2, 2023 In our previous tip we discussed a simple way to extend the PowerShell command set. By saving scripts in a folder that...
Using PowerShell Scripts as Commands (Part 1)
One very simple way of extending PowerShell commands are scripts. To turn a script into a command, pick a folder and store the PowerShell script in...
Dumping Edge Cookies
If you’d like to find out (or document) the website cookies stored by the Edge browser, PowerShell can dump that information for you. The cookie...
Investigating PowerShell Command Results
HTML can be a simple way of formatting data for output reports. In this 3-part series, we first illustrate how you compose HTML reports, then show a...
Querying Advanced Printer Info via SNMP
Many network printer support SNMP to query information about the device, i.e. its serial number, the status and paper sizes of installed trays, or...
Subscribing to Session Lock/Unlock Events
Whenever a user on a Windows box locks his or her session, an event is emitted. Another event is emitted when you unlock your session again. Both...
Custom Action for Unknown Commands
Whenever you enter a command name that cannot be found by PowerShell, it can extend the command search by custom actions that you define. Here is a...
Managing File Shares
The Windows operating system ships with the “Storage” PowerShell module which can be used both from Windows PowerShell and PowerShell 7. One of the...
Showing Warning State in Taskbar Button
When your script needs attention, i.e. asking for user input, let’s turn its taskbar button in the Windows taskbar orange so the user immediately...
Showing Error State in Taskbar Button
When your script runs into an error, wouldn’t it be nice if the error state could be visually communicated via taskbar button? If the taskbar button...
Showing Indeterminate Progress in Taskbar Buttons
Occasionally, you do not know the exact progress of your script but you’d still like to inform the user that your script is “busy”. If you run your...
Showing Progress in Taskbar Buttons
If you run your PowerShell scripts on Windows, you can use the taskbar button as a progress indicator. All you need is install this module:...
DBTA Trend Setting Products 2023
DBTA Announces Idera, Inc. Portfolio of Products as the Trend Setting Products for 2023 “Today’s data environments are highly diverse—residing on...
The new release of SQLyog 13.2 provides one update and multiple bug fixes.
Update Upgraded the PLINK executable bundled with SQLyog to PuTTY/PLINK v 0.77, to support private keys generated in the PPK version 3 file format...
Announcing the General Availability of SQL Secure 4.2
We are pleased to announce the general availability of SQL Secure 4.2 SQL Secure is the industry-leading, state of the art auditing and security...
Identifying Multi-Language Online Documents (Part 2)
How can you automatically check the supported languages for an online document? Provided the URL uses a language ID, it’s easy to create a list of...
Careful with Arrays
Careful with ArraysWith PowerShell you never know whether a cmdlet returns an array or a single object. That’s because PowerShell automatically...
Query a SQL database with Powershell
This script can be used to query an SQL database $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString =...
SQL Server Security: Always Encrypted
Always Encrypted (AE) is a feature Microsoft introduced to SQL Server 2016. This post will provide an overview of AE and talk about how it can be...
What is Logical Data Modeling?
Logical data modeling is the second of the three stages of data modeling and one of three types of data model. The three types of data model -...