Welcome to Rayz.com

Archive for the ‘Software Development’ Category

SQL Coalesce “Duh”

Monday, February 10th, 2014

As some may know, the SQL COALESCE statement will replace any nulls it finds with some other value. This function is a rock and staple of coding in SQL. It is similar to the ISNULL SQL function except it returns the non-null value instead of a boolean without having to write an “if” statement, and is extremely useful in “SELECT” statements.
Continue Reading…

SQL Joins

Friday, January 10th, 2014

Here is a picture that one of my buds sent me. It explains SQL joins to me better than just about anything I’ve seen in the textbooks. Hope it helps.

Continue Reading…

Modifing The Default Visual Studio Template files

Friday, December 27th, 2013

public class MyClassExample
    #region members

    private bool isValid = false;
    private string myString = string.Empty;
    private string anotherString = “Another string”;


Continue Reading…

Microsoft Report Viewer Problem

Wednesday, May 8th, 2013
MS Report Viewer Error

MS Report Viewer Error

One of my pet peeve’s in software development is Microsoft’s Reports. The other day I was minding my own business and up popped this error while I was moving some files around on the server. Continue Reading…