Blog
Paul Seal's personal blog
Blog posts
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 differentThis 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 SQLThis 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 SQLThis 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 resources5 ways to harden your Azure Web App and SQL Database resources
sql How to delete data in SQL Server using an INNER JOIN queryThis 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 repositoryThis 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 GitHubThis 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/configThis 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 dataI 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 versionThis 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 UmbracoThis post shows you how to convert a SQL Compact Edition database to full SQL and speed up Umbraco