This script can be used to query an SQL database $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString =...
Query a SQL database with Powershell
read more
Free tools
KB: Selection of PowerShell Resources
Microsoft Windows PowerShell Infographic: Why DBAs Should Learn PowerShell? Whitepaper: The Guide to Learning PowerShell Geek Sync Webcasts: The...
Get server hostnames on which MSSQLServer service is installed
With this simple script, you will be able to get the server names on which the MS SQL Server service is installed. First, an array is built with the...
News from the General Manager: A Report to our Customers on Embarcadero’s Plans
Developers are under increasing pressure to reduce development cycles and keep up with changing platforms. Here’s how Embarcadero is making that...
KB: link to blog post “Updated Free Tool: PowerShell Scripts for SQL Server 5.0”
The hyperlink to the Community blog post “Updated Free Tool: PowerShell Scripts for SQL Server 5.0” is...
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL...
Virtual Machine Snapshots versus Database Backups
Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient...
Updated Free Tool: PowerShell Scripts for SQL Server 5.0: Added Center for Internet Security (CIS) Benchmarks
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 30 new scripts for Center for Internet Security...
Updated Free Tool: PowerShell Scripts for SQL Server 4.0: Added 13 Scripts
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release supports SQL Server 2016 and 2017, and Windows Server...
New Free Tool: SQL Data Profiler
IDERA released a new free tool, SQL Data Profiler, designed to provide quick visibility into data patterns contained in SQL Server databases. Its...
KB: link to blog post “New Free Tool: SQL Data Profiler”
The hyperlink to the Community blog post "New Free Tool: SQL Data Profiler" is...
How to Build the Essential SQL Server Administration Tool Chest
A well-equipped tool chest is essential for completing jobs around the home — everything from hanging a picture frame to putting together...
New Free Tool: Rapid Database Extractor
IDERA released a new free tool, Rapid Database Extractor, designed to help you gain quick visibility into SQL Server and Oracle databases from a...
KB: link to blog post “New Free Tool: SQL Query Store Optimizer”
The hyperlink to the Community blog post "New Free Tool: SQL Query Store Optimizer" is...
New Free Tool: SQL Query Store Optimizer
IDERA released a new free tool, SQL Query Store Optimizer, designed to help you improve the performance of SQL Server 2016’s Query Store....