Archives | Rodan Sotto’s Tech Blog

Light

Dark

2023

Jan 30, 2023 Key Points To Architecturing Cloud Applications, Part 4: Reliability
Jan 16, 2023 Key Points To Architecturing Cloud Applications, Part 3: Performance

2022

Dec 16, 2022 Key Points To Architecturing Cloud Applications, Part 2: Operations
Dec 14, 2022 Key Points To Architecturing Cloud Applications, Part 1: Cost
Dec 13, 2022 Ways Developer Can Secure An ASP.NET Application (Redux 2022)
Nov 15, 2022 Maintainable and Scalable Software: A Checklist
Oct 23, 2022 Demystifying .NET Core apps, a quick walkthrough (.NET 6)
Oct 2, 2022 Tic-Tac-Toe in Angular, React, and Lit
Sep 25, 2022 My notes on Angular (Redux 14)
Sep 6, 2022 Multi-threading in C#: Task-Based Asynchronous Pattern (TAP)
Aug 7, 2022 How I Trained A Simple Neural Network In C# To Recognize Numbers 0-9
Aug 2, 2022 From CloudFormation To Serverless Framework To Cloud Development Kit?
Jul 14, 2022 Branches of Mathematics, Solving Equations and Calculating Derivatives
Jul 6, 2022 A Simple Neural Network In C#
Jul 4, 2022 Back to the Roots with Algorithms
Jun 19, 2022 Is This Still Working In 2022 ?!?!
Jun 5, 2022 Welcome to My Jekyll-Powered Tech Blog!

2017

Dec 29, 2017 Learning Python for Numeric and Scientific Applications
Dec 9, 2017 LINQ Exercises Using Both Query and Fluent Syntaxes
Dec 4, 2017 Product Catalog: An Angular and Material Demo
Nov 28, 2017 .NET Code Documentation And Testing: They Are There, Why Not Use It?
Nov 25, 2017 I'm familiar with .NET Framework, so what is .NET Standard and .NET Core?
Nov 23, 2017 My notes on Angular (2.0+)
Nov 16, 2017 Multi-threading in C#: A must have in your programming arsenal (IMO)
Nov 13, 2017 A chat app that receives SMS and sends HTTP messages (A Xamarin Android App Preview)
Nov 9, 2017 Some Visual Studio Productivity Tips
Nov 7, 2017 Don't confuse DIP, IoC, and DI together. They are all different but related.
Nov 3, 2017 Ways to Extend The ASP.NET MVC 5 Framework
Nov 1, 2017 ASP.NET MVC 5: OWIN/Katana Pipeline And Middleware Components (A Demo)
Oct 27, 2017 AI, Anyone?
Oct 17, 2017 Quick refresher on JavaScript's objects, prototypes and inheritance
Oct 16, 2017 TypeScript Notes: Part 2
Oct 12, 2017 SQL Tricks: CSV To Table Rows And Vice Versa
Sep 8, 2017 TypeScript Notes: Part 1

2016

Jun 3, 2016 SQL Server: Hiding your prod data and built-in function STUFF()
May 27, 2016 Writing to an output text file and finding out extra characters or lines in it?
May 26, 2016 Column aliases in ORDER BY works on older SQL version but not on SQL 2014?
May 25, 2016 What's new in C# 6?

2015

Nov 19, 2015 Display Bootstrap’s Navbar Dropdown Menu On Hover
Nov 9, 2015 How Many Ways Can You Add Entity Framework Model To Your Project?
Nov 2, 2015 Ways Developer Can Secure An ASP.NET Application, Part 1
Oct 19, 2015 A Custom WebGrid (My 1st Iteration)
Sep 15, 2015 Nested Transactions in SQL Server
Sep 11, 2015 C#: Using or not using
Aug 11, 2015 Calling .Net Assembly from VBA
Mar 13, 2015 Why I Chose C# Over VB.NET?
Feb 27, 2015 C#: What’s with Enums anyways?
Feb 9, 2015 Web Design: A Text Animation Exercise and More
Jan 19, 2015 Web Design: A Fluid Layout Exercise
Jan 15, 2015 C#: Does the code below look familiar?
Jan 9, 2015 Web Design: Resources
Jan 7, 2015 SQL Server: My Quick and Dirty Way of Debugging Stored Procedure
Jan 6, 2015 ASP.NET Web Services - Blast From The Past (Part 2)
Jan 5, 2015 ASP.NET Web Services - Blast From The Past (Part 1)
Jan 1, 2015 SQL Server: Schemas, DELETE vs. TRUNCATE, Generate INSERTs, and NOT IN vs. NOT EXISTS

2014

Dec 26, 2014 The Very Basic Syntax of Razor
Oct 27, 2014 New to Active Directory and need to use it in .NET?
Oct 7, 2014 SQL Server: Quickly run a command on each database. How?
Sep 5, 2014 Is that a VB code or C#?
Jul 9, 2014 Storing an Excel File in a SQL Server Database
Jun 24, 2014 SSRS: Automating Report Deployment using RS.EXE
Jun 4, 2014 Demonstrating the new HTML5 and CSS3 Features
Jun 3, 2014 Access: Type Mismatch Run-time Error After Converting to ACCDB Format
May 27, 2014 C#: A Review on Generics
May 21, 2014 C#: Quick Review on Raising Events
May 16, 2014 C#: Quick Review on Delegates
May 14, 2014 Using CSS Media Queries
May 12, 2014 Testing an HTML Page on the Android Emulator Browser
May 8, 2014 Always wondered how you can write custom code in SQL Server reports?
Apr 3, 2014 Responsive HTML5 and CSS3 Web Design: Responsive Enough? Err… Hello?!?
Mar 18, 2014 Android Development: main() Method, Application Lifecycle, and Event Handling
Mar 3, 2014 WinForms: Using DevExpress, there is a quick way of making sure only one instance of a form is open
Feb 13, 2014 JavaScript: You think you know it well?
Feb 11, 2014 Design Patterns: Factory Method, Abstract Factory, and Singleton
Feb 5, 2014 HTTP Fundamentals, Part 2: Communication Stack, HTTP Connections, and REST Style of Architecture
Jan 17, 2014 Access VBA: How To Call A Windows Form Application with Arguments
Jan 15, 2014 SQL Server: Quick Notes on SYNONYM, MERGE, TRY_CONVERT, TRY_CAST, PARSE, TRY_PARSE, CHECKSUM, ISNULL, COALESCE, NULLIF, and JOIN

2013

Dec 17, 2013 JavaScript: Attaching/Detaching Event, OnLoad vs. DOMContentLoaded, Manipulating DOM and CSS
Dec 9, 2013 JavaScript: RegExp, Error, DOM, and Event
Dec 3, 2013 .NET: Regular Expression Testers and Quick Reference Guides
Dec 2, 2013 So what is Closure?
Nov 26, 2013 C#: Predicates in LINQ to Entities
Nov 12, 2013 ASP.NET: Beginner's Resource on MVC 4, Entity Framework, and Razor
Nov 11, 2013 C#: Quick notes on some cool features…
Nov 6, 2013 Design Patterns: Strategy, Observer, and Decorator
Nov 5, 2013 Design Patterns: The Four OO Basics
Nov 3, 2013 JavaScript Array and How It’s Different from Object
Oct 29, 2013 HTTP Fundamentals, Part 1: URL, Encoding, Request and Response
Oct 14, 2013 CSS Fundamentals
Oct 12, 2013 SQL Server: How to Linked Server an Access Database
Oct 12, 2013 General: Recursive Programming
Sep 21, 2013 Object Oriented Programming In Javascript
Sep 17, 2013 Design Patterns: Fundamentals
Sep 14, 2013 HTML Fundamentals
Sep 11, 2013 Webbing My Way To Frontend Development
Jun 12, 2013 ASP.NET: What are web services?
Jun 9, 2013 General: On a 64-bit OS/machine, what will be the issues in running your application that uses Access database directly or indirectly using SQL Server’s Linked Server object
May 29, 2013 SQL Server: Error Handling
May 20, 2013 HTML, CSS, Javascript, and jQuery: Putting them all together (Part 3)
May 20, 2013 HTML, CSS, Javascript, and jQuery: Putting them all together (Part 2)
May 19, 2013 HTML, CSS, Javascript, and jQuery: Putting them all together (Part 1)
May 13, 2013 C#: How many versions of C# do we have right now?
May 8, 2013 SQL Server: Common Table Expression (CTE), ROW_NUMBER(), RANK(), Derived Table, OPENXML()
May 5, 2013 .NET Framework: From 2.0 to 3.0, to 3.5, to 4.0, and finally to 4.5, what’s the difference?
May 3, 2013 HTML: DOCTYPE, Elements, Attributes, Paragraphs, Empty HTML Elements, Formatting, Link Element, Head Element
May 1, 2013 Web Design: Introduction
Apr 30, 2013 C#: Quick facts on numeric suffixes, verbatim string, null coalescing, short-circuiting, main entry point, fall through switch-case
Apr 28, 2013 General: C#, HTML, CSS, Javascript, AJAX
Apr 25, 2013 SQL Server: Multi-Tenant Data Architecture
Apr 21, 2013 ASP.NET: GET, POST, IsPostBack, QueryString, and Form
Apr 18, 2013 General: If we have Cloud, then what is SaaS? What about ASP?

