Click here to Skip to main content

Articles by Mika Wendelius (Articles: 20, Technical Blog: 1, Tip/Tricks: 29)

Articles: 20, Technical Blog: 1, Tip/Tricks: 29

RSS Feed

Average article rating: 4.84

Database
Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 12,649   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 94
How to create custom aggregates in Oracle using PL/SQL
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 100,129   Rating: 4.69/5    Votes: 9   Popularity: 4.37
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: 16,692   Rating: 4.94/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 230
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: 84,941   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 620
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: 8,730   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 127
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: 14,933   Rating: 5.00/5    Votes: 7   Popularity: 4.23
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: 62,548   Rating: 4.91/5    Votes: 31   Popularity: 7.33
Licence: The Code Project Open License (CPOL)      Bookmarked: 87   Downloaded: 798
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 3 Jan 2009   Updated: 3 Jan 2009   Views: 96,825   Rating: 4.84/5    Votes: 38   Popularity: 7.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 73   Downloaded: 2,467
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: 13,308   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: 33,238   Rating: 4.83/5    Votes: 17   Popularity: 5.93
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 145
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: 26,568   Rating: 4.94/5    Votes: 19   Popularity: 6.32
Licence: The Code Project Open License (CPOL)      Bookmarked: 34   Downloaded: 294
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 204,254   Rating: 4.92/5    Votes: 35   Popularity: 7.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 53   Downloaded: 681
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 10,728   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 60
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Posted: 15 Dec 2011   Updated: 15 Dec 2011   Views: 101,864   Rating: 5.00/5    Votes: 22   Popularity: 6.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 25   Downloaded: 433
Some simple scenarios to calculate running totals in SQL Server.
Posted: 27 Dec 2011   Updated: 27 Dec 2011   Views: 93,023   Rating: 4.85/5    Votes: 12   Popularity: 5.24
Licence: The Code Project Open License (CPOL)      Bookmarked: 22   Downloaded: 752
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: 5,976   Rating: 4.90/5    Votes: 7   Popularity: 4.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 74
This article describes a mechanism how trigger actions bypassed based on database user information
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 36,132   Rating: 4.90/5    Votes: 6   Popularity: 3.80
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 0
Article describes basic information about transaction log behavior and truncation of the log.
Posted: 11 Oct 2008   Updated: 3 Nov 2012   Views: 32,582   Rating: 4.14/5    Votes: 17   Popularity: 5.07
Licence: The Code Project Open License (CPOL)      Bookmarked: 26   Downloaded: 101
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems.
Libraries
Code Libraries
Posted: 22 Apr 2012   Updated: 5 May 2012   Views: 107,938   Rating: 4.92/5    Votes: 35   Popularity: 7.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 90   Downloaded: 10,146
This article describes how to create a basic Excel workbook using Open XML.
Cryptography & Security
Encryption
Posted: 9 Sep 2012   Updated: 3 Dec 2012   Views: 34,388   Rating: 4.99/5    Votes: 35   Popularity: 7.70
Licence: The Code Project Open License (CPOL)      Bookmarked: 93   Downloaded: 2,779
Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.

Average blogs rating: 0.00

Database
SQL Server
Posted: 7 Oct 2012   Updated: 19 Oct 2012   Views: 5,685   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.90

General
Posted: 22 Feb 2011   Updated: 29 Jul 2011   Views: 9,073   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
This tip demonstrates the use of LAG and LEAD functions in Oracle.
Posted: 21 Feb 2011   Updated: 28 Aug 2014   Views: 6,423   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   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: 3,845   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 19
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: 3,128   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 25
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: 3,279   Rating: 4.20/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 20
This tip shows two ways of generating Fibonacci numbers in a single SQL statement
SQL Server
Posted: 20 Feb 2011   Updated: 20 Feb 2011   Views: 64,042   Rating: 4.92/5    Votes: 11   Popularity: 5.11
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   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: 9,590   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: 3,454   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 28
This is an alternative for "Applying Running Total to a Result set"
Posted: 19 May 2012   Updated: 19 May 2012   Views: 3,029   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: 15,529   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: 5,958   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 32
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
Posted: 18 Dec 2012   Updated: 19 Jan 2013   Views: 9,144   Rating: 5.00/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 29
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: 2,861   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 44
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 5,068   Rating: 4.83/5    Votes: 9   Popularity: 4.61
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 64
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 12,707   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 53
This tip demonstrates the use of LAG and LEAD functions in SQL Server.
Posted: 10 Sep 2014   Updated: 10 Sep 2014   Views: 3,051   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 18
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: 2,740   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 45
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: 8,123   Rating: 4.64/5    Votes: 5   Popularity: 3.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 76
How to generate desired amount of rows in SQL Server using CTE
C#
General
Posted: 17 Nov 2012   Updated: 17 Nov 2012   Views: 3,692   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 40
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: 6,217   Rating: 4.50/5    Votes: 3   Popularity: 1.19
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 48
This tip describes few examples how ro cumulate values using an extension method with LINQ
Posted: 28 Jul 2012   Updated: 27 Jul 2012   Views: 4,468   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"
Programming Tips
Design and Strategy
Posted: 20 Jul 2012   Updated: 10 Aug 2012   Views: 16,483   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 57
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: 2,849   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: 7,092   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: 11,595   Rating: 4.86/5    Votes: 7   Popularity: 4.10
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 280
The tip shows one way to resolve if a user control is in design mode.
String handling
Strings
Posted: 7 Nov 2012   Updated: 7 Nov 2012   Views: 7,934   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: 5,263   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: 7,338   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.88

Applications & Tools
General
Posted: 5 Nov 2013   Updated: 26 Jun 2014   Views: 44,176   Rating: 4.88/5    Votes: 34   Popularity: 7.47
Licence: The Code Project Open License (CPOL)      Bookmarked: 130   Downloaded: 0
A list of useful development tools edited by members of CodeProject

Mika Wendelius
Architect
Finland Finland
I've been a programmer since mid 80's using languages like assembler, C/C++, PL/I (mainframe environment), pascal, VB (I know, I know, no comments please) and C# and utilizing different techniques and tools.
 
However I'm specialized in databases and database modeling. Mostly I have used products like Oracle (from version 6), SQL Server (from version 4.2), DB2 and Solid Server (nowadays an IBM product).
 
For the past 10+ years my main concerns have been dealing with different business processes and how to create software to implement and improve them. At my spare time (what ever that actually means) I'm also teaching and consulting on different areas of database management, development and database oriented software design.


Advertise | Privacy | Mobile
Web01 | 2.8.140926.1 | Last Updated 1 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid