List of useful .Net libraries, NuGet packages and Tools for Developers

List of useful .net Libraries, NuGet packages, and Tools LinqPad  Very useful instantly tool to test LINQ, SQL queries ReoGrid: Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (&later) format and working on .NET 3.5 (or client profile), WPF and Android (view … More List of useful .Net libraries, NuGet packages and Tools for Developers

Comparison: Sql Server in Azure VM and Azure Sql Database

Azure SQL Database is native to the Azure and offered as Platform as a service (PaaS). The objective of this offering is to reduce the overall costs to the minimum for provisioning and managing many databases. This offering comes with built-in high availability, disaster recovery, and upgrades for the database. Databases run on latest version of SQL Server Enterprise Edition. Many … More Comparison: Sql Server in Azure VM and Azure Sql Database

Change Tracking example -Sql Server

If there is a requirement to get incremental or changed data from database frequently without putting a heavy load on database objects, then Change Tracking mechanism of Sql Server can be out of the box solution for this requirement. Normally, developers have to do custom implementation to achieve change tracking behavior. It can be implementation … More Change Tracking example -Sql Server

NoSql (It’s “Not only SQL” not “No to Sql”)

This is my first post on NoSql database technologies. There have been drastic changes in database technologies over the few years. Increase in user’s requests, high availability of applications, real time performance forced to think on different database technologies. We have traditional RDBMS, memory and NoSql databases available in market to suffice particular business needs. … More NoSql (It’s “Not only SQL” not “No to Sql”)

When to avoid Between statement in sql query

I was playing with sql queries for performance improvement and got to know that use of Between statement in Sql query for table with huge data degrades performance because it scans all the records within range. Let’s take a scenario where Table A with columns like id, executiondate, name etc. Suppose this table has millions … More When to avoid Between statement in sql query

Common tips to increase performance of Sql Queries

  Below is some very common tips to increase sql queries performance: Every index increases the time in takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not too high. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table, then the number of indexes … More Common tips to increase performance of Sql Queries