I recently had a need to test a migration script which converted product IDs from one ERP to those of … Continue reading Restore database backup programmatically with TSQL
Scheduled WordPress backups with the UpdraftPlus plugin
Just installed UpdraftPlus to schedule backups of all my WordPress related content including of course the database but also the images, … Continue reading Scheduled WordPress backups with the UpdraftPlus plugin
Using Optimistic concurrency with Entity Framework over SQL Server
If you want to have a client-wins or last in wins approach to concurrency management you don’t have to do anything, … Continue reading Using Optimistic concurrency with Entity Framework over SQL Server
Setting up WordPress permalinks on a Blacknight Windows account with ISAPI Rewrite installed
If your hosting your site on a Blacknight shared windows hosting account, you’ll likely have either ISAPI Rewrite 2 or ISAPI Rewrite … Continue reading Setting up WordPress permalinks on a Blacknight Windows account with ISAPI Rewrite installed
Using MSBuild to publish a website just like in Visual Studio
Right clicking on a web project or a WCF project (others too I’m sure) in Visual Studio presents you with … Continue reading Using MSBuild to publish a website just like in Visual Studio
Can’t receive incoming remote connections to SQL Server database
I was having problems allowing some of my co-workers connect to the instance of SQL Server on my machine. Of course I … Continue reading Can’t receive incoming remote connections to SQL Server database
404s with ASP.MVC on IIS 7.5
I was getting page not found errors yesterday when trying to deploy an ASP.Net MVC website which of course worked … Continue reading 404s with ASP.MVC on IIS 7.5
How to check if a default constraint exists in SQL Server
Perhaps your scripting rollout and rollback DDL SQL changes and you want to check for instance if a default constraint … Continue reading How to check if a default constraint exists in SQL Server
Introduction to database indexes
If your database queries are taking an age and a half to execute you could do worse than investigate the … Continue reading Introduction to database indexes
Using a connectionStrings section connection with log4net now supported
Just upgraded to Version 1.2.11 of log4net due to the fact that one of the improvements in this version is … Continue reading Using a connectionStrings section connection with log4net now supported
Sharing connectionStrings and appSettings between multiple projects
My last post talked about how to do this for appSettings via the file attribute however as I mentioned in … Continue reading Sharing connectionStrings and appSettings between multiple projects
Common appSettings file for all projects in a solution
Many solution structures look a bit like below. This means that if some code in for instance MYSOFTWARE.APPLICATIONSERVICES requires access … Continue reading Common appSettings file for all projects in a solution
Register Castle Windsor IOC components via convention
Favouring convention over configuration means less change points (and remember points) for developers to deal with when new code needs … Continue reading Register Castle Windsor IOC components via convention