Database administration

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...
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

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 managing it through the SQL Server database....
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...
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

Formatting Data in Power BI Desktop Visualizations

Business intelligence, Power BI, Work with data

Microsoft’s Power BI is a data analytics tool that can be used for interactive data visualization, using data from various sources such...
Read More

How to Use Semantic Search in SQL Server

Database administration, Search

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

7 Facts About SQL Server Synonyms You Should Know

Database administration, Database Optimization & Structure

Before SQL Server Synonyms appeared, everyone wished to simplify and enhance their database experience. Imagine you have an application...
Read More

Data Visualization in Microsoft Power BI

Business intelligence, Power BI, Work with data

Contents Introduction. How to create a table. How to create a Power BI pie chart. Creating a line chart in Power BI. Report creation....
Read More

How to Load and Manage Data within Microsoft Power BI

Business intelligence, Power BI, Work with data

Contents: Introduction Importing data from Excel, SQL Server, and the Web. Importing data from...
Read More
Close