Click here to Skip to main content
12,359,458 members (67,920 online)

Articles by Manjuke Fernando (Articles: 2, Technical Blogs: 32)

Articles: 2, Technical Blogs: 32

RSS Feed

Average article rating: 5.00

Site & Server Management
General
Posted: 22 Nov 2015   Updated: 22 Nov 2015   Views: 1,651   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
SQL Server
Posted: 18 Nov 2015   Updated: 19 Nov 2015   Views: 3,754   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

Average blogs rating: 4.57

Dialogs and Windows
General
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 18,082   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: 52,666   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: 2,652   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. How ever this wasn’t sound very friendly to the developers, since they w
Files and Folders
File System
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 34,313   Rating: 4.67/5    Votes: 5   Popularity: 3.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 0
There are times that we need to monitor multiple directories and if any changes are available, invoke a given method.
Grid & Data Controls
General
Posted: 5 Aug 2011   Updated: 5 Aug 2011   Views: 100,600   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
A view can be defined as a virtual table or a stored query and the data accessible through a view is not stored in the database as a distinct object. Only the select statement is stored on the database instead. How ever views can be used and perform DML operations (Insert, Update & Delete) also. Co
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 20,808   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
If you have used InfoPath in your development, you might have come across the issue of filtering data using a date range, after the data is received by the form. To illustrate the issue, I will use a sample InfoPath form.
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 12,830   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 2,370   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: 15,063   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 81,353   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: 2,995   Rating: 4.97/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   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: 40,717   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: 27,084   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Briefly describing the features in SQL Server Data Tools.
Database
General
Posted: 19 Oct 2011   Updated: 19 Oct 2011   Views: 23,378   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: 90,738   Rating: 4.86/5    Votes: 12   Popularity: 5.21
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
How to resolve this iisue.
Posted: 20 Jan 2016   Updated: 20 Jan 2016   Views: 1,771   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
SQL
Posted: 6 Nov 2012   Updated: 6 Nov 2012   Views: 50,238   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: 15,323   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Using the new MERGE statement feature in SQL Server 2008.
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 21,491   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 29,343   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: 8 Mar 2012   Updated: 8 Mar 2012   Views: 94,897   Rating: 4.94/5    Votes: 22   Popularity: 6.63
Licence: The Code Project Open License (CPOL)      Bookmarked: 31   Downloaded: 0
Locks and duration of transactions in SQL Server.
Posted: 3 Sep 2012   Updated: 3 Sep 2012   Views: 38,300   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
How to install SQL Server Data Tools.
Posted: 3 Jun 2015   Updated: 3 Jun 2015   Views: 2,382   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: 3,948   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
SQL Reporting Services
General
Posted: 27 Jul 2011   Updated: 27 Jul 2011   Views: 10,301   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
    If you try to install/add feature SQL 2008 Business Intelligence Studio, to a machine with VS2008 having installed to a different location than the default, you will most probably get the following error : In order to install BI Studio 2008 properly, please do the following : Find the folder wh
Posted: 25 Nov 2011   Updated: 25 Nov 2011   Views: 13,780   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Why use CLR?Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different programming environments, unless what you gain worth more than having it.We need to use the CLR functions when occasions such as:When we have to access system resources
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 37,535   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
C#
General
Posted: 20 Oct 2011   Updated: 20 Oct 2011   Views: 58,965   Rating: 4.64/5    Votes: 10   Popularity: 4.36
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: 31,587   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: 2,311   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
Uncategorised Technical Blogs
General
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 4,560   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
                                             As name implies extension methods allow existing classes to be extended without using inheritance or changing class’s source code.Some important points when using extension methods:•    You cannot use extension methods to override existing methods•    An
Posted: 21 Jul 2011   Updated: 21 Jul 2011   Views: 6,150   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
                                             What's a delegate A delegate is a type that safely wraps/encapsulate a  method. It is similar to 'function pointers' in C/C++, but it's type safe.   When to use a delegate Use a delegate when : An eventing design pattern is used. It is desirable to enca
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.160621.1 | Last Updated 1 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid