A hash is a way to uniquely identify a text without exposing the actual text. Hashes are used to identify texts, find duplicate file content, and...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- 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
Why should database administrators learn PowerShell?
Microsoft’s PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language that...
Pretty Out-GridView Dialog Boxes
When you pipe objects to Out-GridView, the cmdlet shows the default properties, so when you use a grid view window as a selection dialog, you have...
Comparing Data Sets and Object Scripts – Aqua Data Studio IDE
Last week, we discussed Generating and Executing Object SQL Scripts, and you can view that post here. In week 5 of our Improving the Daily...
Redirecting PowerShell Output to GridView
When you output data in PowerShell, it gets silently piped to Out-Default and ends up as text in the console. By overriding Out-Default, you can...
Compare AD User
Did you ever want to compare the properties of ADUsers? Provided you have installed the RSAT tools, you can read individual AD users with...
May #SQLChat – Designing Data Warehouses
IDERA’s #SQLChat is back! Join IDERA (@Idera_Software) and host Leslie Andrews (@landrews5807) on Wednesday May 29 at 11AM CT for...
Exporting and Importing Code-Signing Certificates
In the previous tip we explained how you can create self-signed code-signing certificates in Windows 10 and Server 2016 (and better). Today,...
How to be a better accidental database administrator
Data is more important than ever to business success. As data demands continue to skyrocket, many database administrators are given responsibilities...
Creating Code-Signing Certificates
Windows 10 and Server 2016 (and better) ship with an enhanced New-SelfSignedCert cmdlet that finally can create code-signing certificates. With...
Using Catalog Files to Maintain Folder Integrity
If you’d like to make sure a folder content stays untouched, you can use catalog files. A catalog file lists all folder content plus creates...
Generating and Executing Object SQL Scripts – Aqua Data Studio IDE
In week 4 of our Improving the Daily Life of a Database Developer blog series, we discuss the common task of generating and executing object...
Finding PowerShell Named Pipes
Each PowerShell host running PowerShell 5 or better opens a “named pipe” that you can detect. The code below identifies these named...
Finding the Latest PowerShell 6 Download URL
PowerShell 6 is open-source and maintained in a public repository on GitHub. There are frequent releases. Here is a way how you can find out the...
Finding Latest PowerShell 6 Release (and Download URLs)
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...
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...