Tips for your Code Journal | Code Journaling pt 4 of 4

30 Sep 2019 Professional Development No Comments

In this final post of my series on Code Journalling, I am giving you some further tips on creating and using your Code Journal to its full potential. If you have any more tips please include them in the comments at the bottom.

In this third part of my series on Code Journaling I am covering some ideas for what to actually record in your Code Journal. These are only ideas, and you should pick and choose what works for you.

Do you have any other ideas for

Continue reading →

How to start your Code Journal | Code Journaling pt 2 of 4

16 Sep 2019 Professional Development No Comments

In this second post in my series on Code Journaling, I will cover how to start your own Code Journal.

The medium of your Code journal is an important decision. Just as the content will be individual to you so will

Continue reading →

Why you should keep a Code Journal | Code Journaling pt 1 of 4

09 Sep 2019 Professional Development No Comments

Journaling is often thought of as an arty or holistic pastime, an activity for those with a creative streak or too much time on their hands. Why would a technical person be interested in journaling?

Journaling is a tool, and a Code Journal is a

Continue reading →

Neo4j 3.0 with a .Net driver: Neo4jClient

27 Apr 2016 .Net, C#, Databases, Graph Databases, MVC, Neo4j, NoSql No Comments

I started dabbling in Neo4j, a NoSQL graph database, around 2 years ago. I have not used it much in the .Net world, and with the recent release of Neo4j 3.0, with its built in .Net driver, I decided to have a

Continue reading →

Use SQL to drop a column, if it exists in a table

05 Apr 2016 Databases, SQL, Stored Procedures No Comments

I recently needed to write a script for a customer to run against their database, to delete a column from a table. I wanted to make sure it would only run if that column existed, especially as the column had originally been created by a script that failed to complete

Continue reading →

Adding a relationship constraint to an existing or new column in MS SQL

24 Mar 2016 Databases, SQL, Stored Procedures No Comments

I recently needed to write some SQL to add a relationship constraint to an existing column in MS SQL. After a bit of research this is the answer I found. I have also included the SQL for adding the same constraint when creating a new table also.   Resource: Continue reading →

Getting Entity Framework to recognise the return type of a Stored Procedure that returns a #temp table

27 Sep 2013 .Net, C#, SQL, Stored Procedures, Visual Studio No Comments

I recently wanted to declare a table, insert data into it and then, depending on a variable passed in to the stored procedure (@i_bitCurrent), either return the contents of the table, or filter the contents with a Where clause and return them (3 options in total). The reason I wanted

Continue reading →

Progromatically get SessionId Cookie name used in an asp.net application

09 Sep 2013 .Net, C#, MVC No Comments

The default name for the SessionId cookie in an Asp.Net application is ASP.NET_SessionId, but this can be changed in the web.config, e.g. I wanted to get the name of the SessionId cookie for the web app that was implementing my class library. I knew the dll would be implemented by many

Continue reading →

Get the executing assembly of a web app referencing a class library

05 Sep 2013 .Net, C#, MVC No Comments

I needed to check that any web app that was referencing my class library was giving me a valid controller and action name in some settings in its web.config, so that when I used them in a redirection there would be no errors because they did not exist. When I used to

Continue reading →