Why SQL Server Database Attach fails and how to repair it
This article covers a few common errors when attaching database files to an instance, with some information on how to resolve the issues.
Big data: what it is, why projects fail, and how to get value from it
Although ‘Big Data’ (and more specifically, the analysis of it) offers several benefits, organizations often fail to derive the correct insights – the data that could help them make better business decisions. So, in this article, I’ll reveal exactly how organizations can take full advantage of these large datasets to make those better business decisions and improve operational effectiveness.
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
Time Series Data Mining Example with T-SQL when Adding New Data
Please demonstrate the steps for updating an existing time series dataset used in a prior data mining project with a fresh batch of data. Then, repeat the mining performed for the original dataset with the freshly updated dataset.
CROSS APPLY Fundamentals: Part 1
Learn the basics of the CROSS APPLY operator with a few examples in this short piece.
Make It Routine
One of the goals of software is to use the power of the computer to handle repeatable tasks. Steve notes that this can be hard at first, but the goal is that subsequent efforts become routine.
5 T-SQL features that should already exist (2026 SQL Server wish list)
2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage
AI Observability Challenges in FinOps as a DBA
I was performing research for requested AI work and noticed that I was viewing the risks from a database perspective. As the saying goes in the tech industry, “Once a DBA always a DBA…” As foreign as some of the views were, much of it feels familiar and I simply begin to look at it […]
Another Model, More Data Loss
More issues with the newest GPT-5.6 model, including data loss incidents.
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers