SQL Server Lock Escalation

Database administration, Work with data

Introduction Relational databases follow the ACID properties in how they implement transactions –...
Read More

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

Database administration, 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 SQL Server HierarchyID Through Easy Examples

Database administration, Database Optimization & Structure

Do you still hold on to the parent/child design, or would like to try something new, like SQL Server hierarchyID? Well, it is really new...
Read More

Understanding Text Mining with SQL Example

Languages & Coding, T-SQL

The current article focuses on the conceptual understanding of Text Mining. It gives clear examples...
Read More

The Easy Guide on How to Use Subqueries in SQL Server

Database development, Statements • One Comment

Do you use SQL subqueries or avoid using them? Let’s say the chief credit and collections officer asks you to list down the names of...
Read More

Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger

Tools & technologies, Utilities & Extensions

When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live”...
Read More

Learn to Store and Analyze Documents on Windows File System with SQL Server Semantic Search – Part 1

Database administration, Search

The article examines storing unstructured data using native windows directory structure and...
Read More

4 Out-of-the-Box SQL Data Conversion Methods and Use Cases

Database administration, Work with data

First of all, you can’t do without them, right? SQL data conversions or, more specifically, data type conversions are an essential part...
Read More

Creating Maintenance Plans in SQL Server

Database administration, Database Optimization & Structure

Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the...
Read More

Pivoting, Unpivoting, and Splitting Columns in Power BI Query Editor

Database development, Tables, Tools & technologies, Utilities & Extensions

For reference, Power BI is a data visualization and analytics software developed by Microsoft....
Read More
Close