SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).

JavaScript Vs jQuery - Difference Between JavaScript And jQueryJan 11, 2018. This article is mainly for developers who are new into web development. People who start their career will questions like why jQuery while there is JavaScript or difference between JavaScript and jQuery, which is better to use - JavaScript or jQuery, is jQuery an alternative for JavaScript or will jQuery replace JavaScript etc.

Singleton Design Pattern In C# - Part Three (Static vs Singleton)Jan 11, 2018. In this series of learning singleton patterns, we learned lazy initialization and eager initializations with practical examples. We also learned why it is necessary to make the singleton class sealed with sealed keyword. In this article, I’ll try to explain the differences between static and singleton class and where to use static and where to use singleton classes.

Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.

Aborting Thread Vs Cancelling TaskDec 12, 2017. The below post is based on one of the question I answered on StackOverflow, in which the questioner wants to cancel a task when its taking too long to respond; i.e., taking too much time in execution and returning result.

Pug Vs HTMLNov 26, 2017. In the holy wars of &quot;Pug vs HTML&quot;, it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don&#39;t know Pug, and some who know it, know it as a Jade framework.

If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the &quot;boot.ini&quot; file that was used in the old Operating System. For more details check Windows startup process.

Performance - SortedDictionary Vs DictionaryOct 31, 2017. Recently when I was analyzing a clients code base for performance, I found that they were using the collection SortedDictionary in many places in their projects. After looking on how they are using this collection type, I discovered that they really only needed the collection sorted once. So I figured, that if would be better performance to use just Dictionary and sort it once. Before recommending this change to their code, I needed to prove my theory.

Installing And Using .NET 4.7.x, .NET Core 2.0, And C# 7.x With VS 2017Oct 09, 2017. This article explains how to install and use .NET Framework 4.7, .NET Framework 4.7.1 &amp; .NET Core 2.0 and troubleshooting if you are getting an exception while installing these latest components. This article also explains how to use the different versions of C#, e.g. C# 7, C# 7.1, C# 7.2 with Visual Studio 2017 and installing multiple instances of Visual Studio 2017 side by side.

Getting Started With ASP.NET Core MVC Apps Using VS CodeOct 05, 2017. In this article, we will discuss how we can create a HelloWorld app with ASP.NET Core 2.0 using Visual Studio Code. We will learn how to create an ASP.NET Core MVC application, how to create new Controller, how to create new View, and how to run the HelloWorld app etc.

Office 365 Development With Visual Studio 2017 - Part TwoOct 03, 2017. When Visual Studio 2017 was launched earlier this year, I wrote an article to provide glimpses on how to get started with Office 365 development with VS 2017 and different project templates available in VS 2017. You can read it here.

Getting Started With Visual Studio CodeJul 31, 2017. In this article, we will discuss in detail about the Visual Studio Code, how to install the VS Code in Windows and walk through with VS Code features and how to add extensions to VS Code.

AngularJS Vs. ReactJS - A Critical AnalysisJul 01, 2017. Every entrepreneur wants their business website to flourish and to achieve that, the selection of the JavaScript framework becomes quite crucial. It plays a key role not only in the steadiness of the project, but also helps to maintain code and deadlines etc. However, choosing an apt framework to suit your requirements isn’t a cake walk.

Help System In Windows PowerShellJun 26, 2017. Windows PowerShell Help system is the most important resource in PowerShell. Starting with Windows 8 and Windows Server 2012, PowerShell doesn’t come with help already in the system, you have to update it. So the first thing you have to do when you launch PowerShell is to update the help.

Get Started With Visual Studio CodeApr 12, 2016. In this article you will learn how to start with Visual Studio Code. &#39;VS Code&#39;, is a free, lightweight, open-source, cross platform, code editor that works on Windows, Linux and OS X.

AngularJS vs JQuery: Part 2Jan 15, 2016. In this article we’ll learn and discuss AngularJS and jQuery features and also the differences between AngularJS vs jQuery.

Getting Started With AngularJS: Part OneJan 15, 2016. In this article, part one of a series , we will learn AngularJS Step by Step. We’ll also learn many concepts about AngularJS, such as AngularJS history, benefits and point of interest, and most importantly the difference between jQuery vs AngularJS.