Blog

How to tech guides and tutorials

Elasticsearch For .NET Developer : How to work with Elasticsearch using c#

In this post, we are going to take a look at how to integrate Elasticsearch with .NET so that it can be useful in your .NET based projects. This post is part 3 of the series “elasticsearch for .net developer”. Before proceeding, I strongly recommend to check out previous parts listed below: Part 1 : Elasticsearch for .NET Read more about Elasticsearch For .NET Developer : How to work with Elasticsearch using c#[…]

Elasticsearch For .NET Developer : Installing and Configuration

In this post, we will guide you how to quickly set up and running single instance elasticsearch in windows operating system. This post is part 2 of the series “elasticsearch for .net developer”. Before proceeding, I strongly recommend to check out previous post Part 1 : Elasticsearch for .NET Developer – What and Why Elasticsearch You Read more about Elasticsearch For .NET Developer : Installing and Configuration[…]

Elasticsearch For .NET Developer : What and Why Elasticsearch ?

What is ElasticSearch ? Elasticsearch is an open source, NoSQL, distributed, and highly scalable full text search database that is built on top of Lucene, a search engine library written in Java. It provides extremely fast searches and makes data discovery easy. It’s a NoSQL database because it’s a document based storage system instead of using tables and Read more about Elasticsearch For .NET Developer : What and Why Elasticsearch ?[…]

How to take Screenshots when test fails in Selenium?

This method is used to take snapshot on test fail. This method will create separate folder for each test Class and store snapshot everytime with qualified name that contains ClassName, method name and date time of screenshot. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Read more about How to take Screenshots when test fails in Selenium?[…]

How to Track Stored Procedure, Function, View changes in SQL Server

Do you want to track the changes made on database objects like Stored Procedures, Views, Functions? SQL Server supports DDL Triggers that can be used to accomplish this task. SQL Server DDL Triggers is a special kind of trigger that fire in response to Data Definition Language (DDL) statements – CREATE, ALTER, DROP (Table, Function, Read more about How to Track Stored Procedure, Function, View changes in SQL Server[…]

How To Create And Schedule Job Using SQL Server Agent

In this post, we walk through the step by step process of creating and scheduling a job using SQL Server Management Studio.   What is SQL Server Agent ? SQL Server Agent is a component of Microsoft SQL Server which allows the database administrator (DBA) to schedule jobs and handles other automated tasks such as database backups Read more about How To Create And Schedule Job Using SQL Server Agent[…]

How to search a specific text in a SQL Server Stored Procedures, Functions, Views or Triggers

As a DB developer, I often needed to find a stored procedures, functions, views and triggers  that contains a specific piece of text string. For an example, say I want to find any Stored Procedures, Views or Functions that contains a text ‘codemog’. So, How to search a specific text in a SQL Server Stored Procedures,Views or functions Read more about How to search a specific text in a SQL Server Stored Procedures, Functions, Views or Triggers[…]

How to Design Memory Optimize Database using SQL Server In-Memory OLTP

‘In-Memory OLTP’ also known as ‘Hekaton’ and ‘In-Memory Optimization’ is in-memory processing technology that allows you to get most out of SQL Server for your transactional workloads. This feature was introduced with SQL Server 2014 release. This post demonstrates the usage of In-Memory OLTP feature with examples. Create A Database 1 2 — Create a Read more about How to Design Memory Optimize Database using SQL Server In-Memory OLTP[…]

SQL Server: Error – ‘The operation ‘AUTO_CLOSE’ is not supported with databases that have a MEMORY_OPTIMIZED_DATA filegroup.’

The operation ‘AUTO_CLOSE’ is not supported with databases that have a MEMORY_OPTIMIZED_DATA filegroup. You are getting this error because your database set to AUTO_CLOSE ON, which is the default setting for any database in SQL Server. If you are trying to create a memory-optimized file group or data file to use In-Memory OLTP feature of SQL Server, you Read more about SQL Server: Error – ‘The operation ‘AUTO_CLOSE’ is not supported with databases that have a MEMORY_OPTIMIZED_DATA filegroup.’[…]

Linked List – Data Structures and Algorithms using C#

In Previous article, Data Structures and Algorithms using C# – Array  we saw that although arrays provide good performance for static collections of data, they had certain disadvantages as data storage structures. In an un-ordered array, searching is slow, whereas in an ordered array, insertion is slow. In both kinds of arrays, deletion is slow. Read more about Linked List – Data Structures and Algorithms using C#[…]