(Chris Webb) When you’re working with M code in Power BI or Power Query/Get&Transform you may want to include special characters such as carriage returns, line feeds or tabs inside a text value. To do this you’ll need to use character escape sequences inside your text.

(Jason Thomas) Another Friday, another tip. Power BI has undergone a lot of innovative updates over the years, but my favorite one has been a combination of the cross-filtering & highlighting capabilities, multi-selecting across visuals and drilling down filtering other visuals.

(Jack Vamvas) Question: The Statistics tasks in the SQL Server Maintenance plan is getting slower? When I first implemented the task it used to take 1 hr – recently it’s built up 4-5 hrs. I’ve checked underlying resource issues – and everything looks OK.

(Pinal Dave) The increasing size of SQL Server databases, alongside the growing complexity of SQL Server estates, is making more organizations realize the need for a tool that enables proactive monitoring. Let us try to answer a question – What is the ROI of a SQL Server Monitoring Tool?

(Kenneth Fisher) Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it or not) but the techniques are used all through life.

(Mohamed Baioumy) We noticed a few requests come to our support queue asking for a feasibility to export Azure SQL Database to local path directly, so following steps below to build PowerShell script that can do that job to copy Azure SQL Database to another db for consistency, then export Azure SQ

(John Miner) There has been a growing trend in which companies are moving away from on-premises software to the cloud, platform as a service, and other offerings.

(Grant Fritchey) All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

(Rob Farley) I wrote a post recently about DISTINCT and GROUP BY. It was a comparison that showed that GROUP BY is generally a better option than DISTINCT. It’s on a different site, but be sure to come back to sqlperformance.com right after..

(Thomas LaRock) We’ve all been there, sitting in our cubicle, trying to migrate data from one server to another. Most of the time everything works as expected. But sometimes data migrations don’t work at all.