Restoring a SQL Server Database
This is a simple guide to restoring a full backup file in SQL Server, covering a just a few options available during so.
Batch Deletions in SQL Server
This script will delete rows within a table that are out-with the specified retention period. This can be useful if you’re running deletes on large tables, and particularly if;
Copying Dates into Excel
There’s often a need to quickly copy/paste a database query output into an Excel sheet, rather than exporting as a .csv file.
Stack Exchange Data Explorer
The Stack Exchange Data Explorer is an amazing place where you’ll find all the data that is stored for those Q&A’s they’ve got going.
More on SPIDs… and Killing Them
While looking at an old script today, one that kills SPIDs on a SQL Server database… I had an instant urge to try kill a system SPIDs, just to see what would happen.
Change Highlighted Colour of Text in WordPress
This is one from my fix list as the default highlighted text colour on my theme was green. A quick Google search showed me the way.
SQL Server Support
What’s the plan when you don’t know how to fix a production issue? You can prepare this situation by reading and keeping up to date.
Logging sp_whoisactive to a Table
This is a follow-on post of sp_who, sp_who2 & sp_whoisactive and is a run-through of logging SQL Server activity to a table, using the sp_whoisactive stored procedure.
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 script will give you a quick view of data or log growth events on a SQL Server instance. I occasionally use this to check what’s been growing on unmonitored instances.
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
This is a tip on how to show line numbers in your SQL Server Management Studio (SSMS) query window. This can be useful for when you receive an error with reference to a line in your code, although it’s not a necessity having it enabled as you’ll see below.
