Blog

How to tech guides and tutorials

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#[…]

Queue – Data Structures and Algorithms using C#

A queue is a First In First Out (FIFO) data structure. A queue is the most common which you encounter in daily-life as well. For example :  Standing in line for money withdraw at an ATM where the first person in the line is the person to be served first; the last one to be served Read more about Queue – Data Structures and Algorithms using C#[…]

Stack – Data Structures and Algorithms using C#

In our previous article Data Structures and Algorithms using C# – Array , we learnt arrays data structure and the operations performed on them. The various elements can be accessed from any position stored in an array. Some practical applications require that the additions or deletions be done only at one end. For example : Browser Read more about Stack – Data Structures and Algorithms using C#[…]

Arrays – Data Structure and Algorithm using c#

In this article, you will learn the Array data structure – a straightforward and powerful data structure that can store and arrange data in a specific format to fix some type of complex problems. You can use it to store many variables of the same type, such as int, string, etc. We will also look Read more about Arrays – Data Structure and Algorithm using c#[…]

Binary Search Algorithm Using C#

Binary search is the most popular and efficient search algorithm used to solve problems. It tries to find the desired element in a list by dividing the list into left and right sub-lists. Think of this as our childhood game : guessing a number between 1 and 100 played by us where we used to guess Read more about Binary Search Algorithm Using C#[…]

Linear Search Algorithm using C#

Linear search, also known as sequential search, is the most simplest and least performance searching algorithm. Literally, It checks every element in the list sequentially until the desired element is found or until all the elements have been searched. Think of it as finding a contact number in your phone. You starts searching from starting in the list and Read more about Linear Search Algorithm using C#[…]