How Microsoft Copilot in Azure Data Studio enables business analysts to query SQL Server databases in plain English — no SQL knowledge required.
Business analysts submit 30-40 ad-hoc data requests per week to the database team. Each request takes 1-3 days to fulfill. Analysts know what data they need but cannot write SQL. The database team is overwhelmed with simple queries that distract from complex development work.
"Show me total sales by product category for Q4 2025, compared to Q4 2024, sorted by biggest growth"
SELECT
p.Category,
SUM(CASE WHEN YEAR(o.OrderDate)=2025 AND DATEPART(q,o.OrderDate)=4
THEN oi.LineTotal ELSE 0 END) AS Q4_2025,
SUM(CASE WHEN YEAR(o.OrderDate)=2024 AND DATEPART(q,o.OrderDate)=4
THEN oi.LineTotal ELSE 0 END) AS Q4_2024,
SUM(CASE WHEN YEAR(o.OrderDate)=2025 AND DATEPART(q,o.OrderDate)=4
THEN oi.LineTotal ELSE 0 END) -
SUM(CASE WHEN YEAR(o.OrderDate)=2024 AND DATEPART(q,o.OrderDate)=4
THEN oi.LineTotal ELSE 0 END) AS YoY_Growth
FROM Orders o
JOIN OrderItems oi ON o.OrderID = oi.OrderID
JOIN Products p ON oi.ProductID = p.ProductID
GROUP BY p.Category
ORDER BY YoY_Growth DESC;
Let's discuss how AI-enhanced SQL Server & T-SQL Development can deliver similar results for your organization.
Start the Conversation