In my last couple of articles, we took a look at running AI models locally and getting cozy with Obsidian . Now, it’s time to dive...

I'm usually an old-school Notepad type of guy. Throughout my IT career, I've spent countless hours taking notes in Notepad. While it's...

This is a comprehensive guide on how to install wsl on a Windows 10/11 Machine, deploying docker and utilising Ollama for running AI...

Introduction In the world of databases, keys are essential for maintaining data integrity and establishing relationships between tables....

Introduction: Azure Data Factory is a powerful cloud-based data integration service provided by Microsoft Azure. It enables organizations...

Problem Statement A client has asked me to create a solution to return the Police Forces of the UK into a Storage Account in JSON format....

Problem Statement Recently, an internal team requested CSV reports to be stored in a SharePoint folder, which were previously generated...

1. Introduction The aim of this article is to describe the Dashboard Testing Phase of the Dashboard Development Lifecycle. It consists of...

A dashboard is a critical tool for understanding an organization's business performance. Decision-makers may see their company's key...

The requirements gathering in any IT project is essential. In Business Intelligence it ensures that both parties agree on what story the...

Chapter 3 Migrating your SQL Server On-Premise to Azure SQL Database Migration to the cloud is a topic that would become more and more...

Chapter 2 Resources This chapter aims to look at the resources that will be needed to deliver the database solution. Sub-articles will be...

Chapter 1 Problem Statement Cloud computing is fundamentally changing IT and transforming businesses at an unprecedented pace. Companies...

Menu Activation - Move to the menu bar | ALT - Activate the menu for a tool component | Alt + - - Display the context menu | Shift +...

Report or Dashboard Design Check 1. Verify that the report or dashboard page title corresponds to the content of the reports. 2. For...

Restoring AdventureWorks2014 In order to restore the database, we'll need the following tokens: - A certificate file - A private key -...

TDE Encryption on AdventureWorks2014 This how-to guide covers how to protect a database by using transparent data encryption (TDE), and...

In our fast paced data world, most of the times we are in a hurry to submit reports to our end users without fully testing their data...

1. Introduction The purpose of this document is to explain the importance of having a database testing strategy. Database testing is a...

1. Problem The problem that our business is facing now is that we lack documentation of our datasets for the reports. Since we’re working...

1. Introduction This is a how to guide on setting up a SQL Server Audit Log. It’s a fairly new feature introduced in SQL Server version...

This is a simple user guide on how you can fire SSRS Subscriptions manually. Please follow the steps provided below. 1. Open the Failing...

Switch package from 64bit to 32bit Case My Data Flow Task with an Excel connection doesn't run. It throws the following error: Just...

SSIS Testing Plan: 1. Verify all tables have been imported. 2. Verify all rows in each table have been imported. 3. Verify all the...