Click here to Skip to main content
12,076,216 members (37,102 online)

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

Articles: 23, Technical Blogs: 2, Tip/Tricks: 30, Reference: 1

RSS Feed

Average article rating: 4.83

Database
Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 16,630   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 109
How to create custom aggregates in Oracle using PL/SQL
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 133,420   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: 22,640   Rating: 4.94/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 256
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: 117,550   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 795
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: 13,640   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 165
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: 26,510   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: 80,620   Rating: 4.91/5    Votes: 31   Popularity: 7.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 88   Downloaded: 964
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 3 Jan 2009   Updated: 3 Jan 2009   Views: 127,760   Rating: 4.86/5    Votes: 39   Popularity: 7.70
Licence: The Code Project Open License (CPOL)      Bookmarked: 76   Downloaded: 3,253
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
Posted: 11 Feb 2011   Updated: 11 Feb 2011   Views: 17,060   Rating: 4.85/5    Votes: 6   Popularity: 3.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
When considering to use NOLOCK hint, there are a few things that should be kept in mind.
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 44,870   Rating: 4.83/5    Votes: 17   Popularity: 5.93
Licence: The Code Project Open License (CPOL)      Bookmarked: 30   Downloaded: 186
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: 36,460   Rating: 4.95/5    Votes: 21   Popularity: 6.54
Licence: The Code Project Open License (CPOL)      Bookmarked: 38   Downloaded: 378
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 341,023   Rating: 4.91/5    Votes: 46   Popularity: 8.19
Licence: The Code Project Open License (CPOL)      Bookmarked: 62   Downloaded: 910
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 14,870   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 74
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: 148,683   Rating: 4.90/5    Votes: 14   Popularity: 5.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 1,011
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,010   Rating: 4.90/5    Votes: 7   Popularity: 4.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 92
This article describes a mechanism how trigger actions bypassed based on database user information
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 51,300   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: 38,060   Rating: 4.18/5    Votes: 18   Popularity: 5.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 26   Downloaded: 143
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: 196,201   Rating: 4.91/5    Votes: 36   Popularity: 7.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 42   Downloaded: 681
Some simple scenarios to calculate running totals in SQL Server.
Posted: 19 Jan 2015   Updated: 21 Feb 2015   Views: 10,660   Rating: 4.91/5    Votes: 21   Popularity: 6.48
Licence: The Code Project Open License (CPOL)      Bookmarked: 31   Downloaded: 125
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: 15,480   Rating: 4.90/5    Votes: 36   Popularity: 7.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 45   Downloaded: 487
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
C#
Utilities
Posted: 10 Feb 2015   Updated: 17 Feb 2015   Views: 19,182   Rating: 4.88/5    Votes: 37   Popularity: 7.65
Licence: The Code Project Open License (CPOL)      Bookmarked: 81   Downloaded: 1,602
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: 159,762   Rating: 4.93/5    Votes: 38   Popularity: 7.76
Licence: The Code Project Open License (CPOL)      Bookmarked: 99   Downloaded: 14,454
This article describes how to create a basic Excel workbook using Open XML.
Cryptography & Security
Encryption
Posted: 9 Sep 2012   Updated: 21 Aug 2015   Views: 52,690   Rating: 4.98/5    Votes: 44   Popularity: 8.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 116   Downloaded: 3,716
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: 9,920   Rating: 4.72/5    Votes: 6   Popularity: 3.78
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   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: 7,550   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: 5,910   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 21
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: 5,630   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 30
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: 6,860   Rating: 4.20/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 29
This tip shows two ways of generating Fibonacci numbers in a single SQL statement
Posted: 22 Feb 2011   Updated: 26 Jul 2015   Views: 15,240   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: 74,850   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: 13,010   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: 4,880   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: 3,840   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: 20,820   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: 10,400   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: 14,580   Rating: 5.00/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 32
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: 13,812   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 77
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 11,080   Rating: 4.83/5    Votes: 9   Popularity: 4.61
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 81
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 16,060   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 66
This tip demonstrates the use of LAG and LEAD functions in SQL Server.
Posted: 10 Sep 2014   Updated: 10 Sep 2014   Views: 4,020   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: 4,990   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 51
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: 16,992   Rating: 4.64/5    Votes: 5   Popularity: 3.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 86
How to generate desired amount of rows in SQL Server using CTE
Posted: 18 Sep 2015   Updated: 18 Sep 2015   Views: 5,180   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 79
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.
C#
General
Posted: 17 Nov 2012   Updated: 17 Nov 2012   Views: 4,650   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: 9,700   Rating: 4.72/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 59
This tip describes few examples how ro cumulate values using an extension method with LINQ
Posted: 28 Jul 2012   Updated: 27 Jul 2012   Views: 5,570   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 15
This is an alternative for "Cumulating values with LINQ"
LINQ
General
Posted: 5 Oct 2015   Updated: 5 Oct 2015   Views: 4,670   Rating: 4.91/5    Votes: 9   Popularity: 4.68
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 207
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: 25,020   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 72
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: 3,760   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: 11,470   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: 20,611   Rating: 4.87/5    Votes: 8   Popularity: 4.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 426
The tip shows one way to resolve if a user control is in design mode.
Posted: 26 Jul 2015   Updated: 26 Jul 2015   Views: 2,640   Rating: 4.50/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 94
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: 13,091   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: 8,430   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: 9,560   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: 68,871   Rating: 4.89/5    Votes: 40   Popularity: 7.84
Licence: The Code Project Open License (CPOL)      Bookmarked: 155   Downloaded: 0
A list of useful development tools edited by members of CodeProject

Mika Wendelius
Architect
Finland Finland
No Biography provided


Advertise | Privacy | Mobile
Web04 | 2.8.160208.1 | Last Updated 12 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid