(John Miner) The adoption of Power BI desktop and Power BI service has been gaining movement ever since it was released five years ago. Power Query is used to import/transform the data into the model and Power View is used to visualize the data in reports.

(Jack Vamvas) Question: When attempting to expand the Catalogs in the linked server object defined, I received below message.How can I fix this problem?

(Pinal Dave) Recently, I had a very interesting experience with one of my clients where we observed a large number of VLF files impacting negatively to their performance. We used the in-famous DBCC SHRINKFILE to reduce the VLFs.

(Jignesh Raiyani) Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate.

(Gregory Larsen) Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this as much as I do.

(Daniel Farina) There are often times that you need to stop and start SQL Server services, so in this tip we will look at various methods of doing this.

(Kenneth Fisher) It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to completely miss over time. I was having a random conversation with a friend on Twitter the other day and they mentioned an acronym DIE.

(John Sterrett) The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below.

(Pinal Dave) Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health Check. Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan.

(Alejandro Cobar) As DBAs, we all know how important it is to check all of the SQL Server databases under our care for potential corruption issues.