Click here to Skip to main content
13,867,148 members

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

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

RSS Feed

Average article rating: 4.88

Database
Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 28,900   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 138
How to create custom aggregates in Oracle using PL/SQL
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 169,494   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: 36,850   Rating: 4.94/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 299
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: 149,781   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 972
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: 1 May 2012   Views: 25,890   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 236
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: 46,097   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   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: 111,285   Rating: 4.91/5    Votes: 31   Popularity: 7.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 88   Downloaded: 1,095
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 68,102   Rating: 4.85/5    Votes: 18   Popularity: 6.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 30   Downloaded: 209
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: 60,444   Rating: 4.95/5    Votes: 24   Popularity: 6.84
Licence: The Code Project Open License (CPOL)      Bookmarked: 40   Downloaded: 496
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 513,813   Rating: 4.92/5    Votes: 51   Popularity: 8.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 64   Downloaded: 1,170
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 26,081   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 84
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: 221,122   Rating: 4.90/5    Votes: 15   Popularity: 5.76
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 1,239
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: 14,930   Rating: 4.90/5    Votes: 7   Popularity: 4.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 106
This article describes a mechanism how trigger actions bypassed based on database user information
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 63,721   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: 15 Dec 2011   Updated: 12 Dec 2014   Views: 345,314   Rating: 4.90/5    Votes: 40   Popularity: 7.88
Licence: The Code Project Open License (CPOL)      Bookmarked: 48   Downloaded: 913
Some simple scenarios to calculate running totals in SQL Server.
Posted: 19 Jan 2015   Updated: 21 Feb 2015   Views: 27,301   Rating: 4.94/5    Votes: 29   Popularity: 7.23
Licence: The Code Project Open License (CPOL)      Bookmarked: 37   Downloaded: 201
How to log information into a table from inside a transaction, even if the transaction is rolled back.
Posted: 11 Feb 2011   Updated: 12 Jul 2016   Views: 35,130   Rating: 4.97/5    Votes: 17   Popularity: 6.11
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 48
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: 9,070   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 293
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: 13,320   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 439
Few CLR procedure concepts to write into a file from SQL Server database
Posted: 3 Jan 2009   Updated: 11 Dec 2016   Views: 175,306   Rating: 4.87/5    Votes: 44   Popularity: 8.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 88   Downloaded: 4,398
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: 5,460   Rating: 4.95/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 68
This is an alternative for "What You See Is What You Update"
Posted: 23 Mar 2017   Updated: 30 Apr 2017   Views: 14,281   Rating: 4.91/5    Votes: 15   Popularity: 5.75
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 406
This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
Posted: 19 Aug 2015   Updated: 10 Jul 2017   Views: 31,630   Rating: 4.91/5    Votes: 40   Popularity: 7.87
Licence: The Code Project Open License (CPOL)      Bookmarked: 57   Downloaded: 749
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
Posted: 11 Oct 2008   Updated: 7 Feb 2018   Views: 55,714   Rating: 4.34/5    Votes: 23   Popularity: 5.75
Licence: The Code Project Open License (CPOL)      Bookmarked: 35   Downloaded: 187
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems. This is done by enabling snapshot isolation.
Posted: 26 Dec 2018   Updated: 26 Dec 2018   Views: 2,714   Rating: 5.00/5    Votes: 4   Popularity: 2.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 74
This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.
C#
Utilities
Posted: 10 Feb 2015   Updated: 17 Feb 2015   Views: 38,890   Rating: 4.91/5    Votes: 45   Popularity: 8.12
Licence: The Code Project Open License (CPOL)      Bookmarked: 93   Downloaded: 2,486
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: 237,679   Rating: 4.92/5    Votes: 47   Popularity: 8.23
Licence: The Code Project Open License (CPOL)      Bookmarked: 105   Downloaded: 18,602
This article describes how to create a basic Excel workbook using Open XML.
Algorithms & Recipes
Math
Posted: 22 May 2016   Updated: 15 Aug 2017   Views: 28,493   Rating: 4.96/5    Votes: 14   Popularity: 5.69
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 1,214
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: 87,492   Rating: 4.98/5    Votes: 48   Popularity: 8.37
Licence: The Code Project Open License (CPOL)      Bookmarked: 127   Downloaded: 4,432
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: 14,510   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: 11,770   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.88

