Tagged Content List
  • Wiki Page: T-SQL: Safely Concatenate Values Into a Scalar Variable

    Introduction It is often far too easy to experience some behavior in SQL Server, and then extrapolate your belief from that. One example that is seen frequently on forums is the simplistic case of concatenating values into a scalar variable, however the logic that is commonly assumed is false...
  • Wiki Page: How can I prevent crash from IDENTITY column value jump

    Table of Contents Introduction Building the Environment for Testing Causing Gaps in a Sequence Number Changing the startup SQL Server service Using TRACE 272 Conclusion References See Also Other Languages Introduction This article presents a common change in values ​​of columns that have the...
  • Wiki Page: SQL Server: Frequently Used Ports

    Table of Contents Introduction Frequently Used Ports References Introduction This list is about essential TCP/UDP port numbers that an administrator running SQL Server / Cluster requires to know when configuring the firewall or otherwise. It includes those used under OS, server-based programs...
  • Wiki Page: SharePoint: Using PowerShell to Perform a Bulk Delete Operation

    Table of Contents Introduction Example See Also Reference Introduction Have you ever written a really great PowerShell script for migrating data into SharePoint, only to have made the mistake of adding tens of thousands of new list items into the wrong SharePoint list? Oops. Have...
  • Wiki Page: Azure Bot Service: Create Chat Bot

    Table of Contents Introduction Azure Account Azure Account Registration Web App Bot BOT Service Registration Online Code Editor Test in Web Chat Code Connect a bot to Web Chat IFrame code Output Summary See Also Reference Introduction This article explains how to Create and Connect a chat...
  • Wiki Page: SharePoint 2016: Export all first and second stage recycle bin contents to a single File

    Table of Contents References Notes No need to use looping to export the contents of all end user recycle bins and the second-stage recycle bin to a CSV file - a single line of PowerShell will do: (Get-SPSite -Identity "[your site collection URL]").RecycleBin | Export-CSV ...
  • Wiki Page: ASP.NET Core: QR Code Generator Using ZXING.NET

    Table of Contents Introduction Background Zxing.Net Assemblies required Packages required C# Index.chtml _ViewImports.cshtml project.json Output Reference Downloads See Also Note: This article Participated in TechNet Guru Competition May 2017 and won Silver Medal. Introduction In this...
  • Wiki Page: ASP.NET Core And MVC Core: Session State

    Table of Contents Introduction Session State Package Required .csproj Assemblies Required Home Controller Configure Services Configure the HTTP request pipeline Output - Active Session Output - Session Expired Reference Downloads See Also Note: This article participated in TechNet Guru Competition...
  • Wiki Page: ASP.NET Core 2.1: Getting Started with Angular 7

    Table of Contents Introduction Angular 7 Web Application (.NET Core) using Template Step 1- Create Angular 7 ASP.NET Core using Template Angular CLI Step 2 - Build and Run the Application ClientApp folder: Using Asp.NET Core Web Application Step 1- Create ASP.NET Core Web Application Step 2 – Upgrade...
  • Wiki Page: ASP.NET Core 1.0: Middleware And Static files (Part 1)

    Table of Contents Introduction Built-in Middleware Single Request Delegate app.Run app.Use StaticFiles Startup Page HTML Index Page Code Output StaticFiles Configuration ASP.NET Core 1.0 project.json Extension Methods UseStaticFiles() Output UseDefaultFiles() UseFileServer() Reference Conclusion ...
  • Wiki Page: Cognitive Services : Translate Text into multiple languages using Translator Text API With Asp.Net Core & C#

    Table of Contents Introduction Prerequisites Translator Text API Provision a Translator Text Subscription Key Language Request URL Endpoint Index.html site.js Interface Translator Text API Service API Response – Based on the given text Download Output Reference Summary See Also Introduction In...
  • Wiki Page: SQL Server: Ranking Functions

    Table of Contents Introduction Preparation DDL+DML Ranking function in Microsoft SQL Server RANK() DENSE_RANK() Row_Number() NTILE() Reference Conclusion Note: This Article Participated in TechNet Guru Competition December 2016 Jump and won Silver Medal. Introduction In this article...
  • Wiki Page: ASP.NET Core 1.0 Configuration: Aurelia Single Page Applications

    Table of Contents Introduction Configuring Aurelia SPA in ASP.NET Core 1.0 Install Node.js Install Git Install jspm Setting Project Location jspm Initialization Install Aurelia Framework in ASP.NET Core 1.0 Install Aurelia bootstrapper in ASP.NET Core 1.0 Project Structure config.js package.json Conclusion...
Page 20 of 77 (1,925 items) «1819202122»