Checking database backup history

Sometimes, especially with large databases, the duration of a backup can be significant (e.g. multiple hours). So, if you’re wondering exactly how far along a backup is, and when it is estimated to complete, you can run the query below I hope that helps!

Investigating a Log Shipping process

One of the clients that I support has a DR (Disaster Recovery) environment set up. If you want to read a description on DR (and by extension, Log Shipping), then check out this page from Microsoft. Log Shipping and DR were relatively new processes to…

How to get a database out of Recovery Pending state

One of my clients recently suffered an outage for their production environment. The database structure includes Report Server Report Server Temp Transactional Transaction History During the outage all databases were in “Suspect” mode. I had never seen this status before, but it is not fun….

How to Rename a Database

If you ever need to rename a database, I recommend using the following script. It ensures no other users are connected. This is important, otherwise your connection won’t be able to gain a lock. I hope that helps!

Replace Text in a Database

If you need to perform an update on some text value in your database, you can easily get the job done using the REPLACE() function. I strongly suggest using the WHERE clause. You don’t want to accidentally update a row you didn’t mean to. I…

Visual Studio Power Tools

Power Tools is an extension application for Microsoft Visual Studio. It is free to download, and is developed by Microsoft. Here is a summary of the features, from the website Peek Help Solution Error Visualizer Structure Visualizer Double click to maximize windows Timestamp margin Quick…

Starting an app on machine startup

Many of you may be aware that applications often run in the background without you being aware of them. Some may run as a Service, whereas others might automatically start when your machine is turned on (booted). An example of this, is the Windows Desktop…

Infinite note taking space with BigPicture

While searching around for a javascript resource called BigPicture.js (which is a script to support viewing images and videos online – you can find more on it here), I found another amazing project. It’s essentially an endless text canvas, allowing you to type anywhere on…

Use RowCount to determine query success

If you have a Stored Procedure that populates a temporary table, and you want to ensure the temporary table has been populated with something, you could use @@Rowcount. It’s an in-build property, and can be used as an alternative to selecting COUNT(1) from the temporary…