2011

May 11, 2011 .NET 2.0: Addendum to Notes on Foundation Part 1
May 10, 2011 General: Getting certified
Apr 29, 2011 .NET 3.5: Introduction to XAML - Part 1
Apr 27, 2011 SQL Server 2005: SELECT, INSERT, UPDATE, DELETE
Apr 26, 2011 SQL Server 2005: Data Types and Books Online
Apr 21, 2011 SQL Server 2005: Interview Q&A
Apr 20, 2011 General: I’m back blogging again :)

2009

Apr 18, 2009 .NET 3.5: Quick look at what is in WPF
Apr 18, 2009 .NET 3.5: Quick look at what is in WCF
Apr 14, 2009 General: Fibonacci sequence using a loop versus a recursive function
Apr 8, 2009 .NET 2.0: Notes on Foundation Part 5 (C#)
Apr 3, 2009 .NET 3.5: WPF, WCF, WWF, ASP.NET 3.5, ADO.NET 3.5
Apr 3, 2009 .NET 2.0: Notes on Foundation Part 4 (C#)
Apr 2, 2009 Design Patterns: Mediator, Adapter, Proxy, and Observer Patterns
Apr 1, 2009 .NET 2.0: Notes on Foundation Part 3 (C#)
Apr 1, 2009 Design Patterns: Introduction
Apr 1, 2009 ASP.NET 2.0: Crystal Reports – Fitting the report inside the available space in your web page
Mar 31, 2009 .NET 2.0: Notes on Foundation Part 2 (C#)
Mar 28, 2009 .NET 2.0: Notes on Foundation Part 1
Mar 27, 2009 General: It has been a while since my last post

2007

May 8, 2007 ASP.NET 2.0: Learning the Basics, Part III
May 5, 2007 VB 2005: Things to know about the Visual Studio 2005 IDE
May 5, 2007 VB 2005: The Global keyword
May 5, 2007 VB 2005: Putting XML comments to your source code
May 5, 2007 VB 2005: Don't declare a form MustInherit if you will be inheriting the form
May 5, 2007 VB 2005: Code generation in Visual Studio 2005
May 5, 2007 VB 2005: Building applications in VS 2005 IDE
May 5, 2007 SQL Server 2005: Understanding decimal, numeric, float, and real data types
May 5, 2007 SQL Server 2005: Query window in Microsoft SQL Server Management Studio
May 5, 2007 SQL Server 2005: JOINS and UNION
May 5, 2007 SQL Server 2005: Inserting DEFAULT values
May 5, 2007 SQL Server 2005: INFORMATION_SCHEMA views
May 5, 2007 General: Problem importing Access into Oracle using SQL*Loader
May 5, 2007 ASP.NET 2.0: Learning the Basics, Part II
May 4, 2007 ASP.NET 2.0: Learning the Basics, Part I
May 2, 2007 ASP.NET 2.0: Ramping up my knowledge on Microsoft's latest version of ASP
Apr 28, 2007 SQL Server 2005: New data types
Apr 28, 2007 General: Programming Test #1
Apr 21, 2007 VB 2005: Don't use the Timer control on your Windows Service project
Mar 28, 2007 VB 2005: Quick introduction to the world of .NET
Mar 27, 2007 VB 2005: A journey towards mastering Visual Basic 2005
Mar 27, 2007 SQL Server 2005: Aggregate Functions
Mar 27, 2007 Access 2003: A journey towards mastering Access 2003
Mar 26, 2007 SQL Server 2005: Transaction log
Mar 26, 2007 SQL Server 2005: Bit, Image, VarBinary, and unsigned numeric data types
Mar 26, 2007 SLQ Server 2005: Operators you can use in the WHERE clause
Mar 25, 2007 SQL Server 2005: model and msdb system databases
Mar 24, 2007 SQL Server 2005: A journey towards learning SQL Server 2005 better