Articles
T-SQL in SQL Server 2025: The PRODUCT Function
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]
2025-11-28
4,769 reads
How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.
2025-11-26
1,117 reads
Identify Unused Tables in SQL Server and Azure SQL
This article presents a way to discover those tables that are unused over a period of time, along with suggestions on how to get rid of these tables.
2025-11-26(first published:2025-10-15)
14,106 reads
SQL Declare Variable Code Examples
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
Fixing "Login failed for user" error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2025-11-25(first published:2020-11-24)
51,326 reads
PowerShell Day By Day: The Pipeline
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2025-11-25(first published:2020-12-31)
4,279 reads
Steps for Installing AlwaysOn Availability Groups - SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
2025-11-25
43 reads
2025-11-25(first published:2025-04-16)
1,468 reads
The OUTPUT Clause for INSERT and DELETE Statements
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
2025-11-25(first published:2017-05-25)
302,021 reads
Blogs
SQL Training Black Friday Deals
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
BySQLPals
Dry-run xp_delete_file Before Actually Deleting Files?xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
FinOps - the new name for performance tuning
Comments posted to this topic are about the item FinOps - the new name...
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers[8]ページ先頭