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.
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.
This Week's AI Trust Problem Became Everyone’s Problem
There’s a saying in security circles: the weakest link isn’t the lock on the front door but the spare key under the mat. This past week gave us two vivid, simultaneous demonstrations of that principle, and if you’re building anything in the AI space right now, both deserve your full attention. The Mythos Leak and […]
A Double Failure
A company has both a server without a password and live data in test environments. Not a good situation.
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
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.
The Grafana Alternative to SSRS and Power BI
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’
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.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers