Hello, I am using aqua data studio visual analytics for visualization of some data. I have build multiple worksheets which are using same sql...
database-tools
Announcing General Availability of DB PowerStudio, version 18.2
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...
Outputting Color
Occasionally, PowerShell code is supposed to output warnings and reports, so colors can add more readability to it. Traditionally, PowerShell...
Better PowerShell Prompts (Part 2)
In the previous tip we illustrated how you can define your own “prompt” function to customize the PowerShell prompt. One useful item could be to...
Better PowerShell Prompts (Part 1)
I know today’s tip isn’t brand new but considering how many people start using PowerShell, it’s worth mentioning again. By default, the PowerShell...
Reading Recently Installed Software (Improvement #3)
When reading event log data with Get-WinEvent, in the previous tip we explained how you can use the “Properties” property to extract the event...
Reading Recently Installed Software (Improvement #1)
In the previous tip we used Get-WinEvent to read the Windows event log system and get a list of recently installed software, similar to this:...
Is ER/Studio Data Architect really the best data modeling tool?
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...
Reading Recently Installed Software
The MSI installer logs all successful software installation to the Windows event log system. Here is a one-liner that can read back that...
Announcing the General Availability of Aqua Data Studio, Version 22.2!
Aqua Data Studio is the industry leading multi-platform Database Integrated Development Environment (IDE) with Visual Analytics. Data and...
Gathering Forensic Process Info
In order to better understand the processes that run on a server, and possibly identify traces of unwanted processes, PowerShell can dump forensic...
Announcing General Availability of SQL Inventory Manager 2.6.3
We’re excited to announce the release of SQL Inventory Manager 2.6.3 Database administrators need a simple, efficient way to discover, document, and...
Organizing Chaos with PSWorkItems and PowerShell
I spend my working days living in a PowerShell console. Over the years, I’ve developed many PowerShell modules to help me manage the chaos that is...
Announcing the GA of SQL Enterprise Job Manager 2.4
We’re excited to announce the release of SQL Enterprise Job Manager 2.4 SQL Enterprise Job Manager is an industry leading monitoring, scheduling and...
Announcing the General Availability of SQL Secure 4.1
We are pleased to announce the general availability of SQL Secure 4.1 SQL Secure is the industry-leading, state of the art auditing and security...
Infor Compass JDBC Driver / Infor Compass JDBC Driver.ionapi
Does anyone have an example of setting up a ADS server using the Infor Compass JDBC Driver and their oAuth file(Infor Compass JDBC Driver.ionapi)?...
Communication Link failure
I'm using the latest version of Aqua Data studio and have created a connection to a remote MySQL server. Everything was fine a week or so...
Incorporating compound IF THEN ELSE ELSE statements using query builder functions?
Haven't tried this before, but I'm trying to idiot proof a set of query's and make the held values understandable by the end user while utilizing...
Logging Variable Types
As part of your debugging and quality control you may want to log the data that gets assigned to individual variables. For example, you may want to...
Converting Language IDs in Language Names
In our previous mini series we showed different approaches to get to the names of installed OS languages using different PowerShell methods. The...
Announcing the Release of SQL Safe Backup 9.1
We’re excited to announce the release of SQL Safe Backup 9.1 SQL Safe Backup provides the industry's shortest time from starting a SQL Server backup...
Determining Language Packs (Part 3)
In part 2 of this series, you already witnessed how much easier and faster it was to query the list of installed operating system languages using...
Determining Language Packs (Part 2)
In part 2 of this series, we’d like to solve our puzzle – getting installed language packs – by using the built-in PowerShell features. In part 1 we...
Use better tools for SQL Server backup
Not knowing what tools are available There are several tools that come with SQL Server that can be used for backup processing, such as SQL Server...