Rodan Sotto's Tech Blog

To know more about SQL Server 2005 data types, click here.  For SQL Server 2005 Books Online, click here. Read More

I recently had a technical interview and the following questions gave me a  hard time: How many non-clustered indexes can you have?  I know you can only have 1 clustered index but I have no idea for the non-clustered.  The answer is 249.  But in SQL Server 2008, this number was increased to 999. Which among the 2 key constraints allow you ... Read More

These past 2 years have been busy for me, with a new job and a new baby in 2009.  Unfortunately I left my job to take a family-related sabbatical for 8 months.   Now I am looking for another job and blogging again. Since my last blog on the following technologies: .NET Framework 2.0 and briefly on 3.5 (should probably look at 3.0 first), Visual... Read More

Windows Presentation Foundation (WPF) seems to be the successor to Windows Forms for desktop development.  The following are some of the highlights in WPF: Separation of logic code from the presentation code where the presentation code is defined using a declarative syntax called Extensible Application Markup Language (XAML). Three kinds o... Read More

Windows Communication Foundation (WCF) is a platform for building service-oriented applications.  The following are some of the highlights in WCF: Defines the following three core contracts with its consumers when creating WCF services: Service contract, Data contract, and Message contract. Use of service endpoint to expose WCF services to... Read More