Blog | CodeShare

sql How to strip the trailing slash off a URL in SQL

This post shows you how to remove the trailing slash off a URL in SQL and teaches you a lesson about Skybrud Redirects.

17 May 2022 / 1 min read Read →

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 →

conferences·dev 10 practical tips for improving your public speaking

In this post Marcin Zajkowski shares some of his pro tips for improving your public speaking, based on his experiences.

19 Jan 2018 / 7 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