But the Database Worked in Development! Checking for Duplicates
As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.
Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes
An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.
Memory-Optimized TempDB Metadata in SQL Server 2019
For as long as I have worked with SQL Server, and on almost every system I've ever managed, tempdb has been a bottleneck in one way or another.
Introduction to Indexed Views in SQL Server
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
Configure SQL Server Transparent Data Encryption with PowerShell
In this article Filip Holub looks at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
Deployment Suite for Oracle: What’s New?
Stephanie Herr describes the new features in the Deployment Suite for Oracle that will help you automate your database releases safely, on Linux or Windows.
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers