Click here to Skip to main content
Search within:



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

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

RSS Feed

Average article rating: 4.81

Database

Custom Aggregates in Oracle
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 8,680   Rating: 4.91/5    Votes: 8   Popularity: 4.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 71
How to create custom aggregates in Oracle using PL/SQL
Installing Oracle 11g XE (Express Edition)
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 54,710   Rating: 4.58/5    Votes: 8   Popularity: 4.06
Licence: The Code Project Open License (CPOL)      Bookmarked: 21   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
Mimicking SQL Server identity column in Oracle
Posted: 8 Jan 2012   Updated: 8 Jan 2012   Views: 10,217   Rating: 4.94/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 164
This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
Examples for Creating Oracle Functions
Posted: 13 Mar 2011   Updated: 1 Apr 2012   Views: 46,322   Rating: 4.46/5    Votes: 11   Popularity: 4.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 385
The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
Logging information in Oracle
Posted: 30 Apr 2012   Updated: 30 Apr 2012   Views: 4,589   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 86
This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.

SQL

SQL Server: Query to find upcoming birthdays for the current week
Posted: 13 Sep 2012   Updated: 13 Sep 2012   Views: 3,706   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
How to pass multiple records to a Stored Procedure
Posted: 2 Dec 2008   Updated: 2 Dec 2008   Views: 47,511   Rating: 4.91/5    Votes: 30   Popularity: 7.28
Licence: The Code Project Open License (CPOL)      Bookmarked: 81   Downloaded: 620
How to pass multiple records to a Stored Procedure in a single roundtrip.
How to store and fetch binary data into a file stream column
Posted: 3 Jan 2009   Updated: 3 Jan 2009   Views: 73,395   Rating: 4.83/5    Votes: 35   Popularity: 7.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 69   Downloaded: 1,747
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
What should be considered when NOLOCK hint is used
Posted: 11 Feb 2011   Updated: 11 Feb 2011   Views: 8,750   Rating: 4.85/5    Votes: 6   Popularity: 3.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
When considering to use NOLOCK hint, there are a few things that should be kept in mind.
Physical location of a row in SQL Server
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 20,723   Rating: 4.79/5    Votes: 13   Popularity: 5.32
Licence: The Code Project Open License (CPOL)      Bookmarked: 25   Downloaded: 97
This article describes the pseudo column to identify the unique physical location of a single row.
Custom Aggregates in SQL Server
Posted: 17 Mar 2011   Updated: 26 Mar 2011   Views: 16,979   Rating: 4.94/5    Votes: 17   Popularity: 6.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 27   Downloaded: 201
SQL Server not having the aggregates you need? Why not build your own.
Using Table-Valued Functions in SQL Server
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 92,574   Rating: 4.89/5    Votes: 21   Popularity: 6.46
Licence: The Code Project Open License (CPOL)      Bookmarked: 40   Downloaded: 419
This article shows few examples for using Table-Valued Functions.
Mimicking null-safe equal to operator in SQL Server
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 6,615   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 44
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Calculating simple running totals in SQL Server
Posted: 15 Dec 2011   Updated: 15 Dec 2011   Views: 29,976   Rating: 5.00/5    Votes: 10   Popularity: 5.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 218
Some simple scenarios to calculate running totals in SQL Server.
Executing multiple SQL statements as one against SQL Server
Posted: 27 Dec 2011   Updated: 27 Dec 2011   Views: 43,910   Rating: 4.79/5    Votes: 9   Popularity: 4.55
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 521
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
Control trigger logic based on user
Posted: 20 May 2012   Updated: 20 May 2012   Views: 3,808   Rating: 4.83/5    Votes: 6   Popularity: 3.74
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 57
This article describes a mechanism how trigger actions bypassed based on database user information
About transaction log and its truncation in SQL Server
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 15,780   Rating: 4.67/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
Article describes basic information about transaction log behavior and truncation of the log.
Data versioning in SQL Server using row versions
Posted: 11 Oct 2008   Updated: 3 Nov 2012   Views: 26,371   Rating: 4.12/5    Votes: 16   Popularity: 4.93
Licence: The Code Project Open License (CPOL)      Bookmarked: 25   Downloaded: 54
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems.

Libraries

Creating basic Excel workbook with Open XML
Posted: 22 Apr 2012   Updated: 5 May 2012   Views: 50,708   Rating: 4.93/5    Votes: 25   Popularity: 6.88
Licence: The Code Project Open License (CPOL)      Bookmarked: 67   Downloaded: 4,863
This article describes how to create a basic Excel workbook using Open XML.

Cryptography & Security

Encrypting a dataset using AES, including compression
Posted: 9 Sep 2012   Updated: 3 Dec 2012   Views: 20,413   Rating: 4.98/5    Votes: 32   Popularity: 7.50
Licence: The Code Project Open License (CPOL)      Bookmarked: 83   Downloaded: 1,963
Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.

Average blogs rating: 0.00

Database

