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,380 reads
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
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,542 reads
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,312 reads
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
135 reads
2025-11-25 (first published: 2025-04-16)
1,522 reads
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,480 reads
Learn about filtered indexes in SQL Server, how they work, and how they can help improve performance.
2025-11-24
3,541 reads
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2025-11-24 (first published: 2017-01-25)
41,119 reads
2025-11-24 (first published: 2018-12-18)
9,352 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers