(Kenneth Fisher) CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t overly well known is that you can actually update the data within the CTE.

(Koen Verbeeck) We just started using Analysis Services 2016 and we have created a Tabular model. One of the new features is the ability to add translations for the different metadata objects, however this requires editing some JSON file. Is there an easier way?

(Jason Brimhall) An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change.

(Arun Sirpal) Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for both the data and log file. I wanted to know who caused the tempdb growth, when it was done, what the T-SQL was and what sizes were involved.

(Norm Eberly) My colleague Sean Gallardy and I were asked about the process for enabling encrypted connections for SQL Server as outlined here when using a Group Managed Service Account (gMSA).

(Pinal Dave) As a part of my relationship with existing clients, I provide quick help to them on simple issues. Sometimes it is an interesting issue and I write a blog about it as well. Let us learn the error related to SaveToSQLServer.

(Pinal Dave) In this blog post we will discuss how to Enable Backup Compression on by default.

(Kenneth Fisher) Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table is a combination of auditing columns (createdate) and a history table.

(Denny Cherry) I found the above instructions on a blog post I was trying to use to fix an issue in visual studio recently. (Ignore the fact that I was in Visual Studio and focus on the screenshot.)

(_Jo.Pi_) Recently someone was asking if there is a simple SQL Server solution where you would generate text documents and simply pass them to SQL Server to catalog without writing an application to do this. Also, would like to be able to index and search the context of these documents.