The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Sometimes the problems aren't your code. Here a few places where re-examining your assumptions can help improve software development.
2026-04-06
2,560 reads
Articles
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
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
5,845 reads
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
6,496 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,918 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
Using PostgreSQL as a NoSQL Store and a Search Engine
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,025 reads
What’s New in SSIS 2025?
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
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Alamat BCA KCU DIPONEGORO 082225313145??WA CS
WhatsApp 082225313145 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers