services method stories book a call emergency contact 🌐 Italiano
// Microsoft SQL Server Β· since 1998

Databases that perform.
Expertise you can measure.

Specialist SQL Server consulting for companies with mission-critical data β€” Finance, Insurance, Large Retail, Electronics, Logistics and Sports Retail. Senior DBAs, performance audits, HA/DR architecture and NIS2 security.

From 6.5 to 2025
25+ years of experience
6 industry verticals
on-prem Β· Azure SQL Β· SQL MI
emergency response in 2h
// what we do

Rapid Response

When something breaks, or when something can work much better: focused, well-defined interventions with measurable results.

Troubleshooting

An SSIS job that used to run and now fails, sudden timeouts, errors, procedures that break? We start from the symptom and find the root cause β€” data, configuration, permissions, resources, locking or code. Focused diagnosis across the whole SQL Server stack, not just queries.

Performance Tuning & Optimization (PTO)

Making the system fast and efficient, with or without an active problem. Wait stats analysis, index review, query and configuration tuning. From "it works" to "it flies", with measurable results in days, not weeks.

Security & Compliance

NIS2 Article 21 audits, instance hardening, permission management, encryption and vulnerability assessment. Executive reports and remediation plans.

// beyond the intervention

More than Rapid Response

One-off interventions are our calling card. But with many clients the relationship runs deeper: we support them over time and deliver projects that put data where it belongs.

// ongoing service

DBA as a Service

Your senior DBA team, without hiring one. Ongoing management of the data platform, side-by-side work with internal teams, proactive monitoring, governance and evolutionary maintenance. On a retainer or pay-as-you-go, on-prem and cloud β€” with the flexibility to scale when needed.

// projects

Architecture, HA/DR & Migrations

Design and evolution of the data architecture, High Availability and Disaster Recovery for operational continuity. Migrations and upgrades to new SQL Server versions and to the Microsoft cloud β€” Azure SQL, Managed Instance and SQL Server on Azure VMs. Minimal downtime, zero data loss.

// projects

Business Intelligence & DWH

Design of data warehouses and Business Intelligence solutions: data modeling, ETL flows with SSIS, analysis with SSAS and reporting with SSRS, Power BI and Microsoft Fabric. From raw data to business insight.

// real cases

Success stories

Concrete projects on critical environments, where the result is measured in numbers. The first three come from the journey that led to SQL Advisory; clients are anonymized for confidentiality.

01
Insurance

Solvency II: a regulatory process under control

An entirely manual IVASS reporting process, hanging on two technicians on their way out. We turned it into an automated pipeline that validates data at the source and runs itself.

Continuityzero know-how lost read the case
02
Logistics

SQL Server 2016 → 2022 migration on a 24/7 environment

A business-critical high-availability environment to migrate without stopping the business. New environment in parallel, controlled failover, old system as a safety net until the very last moment.

2 secondsof downtime read the case
03
Manufacturing · Tires

Multi-country data distribution for BI

Hundreds of processes duplicated country by country, a ten-hour run at risk of overrunning. Rebuilt at the root: a single read that distributes to every country in one pass.

10h → 8minoverall process read the case
04
Our method

Before the cure, the blood tests

No intervention without diagnosis. A systematic technical assessment of the SQL Server environment β€” at instance level and for every database β€” before proposing any solution.

Assessmentthe starting point learn how
01
Insurance

Solvency II: automating a critical regulatory process

The context

At a leading insurance company, the entire Solvency II process was handled by two technicians who were leaving the company. The process was almost entirely manual: the offices involved uploaded their files to a portal, and two people ran the data checks and launched the processing by hand.

The problem

Data errors surfaced late, deep into processing: each error meant going back, wiping out the work done and starting over. Solvency II reporting has very tight submission windows to IVASS β€” a few weeks, with the year-end double close multiplying the pressure. All the know-how lived in the heads of two people on their way out.

The approach

We redesigned the process into an automated pipeline governed by the database: a state-machine orchestration managing dependencies and phases across offices, unlocking them automatically and notifying who can proceed; automated data validation at the source, catching errors at upload β€” pinpointing field and row and routing them back to the responsible office β€” and adapting to regulatory changes; processing that starts on its own once all data is validated, through to the files for the regulator.

The result

Errors blocked at the source instead of discovered downstream, no manual rework eating up the days, and critical know-how secured in the system rather than in people. The two technicians left without any loss of continuity, and the close β€” once a source of intense stress β€” became a controlled, predictable process.

02
Logistics

SQL Server 2016 → 2022 migration with 2 seconds of downtime

The context

A logistics operator with a business-critical environment running 24/7, on an AlwaysOn Availability Groups architecture: two synchronous nodes in high availability plus one asynchronous node in disaster recovery at a remote site. To migrate from SQL Server 2016 to SQL Server 2022.

The problem

In logistics, a system outage halts real physical operations β€” goods, shipments, flows. Tolerable downtime was close to zero. And an in-place upgrade on an environment like this is risky: if something goes wrong you end up stranded midstream, with production already compromised and no simple way back.

The approach

Rather than upgrading the existing machines, we built a new environment in parallel with the same topology, so production stayed intact as a safety net until the last moment. The new nodes were added to the existing Availability Group as synchronous replicas: data aligned in real time. At cutover, a failover moved the primary role to the new environment. Because the replicas belonged to the same Availability Group, the entry point stayed unchanged: no changes to connections, no DNS work. The whole migration was completed in a few days; the 2016 nodes were removed only after sync was confirmed.

The result

Migration completed with about two seconds of downtime β€” the failover time β€” with no data loss and without touching any connected application. For the operators it was effectively transparent. The environment now runs on a modern, fully supported version, with the same resilience architecture as before.

SQL Server 2016 left Microsoft extended support on 14 July 2026: this is exactly the migration many companies must face right now β€” and it can be done without stopping the business.

03
Manufacturing · Tires

Multi-country data distribution: from 10 hours to 8 minutes

The context

A tire-manufacturing company with a presence in about 15 countries. A central database had to feed the reporting and BI tables for each individual country.

The problem

The process took around ten hours and risked missing its window. Under the hood, the same flow had been duplicated for every country β€” in the order of hundreds of processes to maintain β€” and the read logic piled up costly, redundant operations to compensate downstream for problems that arose further upstream. Each new country made things progressively worse.

The approach

We rebuilt the logic at the root instead of optimizing symptoms. Data is consolidated and cleaned once, upstream, and materialized into ready tables; a single structure, with country as an attribute, replaces the dozens of filtered views. One flow reads the data once and distributes it to all countries in a single pass. Which countries to process is governed by a simple configuration table, editable without touching a line of code.

The result

The overall process went from around ten hours to seven-eight minutes, and the number of processes to maintain collapsed from hundreds to a few dozen. Adding a new country became trivial. A case where the gain comes not from more compute power, but from fixing the design at the root.

04
Our method

Before the cure, the blood tests

The starting point

When a new client reaches out, we don't start with the cure, but with the diagnosis. Before acting on any system, we run a technical assessment of the SQL Server environment. It's the blood-test principle: you don't prescribe a therapy without first measuring the patient's actual state.

How it works

The assessment is systematic and repeatable. An automated data collection analyzes the environment both at instance level and for every single database, producing a report that highlights the critical points. The method combines diagnostic practices recognized as a reference in the SQL Server community with tools and evaluation thresholds matured through our direct experience.

From diagnosis to plan

We share and explain the results. In many cases, simply correcting the configuration yields significant performance gains, with no new hardware. In fact, quite often environments that seemed to need more power turn out to be misconfigured, and once fixed they free up resources thought to be saturated β€” for SQL Server environments, especially Enterprise edition where licenses follow the cores, this can translate into far-from-negligible license savings. From there, a two-tier remediation plan: "hot" interventions with no restart, and "cold" interventions planned with the client.

Beyond the intervention

The assessment is the foundation of what follows: we analyze the databases, propose a treatment plan and put a monitoring plan in place. Monitoring plays a double role: it compares the state before and after the interventions, proving the improvement with hard data, and it keeps watch over time β€” because a database rarely breaks suddenly: it degrades. The assessment brings to light what lies beneath the surface; monitoring proves the interventions worked and keeps the degradation from starting again.

// industries

Verticals we work in

Every industry has its own specifics β€” volumes, SLAs, regulations, workload patterns. We work with companies whose data is complex and whose downtime is not an option.

Finance & Banking
Insurance
Large Retail & Grocery
Electronics & Manufacturing
Logistics & Supply Chain
Sports Retail
// how we work

A proven method

Every engagement follows four precise phases. No improvisation: 25+ years of experience on critical instances.

01.

Listen

Gathering context, perceived pain points and business goals.

02.

Diagnose

DMV analysis, configuration review, root-cause identification.

03.

Fix

Agreed execution: fixes, optimizations, hardening or refactoring.

04.

Report

Executive summary for management, T-SQL and technical docs for the team.

// references

Companies that already trust us

Clients with mission-critical SQL Server estates across six industry verticals.

Finance Β· Insurance

"Outstanding technical expertise and a professional approach. A solid reference point for our SQL Server platform."

Insurance

"Timely interventions, clear documentation. Solved in hours problems we'd had for months."

Logistics Β· Supply Chain

"A reliable partner for our SQL infrastructure. Always available and straight to the point."

// emergency Β· pay by card

Immediate intervention

SQL Server down, blocked queries, production at a standstill. Buy the package online, we connect within 2 business hours. Minimum 4h β€” anything less isn't enough to even understand the problem.

Emergency Base
4 hours
// single block Β· non-divisible
€1,200 + VAT where applicable
// €300/h
  • Response within 2 business hours
  • Diagnosis + documented fix
  • Final technical report
  • On-prem Β· Azure SQL Β· SQL MI
Crisis Cover
16 hours
// 2 full days Β· usable within 30 days
€4,000 + VAT where applicable
// €250/h Β· prepaid hours bundle
  • Response within 2 business hours
  • Hours usable in 4h blocks
  • Diagnosis + fix + optimization
  • Full report after every session
  • On-prem Β· Azure SQL Β· SQL MI
Service window
Mon–Fri Β· 9:00–22:00 CET

If the engagement starts within this window, we respond within 2 business hours and stay on the problem until the system is stabilized β€” beyond office hours if needed: we don't walk away in the middle of an incident. Incidents opened outside the window (night, weekends, holidays): best-effort handling, at a rate to be agreed.

The time shown is our CET service window converted to your local time β€” not a local-hours window β€” and it accounts for daylight saving automatically. It's detected from your device's clock (a VPN won't change it). Where the window falls at night for you, incidents are still covered best-effort, at a rate to be agreed.

Best-efforts obligation. The intervention applies expertise and diligence to diagnose and stabilize the system (restore operations); it does not guarantee a specific outcome: full data recovery depends on the availability and integrity of the client's backups. Any hours beyond the initial block are agreed during the intervention. Full service terms β†’

On-demand hourly rate

For planned interventions, mentoring, reviews or training. Minimum 4h. Online card payment, immediate invoice.

4
€900 + VAT where applicable

This pre-paid time can be used for both online and offline assistance, billed in 30-minute increments, with the following minimums: conference calls minimum 1 hour; offline assistance (e.g. email) minimum 30 minutes. Pre-paid time is valid for 12 months from the date of purchase.

πŸ”’ Secure payment via Stripe Β· Visa Β· Mastercard Β· Amex Β· electronic invoice
// about

A young company, expertise that goes back a long way

SQL Advisory is a new venture, founded to give structure to expertise built over more than 25 years on the Microsoft data platform.

Luca Bovo

// Founder Β· SQL Advisory S.r.l.

Data Platform Architect and DBA working on Microsoft SQL Server since 1998 β€” back to version 6.5 β€” with a demonstrated history in the information technology and services industry. Skilled across the SQL Server environment (Engine, SSRS, SSIS, SSAS, Power BI, SQL Azure IaaS and PaaS), with a focus on SQL Server configuration, database modeling and design, performance tuning and optimization. He also serves as Team Leader on DWH and BI projects for insurance companies and banking groups.

SQL Server Engine SSIS Β· SSRS Β· SSAS Power BI Azure SQL Β· IaaS & PaaS DWH & BI Performance Tuning
// our network of senior collaborators
Alessandro Piccinno
// SQL Server Database Administrator & Developer

He focuses primarily on the analysis, maintenance and performance tuning of data objects and flows in Microsoft SQL Server environments: refactoring stored procedures and T-SQL functions to cut execution time and computational load, optimizing complex views through calculation-logic review and strategic indexing, improving SSIS package performance across data flows and transformations, and analysing bottlenecks with profiling, execution plans and DMVs. The goal is to maximize data-system performance, increasing reliability and reducing operating costs.

SQL Server Engine T-SQL & Stored Procedures Performance Tuning SSIS Query Optimization
Marcelo Cesar Augusto Romeo
// SQL Server Database Administrator & Developer

With 15+ years of experience, he is exclusively focused on Microsoft SQL Server. He collaborates effectively with colleagues, creating the chemistry a team needs to perform at the top level. He approaches every new challenge with a can-do attitude, putting concrete initiatives on the table to help the team overcome it.

SQL Server Engine HA/DR Monitoring Performance Tuning
Mattia Cavallotti
// Microsoft Azure Architect Β· Business Intelligence

Microsoft-certified Azure Solutions Architect with deep knowledge of Microsoft cloud services: networking, virtualization, identity and security, HA/DR and data platforms. He holds a Master's degree in quantitative finance with a strong focus on statistics and programming. In 2021 he founded Datasoluzioni, where he works as a data professional and architect specialized in Microsoft Azure solutions and hybrid-cloud infrastructures for data management and analytics: Azure architectural setup, migrations, system integration in hybrid environments, and development on SQL Server and Azure SQL for data engineering and business intelligence. He is also experienced in Azure DevOps for infrastructure-as-code deployments and Git/TFS project management.

Azure Architect SQL Server Engine HA/DR Azure Migrations Azure DevOps Business Intelligence
// book

Let's talk first

All calls are remote. Pick a format, find an open slot on the calendar, receive the video call link.

// 30 min Β· free

Discovery Call

First conversation: you describe the situation, we figure out if and how we can help. No commitment, no automatic quote.

// 60 min Β· €250 + VAT where applicable

Technical Assessment

For those who already know what they need: we analyse a specific problem, a critical instance or a project to plan. Summary report included.

// contact

Get in touch

SQL Advisory S.r.l.

Corso Vittorio Emanuele II 162
10138 Turin, Italy
VAT IT13452960019

info@sqladvisory.com
www.sqladvisory.com