Articles by Sander Rossel (Articles: 7, Technical Blogs: 33, Tip/Tricks: 6)

Articles: 7, Technical Blogs: 33, Tip/Tricks: 6

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.86

Client side scripting

Beginners

Arrgh.js - Bringing LINQ to JavaScript

Posted: 28 Nov 2016 Updated: 14 May 2017 Views: 46,090 Rating: 4.79/5 Votes: 69 Popularity: 8.81

Licence: The Code Project Open License (CPOL) Bookmarked: 54 Downloaded: 158

Creating a lightweight JavaScript library that brings proper .NET-like collections and LINQ to JavaScript.

Database

SQL Server

Querying SQL Server 2012: Part I

Posted: 13 Dec 2013 Updated: 3 Jan 2014 Views: 246,901 Rating: 4.85/5 Votes: 104 Popularity: 9.72

Licence: The Code Project Open License (CPOL) Bookmarked: 160 Downloaded: 0

The first of two, everything you need to create the most amazing queries!

Querying SQL Server 2012: Part II

Posted: 3 Jan 2014 Updated: 24 Jan 2014 Views: 94,314 Rating: 4.91/5 Votes: 48 Popularity: 8.25

Licence: The Code Project Open License (CPOL) Bookmarked: 97 Downloaded: 0

The second of two; everything you need to create the most amazing queries!

.NET Framework

General

Using Try... Catch..., Finally!

Posted: 5 Feb 2011 Updated: 5 Feb 2011 Views: 289,586 Rating: 4.80/5 Votes: 45 Popularity: 7.94

Licence: The Code Project Open License (CPOL) Bookmarked: 101 Downloaded: 2,337

This article describes multiple implementations of proper Try... Catch... Finally and Using... End Using blocks in your code.

A Look under the hood of the .NET Framework

Posted: 8 Jul 2012 Updated: 11 Feb 2013 Views: 127,251 Rating: 4.95/5 Votes: 78 Popularity: 9.36

Licence: The Code Project Open License (CPOL) Bookmarked: 167 Downloaded: 1,430

Journey to the center of the .NET Framework with a chance of IL along the way!

Collections

General

Having fun with custom collections!

Posted: 11 Oct 2011 Updated: 14 Oct 2011 Views: 146,672 Rating: 4.91/5 Votes: 71 Popularity: 9.10

Licence: The Code Project Open License (CPOL) Bookmarked: 120 Downloaded: 2,759

Creating custom collections from IEnumerable(T) to IDictionary(T) and everything in between!

Design and Architecture

Design Patterns

What not to do: Anti-Patterns and the Solutions

Posted: 26 Apr 2011 Updated: 30 Apr 2011 Views: 87,293 Rating: 4.84/5 Votes: 58 Popularity: 8.54

Licence: The Code Project Open License (CPOL) Bookmarked: 113 Downloaded: 1,046

An introduction to knowing what NOT to do.

Average blogs rating: 4.84

Grid & Data Controls

DataSets, DataGrids etc

Using DataSets to work with (relational) in-memory data [Technical Blog]

Posted: 6 Nov 2014 Updated: 16 Mar 2015 Views: 30,915 Rating: 4.44/5 Votes: 6 Popularity: 3.45

Licence: The Code Project Open License (CPOL) Bookmarked: 20 Downloaded: 0

Need some flexible in-memory data cache? DataSets might be what you're looking for...

Ajax

General

Web development #7: Dynamic page updates with AJAX [Technical Blog]

Posted: 8 Mar 2015 Updated: 16 Mar 2015 Views: 20,450 Rating: 4.29/5 Votes: 6 Popularity: 3.34

Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 0

The seventh in a series on web development.

Applications & Tools

General

Web development #8: Where to go from here [Technical Blog]

Posted: 14 Mar 2015 Updated: 16 Mar 2015 Views: 14,520 Rating: 4.73/5 Votes: 6 Popularity: 3.68

Licence: The Code Project Open License (CPOL) Bookmarked: 14 Downloaded: 0

The last in a series on web development.

Client side scripting

Beginners

Web development #6: Getting interactive with JavaScript [Technical Blog]

Posted: 2 Mar 2015 Updated: 16 Mar 2015 Views: 23,140 Rating: 5.00/5 Votes: 5 Popularity: 3.49

Licence: The Code Project Open License (CPOL) Bookmarked: 14 Downloaded: 0

The sixth in a series on web development.

JavaScript

Knockout.js for data binding in HTML and JavaScript [Technical Blog]

Posted: 29 Mar 2015 Updated: 29 Mar 2015 Views: 33,900 Rating: 4.92/5 Votes: 5 Popularity: 3.44

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0

Knock, knock. Who's there? Knockout. Knockout who? Knockout.js!

Prototype in JavaScript [Technical Blog]

Posted: 18 Oct 2015 Updated: 19 Oct 2015 Views: 12,301 Rating: 4.63/5 Votes: 6 Popularity: 3.72

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

Always wondered about that prototype thing in JavaScript? It's not as hard as you'd think...

Apply, Call and Bind on JavaScript functions [Technical Blog]

Posted: 25 Oct 2015 Updated: 27 Oct 2015 Views: 7,491 Rating: 4.60/5 Votes: 4 Popularity: 2.74

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

Did you know about Apply and Call in JavaScript? Or Bind? They might come in handy!

HTML / CSS

CSS

Web development #3: Styling our page with CSS 3 [Technical Blog]

Posted: 18 Nov 2014 Updated: 16 Mar 2015 Views: 27,760 Rating: 4.72/5 Votes: 9 Popularity: 4.50

Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0

The third in a series on web development.

General

Web development #1: Internet and the World Wide Web [Technical Blog]

Posted: 10 Nov 2014 Updated: 16 Mar 2015 Views: 39,345 Rating: 4.76/5 Votes: 22 Popularity: 6.19

Licence: The Code Project Open License (CPOL) Bookmarked: 40 Downloaded: 0

The first in a series on web development.

Twitter Bootstrap for Responsive, Mobile First Web Apps [Technical Blog]

Posted: 23 Mar 2015 Updated: 24 Mar 2015 Views: 23,090 Rating: 5.00/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0

Using Twitter Bootstrap to create pages that'll look good on all devices

Polymer for reusable web components [Technical Blog]

Posted: 17 May 2015 Updated: 18 May 2015 Views: 20,021 Rating: 4.90/5 Votes: 9 Popularity: 4.68

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

Using Polymer to create custom HTML elements for reusability and fun.

HTML

Web development #5: User input with HTML Forms [Technical Blog]

Posted: 26 Feb 2015 Updated: 16 Mar 2015 Views: 21,430 Rating: 4.64/5 Votes: 7 Popularity: 3.92

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

The fifth in a series on web development.

Web development #2: Our first website using HTML [Technical Blog]

Posted: 11 Nov 2014 Updated: 16 Mar 2015 Views: 27,630 Rating: 4.74/5 Votes: 11 Popularity: 4.74

Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0

The second in a series on web development.

Node.js

General

MEAN web development #4: All aboard the Node.js Express! [Technical Blog]

Posted: 24 May 2015 Updated: 26 May 2015 Views: 13,280 Rating: 4.80/5 Votes: 8 Popularity: 4.33

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

The fourth in a series on MEAN web development.

MEAN web development #1: MEAN, the what and why [Technical Blog]

Posted: 20 Apr 2015 Updated: 27 May 2015 Views: 25,620 Rating: 4.89/5 Votes: 15 Popularity: 5.76

Licence: The Code Project Open License (CPOL) Bookmarked: 29 Downloaded: 0

The first in a series on MEAN web development.

MEAN web development #2: Node.js in the back [Technical Blog]

Posted: 28 Apr 2015 Updated: 27 May 2015 Views: 17,700 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0

The second in a series on MEAN web development.

MEAN web development #3: More Node.js [Technical Blog]

Posted: 10 May 2015 Updated: 27 May 2015 Views: 9,140 Rating: 4.71/5 Votes: 5 Popularity: 3.30

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

The third in a series on MEAN web development.

MEAN web development #5: Jade and Express [Technical Blog]

Posted: 15 Jun 2015 Updated: 16 Jun 2015 Views: 15,360 Rating: 5.00/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

The fifth in a series on MEAN web development.

MEAN web development #7: MongoDB and Mongoose [Technical Blog]

Posted: 6 Sep 2015 Updated: 7 Sep 2015 Views: 13,070 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0

The seventh in a series on MEAN web development.

MEAN web development #6: AngularJS in the front [Technical Blog]

Posted: 30 Aug 2015 Updated: 13 Sep 2015 Views: 13,461 Rating: 4.88/5 Votes: 7 Popularity: 4.09

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

The sixth in a series on MEAN web development.

MEAN web development #8: Sockets will rock your socks! [Technical Blog]

Posted: 13 Sep 2015 Updated: 14 Sep 2015 Views: 11,040 Rating: 4.95/5 Votes: 5 Popularity: 3.44

Licence: The Code Project Open License (CPOL) Bookmarked: 16 Downloaded: 0

The eighth in a series on MEAN web development.

MEAN web development #9: Some last remarks [Technical Blog]

Posted: 20 Sep 2015 Updated: 21 Sep 2015 Views: 9,130 Rating: 5.00/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

The last in a series on MEAN web development.

PHP

General

Web development #4: PHP in the back [Technical Blog]

Posted: 14 Feb 2015 Updated: 16 Mar 2015 Views: 19,350 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

The (long awaited) fourth in a series on web development.

Azure

General

ARM Templates to Deploy your Resources to Azure [Technical Blog]

Posted: 15 Aug 2018 Updated: 16 Aug 2018 Views: 4,320 Rating: 4.78/5 Votes: 2 Popularity: 1.51

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

Taking Continuous Deployment one step further by deploying your infrastructure to Azure using Azure Resource Manager Templates, or ARM Templates. The post ARM Templates to Deploy your Resources to Azure appeared first on Sander Rossel.

WebJobs in Azure with .NET Core 2.1 [Technical Blog]

Posted: 22 Aug 2018 Updated: 23 Aug 2018 Views: 7,790 Rating: 4.88/5 Votes: 6 Popularity: 3.77

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

Learn about and create Azure WebJobs from scratch in .NET Core 2.1 and release them to Azure using Visual Studio, the Azure portal, and VSTS. The post WebJobs in Azure with .NET Core 2.1 appeared first on Sander Rossel.

Azure Functions and Serverless Computing [Technical Blog]

Posted: 29 Aug 2018 Updated: 29 Aug 2018 Views: 4,810 Rating: 5.00/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

Get started with Azure Functions and serverless computing in Azure. We'll see what serverless computing is and how it's implemented in Functions.

Azure Deployment using Visual Studio Team Services (VSTS) and .NET Core [Technical Blog]

Posted: 9 Aug 2018 Updated: 31 Aug 2018 Views: 5,320 Rating: 4.96/5 Votes: 5 Popularity: 3.46

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

Set up Continuous Integration and Deployment to Azure in VSTS using Azure and Visual Studio. The post Azure Deployment using Visual Studio Team Services (VSTS) and .NET Core appeared first on Sander's bits.

Database

SQL Server

Using C# to Connect to and Query from a SQL Database [Technical Blog]

Posted: 3 Nov 2014 Updated: 16 Mar 2015 Views: 334,362 Rating: 4.70/5 Votes: 39 Popularity: 7.43

Licence: The Code Project Open License (CPOL) Bookmarked: 63 Downloaded: 0

Using C# to get data in- and out of your (relational) database

NoSQL

MongoDB

A First Look at NoSQL and MongoDB in Particular [Technical Blog]

Posted: 4 Nov 2014 Updated: 16 Mar 2015 Views: 28,553 Rating: 4.91/5 Votes: 19 Popularity: 6.28

Licence: The Code Project Open License (CPOL) Bookmarked: 35 Downloaded: 0

Getting your feet wet in NoSQL with MongoDB!

Collections

General

Maths in IT #1: Basic set theory [Technical Blog]

Posted: 3 Nov 2015 Updated: 4 Nov 2015 Views: 28,291 Rating: 4.95/5 Votes: 25 Popularity: 6.92

Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 0

A simple introduction to set theory.

Maths in IT #2: Venn diagrams [Technical Blog]

Posted: 7 Nov 2015 Updated: 9 Nov 2015 Views: 16,560 Rating: 5.00/5 Votes: 15 Popularity: 5.88

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

Using Venn diagrams to visualize sets.

Maths in IT #3: Algebra of sets [Technical Blog]

Posted: 13 Nov 2015 Updated: 16 Nov 2015 Views: 12,621 Rating: 4.86/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

An introduction to algebra and algebra of sets.

Programming Tips

General

How to Learn and Polyglot vs. Specialist [Technical Blog]

Posted: 4 Apr 2015 Updated: 4 Apr 2015 Views: 7,870 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

Why you should learn new languages and why you should know a lot about a bit and a bit about a lot.

Average tips rating: 4.72

Database

General

The Evil That is "Select *" [Tip/Trick]

Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 9,580 Rating: 4.43/5 Votes: 6 Popularity: 3.45

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Another 'weird feature' of select * is that in Views select * does not select all columns from a table. It selects all columns from a table that were in the table at the time that the View was created. I found that out when I added some columns to a table and wanted to map those columns in a...

Programming Tips

General

Text box to accept only number [Tip/Trick]

Posted: 24 Apr 2011 Updated: 24 Apr 2011 Views: 56,591 Rating: 4.33/5 Votes: 12 Popularity: 4.33

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

The following Class is a TextBox for WinForms that only accepts 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 (numerics) or backspace as input. Not using regular expressions.using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Windows.Forms;namespace...

Getting the one and only Type of an Object [Tip/Trick]

Posted: 6 Oct 2011 Updated: 7 Oct 2011 Views: 17,620 Rating: 4.85/5 Votes: 6 Popularity: 3.77

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

How to check an Objects Type, ignoring all subtypes, in C# and VB.

Preventing stubbed methods from being released [Tip/Trick]

Posted: 14 Oct 2011 Updated: 15 Oct 2011 Views: 7,410 Rating: 4.90/5 Votes: 3 Popularity: 2.34

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Very nice tips indeed!A somewhat different approach to this might be to use the Debugger.IsAttached[^] static property.Though this works somewhat different.if (System.Diagnostics.Debugger.IsAttached){ // This code executes when starting from VS either in release or debug...

One guideline every VB.NET project should follow! [Tip/Trick]

Posted: 23 Feb 2012 Updated: 25 Feb 2012 Views: 28,430 Rating: 5.00/5 Votes: 11 Popularity: 5.21

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

On the importance of Option Strict...

Write comments that matter [Tip/Trick]

Posted: 28 Sep 2012 Updated: 2 May 2015 Views: 28,131 Rating: 4.84/5 Votes: 21 Popularity: 6.29

Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 0

If you have nothing smart to comment, don't comment anything at all...

No reference articles have been posted.

No projects have been posted.

Sander Rossel

	Software Developer (Senior)
	Netherlands

Sander Rossel is a Microsoft certified professional developer with experience and expertise in .NET and .NET Core (C#, ASP.NET, and Entity Framework), SQL Server, Azure, Azure DevOps, JavaScript, and other technologies.
He has an interest in various technologies including, but not limited to, Cloud, NoSQL, Continuous Integration and Deployment, Functional Programming, and software quality in general.
In his spare time he writes articles for MSDN, CodeProject, and his own blog, as well as books about Object Oriented Programming, Databases, and Azure.

You can't miss his must read book Continuous Integration, Delivery, and Deployment!

Also make sure to check his FREE +/- 100 page eBooks Object-Oriented Programming in C# Succinctly and SQL Server for C# Developers Succinctly.

He wrote a JavaScript LINQ library, arrgh.js (works in IE8+, Edge, Firefox, Chrome, and probably everything else).

Check out his prize-winning articles here on CodeProject and his blogs over at sanderrossel.com as well!