Articles by Christian Graus (Articles: 51)

Articles: 51

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.53

Database Development
SQL Server	SQL Wizardry Part Five - when not to use DISTINCT 3 Jan 2014 Updated: 6 Jan 2014 Rating: 4.86/5 Votes: 9 Popularity: 4.63 Licence: CPOL Views: 19,341 Bookmarked: 18 Downloaded: 190 Please Sign up or sign in to vote. Just a quick explanation of why it's not always a good idea to use DISTINCT
	SQL Wizardry Part One - Joins 21 Dec 2013 Updated: 23 Jan 2014 Rating: 4.81/5 Votes: 42 Popularity: 7.77 Licence: CPOL Views: 102,911 Bookmarked: 73 Downloaded: 689 Please Sign up or sign in to vote. The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL
	SQL Wizardry Part 2 - Select, beyond the basics 24 Dec 2013 Updated: 12 Mar 2014 Rating: 4.83/5 Votes: 16 Popularity: 5.82 Licence: CPOL Views: 32,421 Bookmarked: 38 Downloaded: 342 Please Sign up or sign in to vote. The second in my series digs in to some of the different things you can do within a select statement.
	Thinking in SQL - Working with dates 12 Mar 2014 Updated: 14 Mar 2014 Rating: 4.58/5 Votes: 20 Popularity: 5.96 Licence: CPOL Views: 48,244 Bookmarked: 39 Downloaded: 339 Please Sign up or sign in to vote. In this installment, I talk about working with dates and date functions in SQL Server
	SQL Wizardry Part Four - Passing Lists of Data to SQL Server 3 Jan 2014 Updated: 12 Jan 2014 Rating: 4.74/5 Votes: 19 Popularity: 5.95 Licence: CPOL Views: 31,713 Bookmarked: 33 Downloaded: 299 Please Sign up or sign in to vote. Ways to pass an arbitrary list of values to SQL Server
	SQL Wizardry Part Three - Common Table Expressions (CTEs) 26 Dec 2013 Updated: 12 Jan 2014 Rating: 4.99/5 Votes: 19 Popularity: 6.38 Licence: CPOL Views: 27,413 Bookmarked: 45 Downloaded: 264 Please Sign up or sign in to vote. In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
	SQL Wizardry Part Six - Windowing Functions 12 Jan 2014 Updated: 13 Jan 2014 Rating: 4.70/5 Votes: 9 Popularity: 4.48 Licence: CPOL Views: 26,102 Bookmarked: 25 Downloaded: 199 Please Sign up or sign in to vote. A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
	SQL Wizardry Part Seven - PIVOT and arbitrary lists of data 16 Jan 2014 Updated: 16 Jan 2014 Rating: 4.98/5 Votes: 13 Popularity: 5.55 Licence: CPOL Views: 23,491 Bookmarked: 28 Downloaded: 198 Please Sign up or sign in to vote. Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
	SQL Wizardry Part Eight - Tally Tables 19 Jan 2014 Updated: 21 Jan 2014 Rating: 4.96/5 Votes: 20 Popularity: 6.35 Licence: CPOL Views: 35,984 Bookmarked: 26 Downloaded: 224 Please Sign up or sign in to vote. A description of the best way to create tally tables, and how to use them
	Thinking in SQL - Generating Random Numbers 23 Jan 2014 Updated: 23 Jan 2014 Rating: 4.80/5 Votes: 2 Popularity: 1.44 Licence: CPOL Views: 28,111 Bookmarked: 11 Downloaded: 180 Please Sign up or sign in to vote. A discussion of ways to create random number sequences in SQL Server
	Thinking in SQL - Distribution Functions in SS 2012 24 Mar 2014 Updated: 24 Mar 2014 Rating: 3.67/5 Votes: 3 Popularity: 1.75 Licence: CPOL Views: 16,620 Bookmarked: 7 Downloaded: 75 Please Sign up or sign in to vote. Covering how to use the new Distribution functions in SQL Server 2012
