You are here

Monthly archive

TSQL - Make Excel Link In Output

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and then search through hundreds of images to find the one corresponding with that user.  Sure, they were in numerical order, but still, what a pain!  He wanted to generate an excel file with links to files to quickly access the corresponding image. 

TSQL - Get All Queries Currently Running

This is perhaps my most commonly used query when troubleshooting.

PowerShell - Update All SQL Services To Restart On Failure

PowerShell script to quickly change all Recovery Options to "Restart the Service".

PowerShell - Create And Write Out To Log File

Creating and writing to output file in PowerShell.

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
6 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer