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…

Another online code editor

In the past I have found and shared online resources for developers (e.g. playcode.io), and today I have another one! htmleditor.io does basically what the URL suggests – it allows you to edit HTML. But it does it all in your browser. And it renders…

Setting NOCOUNT in your Stored Procedures

NOCOUNT is a SQL Server setting that (when activated) will stop SQL Server from returning the “x row(s) affected” message as part of its execution. Although this message is helpful with T-SQL queries in SQL Server Management Studio, it is of little use with Stored…

Notepad++

Today I want to say share how great Notepad++ is. I’m actually surprised I haven’t blogged about it before! At it’s core, it’s a text editor. But here are a few features that I feel make it worth downloading Multiple documents can be opened in…

Excluding FILESTREAM when backing up a Database

When using a script to backup a SQL Server database, it can be tricky to exclude the filestream. But, you can exclude filestream by only including the Primary file group, which typically only includes the data and log files. I hope this helps.