JRevell.com

Microsoft Dynamics NAV – View All Active Sessions

November 23, 2016ComputersNo Comments

With Microsoft Dynamics Nav, there are various ways of viewing all the active sessions within the system. The easiest of which is the “Sessions” page within the software itself: The downside of this, is that it only shows active sessions on the tier which the user is connected. This is…

Remembrance Sunday – Poppies at Conisbrough Castle

November 16, 2016PersonalNo Comments

In remembrance for 100 years of the Battle of the Somme, local people and businesses donated towards lighting up Conisbrough Castle. The castle was lit up for 3 days, and raised well over £1500 for British Legion and the renovation of the local cenotaph/park. It is estimated over 5000 people…

Free Gousto Meal Box (well near enough…)

November 3, 2016PersonalNo Comments

Following on from my last post, I’ve had an email through to allow 1 person to try a meal box for £1. Plus then 50% off your 4th box (if you subscribe, if you dont, just have the 1 box!) First come first served..! ONEPOUND3SCY Code expires 10th November 2016.

Gousto Meal Box – £25 off First Box

October 2, 2016PersonalNo Comments

A few weeks ago I visited a country fair and got talking to a rep from Gousto. Having taken up his time, I signed up for a reduced rate trial of their boxes… The idea behind the boxes are to have fresh “meals” delivered to your door, (well the ingredients,…

Convert MS SQL Query to MySQL Automatically

September 28, 2016ComputersNo Comments

With a recent project, I’ve had to reproduce a table from a Microsoft SQL Database into a MySQL Database. The table had lots of fields and would be very time consuming to write the SQL to create the table, but luckily I came across this tool to convert MSSQL to…

SQL Remove Trailing Decimal Places

July 29, 2016ComputersNo Comments

Within a recent project, I’ve been extracting data from Microsoft Dynamics NAV using Taskcentre. Within NAV, decimals are stored as decimal(38,20), complete will all 20 decimal places..! The following SQL query is very handy at removing the un-required decimal places (but keeping the accuracy of the data) The results of…

SQL Server – Find Last Backup Date/Time

March 15, 2016ComputersNo Comments

With SQL server and 3rd party backup software, it can sometimes be difficult to tell when the last SQL backup has been taken and if the backup software has actually performed the backup or not. There are 3 main backup types in SQL Server: Full Incremental Transaction Log The following…

TaskCentre SQL Performance – One way to improve performance

February 24, 2016ComputersNo Comments

When using the “ODBC” or “OLEDB” tools in TaskCentre, it may appear that a single query is executed on the database. In actual fact from trial and error, I have identified multiple queries are being called. For example, if you run the following query (This query identifies all Item Ledger…

Microsoft Dynamics Nav – Either the caller does not have the required permission or the specified path is read-only – Error

February 8, 2016Computers4 Comments

Today on Microsoft Dynamics Nav 2013R2, I kept getting the following error, which stumped me for a bit… Either the caller does not have the required permission or the specified path is read-only. After much investigation, I found a solution to the problem, delete the following folder and restart the…

Automatic T-SQL Formatting with Microsoft SQL Server Management Studio 2014

February 2, 2016ComputersNo Comments

Within MySql Workbench, there’s a feature called “Clean Up SQL” which automatically tidies up your SQL and the indentation automatically. This is a very useful feature, as your messy SQL then becomes nice and neat. Unfortunately with Microsoft SQL Server Management Studio (SSMS), this feature is not standard. Luckily I…