All about Asp.net, C#, SQL Server, Java Script, jQuery, Angular, React, Node JS, MSSQL

In the real world, we load the data on the front from the database one time and load it into memory via data table or in some other form (main table and other supported tables) and then loop through individual records in Parallel For Each for better performance. However, in some cases, if the data load is huge, we may end up having memory issues loading all the records on the front so weload each individual record inside the loop in SQL which could potentially affect the performance. Example :  SELECT First_Name + ' ' + Last_Name FROM REgistration ORDER BY First_Name OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY; In this example, it will skip the first 10 rows and return the next 5 rows. Limitations while Using OFFSET-FETCH ORDER BY is mandatory to use OFFSET and FETCH clause. OFFSET clause is mandatory with FETCH . You can never use, ORDER BY … FETCH. TOP cannot be combined with OFFSET and FETCH in the same query expression. The OFFSET/FETCH row count expression ca

The Runtime Environment of .NET Framework is Called Common Language Runtime. CLR can be considered as Virtual Machine (VM) component of Microsoft's .NET framework. It manages the execution of Managed Code (.NET Programs). CLR uses a just-in-time (JIT) compiler which converts the compiled code of .NET into Native Code. Language Compilers (e.g. C#, VB.Net, J#) convert the .NET Program Code to Microsoft Intermediate Language (MSIL) and this is further converted to Native Code by JIT Compiler of CLR. Role/Features Of CLR  it provides many features like it loads and executes the code, manages the memory, converts the MSIL code to native code, and handles the exception. Major features of CLR: Memory Mangement Code Access security Garbage Collection JIT Compilation Thread Support Debug Engine Exception Handling 

1. TRANSLATE : It basically takes a string as input and then translates the characters with some new characters, see below  Syntax:  TRANSLATE ( inputString, characters, translations) For Example :  SELECT  TRANSLATE ('4*{13+13}/[8-4]','[]{}','()()') Output : 4*(13+13)/(8-4) This function is work as REPLACE function. but TRANSLATE function is easier to use and also useful when we have to replace more than one value in the string. 2. CONCATE_WS :  It simply concats all input arguments with the specified input delimiter. Syntax : CONCAT_WS ( separator, argument1, argument1, [argumentN]… ) For Example : SELECT CONCAT_WS(',','Count', 'nikhil', 'hardik', 'nilesh', 'sandip' ) AS counter; Output : nikhil, hardik, nilesh, sandip 3. TRIM :  It simply works as the C# trim function, removes all spaces from start and end of the string. Syntax: TRIM(inputString) For Ex

The new upcoming SQL server 2018 features list as below. Edible Result Sets Self-destructing transactions New SSMS color schemes by Karl Lagerfeld Deep South Parent/Child Referential Integrity (I didn’t wanna ask for details there) Eventual consistency Scented error messages Duraflame Transaction Log Access storage engine MAIM command – like KILL, but lets you keep up to half of the result sets that have already been delivered Renaming SQL Server Agent to Cortana Twitch integration for a video replay of cool transactions Azure Power Enterprise Server – I’m not quite sure what this is because the description changed three times while we were talking, and the name changed four Opinion-based triggers TSA-grade security

Angular 5 is going to be a much better Angular. The Angular version 5 will be fully released in September/October 2017 . Angular 5 contains a bunch of new features, performance improvements, and a lot of bug fixes. Make AOT the default Watch mode Type checking in templates More flexible metadata Remove *.ngfactory.ts files Better error messages Smooth upgrades Tree-Shakeable components Hybrid Upgrade Application Angular 5 - Performance Improvements Use of addEventListener for the faster rendering and it is the core functionality. Update to new version of build-optimizer. Added some Improvements on the abstract class methods and interfaces Remove decorator DSL which depends on Reflect for Improve the Performance of Apps and This is the core functionality. Added an option to remove blank text nodes from compiled templates  Switch Angular to use Static-Injector instead of Reflective-Injector. Improve the applications testing. Improve the performance of hybrid ap

What is Blazor? Blazor is a new .NET web framework for creating client-side applications using C#/Razor and HTML that runs in the browser with WebAssembly . It can simplify the process of creating single page application (SPA) and at the same time enables full stack web development using .NET. Microsoft has recently released the first public preview of a new .NET web framework, Blazor 0.1.0. Blazor enables the full stack web development with the productivity of .NET but, as this is an alpha version it should not be used in production. Now, Microsoft has announced the release of Blazor 0.2.0 with all the improvements and new goodies to play with. New features in this release include:  Build your own reusable component libraries Improved syntax for event handling and data binding Build on save in Visual Studio Conditional attributes HttpClient improvements Microsoft has also launched a website where you can find getting started instructions, docs, and tutorials for t