(Chris Webb) A new, as-yet undocumented, M function appeared in the December 2017 release of Power BI Desktop (I assume it will appear in Excel soon): Text.Select. Here’s the documentation from the Query Editor:

(Denny Cherry) There’s a lot of versions of SQL Server available today. I’ve seen clients deploying new services on SQL Server 2015, SQL Server 2016, SQL Server 2017 (yes we have a client on SQL Server 2017 already) and SQL DB. But if you’re deploying a new SQL Server what’s the right version to d

(Michael J. Swart) The Blue-Green technique is a really effective way to update services without requiring downtime. One of the earliest references I could find for the Blue-Green method is in a book called Continuous Delivery by Humble and Farley.

(Pinal Dave) Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have a blog about data-warehouse database WideWorldImportersD

(Viacheslav Maliutin) We created a new SQL Server database for testing with empty tables. When we were doing our testing by just adding a few records we started getting deadlock issues that we didn’t see on the same database that had a lot of data.

(Pinal Dave) One of my clients was performing load tests on timesheet application. They noticed that application jobs are failing with below error message about running a new system task.

(Hannes du Preez) Sometimes you will need to disable an index, albeit temporarily. In order to disable an Index, make use of the following T-SQL Query:

(Jack Vamvas) Question: I’ve read the article How to Export Active Directory Group Members with Powershell Get-ADGroupMember . This article has a script to export the members of the AD group , but it exports the name. I require the DOMAIN_NAMElogin_name information .

(Thomas LaRock) The Data Migration Assistant (DMA) offers you the ability to perform a feature assessment against your SQL Server database. Built as the successor for the SQL Server Upgrade Advisor, the DMA is a valuable tool for migration projects.

(Chandresh Patel) In SQL Server, if we have a transactional based system and find a high WRITELOG wait type this is a performance bottleneck and can cause the transaction log file to grow rapidly and frequently.