(Koen Verbeeck) I’m able to refresh a Power Dataset in the Power BI service using the Power BI API. The solution is built in an Azure Logic App. However, when the action calls the API, it immediately succeeds without giving an indication if the refresh actually succeeded or not. Is it possible to do

(Pinal Dave) A few days ago, I wrote a blog about log shipping job failure due to missing permission. In this blog, I would share my experience with another log shipping error “Connection Timeout Expired” for which my client contacted me via Comprehensive Database Performance Health Check.

(Greg Gonzalez) Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

(Michael J. Swart) You have excessive WRITELOG waits (or HADR_SYNC_COMMIT waits) and among other things, you want to understand where.

(Fikrat Azizov) In previous posts we discussed a few Azure Data Factory (ADF) activities that have similar functionality to SQL Server Integration Services (SSIS) tasks. However, we also learned that in some cases SSIS components are more powerful and flexible than their ADF counterparts.

(Thomas LaRock) I came across this “Sequence contains no elements” error when using Always Encrypted a while back and wanted to write a quick post. In this case, I was trying to encrypted a computed column.

(Pinal Dave) Even though there are many disaster recovery solutions available in SQL Server as of today, few of my clients Still go with log shipping. In this blog, I would share my learning about one of the errors which I observed with one of my clients.

(Mohammed Moinudheen) I have a number of SQL Server backups stored in Azure blob storage. Is there any way we can ensure that the backup files are not deleted permanently after deleting them from the blob storage container?

(Jason Brimhall) Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a little fun (the kind that would be non-harmful and lacking in mal-intent).

(James Serra) As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage, as it can get a bit confusing with all the options that are available.