SQL Server Central is expanding with AI Database Central next week.

The Grafana Alternative to SSRS and Power BI

by Steve Jones

SQLServerCentral

humor

Learn how you can use Grafana natively inside SQL Server Reporting Services.

How to migrate from on-prem to the cloud: uncovering legacy system ‘skeletons’

by Additional Articles

SimpleTalk

Cloud Computing

In this article, Pat Wright explains how to identify hidden risks in legacy applications before moving to the cloud. It features practical advice and guidance to avoid migration failures and surprises.

Prompt Requests

by Steve Jones

SQLServerCentral

Should we have prompts in PRs rather than code?

T-SQL in SQL Server 2025: JSON_OBJECTAGG

by Steve Jones

SQLServerCentral

Learn about the new JSON_OBJECTAGG function in SQL Server 2025.

SQL Server Data Warehouse Concepts, Schema Design, and Implementation

by Additional Articles

MSSQLTips.com

Companies generate a huge amount of data on a daily basis from such things as sales transactions, inventory changes, and customer interactions. This data originates from different data sources and is stored in operational databases called OLTP (Online Transaction Processing) systems that primary focuses on transactions like data inserts, updates or deletes. Maintaining the transactional data in an OLTP database is important. However, if you need to analyze or report on the data, storing the data in a centralized repository in well-structured schema is necessary.