PowerShell 6 is open-source and maintained in a public repository on GitHub. There are frequent releases. If you don’t want to dig your way...
database-tools
Do not leave your most valuable backups to chance
Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day....
DevOps and the DBA
Modern application development teams are aligned to deliver software using agile methodologies and a DevOps approach. Agile and DevOps are not the...
Enjoy May Day without “mayday” – protect your SQL Server data
May 1st is traditionally celebrated as “May Day” to welcome the return of spring. In Central Texas, we often get a lot of rain in the...
Finding Latest PowerShell 6 Release
PowerShell 6 is open-source, and there are frequently new releases available. You can always visit https://github.com/PowerShell/PowerShell/releases...
PowerShell ISE Module Browser
If you are using the built-in PowerShell ISE, you might find the “Module Browser Add-on” useful. It is fairly old and was published in...
How to Create High Quality SQL Code that is Easy to Edit. – Aqua Data Studio IDE
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Converting SecureString to String
Sometimes it can make sense to convert a SecureString back to a regular string, for example because you have used the shielded input provided by...
Real-Time Processing for Language Structures
In the previous tip we looked at queues and how they can search the entire file system: # create a new queue $dirs =...
Using a Queue instead of a Recursion
Rather than calling functions recursively, you may at times want to use a Queue object that you can load with fresh tasks while you are unloading...
Selected strengths of SQL Diagnostic Manager
In many organizations today, Microsoft SQL Server supports applications that are critical to organizations where downtime and poor performance has...
Finding Service Privileges
Get-Service can provide basic information about Windows services but won’t list the required privileges. Here is a small PowerShell function...
Using Variable Breakpoints (Part 2)
In the previous tip we examined Set-PSBreakpoint to create dynamic variable breakpoints in PowerShell. We showed how a breakpoint can trigger when a...
Destination URLs or IPs on the web for SQLCM
We are installing SQL Compliance Manager and our IT security guys will not allow us to open access to the Internet without a list of websites or IP...
Transaction Tracking res ipsa loquitur
"Res ipsa loquitor" means it speaks for itself. End-user transaction monitoring is Precise's specialty. This screen shows...
Navigating the Database – Aqua Data Studio Database IDE
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Using Variable Breakpoints (Part 1)
For debugging, variable breakpoints can be of invaluable help. They break into the debugger once a variable changes. If you know that a variable...
Real User Management, transaction tracking
"Res ipsa loquitor" means it speaks for itself. End-user transaction monitoring is Precise's specialty. This screen shows a list of the...
Hiding Properties in Return Results
By default, PowerShell shrink-fits most objects and shows only the most important properties by default: PS C:\> Get-WmiObject -Class Win32_BIOS...
Snowflake Magic! with Aqua Data Studio
Howdy, y'all! Happy Thursday! Today we will be exploring the exciting world of Cloud Data warehouses and my personal favorite,...
Locking Workstation
PowerShell can access low-level API functions by using C#-style signatures. This way, API functions are compiled in-memory and added as new types....
Command Discovery Unleashed (Part 2)
When you enter a command in PowerShell, the engine triggers three events to actually discover the command you want to execute. This gives you a...
Aqua Data Studio does the Magic Again! Salesforce Connectivity!
Howdy, y'all! I am here again with another cool Aqua Data Studio blog. I would like to credit this blog post to my colleague for setting...
Command Discovery Unleashed (Part 1)
Whenever you enter a command in PowerShell, a series of events takes place to figure out where the command is located. This starts with a...