Maximizing Productivity and Creativity: Leveraging Ollama AI Models with Obsidian
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...
top of page
Search
SQL Shark
Aug 197 min read
How to Use Obsidian for Effective Note-Taking and Knowledge Management
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...
971
SQL Shark
Aug 136 min read
Running AI Models Locally with WSL, Ollama, Open Web-UI, and Docker
This is a comprehensive guide on how to install wsl on a Windows 10/11 Machine, deploying docker and utilising Ollama for running AI...
1350
SQL Shark
Jun 16, 20232 min read
Understanding the Differences: Primary Key, Natural Key, and Surrogate Key in T-SQL
Introduction In the world of databases, keys are essential for maintaining data integrity and establishing relationships between tables....
4850
SQL Shark
Jun 15, 20233 min read
Understanding the Different Types of Integration Runtimes in Azure Data Factory
Introduction: Azure Data Factory is a powerful cloud-based data integration service provided by Microsoft Azure. It enables organizations...
2010
SQL Shark
Jun 15, 20232 min read
Azure Data Factory - Extracting API Data into JSON files
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....
380
SQL Shark
May 8, 20232 min read
Move files from Azure Data Lake to Sharepoint
Problem Statement Recently, an internal team requested CSV reports to be stored in a SharePoint folder, which were previously generated...
1820
SQL Shark
Jul 6, 20222 min read
Dashboard Testing
1. Introduction The aim of this article is to describe the Dashboard Testing Phase of the Dashboard Development Lifecycle. It consists of...
880
SQL Shark
May 22, 20225 min read
Dashboard Development Lifecycle
A dashboard is a critical tool for understanding an organization's business performance. Decision-makers may see their company's key...
650
SQL Shark
May 22, 20223 min read
Dashboard Requirements Gathering
The requirements gathering in any IT project is essential. In Business Intelligence it ensures that both parties agree on what story the...
580
SQL Shark
Mar 7, 20215 min read
Setting up your-cost effective Azure Database Environment (3)
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...
470
SQL Shark
Mar 2, 20217 min read
Setting up your cost-effective Azure Database Environment (2)
Chapter 2 Resources This chapter aims to look at the resources that will be needed to deliver the database solution. Sub-articles will be...
730
SQL Shark
Mar 2, 20212 min read
Setting up your cost-effective Azure Database Environment (1)
Chapter 1 Problem Statement Cloud computing is fundamentally changing IT and transforming businesses at an unprecedented pace. Companies...
690
SQL Shark
Apr 13, 202015 min read
Microsoft SQL Server 2017 Keyboard Shortcuts Cheat Sheet
Menu Activation - Move to the menu bar | ALT - Activate the menu for a tool component | Alt + - - Display the context menu | Shift +...
840
SQL Shark
Mar 26, 20202 min read
PowerBi Dashboard Testing Checklist
Report or Dashboard Design Check 1. Verify that the report or dashboard page title corresponds to the content of the reports. 2. For...
2510
SQL Shark
Jan 12, 20203 min read
Restoring a TDE Encrypted Database
Restoring AdventureWorks2014 In order to restore the database, we'll need the following tokens: - A certificate file - A private key -...
4600
SQL Shark
Jan 12, 20204 min read
TDE Encrypting a Database
TDE Encryption on AdventureWorks2014 This how-to guide covers how to protect a database by using transparent data encryption (TDE), and...
640
SQL Shark
Oct 17, 20192 min read
SSRS Data Quality Checks
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...
440
SQL Shark
Oct 17, 20197 min read
Database Testing Strategy
1. Introduction The purpose of this document is to explain the importance of having a database testing strategy. Database testing is a...
290
SQL Shark
Sep 28, 20194 min read
Export and Archive SQL Datasets from the Reporting Server
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...
700
SQL Shark
Sep 26, 20193 min read
SQL Server Audit Log
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...
9070
SQL Shark
Sep 12, 20191 min read
Fire SSRS Subscriptions Manually
This is a simple user guide on how you can fire SSRS Subscriptions manually. Please follow the steps provided below. 1. Open the Failing...
780
SQL Shark
Sep 12, 20192 min read
SSIS - Switching from 64-bit to 32-bit
Switch package from 64bit to 32bit Case My Data Flow Task with an Excel connection doesn't run. It throws the following error: Just...
4,3890
SQL Shark
Sep 12, 20191 min read
SSIS - Manual Tests
SSIS Testing Plan: 1. Verify all tables have been imported. 2. Verify all rows in each table have been imported. 3. Verify all the...
191
_edited_edited.jpg)
bottom of page