Rodan Sotto's Tech Blog

I was going through some job description that I was applying for and stumbled upon this tech jargon multi-tenant describing a data architecture, which I will be talking about on a separate post under SQL Server.  I searched the Internet and found out that this tech jargon is actually common in the SaaS, Cloud or ASP space.  From my limited under... Read More

Addendum to .NET 2.0: Notes on Foundation Part 1 Value Types – Built-in, User-defined, and Enumerations Built-in value types in .NET are sbyte, byte, short, int, uint, long, float, double, decimal, char, bool, and date.  For performance, use int and double by default.  When using a nullable value type, you can use the HasValue method to determ... Read More

I’m excited to start in my new job next week.  I can’t wait.  Now that everything seems to be going back to normal (hopefully it stays that way), I plan on getting back on track to certify myself on .NET.  I browsed the Microsoft certification website and it seems getting certified with .NET Framework Foundation is a good bet.  Not only it appli... Read More

What is XAML So what is XAML anyways?  It stands for eXtensible Application Markup Language and is based on XML.  It was initially created to be used in WPF (Windows Presentation Foundation) but is now being used also in WF (Windows Workflow Foundation), Silverlight, and XPS (XML Paper Specification).  Why XAML So why another markup language?... Read More

The parts of a SELECT statement are: [sourcecode language=”sql” gutter=”false” light=”true” toolbar=”false”] SELECT FROM WHERE GROUP BY HAVING ORDER BY FOR XML OPTION [/sourcecode] By default, ALL is assumed in SELECT, thus including every row.  Using SELECT DISTINCT excludes duplicate rows.  Note that you can also use DISTINCT in aggreg... Read More