SQL Server

Introduction to Synonyms in SQL Server

Database administation, SQL Server, Work with data • One Comment

A synonyms in SQL Server are database objects that give an alternative name to the database objects...
Read More

How to Check Status Of SQL Agent Jobs using PowerShell Tool

Languages & Coding, Microsoft Azure, PowerShell, SQL Server, Tools & technologies

From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential...
Read More

In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples

Database administation, Memory Optimization, SQL Server • 2 Comments

What if 1 second of a transaction process is too long? You can tune your queries. But what if it’s not enough, can you still step up...
Read More

9 Best Practices for Writing SQL Queries

Database administation, Database development, MySQL, Oracle, Perfomance Tuning, PostgreSQL, SQL Server, Statements

If you are reading this article, most probably, you are already familiar with SQL. You know how to...
Read More

Virtual Columns and Functional Indexes

Database development, Indexes, MySQL, Oracle, PostgreSQL, SQL Server, Tables

Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Read More

Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables

Database development, SQL Server, Statements, Tables

INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
Read More

DevOps Solutions for Database Development Automation

Programming, SQL Server

What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating...
Read More

Create Indexed Views in SQL Server

SQL Server

Introduction You would have already heard about views in databases. We create views for a number of reasons. One of the main reasons for...
Read More

Structured Query Language – Importance of learning SQL

Database administation, Database development, MySQL, Oracle, PostgreSQL, SQL Server • One Comment

Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Read More

Dynamic SQL vs Stored Procedure

SQL Server

Dynamic SQL and stored procedures are among the most important SQL Server components. Both have...
Read More
Close