Archive for admin

Semantic search in SQL Server using word net

Semantic search is a feature of SQL Server that allows you to perform advanced searches on unstructured text data. With semantic search, you can use natural language search queries to find relevant information in documents and other text-based data stored in SQL Server. In this article I have explained, how you can implement semantic search […]

Code snippets and steps to create custom code snippets

Code snippets are meant as small region of reusable code. Which allow you to use intellisense to insert set of code N number of times. Below are the content you will cover in lecture. Using code snippets can save a lot of time and effort. Also help in distributing common standard code among team. • […]

Finding expensive queries in SQL Server and performance optimization

Finding expensive queries can be challenging on SQL Server, this tutorial will help you in finding expensive queries on production. Using below DMVs: SYS.DM_EXEC_QUERY_STATS SYS.DM_EXEC_SQL_TEXT SYS.DM_EXEC_CACHED_PLANS SYS.DM_EXEC_TEXT_QUERY_PLAN First is using average logical reads, execution count and total worker time. But still people can use other combinations as well. I have also explained how missing index […]

Hosting react and nodejs on same server using multiple domain

It is very common for developer to have react app supported by nodejs API for backend. In some cases developer may use API developed in php or any other programming knowledge. When it comes to deployment, programmer may face difficulty in deploying both on same server. As one can only host single application to single […]

Print POS thermal receipt from web browser using Techsapphire Direct Print

Below is instruction and demo video for same. We all know and agree with the age old slogan that says ‘Necessity is the Mother of Invention’. From a pin to a super computer was created due to our needs. Latest in this is our direct print. As the name suggests, it lets you print directly […]

Automation Testing

What is Automation Testing? Automation Testing/Test Automation is testing software which is performed using special automated testing software tools for the execution of a test case suite. On the other hand, manual testing is done by a human, who sits in front of the computer executing every step of the test with utmost care. Automation […]

Self Hosting using Nancy

Code: static class Program { /// /// The main entry point for the application. /// static NancyHost host; public class SampleModule : Nancy.NancyModule { public SampleModule() : base(“/Sample”) { Get(“/”, _ => “Hello World!”); } } public class MainModule : Nancy.NancyModule { public MainModule() : base(“/”) { Get(“/”, _ => { return “Hello Base!”; }); […]

Zoom SDK integration with react and node js

In this lecture we are going to learn the integration of Zoom in reactjs using nodejs and zoom SDK. How we can create a meeting on single click of a button with a name only? We will learn this also in above lecture. Steps for creating SDK: Zoom SDK Open https://marketplace.zoom.us/ and sign up into […]

SQL Server Database Management Services

With the increase of customers and operational information stored by organizations, the complexity of managing that data also increases. Techsapphire database experts are ready to help you with all aspects of data management, ranging from database design to diagnostics and performance tuning, monitoring and ongoing remote administration. Our trained and highly qualified consultants and database […]