Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
2026-04-03
2,257 reads
Articles
IDENTITY vs SEQUENCE in SQL Server – which should you use?
This guide explains how IDENTITY columns and SEQUENCE objects differ in SQL Server, and how you might decide which one is appropriate for a given design.
2026-04-03
The Grafana Alternative to SSRS and Power BI
Learn how you can use Grafana natively inside SQL Server Reporting Services.
2026-04-01
5,461 reads
How to migrate from on-prem to the cloud: uncovering legacy system ‘skeletons’
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.
2026-04-01
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Learn about the new JSON_OBJECTAGG function in SQL Server 2025.
2026-03-30
2,243 reads
SQL Server Data Warehouse Concepts, Schema Design, and Implementation
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.
2026-03-30
SQL Server 2016 Build List
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2026-03-27 (first published: 2017-01-25)
41,603 reads
2026-03-27 (first published: 2018-12-18)
9,567 reads
2026-03-27 (first published: 2018-12-20)
13,616 reads
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2026-03-27 (first published: 2022-09-01)
4,879 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
How Accounting Assignment Help Improved My Academic Performance
I recently used accounting assignment help, and it made a huge difference in my...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers