How to determine the last value used by a sequence in SQL Server
I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to that, developers had a choice of IDENTITY columns or a roll-your-own table mechanism.
2026-04-06
I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to that, developers had a choice of IDENTITY columns or a roll-your-own table mechanism.
2026-04-06
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
2026-04-03
6,774 reads
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
Learn how you can use Grafana natively inside SQL Server Reporting Services.
2026-04-01
6,606 reads
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
Learn about the new JSON_OBJECTAGG function in SQL Server 2025.
2026-03-30
3,049 reads
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
Introduction We mostly get inclined to use/introduce MongoDB for JSON storing/processing in our database system and Elasticsearch for searching operations in JSON data. However, what we often tend to overlook is that in reality, PostgreSQL can actually act as both NoSQL store and a powerful search engine too. It also comes with ACID guarantees, transactions, […]
2026-03-27
2,242 reads
There’s a new version of SQL Server released and we’re mainly an on-premises SQL Server shop. We’ve been using Integration Services (SSIS) for years now for all our ETL and data integration needs. With Microsoft’s focus on cloud (Azure and Fabric), does it make sense to upgrade our SSIS packages? Are there any new features?
2026-03-27
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,731 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers