Click here to Skip to main content
15,891,248 members

Technical Blogs


Page 1 of 2
1 2


1. Computed Columns in SQL Server
Computed columns in SQL Server
Database Development » SQL Server »
Manjuke Fernando Updated: 29 May 2018
Rating: 4.58/5 ( (7 votes))
2. Strange Behaviour Converting NVARCHAR(MAX) to BINARY
Strange behaviour converting NVARCHAR(MAX) to BINARY
Manjuke Fernando Updated: 10 Mar 2018
Rating: 3.46/5 ( (4 votes))
3. Behaviour of IDENTITY Columns and SEQUENCES with TRANSACTIONS
Behavior of IDENTITY Columns and SEQUENCES with TRANSACTIONS
Manjuke Fernando Updated: 3 Dec 2017
Rating: 5.00/5 ( (1 vote))
4. Understanding JOINs in SQL Server
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.
Database Development » SQL Server »
Manjuke Fernando Updated: 4 Dec 2016
Rating: 4.95/5 ( (45 votes))
5. Always Encrypted Feature in SQL Server 2016
Always encrypted feature in SQL Server 2016
Database Development » SQL Server » SQL Server 2016
Manjuke Fernando Updated: 19 Oct 2016
Rating: 5.00/5 ( (3 votes))
6. DROP IF EXISTS in SQL Server 2016 (DIE)
DROP IF EXISTS in SQL Server 2016 (DIE)
Database Development » SQL Server » SQL Server 2016
Manjuke Fernando Updated: 24 Aug 2016
Rating: 4.74/5 ( (9 votes))
7. 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)
Connecting to MS SQL Server using NodeJS
Web Development » Node.js »
Manjuke Fernando Updated: 15 Aug 2016
Rating: 4.00/5 ( (1 vote))
8. String or Binary Data Would Be Truncated / Arithmetic Overflow Error Converting Numeric to Data Type Numeric – Workaround
String or binary data would be truncated / arithmetic overflow error converting numeric to data type numeric – workaround
All Topics » »
Manjuke Fernando Updated: 9 Mar 2016
Rating: 5.00/5 ( (2 votes))
9. Index REBUILD vs. REORGANIZE in SQL SERVER
What is the difference between Index REBUILD and REORGANIZE and when exactly should you use it
Database Development » SQL Server »
Manjuke Fernando Updated: 16 Feb 2016
Rating: 4.89/5 ( (2 votes))
10. 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.)
Error accessing Oracle Database Objects via Linked Server in SQL Server
Manjuke Fernando Updated: 20 Jan 2016
Rating: 5.00/5 ( (2 votes))
11. Analyzing SQL Server Error Logs / Agent Logs using T-SQL
Analyzing SQL Server Error Logs / Agent Logs using T-SQL
Programming Languages » T-SQL »
Manjuke Fernando Updated: 25 Nov 2015
Rating: 4.97/5 ( (10 votes))
12. Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas
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.
Manjuke Fernando Updated: 26 Oct 2015
Rating: 5.00/5 ( (1 vote))
13. Error Occurs When CTE Alias is ‘RESULT’ - Incorrect Syntax Near 'RESULT'
Error occurs when CTE Alias is ‘RESULT’ - Incorrect syntax near 'RESULT'. Succeeds on some SQL Server databases but fails on others.
Database Development » SQL Server » SQL Server 2012
Manjuke Fernando Updated: 3 Jun 2015
Rating: 4.00/5 ( (1 vote))
14. Conflict in log4net on GAC when a Crystal Report is Viewed through .NET Code
Conflict in log4net on GAC when a Crystal Report is Viewed through .NET Code
All Topics » »
Manjuke Fernando Updated: 20 May 2015
Rating: 2.00/5 ( (1 vote))
15. Create a Cursor using Dynamic SQL Query
Create a Cursor using dynamic SQL query.
Manjuke Fernando Updated: 6 Nov 2012
Rating: 4.57/5 ( (6 votes))
16. Exclusive Access Could Not Be Obtained Because the Database is in Use ~ Resolved
How to resolve this issue
Manjuke Fernando Updated: 19 Oct 2012
Rating: 4.86/5 ( (12 votes))
17. Introduction to SSDT (SQL Server Data Tools)
Briefly describing the features in SQL Server Data Tools.
Database Development » SQL Server » SQL Server 2008
Manjuke Fernando Updated: 20 Sep 2012
Rating: 4.75/5 ( (3 votes))
18. Installing SQL Server Data Tools (SSDT)
How to install SQL Server Data Tools
Database Development » SQL Server »
Manjuke Fernando Updated: 3 Sep 2012
Rating: 3.00/5 ( (1 vote))
19. Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL
Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL
All Topics » »
Manjuke Fernando Updated: 26 Nov 2011
Rating: 5.00/5 ( (6 votes))
20. Using CLR functions with T-SQL
Using CLR functions with T-SQL
Manjuke Fernando Updated: 25 Nov 2011
Rating: 5.00/5 ( (1 vote))

Page 1 of 2
1 2