Blog | CodeShare

sql SQL snippet for creating a database with a login and user in SQL

This post is just basically a SQL snippet for you to copy, paste and edit for use when you need to create a SQL database with a login and a user.

10 Nov 2021 / 1 min read Read →

web·sql 5 ways to harden your Azure Web App and SQL Database resources

5 ways to harden your Azure Web App and SQL Database resources

13 Jul 2020 / 8 min read Read →

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 →

community Hack24 2018 Live Blog

This is a live blog post, documenting my experience of Hack24 2018 in Nottingham.

10 Mar 2018 / 12 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