2016-04-27
PowerShell – Get All SQL Instances On Server
This script will return all SQL instances running on a server or list of servers. cls...
2016-04-20
PowerShell – Get “Logon As” Information From Remote (or local) Server
This was made possible by the Scripting Guy. I have boiled it down to the answer....
2016-04-14
T-SQL – Get Currently Running Jobs With Duration
Query to get all currently running jobs with their run duration in seconds. Source: http://www.sanssql.com/2013/08/t-sql-query-to-find-currently-running.html SELECT...
2016-04-14
Restore All Databases With Most Recent Backup
This is a bit of a scary task. Someone tells you about 87 databases that all...
2016-04-08
PowerShell – List All Directories With Users Who Can Access
Maybe this is a one-off type of thing, but if you need to see every folder...
2016-03-29
SQL Server – Database Stuck In Single User Mode
If you've painted yourself into the single_user corner, here is how you can get out.
2016-03-24
2016-03-24
Favorite Computer Environment Tools
The Deep Secrets of My Computing Environment!
In my computing environment, I have a set of tools that I rely on because they just make life easier. Here they are in order of (perceived) actual usage.
2016-03-23
SQL Server – Getting All SQL Services Running On System
Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services
2016-03-23
PowerShell – Getting All Running SQL Services
Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11″...