Blog posts

12 results found

12 results in Git, SQL

git How to rebase with Git

This post is just a place for me to put the steps for me or someone else to follow when doing a rebase using git.

dotnet·sql·umbraco How to solve the Umbraco Deploy schema mismatch error Database type is different

This post shows you how to fix the umbraco deploy schema mismatch error where the database type is different

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.

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.

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

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

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