Category: SQL Server Tools
This category contains all articles and posts about SQL Server tools
-
Management Studio tip – A menu driven RunAs launcher batch file to open SSMS using multiple different login credentials
Tired of repeatedly launching SQL Server Management Studio (SSMS) with different Windows accounts? This post provides a lightweight, menu-driven batch file that lets you choose the required security context and open SSMS instantly. It’s a simple productivity tool that’s ideal for DBAs and developers who regularly work across multiple domains, environments, or privileged accounts.
-
How to compare the server configuration and settings (sp_configure settings) of two SQL instances and identify the differences?
Have you ever wanted to compare the server configuration settings of two SQL Servers, but struggled with creating linked servers between the servers or by manually comparing the data? No longer! This post provides you with a PowerShell script, that takes two SQL Server names as input parameters, quickly compares the server configuration and highlights…
-
SQLScriptRunner – A free PowerShell tool for deploying/executing scripts across multiple SQL Servers
Need to run or deploy scripts across multiple SQL Servers in your estate? This page provides you with a free PowerShell script that can be used to deploy or execute SQL Server scripts across any number of SQL Servers in your estate.
-
How to search all character columns of all tables in your database for a specific search string or keyword?
Have you ever had a need to search for a specific string across all the tables in your database? Surprisingly this does seem like a
-
What is sp_WhoIsActive? How to deploy and configure it, as well as maintain the collected data?
If you’ve been an SQL Server DBA for a while, chances are you are already familiar with sp_WhoIsActive, a comprehensive, free, lightweight stored procedure developed
-
How to send email for free, from SQL Server using Database Mail feature?
You can use the Database Mail feature of SQL Server to send emails. Thesse can be ad hoc emails, or could be sent from within
-
SQLPing: A PowerShell tool that pings SQL Server rather than a host
As IT professionals and system administrators, we all are familiar with the command line tool Ping. We all use it, all the time, to see
Latest Articles
