Click here to Skip to main content
12,956,606 members (71,405 online)

Articles by Wendelius (Articles: 28, Technical Blogs: 2, Tip/Tricks: 34, Reference: 1)

Articles: 28, Technical Blogs: 2, Tip/Tricks: 34, Reference: 1

RSS Feed

Average article rating: 4.86

Database
Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 19,908   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 125
How to create custom aggregates in Oracle using PL/SQL
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 148,821   Rating: 4.72/5    Votes: 11   Popularity: 4.90
Licence: The Code Project Open License (CPOL)      Bookmarked: 23   Downloaded: 0
This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer
Posted: 8 Jan 2012   Updated: 8 Jan 2012   Views: 26,212   Rating: 4.94/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 279
This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
Posted: 13 Mar 2011   Updated: 1 Apr 2012   Views: 131,812   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 868
The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
Posted: 30 Apr 2012   Updated: 30 Apr 2012   Views: 16,866   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 200
This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
SQL
Posted: 13 Sep 2012   Updated: 13 Sep 2012   Views: 34,653   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
SQL Server
Posted: 2 Dec 2008   Updated: 2 Dec 2008   Views: 90,928   Rating: 4.91/5    Votes: 31   Popularity: 7.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 88   Downloaded: 1,036
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 53,558   Rating: 4.83/5    Votes: 17   Popularity: 5.93
Licence: The Code Project Open License (CPOL)      Bookmarked: 30   Downloaded: 199
This article describes the pseudo column to identify the unique physical location of a single row.
Posted: 17 Mar 2011   Updated: 26 Mar 2011   Views: 44,419   Rating: 4.95/5    Votes: 23   Popularity: 6.74
Licence: The Code Project Open License (CPOL)      Bookmarked: 39   Downloaded: 435
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 428,425   Rating: 4.92/5    Votes: 49   Popularity: 8.31
Licence: The Code Project Open License (CPOL)      Bookmarked: 64   Downloaded: 1,065
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 18,110   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 80
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Posted: 27 Dec 2011   Updated: 27 Dec 2011   Views: 181,246   Rating: 4.90/5    Votes: 14   Popularity: 5.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 1,123
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
Posted: 20 May 2012   Updated: 20 May 2012   Views: 9,592   Rating: 4.90/5    Votes: 7   Popularity: 4.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 98
This article describes a mechanism how trigger actions bypassed based on database user information
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 58,003   Rating: 4.55/5    Votes: 8   Popularity: 4.47
Licence: The Code Project Open License (CPOL)      Bookmarked: 25   Downloaded: 0
Article describes basic information about transaction log behavior and truncation of the log.
Posted: 11 Oct 2008   Updated: 3 Nov 2012   Views: 41,830   Rating: 4.18/5    Votes: 18   Popularity: 5.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 26   Downloaded: 155
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems.
Posted: 15 Dec 2011   Updated: 12 Dec 2014   Views: 272,073   Rating: 4.92/5    Votes: 39   Popularity: 7.82
Licence: The Code Project Open License (CPOL)      Bookmarked: 46   Downloaded: 795
Some simple scenarios to calculate running totals in SQL Server.
Posted: 19 Jan 2015   Updated: 21 Feb 2015   Views: 15,479   Rating: 4.94/5    Votes: 27   Popularity: 7.06
Licence: The Code Project Open License (CPOL)      Bookmarked: 33   Downloaded: 156
How to log information into a table from inside a transaction, even if the transaction is rolled back.
Posted: 19 Aug 2015   Updated: 3 Oct 2015   Views: 21,956   Rating: 4.90/5    Votes: 37   Popularity: 7.68
Licence: The Code Project Open License (CPOL)      Bookmarked: 49   Downloaded: 603
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
Posted: 11 Feb 2011   Updated: 12 Jul 2016   Views: 24,075   Rating: 4.97/5    Votes: 16   Popularity: 5.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 35
When considering to use NOLOCK hint, there are a few things that should be kept in mind.
Posted: 13 Oct 2016   Updated: 18 Oct 2016   Views: 5,334   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 232
Discussion and a few approaches how to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure.
Posted: 2 Oct 2016   Updated: 4 Nov 2016   Views: 9,675   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 400
Few CLR procedure concepts to write into a file from SQL Server database
Posted: 3 Jan 2009   Updated: 11 Dec 2016   Views: 147,740   Rating: 4.87/5    Votes: 44   Popularity: 7.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 86   Downloaded: 3,713
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
Posted: 2 Apr 2017   Updated: 2 Apr 2017   Views: 3,106   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 53
This is an alternative for "What You See Is What You Update"
Posted: 23 Mar 2017   Updated: 30 Apr 2017   Views: 9,607   Rating: 4.91/5    Votes: 15   Popularity: 5.75
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 335
This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
C#
Utilities
Posted: 10 Feb 2015   Updated: 17 Feb 2015   Views: 25,992   Rating: 4.91/5    Votes: 43   Popularity: 8.02
Licence: The Code Project Open License (CPOL)      Bookmarked: 84   Downloaded: 2,004
This article shows how to build a responsive directory size browser application utilizing threading. The source code includes both C# and VB.Net
Libraries
Code Libraries
Posted: 22 Apr 2012   Updated: 5 May 2012   Views: 197,774   Rating: 4.92/5    Votes: 44   Popularity: 8.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 102   Downloaded: 16,790
This article describes how to create a basic Excel workbook using Open XML.
Algorithms & Recipes
Math
Posted: 22 May 2016   Updated: 5 Jun 2016   Views: 11,024   Rating: 4.83/5    Votes: 9   Popularity: 4.59
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 463
Simple linear trend calculation with different types for X values implemented in C#, VB, and F#
Cryptography & Security
Encryption
Posted: 9 Sep 2012   Updated: 21 Aug 2015   Views: 63,470   Rating: 4.98/5    Votes: 47   Popularity: 8.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 122   Downloaded: 4,113
Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.

