Databases are vitally crucial to modern businesses across all market sectors. They are the repository of an organization’s information resources,...
database-tools
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Harnessing Big Data: A Strategic Advantage for Modern Organizations
There are different claims regarding the coinage of the term big data, but the concept of big data has existed since the mid-20th Century....
Key Insights into Ensuring SQL Server Security with These Practices
There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017,...
Improve SQL Server Usage Management and Efficiency
If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to...
Identifying AD Accounts without Proper Encryption Type
You may have accounts (inc. trust accounts) in AD that have a null value for msds-SupportedEncryptionTypes. They may have been working "by accident"...
SpeculationControl: Use PowerShell to Check for Risks
Microsoft released a module a couple of years ago (updated 3 weeks ago) that you can use to identify whether your hardware is vulnerable against...
Creating ISO Files
PowerShell can turn regular folders into ISO files. ISO files are binary files that can be mounted and then behave like a read-only CD-ROM drive. In...
Initialize Transactional Replication from your Backups
This blog provides guidance on the perceived limitations and restrictions on initializing transactional replication subscribers from backups. The...
Automating Defender Antivirus (Part 2)
On Windows, PowerShell comes with cmdlets to automate the built-in antivirus engine “Defender”. In this second part, let’s take a look at how you...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
Converting Wavelength to RGB
PowerShell is a generic script language so you can do all kinds of stuff with it. Below is a function that takes a light wavelength and converts it...
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...
SQL Diagnostic Manager 12.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
Determining Language Packs (Part 1)
Let’s assume you need to find the installed language packs for a Windows machine. In this three-part series, we use PowerShell’s features to tackle...
Running $PSScriptRoot in Selected Code
One of the big pitfalls in PowerShell code is the automatic variable $PSScriptRoot which always holds the path to the folder the current script is...
Pasting Multiple Lines in PowerShell
When you copy multiple lines of PowerShell code and paste them into a shell window, the result often is not what you expect. PowerShell starts...
Cleaning Up PowerShell Modules (Part 2)
In part 1 we looked at removing PowerShell modules that were originally installed via “Install-Module”. You can as well remove PowerShell modules...
Cleaning Up PowerShell Modules (Part 1)
There are plenty of scripts available that promise to read the original Windows 10 product key from the registry by converting a series of binary...
Quickly Finding Outdated PowerShell Modules
In the most simplistic case, you can check all your installed modules for updates with just a one-liner (remove -WhatIf to actually perform the...
Analyze blocking for SQL Server
Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...
Using Efficient Lists in PowerShell
By default, PowerShell uses simple “object arrays” when you define lists, when commands return more than one result, or when you otherwise need to...
Managing File Shares on Windows with PowerShell (Part 1)
Windows comes with a module called “SMBShare” which contains 42 cmdlets to manage network shares. This module works with Windows PowerShell and...
Out-GridView with Custom Columns
Out-GridView can be a universal dialog when you use the -OutputMode or -PassThru parameters. When you do, a grid view window displays additional...
Converting Ticks to DateTime
Occasionally, date and time information are stored as “Ticks” in the format of a so-called “FileTime”. Ticks are 100-nanosecond units since...
Top 5 Benefits of Universal Database GUI
Universal database graphical user interfaces (GUIs) are among the most productive tools available to database administrators (DBAs) and developers....
Finding and Fixing Locking Issues on SQL Server Databases
In SQL Server, locking helps improve efficiency by preventing resources from being used simultaneously by different transactions. Issues with SQL...
Top 5 Reasons for Slow SQL Server Queries and How to Fix Them
Slow SQL Server Queries are a common issue among database administrators (DBAs). You would be hard-pressed to find a SQL Server DBA who was not...
Unlock Additional PowerShell Modules in Windows 10
Windows 10 comes with a number of PowerShell modules that you can use to control Server functionality - like WSUS Update Management which is only...
Exporting CSV without Quotes (and Other Conversion Tricks)
PowerShell comes with a bunch of Export- and ConvertTo- cmdlets so you can serialize object data to CSV, JSON, XML, and other formats. That’s great...
What Is an IDE? – The Difference Between IDEs and Code Editors
When evaluating integrated development environments vs. code editors, the right option comes down to your requirements. IDE's have a broad...