Sebastiao Pereira

Sebastião Pereira has over 40 years of experience in database development including T-SQL, algorithm design, machine learning and bringing innovative mathematical formulas to SQL Server. He started his career at a transnational fast-moving consumer goods (FMCG) company as an employee then later transitioning into a consultant role. He eventually founded his own company to develop software solutions for the healthcare industry.  Sebastião is a respected award-winning author on MSSQLTips.com extending SQL Server capabilities beyond traditional workloads.
  • MSSQLTips Awards
    • Author of the Year - 2025
    • Trendsetter (25+ tips) - 2025
    • Rookie of the Year - 2024
Title Category Date
Graph Theory – Shortest Path Algorithms TSQL2026-06-11
Neural Network in SQL Server Artificial Intelligence2026-05-29
SQL Server 2025 Vector Search SQL Server 20252026-05-21
Graham Scan Algorithm in SQL Server TSQL2026-05-18
Machine Learning Binary Classification Performance in SQL Server Artificial Intelligence2026-05-10
Tokenization in SQL Server: The Security Layer You Forgot Encryption2026-05-09
Fuzzy String Matching Algorithms in SQL Server TSQL2026-05-04
Kanban in SQL Server TSQL2026-04-22
SOFTMAX Function in SQL Server TSQL2026-04-09
Net Present Value and Internal Rate of Return in SQL Server TSQL2026-03-28
SQL Bitwise Operators TSQL2026-03-19
Random Number Generator in SQL using Marsaglia Polar TSQL2026-03-06
Random Exponential Gaussian Numbers in SQL using Ziggurat Algorithm TSQL2026-03-06
Shamir’s Secret Sharing in SQL Server Encryption2026-03-04
Zero Knowledge Proof (ZKP) in SQL Server Encryption2026-02-18
OPTICS Clustering Algorithm in SQL Server TSQL2026-02-04
Homomorphic Encryption Algorithm in SQL Server Encryption2026-01-20
Random Numbers Generator for Poker Simulator in SQL Server TSQL2026-01-05
Generating Shape Bound Random Points in SQL Server TSQL2025-12-05
Ziggurat Algorithm for Normal Random Gaussian Numbers in SQL Server TSQL2025-11-07
Random Gaussian Numbers in SQL using Box-Muller Transform TSQL2025-10-15
Storing and Reporting on Genealogy Data in SQL Server TSQL2025-10-06
DBSCAN Algorithm in SQL Server TSQL2025-09-19
K-Means Clustering in SQL Server Artificial Intelligence2025-09-05
Modernizing Strategic Planning using StratML in SQL Server Business Intelligence2025-08-14
Microsoft Python Driver for SQL Server Python2025-08-01
Graph Minimum Spanning Tree (MST) in SQL Server TSQL2025-06-23
Using local Large Language Model OLLAMA with SQL Server Artificial Intelligence2025-05-07
SQL Matrix Calculator and Operations Toolkit TSQL2025-04-09
Calculating Matrix Inverse in SQL Server TSQL2025-04-02
Gauss-Seidel Method SQL Function to Solve Linear Equations Functions User Defined UDF2025-03-10
Lagrange Interpolation Function for SQL Server Functions User Defined UDF2025-03-04
Basic Regex Emulator for SQL Server Functions User Defined UDF2025-02-25
Regression Analysis in SQL TSQL2025-02-06
Calculate Distance Between Two Points with SQL TSQL2025-01-27
Database Version Control with Git in Azure DevOps DevOps2025-01-24
How to Find Outliers in SQL Server TSQL2025-01-10
Import PDF into SQL Server Import and Export2024-12-04
Display SSRS Report in .NET Core Application Reporting Services Development2024-11-05
Capture SQL Server Database Object Changes Comparison Data and Objects2024-10-14
Auto Generate SQL Variable Syntax for Table Column Names TSQL2024-09-16
Working with XML data in SQL Server XML2024-09-10
Excel as Front End Application for SQL Server Microsoft Excel Integration2024-08-12
Building an Enterprise Resource Planning (ERP) Database System Database Design2024-08-07
Express a Number or Currency in Words with T-SQL Code TSQL2024-07-16
Create Document Templates in a SQL Server Database Table TSQL2024-07-08
SQL Stored Procedure for all CRUD Operations and Change Tracking Stored Procedures2024-06-04