When you enable ScriptBlockLogging, PowerShell logs all PowerShell code that is executed on your machine. Even if it is disabled, any...
database-tools
Welcome Webyog Social Media Followers!
We are excited to welcome Webyog into the Idera, Inc. family! In an effort to streamline all social media accounts, we are transitioning Webyog and...
SQL Diagnostic Manager 10.3 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through...
Manipulating Registry User Hive
Reading and writing values to the HKEY_LOCAL_USER hive in the registry is easy, because this hive is the same for all users. How would you read or...
SQL Diagnostic Manager for MySQL 8.7 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.7. Existing users may upgrade to this version through...
Initializing replication from backup
Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and...
Managing Windows Features (Part 2)
In Windows 10, unlike in Windows Server, you cannot use the Get-WindowsFeature and Add-WindowsFeature cmdlets to manage Windows features. However,...
Managing Windows Features (Part 1)
Windows 10 comes with a vast number of features, and only a subset is installed. Manually, you would open Control Panel and look at the Windows...
Simple Worthwhile Database Security Practices – Part III
Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed...
Running CMD commands in PowerShell
PowerShell by default does not support the native cmd.exe command such as „dir“. Instead, it uses historic aliases called...
IDERA Now Offers Safyr for ER/Studio
Hopefully you’ve seen the news by now, but if you haven’t, you should know that earlier this month, Silwood Technologies announced that...
Getting Excuses Automatically
Invoke-WebRequest can retrieve HTML info from web pages, and regular expressions can then scrape information from these pages. Here is some code...
Separating Variables in Expandable Strings
When you use double-quoted strings, you can expand variables inside of them like this: PS C:\> "Windir: $env:windir" Windir: C:\Windows...
Understanding database backup strategies
As seasoned database administrators, you should be well on top of your backup strategies. These strategies are not written in stone. It is a journey...
Finding Windows Build Numbers
When you run winver.exe, you can easily retrieve the full Windows build number. Reading the build number from PowerShell is not as obvious. There is...
Checking for USB Devices
If you’d like to know whether a specific device is attached to your computer, you can use WMI to dump the names of all plug&play devices:...
Migrating Schemas and Data with DBArtisan
DBArtisan is a product developed by IDERA. It is a multi-platform database administration tool that simplifies your day-to-day tasks. One of those...
Simple Worthwhile Database Security Practices – Part II
Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed...
Using PSGraph
PSGraph is an awesome free PowerShell library that you can use to visualize relationships. Before you can use PSGraph, you need to install its...
Using AD Filters with Cmdlets (Part 4)
In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results, and looked...
Using AD Filters with Cmdlets (Part 3)
In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results, and started...
Simple Worthwhile Database Security Practices – Part I
Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed...
Using AD Filters with Cmdlets (Part 2)
In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results. You learned...
How to Start SQL Server Performance Tuning
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...