General
Posted: 21 Feb 2011   Updated: 26 Jul 2015   Views: 14,880   Rating: 4.86/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
This alternative is created to correct few mistakes in the original tip. Most importantly: Never update system tables.
Oracle
Posted: 19 May 2012   Updated: 19 May 2012   Views: 8,520   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: 10,172   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 33
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: 16,972   Rating: 4.20/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 43
This tip shows two ways of generating Fibonacci numbers in a single SQL statement
Posted: 22 Feb 2011   Updated: 26 Jul 2015   Views: 20,311   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.
Posted: 13 Jul 2017   Updated: 13 Jul 2017   Views: 9,182   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 33
This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"
SQL Server
Posted: 20 Feb 2011   Updated: 20 Feb 2011   Views: 91,690   Rating: 4.95/5    Votes: 12   Popularity: 5.31
Licence: The Code Project Open License (CPOL)      Bookmarked: 22   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: 19,811   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: 6,940   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 31
This is an alternative for "Applying Running Total to a Result set"
Posted: 19 May 2012   Updated: 19 May 2012   Views: 5,261   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: 27,671   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: 20,372   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 44
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
Posted: 18 Dec 2012   Updated: 19 Jan 2013   Views: 26,051   Rating: 5.00/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 37
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: 38,241   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 178
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 26,492   Rating: 4.83/5    Votes: 10   Popularity: 4.83
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 92
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 22,260   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: 6,100   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: 8,530   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 57
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: 39,384   Rating: 4.64/5    Votes: 5   Popularity: 3.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 89
How to generate desired amount of rows in SQL Server using CTE
Posted: 18 Sep 2015   Updated: 18 Sep 2015   Views: 30,431   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 144
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: 7,001   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: 13,748   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: 7,100   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 36
A little tip on how to format repeating values in SQL output using LAG function
Posted: 7 Dec 2016   Updated: 7 Dec 2016   Views: 8,651   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 26
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: 7,040   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 48
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: 16,931   Rating: 4.72/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 85
This tip describes few examples how ro cumulate values using an extension method with LINQ
Posted: 28 Jul 2012   Updated: 27 Jul 2012   Views: 8,392   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: 13,131   Rating: 4.93/5    Votes: 11   Popularity: 5.12
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 425
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: 42,444   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 99
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: 5,981   Rating: 4.60/5    Votes: 3   Popularity: 1.43
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: 17,770   Rating: 4.73/5    Votes: 6   Popularity: 3.89
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: 35,043   Rating: 5.00/5    Votes: 10   Popularity: 4.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 581
The tip shows one way to resolve if a user control is in design mode.
Posted: 26 Jul 2015   Updated: 26 Jul 2015   Views: 5,360   Rating: 4.50/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 129
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: 21,140   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 "Manipulating a string array using a Lambda Expression"
Installation
General
Posted: 27 Mar 2012   Updated: 27 Mar 2012   Views: 14,030   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: 12,810   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.92

Tools and IDE
General
Posted: 5 Nov 2013   Updated: 4 Aug 2017   Views: 138,898   Rating: 4.92/5    Votes: 50   Popularity: 8.35
Licence: The Code Project Open License (CPOL)      Bookmarked: 213   Downloaded: 0
A list of useful development tools edited by members of CodeProject
No projects have been posted.

Wendelius
Architect
Europe Europe
This member does have enough reputation to be able to display their biography and homepage.







Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190214.1 | Last Updated 21 Feb 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid