by Oly | August 12, 2017 9:40 am | Office, Programming, Tutorials
As well as doing work in SQL Server and “.net” i sometimes have to write VBA code for clients and error handling in Excel is a common requirement when writing VBA so i decided to write an article on VBA error handling. If you would like to watch a video on...
by Oly | December 22, 2016 11:06 am | Programming, SQL, Tutorials
Following on from yesterdays post on how to debug a stored procedure i decided to do a post on how to conduct a sql server 2012 search and by this i mean finding anywhere that a column is referenced in a stored procedure or function or view. This really helps if you...
by Oly | December 21, 2016 9:06 pm | Programming, SQL, Tutorials
I often write multi statement stored procedures and it is very hard to work out what is going on if you don’t debug in SQL Server. Luckily SQL Server management studio allows you to do just this. In this article i am going to explain how to debug in SQL Server,...
by Oly | December 12, 2015 2:28 pm | Programming, Tutorials, Web Design, Websites
I recently did a new install of WordPress for my travel blog called Around The World In 80 Raves. On logging into the WordPress dashboard i went to the plugins page to and received the WordPress Oops That Page Can’t Be Found error. I found this very strange...
