by Oly | October 14, 2017 9:53 am | Blogging, Social Media, Tutorials, Videos, Websites, Wordpress
If you want to write content that is seen by lots of people and shared across the world there are some basics you need to be seen so i decided to write a list of blog post tips every article needs. If you would rather watch a video then click play below otherwise jump...
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 | January 24, 2017 8:23 pm | SQL, Tutorials, Videos
I often have to write big and complex queries in my day job and so using the Query Designer in SQL Server Management Studio makes this a lot easier to work with. One problem that i have found with it is that it doesn’t seem to like temporary tables but i have...
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,...