Struggling with System.IO.Packaging when creating a CLR procedure [Technical Blog]
Posted: 7 Oct 2012   Updated: 19 Oct 2012   Views: 3,879   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.93

How to Change Password in Oracle [Tip/Trick]
Posted: 21 Feb 2011   Updated: 21 Feb 2011   Views: 2,121   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
One option to change the password is to include the new password to a GRANT statement, for example:GRANT CONNECT TO SomeUser IDENTIFIED BY SomePassword;However be careful: If you specify a non-existent user, the user will be created so it's easy to mistakenly create unwanted users.Few...
How to fetch data from the previous or next rows in the resultset [Tip/Trick]
Posted: 27 Jul 2011   Updated: 27 Jul 2011   Views: 5,908   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
This tip demonstrates the use of LAG and LEAD functions in SQL Server.
How to fetch data from the previous or next rows in the resultset [Tip/Trick]
Posted: 22 Feb 2011   Updated: 29 Jul 2011   Views: 7,529   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.
How to Guarantee a Fixed Amount of Rows in a Table in Oracle [Tip/Trick]
Posted: 19 May 2012   Updated: 19 May 2012   Views: 2,265   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 14
This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.
How to remove duplicate rows in SQL Server 2008 when no key is present [Tip/Trick]
Posted: 20 Feb 2011   Updated: 20 Feb 2011   Views: 44,210   Rating: 4.92/5    Votes: 11   Popularity: 5.11
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
This tip describes how to delete duplicate rows from a table that doesn't have a key.
List SQL Server Table Column Name as Rows [Tip/Trick]
Posted: 5 May 2012   Updated: 6 May 2012   Views: 6,534   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
This is an alternative for "List SQL Server table column name as rows".
Applying Running Total to a Result set [Tip/Trick]
Posted: 14 May 2012   Updated: 14 May 2012   Views: 2,253   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 25
This is an alternative for "Applying Running Total to a Result set"
How to Guarantee a Fixed Amount of Rows in a Table [Tip/Trick]
Posted: 19 May 2012   Updated: 19 May 2012   Views: 2,271   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
How to remove duplicate rows in SQL Server 2005 when no key is present [Tip/Trick]
Posted: 20 Feb 2011   Updated: 20 Dec 2012   Views: 10,093   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 0
This tip describes how to delete duplicate rows from a table that doesn't have a key.
Calculate aggregates for dynamic columns using UNPIVOT [Tip/Trick]
Posted: 27 Dec 2012   Updated: 17 Jan 2013   Views: 2,921   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 24
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
Check if a number is a power of 2 with Sql Server 2012 [Tip/Trick]
Posted: 18 Dec 2012   Updated: 19 Jan 2013   Views: 4,985   Rating: 5.00/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 26
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.

C#

Multiple partial definitions for a class [Tip/Trick]
Posted: 17 Nov 2012   Updated: 17 Nov 2012   Views: 2,617   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 29
The tip shows an example for using multiple partial classes to define a single class.
Cumulating values with LINQ [Tip/Trick]
Posted: 26 Jul 2012   Updated: 26 Jul 2012   Views: 3,182   Rating: 4.50/5    Votes: 3   Popularity: 1.19
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 33
This tip describes few examples how ro cumulate values using an extension method with LINQ
Cumulating values with LINQ [Tip/Trick]
Posted: 28 Jul 2012   Updated: 27 Jul 2012   Views: 3,220   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 10
This is an alternative for "Cumulating values with LINQ"

Programming Tips

Using enum to define a new enum [Tip/Trick]
Posted: 20 Jul 2012   Updated: 10 Aug 2012   Views: 9,726   Rating: 4.64/5    Votes: 10   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 47
This tip describes how to use an existing enum to define a new, for example a context specific enum.
All the jobs in SQL Server [Tip/Trick]
Posted: 10 Aug 2011   Updated: 10 Aug 2011   Views: 1,367   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)[^]
How to connect with different types of DataBase? [Tip/Trick]
Posted: 25 Nov 2011   Updated: 24 Dec 2011   Views: 2,931   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.
Resolve DesignMode for a user control [Tip/Trick]
Posted: 26 Aug 2012   Updated: 26 Aug 2012   Views: 4,385   Rating: 4.82/5    Votes: 4   Popularity: 2.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 88
The tip shows one way to resolve if a user control is in design mode.

String handling

Manipulating a string array using a Lambda Expression [Tip/Trick]
Posted: 7 Nov 2012   Updated: 7 Nov 2012   Views: 2,831   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

Getting publishing information for a ClickOnce deployment [Tip/Trick]
Posted: 27 Mar 2012   Updated: 27 Mar 2012   Views: 3,068   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
This tip describes a way to get publishing information for a ClickOnce deployed application
Getting publishing information for a ClickOnce deployment [Tip/Trick]
Posted: 1 Apr 2012   Updated: 1 Apr 2012   Views: 4,838   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"

Mika Wendelius
Architect
Finland Finland
Member
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
Web02 | 2.6.130523.1 | Last Updated 24 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid