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 …
Category:
Scripts
-
-
This post contains a script that I’ve written and used a few times when I’ve needed to search for a string in an entire SQL Server database. You can find …
-
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 query database sizes in SQL Server along with some additional info like file counts per file types and their sizes in …
-
This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression …
-
Version 2.1.0 of the PSBlitz SQL Server diagnostics collection and output tool brings bug fixes, quality of life enhancements, and added diagnostics data. Enhancements Additional diagnostics data The following sheets …
-
PSBlitz is a PowerShell script that outputs SQL Server health and performance diagnostics data to Excel and saves execution plans and deadlock graphs as .sqlplan and .xdl files. Introduction Since …
-
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 …
Older Posts