Update: This was my original solution to automate the DBA Checks process. I don’t recommend people use this solution as it doesn’t scale well to a larger number of servers and the CLR function used to get drive space requires the TRUSTWORTHY property to be enabled which can be a potential security …
Warning: the use of TRUSTWORTHY described in this article can be a potential security risk so you might want to consider alternative options. Using CLR (.NET Framework) code in SQL Server is a very powerful way of extending the built-in features and functionality. The .NET framework provides access …
This script is a simple utility to allow users to restore SQL Server databases. It’s easier to use for non-DBAs and it provides a method of restoring databases when the management tools are not installed. It’s a good demonstration of a HTA application, but it’s not a intended as a replacement for …
Check if the Windows calculator is running on the local computer. Easily customized to check if any process is running on the local or a remote computer.
Show running time and estimated time to go for SQL backup and restore operations.
Collects WMI information about a specified computer and displays a formatted HTML report. Also allows you to monitor and terminate running processes, connect to shares on the remote computer and shutdown/reboot the remote computer. Don’t be put off by the amount of code - just save the script as a …
Display a drive space report for multiple computers. This HTA can check the drives of multiple computers and produce a HTML report that will highlight any drives that are low on free space. The HTA also generates a CSV version of the report. The Drive Space Report is a GUI script that allows you to …
Extract user data from Active Directory to a CSV file. By default all users in the domain will be exported with attributes from the “General” page in ADU&C. The script is easy to modify if different criteria is required. See the “Setup” section to change criteria.
This function converts a string to proper case. e.g. Convert this: A LONG TIME AGO IN A GALAXY FAR, FAR AWAY To this: A Long Time Ago In A Galaxy Far, Far Away Note: It might be better to do this in the application rather than the database and it could be better written as a CLR function. This is …