Click here to Skip to main content
12,954,276 members (73,459 online)

Articles by Manjuke Fernando (Articles: 5, Technical Blogs: 34)

Articles: 5, Technical Blogs: 34

RSS Feed

Average article rating: 4.99

Site & Server Management
General
Posted: 22 Nov 2015   Updated: 22 Nov 2015   Views: 2,493   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
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
Database
General
Posted: 7 Sep 2016   Updated: 7 Sep 2016   Views: 9,384   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
A brief description of the native JSON Support in SQL Server 2016.
SQL Server
Posted: 8 Mar 2012   Updated: 8 Mar 2012   Views: 111,912   Rating: 4.94/5    Votes: 22   Popularity: 6.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 33   Downloaded: 0
Locks and duration of transactions in SQL Server
Posted: 18 Nov 2015   Updated: 19 Nov 2015   Views: 5,849   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
How to capture and analyze deadlocks in SQL Server
C#
Delegates and Events
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 7,070   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Delegates in C#

Average blogs rating: 4.61

Dialogs and Windows
General
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 19,183   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Design forms beyond the size of our development machine's screen resolution
Windows 2000 Styles
Posted: 15 May 2011   Updated: 15 May 2011   Views: 58,667   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
How to deploy Windows applications using ClickOnce (Visual Studio 2008)
Document / View
Doc/View Internals
Posted: 26 Oct 2015   Updated: 26 Oct 2015   Views: 3,644   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
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.
Files and Folders
File System
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 37,817   Rating: 4.67/5    Votes: 5   Popularity: 3.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 0
There are times when we need to monitor multiple directories and if any changes are available, invoke a given method.
Grid & Data Controls
General
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 23,094   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
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: 13,380   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
How to display distinct data from a duplicated data source in an InfoPath form
Posted: 9 Mar 2016   Updated: 9 Mar 2016   Views: 3,424   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
String or binary data would be truncated / arithmetic overflow error converting numeric to data type numeric – workaround
PropertyGrid
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 16,295   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
How to show properties of a class on a PropertyGrid
ATL Server
General
Posted: 28 Jul 2011   Updated: 28 Jul 2011   Views: 101,619   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Using Update Cursors in SQL Server
Posted: 25 Nov 2015   Updated: 25 Nov 2015   Views: 4,659   Rating: 4.97/5    Votes: 10   Popularity: 4.97
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
Analyzing SQL Server Error Logs / Agent Logs using T-SQL
Charts, Graphs and Images
Images and multimedia
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 43,202   Rating: 4.75/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
How to show an image saved in a SQL Server table on an ASP.NET Image control.
Site & Server Management
General
Posted: 20 Sep 2012   Updated: 20 Sep 2012   Views: 33,402   Rating: 4.75/5    Votes: 3   Popularity: 2.23
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 0
Briefly describing the features in SQL Server Data Tools.
Database
General
Posted: 19 Oct 2011   Updated: 19 Oct 2011   Views: 25,744   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
This is a common issue that development teams face when reports are being deployed to the production environment.
Posted: 16 Jan 2012   Updated: 19 Oct 2012   Views: 105,217   Rating: 4.86/5    Votes: 12   Popularity: 5.21
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
How to resolve this issue
Posted: 20 Jan 2016   Updated: 20 Jan 2016   Views: 2,644   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Error accessing Oracle Database Objects via Linked Server in SQL Server
Posted: 9 Oct 2016   Updated: 4 Dec 2016   Views: 15,120   Rating: 4.95/5    Votes: 43   Popularity: 8.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 43   Downloaded: 0
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.
SQL
Posted: 5 Aug 2011   Updated: 5 Aug 2011   Views: 124,132   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
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: 60,276   Rating: 4.50/5    Votes: 5   Popularity: 3.03
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Create a Cursor using dynamic SQL query.
SQL Server
Posted: 31 Jul 2011   Updated: 31 Jul 2011   Views: 16,243   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
How to use the new MERGE statement feature in SQL Server 2008
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 22,293   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
How to save an image to a SQL Server table
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 32,790   Rating: 4.44/5    Votes: 7   Popularity: 3.70
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
How to repeat a SQL row based on a value in a different column
Posted: 3 Sep 2012   Updated: 3 Sep 2012   Views: 45,573   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
How to install SQL Server Data Tools
Posted: 3 Jun 2015   Updated: 3 Jun 2015   Views: 3,613   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
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: 6,242   Rating: 4.89/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
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: 5,802   Rating: 4.57/5    Votes: 9   Popularity: 4.32
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
DROP IF EXISTS in SQL Server 2016 (DIE)
Posted: 19 Oct 2016   Updated: 19 Oct 2016   Views: 4,202   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
With the introduction of SQL Server 2016 in June (Official Final Release), Microsoft had introduced few, new and very useful features in to the SQL Server. One such feature is the ‘Always Encrypted’. ‘Always Encrypted’ is the ability to perform SQL operations (there are restrictions) on your data as
SQL Reporting Services
General
Posted: 27 Jul 2011   Updated: 27 Jul 2011   Views: 10,862   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features
Posted: 25 Nov 2011   Updated: 25 Nov 2011   Views: 14,321   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Using CLR functions with T-SQL
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 43,975   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL
Printing
Posted: 15 Aug 2016   Updated: 15 Aug 2016   Views: 3,780   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Connecting to MS SQL Server using NodeJS
C#
General
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 4,902   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Extension methods in C#
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 71,577   Rating: 4.63/5    Votes: 14   Popularity: 5.41
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Constructor Chaining is an approach where a constructor calls another constructor in the same or base class.
Reporting
Posted: 8 Aug 2011   Updated: 8 Aug 2011   Views: 34,754   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
How to invoke a method in our client application when the print button of the report viewer is clicked
Code Generation
General
Posted: 20 May 2015   Updated: 20 May 2015   Views: 3,283   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Conflict in log4net on GAC when a Crystal Report is Viewed through .NET Code
No tips have been posted.
No reference articles 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


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 28 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid