This post contains a short SQL Server query to get storage info for the disks hosting your instance’s database files without having to RDP into its host VM. The query …
script
-
-
I’ve been messing around with routers this weekend, and I’ve decided to write a PowerShell script to decode Asus router configuration backup files. The script is inspired by this Bash …
-
This brief post contains a script that can help switch a whole SQL Server instance, model and all user databases, to SIMPLE recovery. The script is useful in case of …
-
This post demos a PowerShell script that I’ve put together to automate the configuration of the static TCP port, and the addition of firewall rules, for a SQL Server instance. …
-
This is a brief post containing a script you can use to delete extra tempdb data files and avoid the “file not empty” (Msg 5042) error. I’ve occasionally ran into …
-
In this post I cover a script I’ve put together for measuring storage write speeds in SQL Server, namely against database data files. This is meant to help get an …
-
This is a brief post containing a script to grant permissions on functions and stored procedures to a database user or role in SQL Server. Every few months I end …
-
While working on updating the PSBlitz script that retrieves statistics info for a SQL Server database, I’ve decided I should also make it available in a blog post and add …
-
This post contains a script I’ve put together to get database sizes in SQL Server along with some additional info like file counts per file types and their sizes in …
-
Ever needed a script to kill multiple sessions on your SQL Server instance, but still required some level of control over what was being targeted? This script might come in …