Perhaps we ought to have some assistants that help users run queries.

T-SQL Decommenter Part III

by Toby Ovod-Everett

SQLServerCentral.com

T-SQL

Detailed explanation of the recursive section of the T-SQL Decommenter.

Installing SQL Server 2019 CTP 2.0

by Additional Articles

Database Journal

SQL Server 2019

Greg Larsen offers detailed instructions on how to install SQL Server 2019 CTP 2.0.

Break Problems Down

by Steve Jones

SQLServerCentral.com

Editorial

Learning to methodically attack problems is a skill we all need to learn.

PASS Summit 2018 Recap

by Kathi Kellenberger

SQLServerCentral.com

Editorial

This year, PASS celebrated the 20th PASS Summit. As it has been many times, this year’s Summit was held in Seattle. PASS Summit has visited other locations such as Orlando and Charlotte, but, at least to me, it feels like home when it’s hosted in Seattle. For those of us who have participated for many […]

Recursive CTE calculations

by Huub Loete

SQLServerCentral.com

Recursive CTE

Reusing the previous value of a recursive CTE to construct the new value

What Is SQLPSX?

by Additional Articles

SimpleTalk

PowerShell

SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.