In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.

Looking Forward to SQL Server vNext

by Kathi Kellenberger

SQLServerCentral

Database Weekly

Releases of on-premises SQL Server arrived quite rapidly for a few years with seven releases during the years spanning 2008 and 2019. While it has technically been less than two years since SQL Server 2019 reached general availability in November 2019, it feels like ages since we have heard any news about what’s coming next. […]

Office FOMO

by Steve Jones

SQLServerCentral

Work environment

There are many things we may miss about the office, but one of them is the chance to interact with and impress management.

Soft Skills: Controlling your career

by David Poole

SQLServerCentral

Career Growth

Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]

Learn basics of Data Wrangling in SQL Server to handle Invalid Values

by Additional Articles

MSSQLTips.com

data cleansing

In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.

Dynamically Add a Timestamp To Files in Azure Data Factory

by diponkar.paul

SQLServerCentral

This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]