Blog posts

32 results found

32 results in DevOps, Git, SQL, Videos

sql How to delete data in SQL Server using an INNER JOIN query

This post will give you a clear example to follow to help you delete data in SQL Server using an INNER JOIN query, giving you the confidence that you query is correct.

git How to ignore a file locally in git without ignoring it from the repository

This post shows you how you can ignore a file in git locally without ignoring it from the repository.

git How to keep your fork up to date with the master repository in GitHub

This post gives you the commands you will need to keep your fork up to date with the master repository in GitHub.

git How to solve the git error fatal: unable to access '\/.config/git/config

This post shows you how to solve the git error fatal: unable to access '\/.config/git/config

sql The day I hacked Troy Hunt's website to delete my data

I needed to remove my personal details from Troy Hunt's website. This post shows you why and how I did it.

sql How to migrate or downgrade a SQL Server database to a lower version

This post shows you how you can migrate or downgrade a SQL Server database from one version to a lower or earlier one. E.g. 2016 to 2014, 2014 to 2012, 2012 to 2008 etc

videos Outtakes March 2017

This is a collection of outtakes from when I'm trying to record videos for my YouTube channel.

sql How to convert SQL Server Compact Edition .sdf to Full SQL and speed up Umbraco

This post shows you how to convert a SQL Compact Edition database to full SQL and speed up Umbraco