SQL Server

MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management

Database administration, Database Optimization & Structure, SQL Server

In the previous articles of the SQL Server System Databases series, we have gone through the System...
Read More

GROUP BY in SQL Server: 3 Easy Examples to Group Results

Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
Read More

SQL AS: Usage, Examples, and How it Can Benefit You Best

Database development, SQL Server, Statements

What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a table or column. This alias can be used...
Read More

How to Change Database Collation in SQL Server: Step-by-Step Guide

Database administration, SQL Server, Work with data

When you develop an application or write a code in the SQL database system, it is crucial to...
Read More

10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL

SQL Server • One Comment

Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow someone to take over your database. Plus,...
Read More

SQL Server Transactional Replication Configuration

Database administration, SQL Server, Transaction Log

Transactional Replication in SQL Server is one of the most commonly used Replication techniques to copy or distribute data across multiple...
Read More

A Simple Use Case for Indexes on Primary Keys

Database administration, Database development, Indexes, Performance Tuning, SQL Server • 3 Comments

Introduction Recently we encountered an interesting performance problem on one of our SQL Server...
Read More

Introduction to Synonyms in SQL Server

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

A synonyms in SQL Server are database objects that give an alternative name to the database objects existing locally or on the remote...
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 administration, 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...
Read More