Average blogs rating: 4.72

Database
General
Posted: 23 Aug 2015   Updated: 25 Aug 2015   Views: 11,574   Rating: 4.72/5    Votes: 6   Popularity: 3.78
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
This post discusses about how to add checks into a SQL statement in order to prevent wrong results in case of possible future changes.
SQL Server
Posted: 7 Oct 2012   Updated: 19 Oct 2012   Views: 9,213   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
System.IO.Packaging namespace in WindowsBase may cause problems when trying to create a CLR procedure.

Average tips rating: 4.89

Oracle
Posted: 19 May 2012   Updated: 19 May 2012   Views: 6,971   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 22
This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.
Posted: 31 Aug 2014   Updated: 31 Aug 2014   Views: 7,461   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 32
Two ways of generating desired amount of rows in Oracle by using a single SQL statement.
Posted: 5 Sep 2014   Updated: 5 Sep 2014   Views: 11,272   Rating: 4.20/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 36
This tip shows two ways of generating Fibonacci numbers in a single SQL statement
Posted: 22 Feb 2011   Updated: 26 Jul 2015   Views: 17,389   Rating: 4.82/5    Votes: 6   Popularity: 3.74
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
This tip demonstrates the use of LAG and LEAD functions in Oracle.
SQL Server
Posted: 20 Feb 2011   Updated: 20 Feb 2011   Views: 81,904   Rating: 4.95/5    Votes: 12   Popularity: 5.31
Licence: The Code Project Open License (CPOL)      Bookmarked: 21   Downloaded: 0
This tip describes how to delete duplicate rows from a table that doesn't have a key.
Posted: 5 May 2012   Updated: 6 May 2012   Views: 15,739   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
This is an alternative for "List SQL Server table column name as rows".
Posted: 14 May 2012   Updated: 14 May 2012   Views: 5,723   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 30
This is an alternative for "Applying Running Total to a Result set"
Posted: 19 May 2012   Updated: 19 May 2012   Views: 4,440   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 24
This tip describes how to guarantee a fixed amount of rows in a table by using triggers
Posted: 20 Feb 2011   Updated: 20 Dec 2012   Views: 23,789   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 0
This tip describes how to delete duplicate rows from a table that doesn't have a key.
Posted: 27 Dec 2012   Updated: 17 Jan 2013   Views: 14,507   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 38
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
Posted: 18 Dec 2012   Updated: 19 Jan 2013   Views: 18,316   Rating: 5.00/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 36
This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.
Posted: 26 Aug 2014   Updated: 26 Aug 2014   Views: 25,461   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 130
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 16,970   Rating: 4.83/5    Votes: 10   Popularity: 4.83
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 84
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 18,424   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 68
This tip demonstrates the use of LAG and LEAD functions in SQL Server.
Posted: 10 Sep 2014   Updated: 10 Sep 2014   Views: 4,570   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 23
The tip shows how to intentionally cause an error in a situation where a non-existing reference would be updated.
Posted: 13 Sep 2014   Updated: 13 Sep 2014   Views: 6,402   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 53
This tip describes how to fetch the first or the last occurrence of given day of week within a month by using a single SQL statement.
Posted: 26 Aug 2014   Updated: 16 Sep 2014   Views: 23,868   Rating: 4.64/5    Votes: 5   Popularity: 3.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 88
How to generate desired amount of rows in SQL Server using CTE
Posted: 18 Sep 2015   Updated: 18 Sep 2015   Views: 10,986   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 87
This tip shows how to calculate a difference between two datetime values and to express the difference in years, days, hours, minutes and so on.
Posted: 26 Sep 2016   Updated: 30 Sep 2016   Views: 5,393   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
TrimChar function which removes occurences of the desired character from both ends of a string.
Posted: 4 Oct 2016   Updated: 4 Oct 2016   Views: 3,551   Rating: 4.50/5    Votes: 5   Popularity: 3.10
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Few tips for connecting to an SQL Server instance using DAC
Posted: 13 Oct 2016   Updated: 13 Oct 2016   Views: 4,950   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 35
A little tip on how to format repeating values in SQL output using LAG function
Posted: 7 Dec 2016   Updated: 7 Dec 2016   Views: 7,640   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 25
This tip demonstrates how to select valid records from a table that contains validity date limits.
C#
General
Posted: 17 Nov 2012   Updated: 17 Nov 2012   Views: 5,401   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 47
The tip shows an example for using multiple partial classes to define a single class.
Samples
Posted: 26 Jul 2012   Updated: 26 Jul 2012   Views: 12,439   Rating: 4.72/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 69
This tip describes few examples how ro cumulate values using an extension method with LINQ
Posted: 28 Jul 2012   Updated: 27 Jul 2012   Views: 6,571   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 18
This is an alternative for "Cumulating values with LINQ"
LINQ
General
Posted: 5 Oct 2015   Updated: 5 Oct 2015   Views: 7,705   Rating: 4.91/5    Votes: 9   Popularity: 4.68
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 331
This tip shows one way to query hierarchical data from a DataTable by using an AsTree() method.
Programming Tips
Design and Strategy
Posted: 20 Jul 2012   Updated: 10 Aug 2012   Views: 31,562   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 85
This tip describes how to use an existing enum to define a new, for example a context specific enum.
General
Posted: 10 Aug 2011   Updated: 10 Aug 2011   Views: 4,472   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Or simply:exec msdb..sp_help_jobsp_help_job (Transact-SQL)[^]
Posted: 25 Nov 2011   Updated: 24 Dec 2011   Views: 14,281   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
As a general rule of thumb, I'd suggest browsing http://www.connectionstrings.com/[^] for connection strings against popular data sources.
Posted: 26 Aug 2012   Updated: 26 Aug 2012   Views: 27,037   Rating: 5.00/5    Votes: 10   Popularity: 4.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 507
The tip shows one way to resolve if a user control is in design mode.
Posted: 26 Jul 2015   Updated: 26 Jul 2015   Views: 3,603   Rating: 4.50/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 114
This tip shows how to extract images from an Office document saved in Office Open XML format.
String handling
Strings
Posted: 7 Nov 2012   Updated: 7 Nov 2012   Views: 16,378   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
This is an alternative for "Manipulating a string array using a Lambda Expression"
Installation
General
Posted: 27 Mar 2012   Updated: 27 Mar 2012   Views: 10,991   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
This tip describes a way to get publishing information for a ClickOnce deployed application
Posted: 1 Apr 2012   Updated: 1 Apr 2012   Views: 10,991   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
This is an alternative for "Getting publishing information for a ClickOnce deployment"

Average reference rating: 4.89

Applications & Tools
General
Posted: 5 Nov 2013   Updated: 26 Jun 2014   Views: 88,481   Rating: 4.89/5    Votes: 41   Popularity: 7.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 165   Downloaded: 0
A list of useful development tools edited by members of CodeProject

Wendelius
Architect
Finland Finland
No Biography provided


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 30 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid