Category:

Scripts

Scripts SQL Server
Script to get database sizes in SQL Server

by Vlad Drumea September 16, 2023

by Vlad Drumea September 16, 2023 3 comments

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 …

8 Facebook Twitter Linkedin Reddit Copy Link Email
Scripts SQL Server
Script to get table sizes in SQL Server

by Vlad Drumea August 24, 2023

by Vlad Drumea August 24, 2023 2 comments

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 …

8 Facebook Twitter Linkedin Reddit Copy Link Email
PowerShell Scripts SQL Server
PSBlitz – 2.1.0 update

by Vlad Drumea December 6, 2022

by Vlad Drumea December 6, 2022 0 comments

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 …

2 Facebook Twitter Linkedin Reddit Copy Link Email
PowerShell Scripts SQL Server
PSBlitz – Easily outputs SQL Server diagnostics data

by Vlad Drumea September 15, 2022

by Vlad Drumea September 15, 2022 10 comments

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 …

4 Facebook Twitter Linkedin Reddit Copy Link Email
Scripts SQL Server
T-SQL script to kill multiple sessions in one go

by Vlad Drumea March 2, 2021

by Vlad Drumea March 2, 2021 0 comments

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 …

4 Facebook Twitter Linkedin Reddit Copy Link Email

Older Posts

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duration	Description
cookielawinfo-checbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.