Install and Configure SQL Server 2019 on Windows Server 2016
SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5....
Using SQL Server 2016 Upgrade Advisor
INTRODUCTION SQL Server is designed to allow multiple databases on a single instance. With this model it is possible to have databases...
Storing and Analyzing Documents on Windows File System with SQL Server Semantic Search – Part 2
This is the second part of the material dedicated to SQL Server Semantic Search. In the previous article, we explored the basics. Now, we...
How to Use Semantic Search in SQL Server
This article deals with the basics of Semantic Search, including a complete walkthrough of Semantic...
Implementing Full-Text Search in SQL Server 2016 for Advanced Users
This article tells about advanced methods of Full-Text Search usage for data professionals. It enables better search experience in their...
Implementing Full-Text Search in SQL Server 2016 for beginners
This article talks about the full-text search and its implementation for the beginners to get started. Additionally, the readers will know...
In-depth Exploration of Row Level Security
Introduction Organizations are becoming more and more concerned about how to reduce the cost of...
Introduction to Row-Level Security in SQL Server
Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default lowest level of security for a database. In...
Traditional and Natively Compiled Scalar-Valued User-Defined Functions
In the software programming world, there are several approaches used by developers that help them with effortless software development....
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step...