Click here to Skip to main content
12,634,651 members (26,803 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.86

Database
Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 18,434   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 116
How to create custom aggregates in Oracle using PL/SQL
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 142,237   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: 24,722   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: 126,607   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 840
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,404   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 189
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: 2,590   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 53
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: 31,864   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: 87,622   Rating: 4.91/5    Votes: 31   Popularity: 7.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 88   Downloaded: 1,004
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 3 Jan 2009   Updated: 3 Jan 2009   Views: 139,843   Rating: 4.86/5    Votes: 40   Popularity: 7.79
Licence: The Code Project Open License (CPOL)      Bookmarked: 78   Downloaded: 3,421
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 50,218   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: 41,456   Rating: 4.95/5    Votes: 22   Popularity: 6.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 39   Downloaded: 411
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 398,469   Rating: 4.92/5    Votes: 49   Popularity: 8.31
Licence: The Code Project Open License (CPOL)      Bookmarked: 64   Downloaded: 1,008
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 16,713   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: 169,431   Rating: 4.90/5    Votes: 14   Popularity: 5.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 1,073
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: 8,851   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: 55,999   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,286   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: 248,564   Rating: 4.92/5    Votes: 39   Popularity: 7.82
Licence: The Code Project Open License (CPOL)      Bookmarked: 46   Downloaded: 738
Some simple scenarios to calculate running totals in SQL Server.
Posted: 19 Jan 2015   Updated: 21 Feb 2015   Views: 13,544   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,025   Rating: 4.90/5    Votes: 36   Popularity: 7.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 47   Downloaded: 562
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: 22,821   Rating: 4.97/5    Votes: 16   Popularity: 5.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 25
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,550   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 196
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,220   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 356
Few CLR procedure concepts to write into a file from SQL Server database
C#
Utilities
Posted: 10 Feb 2015   Updated: 17 Feb 2015   Views: 23,507   Rating: 4.89/5    Votes: 39   Popularity: 7.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 83   Downloaded: 1,857
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: 185,357   Rating: 4.92/5    Votes: 42   Popularity: 8.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 101   Downloaded: 16,097
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: 8,910   Rating: 4.81/5    Votes: 8   Popularity: 4.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 359
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: 59,780   Rating: 4.98/5    Votes: 46   Popularity: 8.28
Licence: The Code Project Open License (CPOL)      Bookmarked: 119   Downloaded: 3,972
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,174   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,660   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 cerate a CLR procedure.

Average tips rating: 4.89

Oracle
Posted: 19 May 2012   Updated: 19 May 2012   Views: 6,730   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: 6,851   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: 9,395   Rating: 4.20/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 34
This tip shows two ways of generating Fibonacci numbers in a single SQL statement
Posted: 22 Feb 2011   Updated: 26 Jul 2015   Views: 16,895   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,102   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,177   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,493   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,290   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,132   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,084   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,284   Rating: 5.00/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 34
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: 21,015   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 113
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 15,437   Rating: 4.83/5    Votes: 10   Popularity: 4.83
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 82
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 17,823   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,420   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: 5,940   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: 21,715   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: 7,958   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,000   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,590   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,030   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: 6,170   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 17
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,151   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,603   Rating: 4.72/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 68
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,211   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: 6,690   Rating: 4.91/5    Votes: 9   Popularity: 4.68
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 301
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: 29,527   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 83
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,180   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,650   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: 24,917   Rating: 4.89/5    Votes: 9   Popularity: 4.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 480
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,261   Rating: 4.50/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 110
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,213   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,260   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,571   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: 84,895   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.161208.2 | Last Updated 10 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid