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: 20,313 Bookmarked: 18 Downloaded: 210 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: 112,474 Bookmarked: 74 Downloaded: 704 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: 33,032 Bookmarked: 38 Downloaded: 355 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: 49,486 Bookmarked: 39 Downloaded: 350 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: 32,706 Bookmarked: 33 Downloaded: 314 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: 28,114 Bookmarked: 45 Downloaded: 276 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,693 Bookmarked: 25 Downloaded: 211 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: 24,271 Bookmarked: 28 Downloaded: 208 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: 37,475 Bookmarked: 26 Downloaded: 239 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,431 Bookmarked: 11 Downloaded: 194 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,903 Bookmarked: 7 Downloaded: 90 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: 418,355 Bookmarked: 62 Downloaded: 910 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: 111,905 Bookmarked: 29 Downloaded: 1,843 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: 118,825 Bookmarked: 29 Downloaded: 2,586 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: 229,356 Bookmarked: 39 Downloaded: 5,053 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: 385,247 Bookmarked: 42 Downloaded: 2,402 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: 2,030,355 Bookmarked: 219 Downloaded: 12,156 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: 234,614 Bookmarked: 84 Downloaded: 7,103 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: 356,773 Bookmarked: 127 Downloaded: 7,930 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: 27,785 Bookmarked: 1 Downloaded: 635 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: 11,046 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: 13,084 Bookmarked: 2 Downloaded: 144 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: 137,803 Bookmarked: 27 Downloaded: 244 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: 135,014 Bookmarked: 30 Downloaded: 138 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: 126,727 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: 259,864 Bookmarked: 39 Downloaded: 2,062 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: 423,291 Bookmarked: 68 Downloaded: 3,296 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: 103,533 Bookmarked: 33 Downloaded: 1,562 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,523,687 Bookmarked: 579 Downloaded: 21,496 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: 252,534 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: 362,098 Bookmarked: 129 Downloaded: 7,844 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: 900,236 Bookmarked: 83 Downloaded: 4,486 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: 652,350 Bookmarked: 244 Downloaded: 15,037 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: 516,201 Bookmarked: 179 Downloaded: 5,861 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: 976,768 Bookmarked: 283 Downloaded: 10,275 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: 432,742 Bookmarked: 199 Downloaded: 8,017 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,665,676 Bookmarked: 331 Downloaded: 15,458 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,614 Bookmarked: 31 Downloaded: 1,462 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: 108,331 Bookmarked: 38 Downloaded: 1,455 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,432 Bookmarked: 34 Downloaded: 824 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: 122,026 Bookmarked: 39 Downloaded: 2,191 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: 176,751 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: 249,726 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: 363,367 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: 182,781 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: 189,213 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: 306,275 Bookmarked: 44 Downloaded: 1,297 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,867 Bookmarked: 23 Downloaded: 970 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: 126,620 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: 91,553 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: 42,063 Bookmarked: 44 Downloaded: 329 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: