Power BI: How to Connect to MariaDB Server Database
Connecting Power BI to a MariaDB SQL Server requires a specific third-party connector, which can be a bit more complex…
SQLServer
Read More
Data Modeling in SQL Server
In this SQL Server tutorial, we embarked on a journey to understand and implement data modeling concepts. The primary goal…
How to Create SQL Server Database from CSV Files in Simple Steps (With Download Link to CSV Files)
Today, we demonstrated building an SQL Server database from CSV files. We had multiple CSVs, each representing a table (‘brand’,…
The Ultimate Real-Time Crypto Dashboard: Power BI, Power Automate and SQL Magic
Alright, buckle up for a whirlwind tour of creating a real-time Bitcoin price dashboard! We’re diving into the exciting world…
Configuring SQL Server for Local Area Network: Access SQL Server using Local IP Address
To configure an SQL server for access over a local area network, begin by opening the SQL Server Configuration Manager…
SQL: Complete Tutorial on SQL Basics for Beginners
The tutorial has two videos. In first video the downloading installation and setting up of the SQL server express, and…
Using Custom SQL Queries in Power BI
This tutorial explains how to use custom SQL queries in Power BI to manipulate data before loading it. It covers…
Time Machine for Your Database: Track Every Change with SQL Server
This tutorial explains how to enable and use change tracking in SQL Server to monitor data changes in tables. It…
Creating a Dice Video Game in Power BI using Realtime SQL Server Data and DAX
The tutorial starts by guiding you through creating a table in SQL Server to store game data like turn number,…
Setting up Public mySQL Server on your PC, and connecting it to Looker Reports
Welcome to our Looker Studio tutorial! In this tutorial, we’ll guide you through the process of setting up a XAMPP…