Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
2,137 reads
PowerShell
Managing Power BI Workspaces with PowerShell
In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.
2020-11-02
Execute SSIS Package from PowerShell - Part 1
In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.
2020-10-27
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,851 reads
SQL Server High CPU Query Use Monitoring with PowerShell
In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.
2020-10-06
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,328 reads
SQL Server Wait Stats Monitoring with PowerShell
In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.
2020-09-15
How to Use Parameters in PowerShell Part II
PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more.
2020-09-07
Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
2,947 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers