AI Baseline Analyzer 1.0

Here is a lifelong pain point of my job.

Every time I was asked to analyze and resolve a performance issue with a database, I started with little to no information about what in fact is considered as "acceptable performance". When speaking of performance, you basically tend to balance between budget and service response time. But who is actually able to tell what normal looks like, or where do I get the expected perception of system behavior.

I had to dig every piece of information on my own and get the picture as fast as possible which caused significant amount of effort and took most of the valuable time. ...

Case Study: A 250 TB SQL data warehouse for production line archive, part I.

Overview

This technical case study explores the implementation of partitioned views in Microsoft SQL Server to improve scalability, performance, and manageability of large datasets. By distributing data across multiple tables while presenting them as a single logical view, partitioned views provide an efficient approach for handling growing transactional workloads and optimizing query execution. The study examines the architecture, design considerations, implementation process, and performance impact of partitioned views within a SQL Server environment, highlighting practical benefits and common challenges encountered in enterprise database systems.

The goal

A production facility operating SMT (Surface Mount Technology) is evaluating options to keep history of the items produced for quality assurance. ...

WELCOME

Congratulations! You have reached my services web page - the first step to a secure, reliable and fast SQL database.

About me

My name is Jozef Bača. I am a certified data professional with 20+ years hands-on experience in IT infrastructure. From managing operating systems, storage arrays, backups, SAN networks to databases, I am now specializing in SQL Server, Azure SQL and AI Solutions Architecture. ...