Blog | CodeShare

29 results in DevOps, General Content, SQL, Videos, Web

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.

20 Mar 2019 / 2 min read Read →

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.

03 Aug 2017 / 5 min read Read →

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

21 Apr 2017 / 2 min read Read →

videos Outtakes March 2017

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

31 Mar 2017 / 1 min read Read →

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

10 Jan 2017 / 5 min read Read →

Blog posts