Click here to Skip to main content
15,167,867 members

Articles by Manjuke Fernando (Articles: 7, Technical Blogs: 37, Tip/Trick: 1)

Articles: 7, Technical Blogs: 37, Tip/Trick: 1

RSS Feed

Average article rating: 4.99

Database Development
Posted: 8 Mar 2012   Updated: 8 Mar 2012   Views: 144,726   Rating: 4.95/5    Votes: 24   Popularity: 6.83
Licence: The Code Project Open License (CPOL)      Bookmarked: 35   Downloaded: 0
Please Sign up or sign in to vote.
Locks and duration of transactions in SQL Server
SQL Server
Posted: 10 May 2019   Updated: 12 May 2019   Views: 5,850   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values
Posted: 6 Jul 2018   Updated: 6 Jul 2018   Views: 4,390   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to replace sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities
Enterprise
Posted: 7 Sep 2016   Updated: 7 Sep 2016   Views: 21,601   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
A brief description of the native JSON Support in SQL Server 2016.
Programming Languages
C#
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 11,120   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Delegates in C#
C++
Posted: 22 Nov 2015   Updated: 22 Nov 2015   Views: 5,910   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Technorati Tags: MicroSoft SQL Server Every time the SQL data file or log file expands, it fills the newly allocated (expanded) space with zero. There are few good and bad having this feature (Zeroing the allocated space). One downside of this is, this process will block all the sessions which are w
SQL
Posted: 19 Nov 2015   Updated: 19 Nov 2015   Views: 13,874   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
How to capture and analyze deadlocks in SQL Server

Average blogs rating: 4.60

All Topics
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 29,264   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
How to filter data correctly on a repeating table in an InfoPath form using a date range
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 15,760   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
How to display distinct data from a duplicated data source in an InfoPath form
Posted: 9 Mar 2016   Updated: 9 Mar 2016   Views: 7,470   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
String or binary data would be truncated / arithmetic overflow error converting numeric to data type numeric – workaround
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 56,830   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL
Posted: 20 May 2015   Updated: 20 May 2015   Views: 5,960   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Conflict in log4net on GAC when a Crystal Report is Viewed through .NET Code
Database Development
SQL Server
Posted: 20 Sep 2012   Updated: 20 Sep 2012   Views: 49,130   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
Briefly describing the features in SQL Server Data Tools.
Posted: 31 Jul 2011   Updated: 31 Jul 2011   Views: 19,500   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
How to use the new MERGE statement feature in SQL Server 2008
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 40,103   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
How to save an image to a SQL Server table
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 48,154   Rating: 4.44/5    Votes: 7   Popularity: 3.76
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
How to repeat a SQL row based on a value in a different column
Posted: 3 Sep 2012   Updated: 3 Sep 2012   Views: 81,165   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
How to install SQL Server Data Tools
Posted: 3 Jun 2015   Updated: 3 Jun 2015   Views: 8,610   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Error occurs when CTE Alias is ‘RESULT’ - Incorrect syntax near 'RESULT'. Succeeds on some SQL Server databases but fails on others.
Posted: 16 Feb 2016   Updated: 16 Feb 2016   Views: 22,691   Rating: 4.89/5    Votes: 2   Popularity: 1.47
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
What is the difference between Index REBUILD and REORGANIZE and when exactly should you use it
Posted: 23 Aug 2016   Updated: 24 Aug 2016   Views: 18,450   Rating: 4.74/5    Votes: 10   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
DROP IF EXISTS in SQL Server 2016 (DIE)
Posted: 19 Oct 2016   Updated: 19 Oct 2016   Views: 14,260   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Always encrypted feature in SQL Server 2016
Posted: 29 May 2018   Updated: 29 May 2018   Views: 8,662   Rating: 4.58/5    Votes: 7   Popularity: 3.87
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Computed columns in SQL Server
Posted: 10 Oct 2016   Updated: 4 Dec 2016   Views: 28,351   Rating: 4.95/5    Votes: 45   Popularity: 8.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 45   Downloaded: 0
Please Sign up or sign in to vote.
It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.
Desktop Programming
ATL
Posted: 28 Jul 2011   Updated: 28 Jul 2011   Views: 185,831   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Using Update Cursors in SQL Server
Windows Forms
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 23,160   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Design forms beyond the size of our development machine's screen resolution
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 23,750   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to show properties of a class on a PropertyGrid
Operating Systems
Windows
Posted: 15 May 2011   Updated: 15 May 2011   Views: 73,344   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
How to deploy Windows applications using ClickOnce (Visual Studio 2008)
Programming Languages
C#
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 51,402   Rating: 4.71/5    Votes: 6   Popularity: 3.67
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 0
Please Sign up or sign in to vote.
There are times when we need to monitor multiple directories and if any changes are available, invoke a given method.
Posted: 19 Oct 2011   Updated: 19 Oct 2011   Views: 36,413   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
This is a common issue that development teams face when reports are being deployed to the production environment.
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 6,260   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Extension methods in C#
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 140,537   Rating: 4.44/5    Votes: 16   Popularity: 5.09
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
Constructor Chaining is an approach where a constructor calls another constructor in the same or base class.
Posted: 8 Aug 2011   Updated: 8 Aug 2011   Views: 46,191   Rating: 4.50/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
How to invoke a method in our client application when the print button of the report viewer is clicked
C++
Posted: 26 Oct 2015   Updated: 26 Oct 2015   Views: 6,640   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Due to an unavoidable situation, it was decided that all the write access to a particular server (SQL Server) was required to be removed immediately. And only few people should be able to access the server with full privileges.
SQL
Posted: 16 Jan 2012   Updated: 19 Oct 2012   Views: 136,273   Rating: 4.86/5    Votes: 12   Popularity: 5.24
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
Please Sign up or sign in to vote.
How to resolve this issue
Posted: 20 Jan 2016   Updated: 20 Jan 2016   Views: 6,832   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Error accessing Oracle Database Objects via Linked Server in SQL Server
Posted: 5 Aug 2011   Updated: 5 Aug 2011   Views: 222,853   Rating: 5.00/5    Votes: 11   Popularity: 5.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
This post will show you how to insert data using SQL views created using multiple tables.
Posted: 6 Nov 2012   Updated: 6 Nov 2012   Views: 90,585   Rating: 4.50/5    Votes: 5   Popularity: 3.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Create a Cursor using dynamic SQL query.
Posted: 3 Dec 2017   Updated: 3 Dec 2017   Views: 3,870   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Behavior of IDENTITY Columns and SEQUENCES with TRANSACTIONS
Posted: 27 Jul 2011   Updated: 27 Jul 2011   Views: 12,790   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 16,890   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Using CLR functions with T-SQL
Posted: 10 Mar 2018   Updated: 10 Mar 2018   Views: 4,130   Rating: 3.46/5    Votes: 4   Popularity: 2.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Strange behaviour converting NVARCHAR(MAX) to BINARY
T-SQL
Posted: 25 Nov 2015   Updated: 25 Nov 2015   Views: 9,960   Rating: 4.97/5    Votes: 10   Popularity: 4.97
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Analyzing SQL Server Error Logs / Agent Logs using T-SQL
Web Development
HTML
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 51,830   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
How to show an image saved in a SQL Server table on an ASP.NET Image control.
Node.js
Posted: 15 Aug 2016   Updated: 15 Aug 2016   Views: 14,402   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Connecting to MS SQL Server using NodeJS

Average tips rating: 5.00

Database Development
SQL Server
Posted: 9 Sep 2018   Updated: 10 Sep 2018   Views: 3,610   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
How to give db_datareader access to a specific user across all the databases on a particular SQL Server

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Manjuke Fernando
Technical Lead Air Liquide Industrial Services (Singapore)
Singapore Singapore
My passion lies in building business intelligence and data-based solutions, writing about things I work with and talking about it. New technologies relevant to my line of work interest me and I am often seen playing with early releases of such technologies.

My current role involves architecting and building a variety of data solutions, providing database maintenance and administration support, building the organization’s data practice, and training and mentoring peers.

My aspiration over the next several years is to achieve higher competency and recognition in the field of Data Analytics and move into a career of data science.


Specialities: SQL Server, T-SQL Development, SQL Server Administration, SSRS, SSIS, C#, ASP.Net, Crystal Reports