Desktop Programming
MFC	Christian and James' Code Project Screensaver 17 Apr 2002 Updated: 16 May 2002 Rating: 4.41/5 Votes: 16 Popularity: 5.06 Licence: Custom Views: 404,323 Bookmarked: 62 Downloaded: 892 Please Sign up or sign in to vote. Our attempt at a screen saver with a Code Project theme, written in C#
	CCheckStatic 12 Mar 2001 Updated: 12 Mar 2001 Rating: 4.94/5 Votes: 18 Popularity: 5.95 Licence: Not specified Views: 110,295 Bookmarked: 29 Downloaded: 1,817 Please Sign up or sign in to vote. A Static derived class which provides a check box to enable/disable items inside it
	CGSToolBar 20 Feb 2001 Updated: 20 Feb 2001 Rating: 3.86/5 Votes: 8 Popularity: 3.48 Licence: CPOL Views: 117,442 Bookmarked: 29 Downloaded: 2,558 Please Sign up or sign in to vote. A flexible extension to the CToolBar class
	Grausteroids - an Asteroids game using DirectX and C++ 7 Apr 2002 Updated: 7 Apr 2002 Rating: 4.95/5 Votes: 22 Popularity: 6.33 Licence: Not specified Views: 225,396 Bookmarked: 39 Downloaded: 5,017 Please Sign up or sign in to vote. An Asteroid's clone which needs some work but will illustrate some points about writing games.
	GDI+ Brushes and Matrices 12 May 2001 Updated: 30 May 2001 Rating: 4.72/5 Votes: 9 Popularity: 4.51 Licence: Not specified Views: 379,797 Bookmarked: 42 Downloaded: 2,363 Please Sign up or sign in to vote. Using GDI+ to draw solid/gradient filled and textured shapes
	Starting with GDI+ 12 May 2001 Updated: 12 Mar 2003 Rating: 4.80/5 Votes: 70 Popularity: 8.67 Licence: Not specified Views: 1,972,613 Bookmarked: 219 Downloaded: 12,071 Please Sign up or sign in to vote. Getting started with the new Microsoft Graphics Libraries
WPF	WPF Tutorial - Part 2 : Writing a custom animation class 12 Apr 2007 Updated: 12 Apr 2007 Rating: 4.85/5 Votes: 53 Popularity: 8.28 Licence: CPOL Views: 229,372 Bookmarked: 84 Downloaded: 7,057 Please Sign up or sign in to vote. This article covers how animations can be applied on properties that do not have an associated animation class
	WPF Tutorial - Part 1 : Transformations 21 Jul 2006 Updated: 28 Jun 2010 Rating: 4.40/5 Votes: 56 Popularity: 7.63 Licence: CPOL Views: 352,690 Bookmarked: 127 Downloaded: 7,908 Please Sign up or sign in to vote. A brief introduction to using transformations with the WPF
Hosted Services
Azure	Using Azure AD for login to an Angular application Part 1 15 Apr 2019 Updated: 15 Apr 2019 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 26,763 Bookmarked: 1 Downloaded: 622 Please Sign up or sign in to vote. First in a series on using Azure AD with Angular applications
	Azure AD and Angular Part 2 - Securing the Back End 16 Apr 2019 Updated: 16 Apr 2019 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 10,373 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. In part two, we start protecting our back end APIs with Azure AD
	Angular and Azure AD part 3 - adding role based security 17 Apr 2019 Updated: 17 Apr 2019 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 12,334 Bookmarked: 2 Downloaded: 129 Please Sign up or sign in to vote. Adding role based security to our Azure AD/Angular website
Mobile Apps
	Your first Palm app - covering GUI components, alerts and forms. 4 Nov 2002 Updated: 5 Nov 2002 Rating: 4.50/5 Votes: 5 Popularity: 3.15 Licence: CPOL Views: 135,550 Bookmarked: 27 Downloaded: 213 Please Sign up or sign in to vote. Building on previous articles, we develop a simple application and discuss some of the components available for Palm GUI.
	Palm databases - how to persist data on a Palm hand held 6 Nov 2002 Updated: 6 Nov 2002 Rating: 4.17/5 Votes: 8 Popularity: 3.76 Licence: CPOL Views: 132,841 Bookmarked: 30 Downloaded: 113 Please Sign up or sign in to vote. Continuing our series of articles, we discuss how to create databases, and create, modify and delete records
	An introduction to the Palm platform 7 Nov 2002 Updated: 7 Nov 2002 Rating: 4.83/5 Votes: 9 Popularity: 4.61 Licence: CPOL Views: 124,865 Bookmarked: 45 Downloaded: 0 Please Sign up or sign in to vote. An overview of the Palm world, including a list of C functions which have preferred equivalents in PalmOS
Multimedia
DirectX	Problems in the AudioVideoPlayback namespace of managed DirectX9 13 Sep 2004 Updated: 13 Sep 2004 Rating: 4.68/5 Votes: 38 Popularity: 7.22 Licence: CPOL Views: 254,394 Bookmarked: 39 Downloaded: 2,043 Please Sign up or sign in to vote. A guided tour of the many reasons NOT to use DirectX9 for your audio/video playback needs
GDI+	Doodle - A Basic Paint Package in GDI+ 3 Jun 2001 Updated: 3 Jun 2001 Rating: 4.72/5 Votes: 15 Popularity: 5.41 Licence: Custom Views: 410,159 Bookmarked: 68 Downloaded: 3,262 Please Sign up or sign in to vote. Using GDI+ to create a paint program with soft brushes and loading/saving images
	GDI+ RoundedRect 15 Feb 2002 Updated: 15 Feb 2002 Rating: 3.80/5 Votes: 9 Popularity: 3.63 Licence: Not specified Views: 102,671 Bookmarked: 33 Downloaded: 1,531 Please Sign up or sign in to vote. Providing a RoundedRect function for GDI+
	Image Processing for Dummies with C# and GDI+ Part 1 - Per Pixel Filters 20 Mar 2002 Updated: 20 Mar 2002 Rating: 4.91/5 Votes: 200 Popularity: 11.23 Licence: Not specified Views: 2,453,096 Bookmarked: 578 Downloaded: 21,398 Please Sign up or sign in to vote. The first in a series of articles which will build an image processing library in C# and GDI+
Operating Systems
Windows	How to Use Google and Other Tips for Finding Programming Help 8 Mar 2008 Updated: 8 Mar 2008 Rating: 4.38/5 Votes: 161 Popularity: 9.65 Licence: CPOL Views: 246,793 Bookmarked: 129 Downloaded: 0 Please Sign up or sign in to vote. A primer for people looking to learn to help themselves find answers to programming questions
Programming Languages
C#	MSDEGUI - a GUI tool to help developers use the MSDE database 18 Nov 2002 Updated: 27 Nov 2002 Rating: 4.79/5 Votes: 29 Popularity: 6.77 Licence: Not specified Views: 356,635 Bookmarked: 129 Downloaded: 7,837 Please Sign up or sign in to vote. This tool uses ADO.NET to offer browsing of databases and tables, editing values and an SQL window to test queries.
	A wrapper for the canon CDSDK and PRSDK for remote capture 26 Jan 2007 Updated: 18 May 2007 Rating: 4.94/5 Votes: 31 Popularity: 7.23 Licence: Not specified Views: 870,250 Bookmarked: 83 Downloaded: 4,470 Please Sign up or sign in to vote. A wrapper to allow remote capture of images with Canon cameras in C#
	Image Processing for Dummies with C# and GDI+ Part 3 - Edge Detection Filters 31 Mar 2002 Updated: 31 Mar 2002 Rating: 4.92/5 Votes: 71 Popularity: 9.02 Licence: CPOL Views: 638,006 Bookmarked: 244 Downloaded: 15,006 Please Sign up or sign in to vote. The third in a series of articles which will build an image processing library in C# and GDI+
	Image Processing for Dummies with C# and GDI+ Part 4 - Bilinear Filters and Resizing 14 Apr 2002 Updated: 14 Apr 2002 Rating: 4.80/5 Votes: 49 Popularity: 7.94 Licence: CPOL Views: 508,489 Bookmarked: 179 Downloaded: 5,854 Please Sign up or sign in to vote. The fourth installment covers how to write a filter that resizes an image, and uses bilinear filtering
	Image Processing for Dummies with C# and GDI+ Part 5 - Displacement filters, including swirl 23 Dec 2002 Updated: 25 Dec 2002 Rating: 4.90/5 Votes: 146 Popularity: 10.54 Licence: Not specified Views: 942,835 Bookmarked: 283 Downloaded: 10,229 Please Sign up or sign in to vote. In the fifth installment, we build a framework for generating filters that work by changing a pixel's location, rather than colour.
	Image Processing for Dummies with C# and GDI+ Part 6 - The HSL color space 22 May 2004 Updated: 28 Jun 2004 Rating: 4.84/5 Votes: 57 Popularity: 8.46 Licence: CPOL Views: 418,731 Bookmarked: 199 Downloaded: 7,975 Please Sign up or sign in to vote. A discussion of the HSL color space, including code for a color picker and image filters
	Image Processing for Dummies with C# and GDI+ Part 2 - Convolution Filters 23 Mar 2002 Updated: 7 Nov 2005 Rating: 4.91/5 Votes: 120 Popularity: 10.14 Licence: CPOL Views: 1,596,860 Bookmarked: 331 Downloaded: 15,409 Please Sign up or sign in to vote. The second in a series of articles which will build an image processing library in C# and GDI+.
	Bottleneck - a tool for finding code bottlenecks in C# 14 May 2002 Updated: 14 May 2002 Rating: 3.56/5 Votes: 11 Popularity: 3.70 Licence: Not specified Views: 91,011 Bookmarked: 31 Downloaded: 1,456 Please Sign up or sign in to vote. A simple tool that can be used to time how long different parts of your code take to execute, and where bottlenecks occur
	Collision - A C# Game, Part 1: Parallax Scrolling 16 Apr 2002 Updated: 16 Apr 2002 Rating: 3.86/5 Votes: 4 Popularity: 2.32 Licence: Custom Views: 107,901 Bookmarked: 38 Downloaded: 1,447 Please Sign up or sign in to vote. In which I attempt to write a simple game in C#
	Collision - A C# Game, Part 2: Tracking Game Elements and Adding Interaction 16 Apr 2002 Updated: 16 Apr 2002 Rating: 3.22/5 Votes: 3 Popularity: 1.54 Licence: Custom Views: 64,122 Bookmarked: 34 Downloaded: 818 Please Sign up or sign in to vote. Continuing my attempt at a simple game in C#
	Collision - A C# Game, Part 3: Pixel Perfect Collision Detection 16 Apr 2002 Updated: 16 Apr 2002 Rating: 4.38/5 Votes: 16 Popularity: 5.15 Licence: Custom Views: 121,056 Bookmarked: 39 Downloaded: 2,187 Please Sign up or sign in to vote. Finishing my attempt at a simple game in C#
C++	Koenig Lookup - a C++ primer 15 Dec 2002 Updated: 15 Dec 2002 Rating: 4.34/5 Votes: 37 Popularity: 6.54 Licence: Not specified Views: 174,286 Bookmarked: 26 Downloaded: 0 Please Sign up or sign in to vote. A discussion of Koenig namespace lookup, for those with VS.NET 2003
	STL 101 Part A - Vector 20 Feb 2002 Updated: 20 Feb 2002 Rating: 3.31/5 Votes: 23 Popularity: 4.51 Licence: Not specified Views: 244,164 Bookmarked: 37 Downloaded: 6 Please Sign up or sign in to vote. The first in a series of articles on STL, this one covers vector and some common algorithms
	STL101 Part B - List and Iterators 24 Feb 2002 Updated: 24 Feb 2002 Rating: 4.20/5 Votes: 11 Popularity: 4.20 Licence: Not specified Views: 361,777 Bookmarked: 30 Downloaded: 0 Please Sign up or sign in to vote. My second STL article covers std::list and discusses different iterator types
	STL 101 Part D - sorted associative containers, Set and Map 23 Mar 2002 Updated: 23 Mar 2002 Rating: 4.71/5 Votes: 15 Popularity: 5.25 Licence: Not specified Views: 181,471 Bookmarked: 33 Downloaded: 1,743 Please Sign up or sign in to vote. Coverage of two more containers from the STL, namely set and map, and the functions provided for them.
	STL101 Part C - Functors 24 Feb 2002 Updated: 1 Apr 2002 Rating: 3.52/5 Votes: 16 Popularity: 4.24 Licence: Not specified Views: 187,342 Bookmarked: 39 Downloaded: 0 Please Sign up or sign in to vote. This third article describes how to write function adaptors which allow customization of STL functions.
	OStringStream, or how to stop worrying and never use sprintf again 20 Mar 2002 Updated: 20 Mar 2002 Rating: 4.71/5 Votes: 28 Popularity: 6.67 Licence: Not specified Views: 302,635 Bookmarked: 44 Downloaded: 1,295 Please Sign up or sign in to vote. A typesafe alternative to sprintf from the std library
	IOStream Inserters And Extractors 16 Apr 2002 Updated: 16 Apr 2002 Rating: 4.29/5 Votes: 9 Popularity: 4.10 Licence: Not specified Views: 83,374 Bookmarked: 23 Downloaded: 968 Please Sign up or sign in to vote. Showing how to extend iostreams in order to stream custom types
	iostream modifiers 14 Jul 2002 Updated: 14 Jul 2002 Rating: 4.60/5 Votes: 7 Popularity: 3.89 Licence: Not specified Views: 125,140 Bookmarked: 21 Downloaded: 398 Please Sign up or sign in to vote. An exploration of extending the iostreams framework through stream modifiers
	Deriving your own stream from the iostreams framework 24 Jul 2002 Updated: 24 Jul 2002 Rating: 3.80/5 Votes: 7 Popularity: 3.21 Licence: Not specified Views: 90,862 Bookmarked: 20 Downloaded: 987 Please Sign up or sign in to vote. An exploration of extending the iostreams framework through custom streams.
Web Development
ASP.NET	A Wrapper for Using .NET to Submit Credit Card Transactions via the Authorize Gateway 11 Apr 2008 Updated: 11 Apr 2008 Rating: 4.38/5 Votes: 9 Popularity: 4.17 Licence: CPOL Views: 41,411 Bookmarked: 44 Downloaded: 328 Please Sign up or sign in to vote. A .NET wrapper for Authorize

Average blogs rating:

No blogs have been submitted.

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Christian Graus

Software Developer (Senior)

Australia

Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.

Articles by Christian Graus (Articles: 51)

Articles: 51

Average article rating: 4.53

Database Development

Desktop Programming

Hosted Services

Mobile Apps

Multimedia

Operating Systems

Programming Languages

Web Development

Average blogs rating:

Average tips rating:

Average reference rating:

Average project rating: