sp_who, sp_who2 & sp_whoisactive
Sp_whatnow? sp_who, sp_who2 and sp_whoisactive are stored procedures that allow you to view current users, sessions, and processes within a SQL Server instance.
Get Database Growth Events in SQL Server
This post contains a script to get database and log file growth events on a SQL Server instance. I often find a need to use this script to check what databases have been growing on unmonitored SQL Servers.
Geographical Spatial Environmental Mental
The title is just words thrown together. I’m glad you noticed. This post is the start of a “Study Blog” category, which is more or less a scribble pad for when I’m watching a video or reading stuff.
Show Line Numbers in SQL Server Management Studio (SSMS)
This is a tip on how to show line numbers in the SQL Server Management Studio (SSMS) query window. This is useful when you receive an error message with reference to a line in your code, although it’s not a necessity to have it enabled as you’ll see in the demo below.
Show Available Disk Space in SQL Server
This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a SQL Server host.
Killing SQL Server Processes (SPIDs)
There are many reasons why you’d KILL a SPID in SQL Server. Whether it’s impending disk space doom due to data or log file bloat, or a long running query that’s lost in space…
Renaming a computer that hosts SQL Server
When changing the hostname of a computer running SQL Server, system metadata must be updated so that remote connections and applications do not lose connectivity.
Installing SQL Server 2017
Installing SQL is a straight-forward task… but it’s important that things are in-place from the get-go to prevent having to make changes on a live system.
Get Estimated Database Restore Time
If you’re backing up or restoring a large database in SQL Server, you can run the SQL script in this post to find out how long it has left to complete.
