Automating Your SQL Server Best Practice Reports: The Document
If you're making a report from table-based data, an MS Word document is often a good option. In the second part of his introduction to SQL Server best-practice monitoring, Laerte Junior shows how to use PowerShell scripts to create a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.
SQL Prompt Tips #5 - Current Statement Execution
Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.
Extended Statistics and Oracle 12c
David Fitzjarrell looks at how and why to use a feature called Automatic Column Group Detection to recognize column dependencies and create extended statistics on recognized groups in Oracle 12.1.0.2.
Add Dependencies to a SQL Server Resource in Windows 2003
In this article, see how to add a dependency to a SQL Server Resource in a Windows 2003 cluster.
Do You Have Scary Code?
Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.
Introduction to PolyBase in SQL Server 2016 - Part 1
One of the features introduced in SQL Server 2016 is PolyBase. The goal of PolyBase is to make interacting with unstructured, semi-structured and non-relational data stored in Hadoop as easy as writing Transact-SQL statements. Edwin Sarmiento explains.
A big thank you
Grant Fritchey shows his softer side, extending his appreciation to all DBAs who work tirelessly to keep our software running in the face of adversity.
How to Add a Drive as a Clustered Physical Disk Resource in Windows
This article is covers how to add a drive as a Clustered Physical Disk Resource in Windows 2003.
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers