Browse by Tags

Table of Contents Introduction Node.js Installation Test Node.js Environment Node.js with Visual Studio 2017 Conclusion References Introduction This article is intended to create first node.js application with the Visual Studio 2017. The Node.js is a JavaScript-based platform, built on Google’s...

This article describes the 'Chain of Responsibility' design pattern . This is a behavioral design pattern , a category of design pattern used by software engineers, when writing computer programs. Table of Contents Introduction Benefits Examples of the pattern See Also Community...

Table of Contents 1 Introduction 2 Background 3 Create a Web application using ASP.NET Core in Visual Studio 2017 3.1 Create a ASP.NET Core web application 3.2 Create Student Model 3.3 Create Student Controller 3.4 Create the database 4 Show a confirmation box when a student edits 5 Show a confirmation...

Table of Contents Introduction Checking .NET Core Installation Installing .NET Core SDK on Windows Creating Console Application Adding Project Template Building and Running the Application Summary References Introduction In this post, we will create our very first console application in .NET...

Here I am trying to explain how to change the language of Existing sharepoint site using SQL Query Note: Before converting sharepoint site language don't forget to install the required language packs.. please refer below links to know about sharepoint language pack installation Note: Take Granular...

Table of Contents Introduction Performing the test Does DMV list all Enterprise-only features? sys.dm_db_persisted_sku_features Conclusion References Introduction I have SQL Server 2008 that was installed as an Enterprise edition, now we want to upgrade this server to SQL 2012, starting from...

Table of Contents Introduction Assumptions Solution References See Also Introduction Many organizations these days want to coexist due to different reasons. The major reason is that user demands more and organizations want to cater to this ever demanding user base. Some users might be familiar...

Vamos a instalar Sharepoint 2016, y veamos que cosas nuevas trae. Primero que nada necesitamos bajarlo. Para eso vamos a bajarlo desde aca . Mientras se baja que son unos 3 gb, vamos a ver que necesitamos para instalarlo. Requerimientos de Hardware SQL Server Tengan en cuenta que...

Table of Contents Overview Slowly Changing Dimensions DEMO Data Model Enabling Temporal for Existing Tables Simulate the ETL Process Dig into Modified Query Considerations References Overview Microsoft has introduced many great features with the SQL Server 2016. Even though some of the features...

Table of Contents Problem Statement: Solution: Generate script for matching search string of all SP's Using sp_helptext Using system view sys.procedures Generate modified SP's script Create Linked Server Alias Conclusion References Problem Statement: After SQL Server Migration or database...

Table of Contents Introduction / Background Intended Audience Requirement Statement Solution Business Data Catalog Model Database Deployment Steps 1. Deploying Business Data Catalog Model File 2. Set Permission on external content type 3. Create Line of Business Content source under Search Service 4...

Bu makalemizde Ekim 2017 tarihinde kararlı sürümü piyasaya sürülen SQL Server 2017 ürününün kurulumunu ele alıyor olacağız. Makalemizde SQL 2017 kurulumunu ele alıp yeniliklerine yer vermeyeceğiz. 2017 ile birlikte gelen en temel özellikler performans iyileştirmesi ve Linux tarafındaki ilk sürüm niteliğinde...

Table of Contents Azure DevOps Project - What is it? Walkthrough Select a new application to bring into VSTS Selecting Application/Framework Service Configuration Dashboard CI/CD Pipeline Application Insights So why is this so cool? Azure DevOps Project is in public preview as announced here ...

Introduction: We have a requirement for our REST API to send and accept the data as JSON object. So I have created a generic class that can convert DataSet or DataTable into JSON Objects. You can also define the Relationship between the dataTables So that you can get hierarchical JSON object from...

Table of Contents Credits Introduction Steps Summary References and more info Credits The credits for this article go to Carsten Siemens. The initial content is based on a procedure he provided. And it's Carsten that has done the initial investigation to get his procedure documented, including...

Table of Contents How to perform PnP search using SharePoint Framework(SPFx) Setup for Client Web Part Steps for Search Client Web Part Conclusion References How to perform PnP search using SharePoint Framework(SPFx) It’s a simple example of how we can leverage SharePoint Pattern & Practice...

Table of Contents Background: Requirement: Solution: Background: A Site Collection has three subsites which have some common groups among them. All three subsites have stopped the inheritance from their parent. That is to say, they have unique permissions now. If the customer deletes the common...

Table of Contents Admin Center OneDrive Apps As you may already know, Office 365 comes with different subscription models. First, you need to make your billing address available in supported countries. You can find the geographical availability by referring below URL: https:/...

Table of Contents Introduction Pre Requisite Process References Introduction Below provided PowerShell will come very handy if we need to upload multiple files to SharePoint Online document Library. In this script, we iterate through local folder provided and upload files to specified SharePoint...

Table of Contents Introduction Building the Environment for Testing Paging rows with Limit Paging in SQL Server 2012 Comparing the Queries - ROW_NUMBER vs OFFSET/FETCH Conclusion References See Also Other Languages Introduction Sometimes it is necessary to optimize the data returned by a query,...

Table of Contents Introduction Explanation See Also: Introduction In SQL Server 2017, a new string function Concat_WS introduced which concats two or more expression into a single string. Explanation Concat_WS function concatenates the two or more expressions into a single string...

Table of Contents Introduction Logic Apps Cognitive Services Azure Event Hubs Fictional Scenario Solution Designed For the Requirement Solution Implementation On Premises Systems Design SQL Data Store BizTalk Application On Premises Data Gateway Cloud Systems Design Creating Text Analytics Api Analysis...

Table of Contents Background VNET Peering Concept Hands-On Pricing References Background In the last article , we have seen the details of Azure Active Directory Domain Services and we also saw how to set it up. As mentioned currently ADDS only supports classic virtual networks and so only machines...

Table of Contents Introduction Building the Environment for Testing Moving Old Data Freezing Table Conclusion References See Also Other Languages Introduction This article provides a way to maintain one or more tables in a database without the possibility of change to the structure or your data...

Table of Contents Introduction Building the Environment for Testing Environment Requirements Automation in Excel using VBA Conclusion References See Also Other Languages Introduction Critical situations, especially for small business with hardware and/or software limited. Also on places with...