Click here to Skip to main content
12,761,098 members (30,142 online)

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

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

RSS Feed

Average article rating: 4.85

Database
Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 19,014   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 118
How to create custom aggregates in Oracle using PL/SQL
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 145,597   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: 25,342   Rating: 4.94/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 268
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: 128,517   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 846
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: 15,954   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 191
This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
Posted: 5 Nov 2016   Updated: 5 Nov 2016   Views: 3,020   Rating: 4.73/5    Votes: 6   Popularity: 3.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 63
This article discusses four different approaches such as associative arrays and user-defined types (UDT) how to get the data into a table.
SQL
Posted: 13 Sep 2012   Updated: 13 Sep 2012   Views: 33,024   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: 88,842   Rating: 4.91/5    Votes: 31   Popularity: 7.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 88   Downloaded: 1,016
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 51,578   Rating: 4.83/5    Votes: 17   Popularity: 5.93
Licence: The Code Project Open License (CPOL)      Bookmarked: 30   Downloaded: 191
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: 42,746   Rating: 4.95/5    Votes: 22   Popularity: 6.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 39   Downloaded: 419
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 410,529   Rating: 4.92/5    Votes: 49   Popularity: 8.31
Licence: The Code Project Open License (CPOL)      Bookmarked: 64   Downloaded: 1,025
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 17,283   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 75
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: 174,051   Rating: 4.90/5    Votes: 14   Popularity: 5.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 1,080
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,191   Rating: 4.90/5    Votes: 7   Popularity: 4.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 93
This article describes a mechanism how trigger actions bypassed based on database user information
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 56,849   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: 40,966   Rating: 4.18/5    Votes: 18   Popularity: 5.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 26   Downloaded: 148
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: 258,594   Rating: 4.92/5    Votes: 39   Popularity: 7.82
Licence: The Code Project Open License (CPOL)      Bookmarked: 46   Downloaded: 762
Some simple scenarios to calculate running totals in SQL Server.
Posted: 19 Jan 2015   Updated: 21 Feb 2015   Views: 14,284   Rating: 4.93/5    Votes: 26   Popularity: 6.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 31   Downloaded: 142
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: 20,945   Rating: 4.90/5    Votes: 37   Popularity: 7.68
Licence: The Code Project Open License (CPOL)      Bookmarked: 48   Downloaded: 576
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: 23,291   Rating: 4.97/5    Votes: 16   Popularity: 5.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 26
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: 4,870   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 207
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: 8,810   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 386
Few CLR procedure concepts to write into a file from SQL Server database
Posted: 3 Jan 2009   Updated: 11 Dec 2016   Views: 144,193   Rating: 4.85/5    Votes: 43   Popularity: 7.92
Licence: The Code Project Open License (CPOL)      Bookmarked: 83   Downloaded: 3,576
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
C#
Utilities
Posted: 10 Feb 2015   Updated: 17 Feb 2015   Views: 24,497   Rating: 4.89/5    Votes: 39   Popularity: 7.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 83   Downloaded: 1,917
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: 190,237   Rating: 4.92/5    Votes: 43   Popularity: 8.03
Licence: The Code Project Open License (CPOL)      Bookmarked: 102   Downloaded: 16,417
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: 9,710   Rating: 4.81/5    Votes: 8   Popularity: 4.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 401
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: 61,180   Rating: 4.98/5    Votes: 46   Popularity: 8.28
Licence: The Code Project Open License (CPOL)      Bookmarked: 121   Downloaded: 4,026
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,324   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: 8,900   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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,840   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,051   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: 10,165   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,095   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: 80,782   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,397   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,593   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,350   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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,372   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: 13,654   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: 17,704   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: 22,585   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 122
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 16,007   Rating: 4.83/5    Votes: 10   Popularity: 4.83
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 83
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 18,033   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 67
This tip demonstrates the use of LAG and LEAD functions in SQL Server.
Posted: 10 Sep 2014   Updated: 10 Sep 2014   Views: 4,500   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,140   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 52
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: 22,495   Rating: 4.64/5    Votes: 5   Popularity: 3.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 87
How to generate desired amount of rows in SQL Server using CTE
Posted: 18 Sep 2015   Updated: 18 Sep 2015   Views: 9,788   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 85
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,210   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: 2,890   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,600   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 34
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,520   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 22
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,221   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 11,923   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,361   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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,130   Rating: 4.91/5    Votes: 9   Popularity: 4.68
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 313
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: 30,367   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 84
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,280   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: 13,920   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: 25,787   Rating: 4.89/5    Votes: 9   Popularity: 4.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 491
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,381   Rating: 4.50/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 112
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: 15,653   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,560   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,741   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: 86,945   Rating: 4.89/5    Votes: 40   Popularity: 7.84
Licence: The Code Project Open License (CPOL)      Bookmarked: 164   Downloaded: 0
A list of useful development tools edited by members of CodeProject

Mika Wendelius
Architect
Finland Finland
No Biography provided


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