Get Free Tips
MSSQLTips.com

Author: Sebastiao Pereira

Home » Archives for Sebastiao Pereira

Sebastião Pereira has over 40 years of experience in database development. Starting 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.

  • MSSQLTips Awards: Trendsetter (25+ tips) - 2025 | Rookie of the Year - 2024

TitleCategoryDate
K-Means Clustering in SQL ServerArtificial Intelligence2025-09-05
Modernizing Strategic Planning using StratML in SQL ServerBusiness Intelligence2025-08-14
Microsoft Python Driver for SQL ServerPython2025-08-01
SQL Server 2025 Vector SearchSQL Server 20252025-07-25
Fuzzy String Matching Algorithms in SQL ServerTSQL2025-07-14
Graph Minimum Spanning Tree (MST) in SQL ServerTSQL2025-06-23
Neural Network in SQL ServerArtificial Intelligence2025-06-05
Graph Theory – Shortest Path AlgorithmsTSQL2025-05-19
Using local Large Language Model OLLAMA with SQL ServerArtificial Intelligence2025-05-07
SQL Matrix Calculator and Operations ToolkitTSQL2025-04-09
Calculating Matrix Inverse in SQL ServerTSQL2025-04-02
Gauss-Seidel Method SQL Function to Solve Linear EquationsFunctions User Defined UDF2025-03-10
Lagrange Interpolation Function for SQL ServerFunctions User Defined UDF2025-03-04
Basic Regex Emulator for SQL ServerFunctions User Defined UDF2025-02-25
Regression Analysis in SQLTSQL2025-02-06
Calculate Distance Between Two Points with SQLTSQL2025-01-27
Database Version Control with Git in Azure DevOpsDevOps2025-01-24
How to Find Outliers in SQL ServerTSQL2025-01-10
Import PDF into SQL ServerImport and Export2024-12-04
Display SSRS Report in .NET Core ApplicationReporting Services Development2024-11-05
Capture SQL Server Database Object ChangesComparison Data and Objects2024-10-14
Auto Generate SQL Variable Syntax for Table Column NamesTSQL2024-09-16
Working with XML data in SQL ServerXML2024-09-10
Excel as Front End Application for SQL ServerMicrosoft Excel Integration2024-08-12
Building an Enterprise Resource Planning (ERP) Database SystemDatabase Design2024-08-07
Express a Number or Currency in Words with T-SQL CodeTSQL2024-07-16
Create Document Templates in a SQL Server Database TableTSQL2024-07-08
SQL Stored Procedure for all CRUD Operations and Change TrackingStored Procedures2024-06-04

Categories

Recent Articles

  • Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions

  • State of the DBA in 2025

  • Natural Language Query for SQL Server

  • Building a Dynamic Countdown Timer in Power BI

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide