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

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

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.99

Database Development
	Locks and Duration of Transactions in MS SQL Server 8 Mar 2012 Updated: 8 Mar 2012 Rating: 4.95/5 Votes: 24 Popularity: 6.83 Licence: CPOL Views: 148,846 Bookmarked: 35 Downloaded: 0 Please Sign up or sign in to vote. Locks and duration of transactions in SQL Server
SQL Server	Strange Behavior on JSON_VALUE When Table Contains Blank and Non-blank Values (JSON Text is Not Properly Formatted. Unexpected Character '.' is Found at Position 0.) 10 May 2019 Updated: 12 May 2019 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 18,040 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
	Replacing sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities 6 Jul 2018 Updated: 6 Jul 2018 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,200 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
	Native JSON Support in SQL Server 2016 7 Sep 2016 Updated: 7 Sep 2016 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 23,131 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#	Delegates in C# 21 Jul 2011 Updated: 21 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 11,370 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Delegates in C#
C++	Enabling Instant File Initialization in SQL Server 22 Nov 2015 Updated: 22 Nov 2015 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 6,570 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	Capturing and Analyzing Deadlocks in SQL Server 18 Nov 2015 Updated: 19 Nov 2015 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 15,414 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
	How to Filter Data Correctly on a Repeating Table in an InfoPath Form Using a Date Range [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 30,454 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
	How to Display Distinct Data from a Duplicated Data Source in an InfoPath Form [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 15,970 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
	String or Binary Data Would Be Truncated / Arithmetic Overflow Error Converting Numeric to Data Type Numeric – Workaround [Technical Blog] 9 Mar 2016 Updated: 9 Mar 2016 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 7,810 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
	Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL [Technical Blog] 26 Nov 2011 Updated: 26 Nov 2011 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: CPOL Views: 58,960 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
	Conflict in log4net on GAC when a Crystal Report is Viewed through .NET Code [Technical Blog] 20 May 2015 Updated: 20 May 2015 Rating: 2.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 6,130 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	Introduction to SSDT (SQL Server Data Tools) [Technical Blog] 20 Sep 2012 Updated: 20 Sep 2012 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: CPOL Views: 50,710 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. Briefly describing the features in SQL Server Data Tools.
	Using the MERGE Statement in SQL Server 2008 [Technical Blog] 31 Jul 2011 Updated: 31 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 19,700 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. How to use the new MERGE statement feature in SQL Server 2008
	Saving an Image to SQL Server [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 41,483 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. How to save an image to a SQL Server table
	Repeating a SQL Row Based on a Value in a Different Column [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 4.44/5 Votes: 7 Popularity: 3.76 Licence: CPOL Views: 51,524 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
	Installing SQL Server Data Tools (SSDT) [Technical Blog] 3 Sep 2012 Updated: 3 Sep 2012 Rating: 3.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 82,905 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. How to install SQL Server Data Tools
	Error Occurs When CTE Alias is ‘RESULT’ - Incorrect Syntax Near 'RESULT' [Technical Blog] 3 Jun 2015 Updated: 3 Jun 2015 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 9,220 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.
	Index REBUILD vs. REORGANIZE in SQL SERVER [Technical Blog] 16 Feb 2016 Updated: 16 Feb 2016 Rating: 4.89/5 Votes: 2 Popularity: 1.47 Licence: CPOL Views: 23,111 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
	DROP IF EXISTS in SQL Server 2016 (DIE) [Technical Blog] 23 Aug 2016 Updated: 24 Aug 2016 Rating: 4.74/5 Votes: 10 Popularity: 4.52 Licence: CPOL Views: 19,100 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. DROP IF EXISTS in SQL Server 2016 (DIE)
	Always Encrypted Feature in SQL Server 2016 [Technical Blog] 19 Oct 2016 Updated: 19 Oct 2016 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 15,100 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Always encrypted feature in SQL Server 2016
	Computed Columns in SQL Server [Technical Blog] 29 May 2018 Updated: 29 May 2018 Rating: 4.58/5 Votes: 7 Popularity: 3.87 Licence: CPOL Views: 9,852 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Computed columns in SQL Server
	Understanding JOINs in SQL Server [Technical Blog] 9 Oct 2016 Updated: 4 Dec 2016 Rating: 4.95/5 Votes: 45 Popularity: 8.18 Licence: CPOL Views: 30,951 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	How to Use Update Cursors in SQL Server [Technical Blog] 28 Jul 2011 Updated: 28 Jul 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 197,794 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Using Update Cursors in SQL Server
Windows Forms	Designing a Windows Form Where Size Exceeds Your Screen’s Resolution [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 23,860 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Design forms beyond the size of our development machine's screen resolution
	Show Properties of a Class on a PropertyGrid [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 25,321 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	Deploying Windows applications using ClickOnce (Visual Studio 2008) [Technical Blog] 15 May 2011 Updated: 15 May 2011 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 75,054 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#	Using FileSystemWatcher to Monitor Multiple Directories [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 4.71/5 Votes: 6 Popularity: 3.67 Licence: CPOL Views: 54,582 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.
	Change the Data Source of a Crystal Reports Report at Run-time using C# [Technical Blog] 19 Oct 2011 Updated: 19 Oct 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 38,493 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.
	Extension Methods in C# [Technical Blog] 21 Jul 2011 Updated: 21 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 6,400 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Extension methods in C#
	Constructor Chaining in C# [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 4.46/5 Votes: 17 Popularity: 5.25 Licence: CPOL Views: 153,439 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.
	Invoke a Custom Method when Crystal Report Viewers’ Print Button is Clicked / Add Custom Button to Crystal Report Viewer Toolbar [Technical Blog] 8 Aug 2011 Updated: 8 Aug 2011 Rating: 4.50/5 Votes: 3 Popularity: 2.15 Licence: CPOL Views: 47,481 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++	Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas [Technical Blog] 26 Oct 2015 Updated: 26 Oct 2015 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 7,060 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	Exclusive Access Could Not Be Obtained Because the Database is in Use ~ Resolved [Technical Blog] 16 Jan 2012 Updated: 19 Oct 2012 Rating: 4.86/5 Votes: 12 Popularity: 5.24 Licence: CPOL Views: 138,603 Bookmarked: 17 Downloaded: 0 Please Sign up or sign in to vote. How to resolve this issue
	Error Accessing Oracle Database Objects via Linked Server in SQL Server (The OLE DB provider "OracleOLEDB.Oracle" for linked server reported an error. Access denied.) [Technical Blog] 20 Jan 2016 Updated: 20 Jan 2016 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 8,002 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Error accessing Oracle Database Objects via Linked Server in SQL Server
	How to Insert Data Using SQL Views Created Using Multiple Tables [Technical Blog] 5 Aug 2011 Updated: 5 Aug 2011 Rating: 5.00/5 Votes: 11 Popularity: 5.00 Licence: CPOL Views: 227,723 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.
	Create a Cursor using Dynamic SQL Query [Technical Blog] 6 Nov 2012 Updated: 6 Nov 2012 Rating: 4.57/5 Votes: 6 Popularity: 3.56 Licence: CPOL Views: 94,895 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Create a Cursor using dynamic SQL query.
	Behaviour of IDENTITY Columns and SEQUENCES with TRANSACTIONS [Technical Blog] 3 Dec 2017 Updated: 3 Dec 2017 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 4,250 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Behavior of IDENTITY Columns and SEQUENCES with TRANSACTIONS
	Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features [Technical Blog] 27 Jul 2011 Updated: 27 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 13,130 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features
	Using CLR functions with T-SQL [Technical Blog] 25 Nov 2011 Updated: 25 Nov 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 17,160 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Using CLR functions with T-SQL
	Strange Behaviour Converting NVARCHAR(MAX) to BINARY [Technical Blog] 10 Mar 2018 Updated: 10 Mar 2018 Rating: 3.46/5 Votes: 4 Popularity: 2.08 Licence: CPOL Views: 4,620 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Strange behaviour converting NVARCHAR(MAX) to BINARY
T-SQL	Analyzing SQL Server Error Logs / Agent Logs using T-SQL [Technical Blog] 25 Nov 2015 Updated: 25 Nov 2015 Rating: 4.97/5 Votes: 10 Popularity: 4.97 Licence: CPOL Views: 10,890 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	Show an image saved in a SQL Server table on an ASP.NET Image control [Technical Blog] 20 Oct 2011 Updated: 20 Oct 2011 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: CPOL Views: 53,060 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	Connecting to an MS SQL Instance using NodeJS (Fixing ConnectionError: Port for SQLServer not found in ServerName & Failed to connect to localhost:undefined in 15000ms) [Technical Blog] 15 Aug 2016 Updated: 15 Aug 2016 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 17,102 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	Applying Database Principal Throughout the Server (for all Databases) for a Particular User [Tip/Trick] 9 Sep 2018 Updated: 10 Sep 2018 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 3,980 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

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

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

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

Average article rating: 4.99

Database Development

Enterprise

Programming Languages

Average blogs rating: 4.60

All Topics

Database Development

Desktop Programming

Operating Systems

Programming Languages

Web Development

Average tips rating: 5.00

Database Development

Average reference rating:

Average project rating: