Tag: sql server

Implementing Full-Text Search in SQL Server 2016 for beginners

Database administration, Search • One Comment

This article talks about the full-text search and its implementation for the beginners to get...
Read More

How to install SQL Server vNext and Azure data studio on Ubuntu 18.04

Azure, Cloud

Azure data studio is a cross-platform database management tool. This tool is used to connect, configure, and administrate SQL Server...
Read More

Dynamic Data Masking in SQL Server for Advanced Users

Database administration, Work with data

This article gives a high-level understanding of dynamic data masking in SQL Server along with its use cases, best practices and security...
Read More

Deploying a SQL Server Docker Container

Containers, Docker, Tools & technologies

Introduction Containerization has become the dominant topic after the Server Virtualization and...
Read More

Move System Databases in the SQL Server Failover Cluster

Database administration, Database Optimization & Structure

Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us to replace the old one with a new SAN....
Read More

Filtering Data in T-SQL

Languages & Coding, T-SQL

Introduction In most scenarios when working with data, users do not require all the data in each instance of a query. T-SQL (and SQL of...
Read More

How to Capture and Analyze SQL Server Events

Database development, Events

When working as a SQL Server database administrator, you should have the skills to dive deeply into...
Read More

Collation in SQL Server

Database administration, Work with data • One Comment

Introduction You must have already heard the term “Collation” in SQL Server. Collation is a configuration that determines how character...
Read More

Using Transaction ROLLBACK in SQL Server

Database administration, Statements, Transaction Log

Introduction Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE...
Read More

SQL Server High availability: Add new disk to an existing failover cluster instance

Database administration, Database Optimization & Structure

In my previous article, I have explained the step-by-step process of installing a node in existing...
Read More
Close