(Koen Verbeeck) This tip covers a new Reporting Services 2016 feature: exporting reports to PowerPoint.

(Kenneth Fisher) T-SQL Tuesday It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited us to talk about Text. Text.

(Chris Webb) When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you reference column values dynamically?

(Pinal Dave) ApexSQL Generate is a test data generation tool for SQL Server. In this article, we’ll introduce the tools’ core features, describe the main types of generators, walk you through an example and, finally, cover some advanced features.

(Steve Hood) Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it happened to me. Unfortunately for me, that was before I was a proponent of tracing or using XEvents to watch for recompiles.

(Manoj Pandey) Niladic functions are functions that do not accept any parameters, are specified without parentheses, and return only one result.

(Scott Mattie) Recently, I had an issue where I installed SQL server with the default users to start the services. Later when I tried to change the service accounts to my active directory accounts, I got the following error message when trying to open SQL Server Configuration Manager.

(Dennes Torres) A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of providing an effective date dimension to a cube.

(Pinal Dave) Getting back to consulting mode has got my newer clients and bigger challenges. Not only that I am seeing interests for some of the greatest and latest versions, but some clients are sitting on an older version of SQL Server requiring some serious help for trivial issues.

(Scott Murray) How do I pin a SQL Server Reporting Services (SSRS) report to Power BI Dashboards?