Monthly Archives: August 2013

ShadowOverlay

[UPDATE] – New version uploaded.

This little application will allow you to shadow part of your screen while maintaining full screen brightness. This is to prevent prying eyes from easily reading for example an IM conversation.

The application is in early alpha and has not been properly tested. For now it will only allow you to shadow the left side of your screen starting from the top. When you start the application you will see an option window where you can set width and height as well as overlay opacity. If you can’t see it, right click the little smiley with the sunglasses in your system tray and click options.

The overlay is click through so you can work with your background application properly. I’ll try to add more features when I have time, such as positioning, different overlay colors and such.

I take no responsibility for damage or software loss caused by this application. It is in early alpha and has not been thoroughly tested. You have been warned.

1.0.0.5 – https://www.dropbox.com/s/bfpu0wxd2fesxji/shadowoverlay1005.zip
Supports saving and loading profiles (with limitations). Other tiny changes.

Checking recovery models in MS SQL Server

We have quite a few databases that have been added to our SQL environment by 3rd parties. The default recovery model is “Full”, yet a lot of the databases have no scheduled transaction log backups. What does this mean?

Well, a database with “Full” recovery model will never reclaim space in LDF files unless a transaction log backup is run. A full database backup isn’t enough.

So the options here are: set recovery model to simple, or make sure you have backup jobs in place to empty your log files periodically.

Here’s how to list all your databases and their associated recovery models:

SELECT name AS [Database Name],
recovery_model_desc AS [Recovery Model]
FROM sys.databases
GO