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 →

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.

22 Jan 2019 / 2 min read Read →

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.

30 May 2018 / 2 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 →

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

26 Oct 2017 / 1 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