Tag: sql server 2016

Install and Configure SQL Server 2019 on Windows Server 2016

12:05 Tools & technologies

SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5....
Read More

Using SQL Server 2016 Upgrade Advisor

13:32 Tools & technologies, Utilities & Extensions

INTRODUCTION SQL Server is designed to allow multiple databases on a single instance. With this model it is possible to have databases...
Read More

Storing and Analyzing Documents on Windows File System with SQL Server Semantic Search – Part 2

11:40 Database administation, Search

This is the second part of the material dedicated to SQL Server Semantic Search. In the previous article, we explored the basics. Now, we...
Read More

How to Use Semantic Search in SQL Server

10:01 Database administation, Search

This article deals with the basics of Semantic Search, including a complete walkthrough of Semantic...
Read More

Implementing Full-Text Search in SQL Server 2016 for Advanced Users

01:31 Database administation, Search

This article tells about advanced methods of Full-Text Search usage for data professionals. It enables better search experience in their...
Read More

Implementing Full-Text Search in SQL Server 2016 for beginners

02:39 Database administation, Search • One Comment

This article talks about the full-text search and its implementation for the beginners to get started. Additionally, the readers will know...
Read More

In-depth Exploration of Row Level Security

17:59 Database administation, Security

Introduction Organizations are becoming more and more concerned about how to reduce the cost of...
Read More

Introduction to Row-Level Security in SQL Server

11:56 Database administation, Security

Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default lowest level of security for a database. In...
Read More

Traditional and Natively Compiled Scalar-Valued User-Defined Functions

16:09 Languages & Coding, T-SQL

In the software programming world, there are several approaches used by developers that help them with effortless software development....
Read More

Compare Execution Plans in SQL Server

12:47 Database administation, Database Optimization & Structure

Database Administrator always makes an effort to tune SQL Server query performance. The first step...
Read More