(Ben Snaidero) In my never ending quest of improving SQL Server database performance I often think about how foreign key constraints can slow down insert performance. While everyone understands why foreign key constraints are required, to protect referential integrity, what if there was some other

(Pinal Dave) Recently I was working with a client on Comprehensive Database Performance Health Check and we discovered that they are struggling with Memory issues. During the health check, we reached the point where we needed a investigate the data in memory for a single database.

(Sergey Gigoyan) In the previous articles, we have learned how to create, configure and use SQL Server Maintenance Plans. Sometimes, it is needed to move these plans from one environment to another.

(Kenneth Fisher) The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you the man is amazing. In a very brief exchange where he tossed a few T-SQL scripts at me, my brain hurt and I learned some really interesting stuff.

(Pinal Dave) One of my clients of Comprehensive Database Performance Health Check recently asked me if there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show in the report. Let us see how we can fix that.

(Aveek Das) In this article, I am going to explain how to use the Power BI REST API to programmatically access the Power BI Service features. I’ll also discuss the basis of REST API and how to use the APIs using Postman.

(James Serra) I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob storage. Now there are more new features for blog storage that I will talk about.

(Jeremy Kadlec) In my T-SQL code, I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing.

(Chris Webb) In the April release of Power BI Desktop the Power Query Query Diagnostics feature was enhanced so that you can now return performance counter data. As the blog post says:

(Pinal Dave) Working with SQL Server has been always an interesting experience and every single day, I learn something new. Recently one of my clients of Comprehensive Database Performance Health Check, asked me if I have a script for validating natural integer.