(Pinal Dave) Today’s blog post is based on a very interesting observation sent to my client of the Comprehensive Database Performance Health Check. While I primarily focus on improving the performance of SQL Server, often I receive question-related to T-SQL and I enjoy answering them.

(Sergey Gigoyan) After installing SQL Server 2017 or SQL Server 2016, a user tries to connect to SQL Server Integration Services (SSIS) for the first-time using SQL Server Management Studio (SSMS), most likely the connection attempt will fail. The received error message indicates: Failed to retriev

(Pinal Dave) Today is the first day of the year 2020 and I would like to share an interesting conversation that I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.

(Grant Fritchey) If you go through all the stuff I’ve written about Extended Events, you’ll find that I use causality tracking quite a bit.

(Greg Larsen) When you turn on Transparent Data Encryption (TDE), the SQL Server database engine asynchronously starts encrypting data pages.

(Koen Verbeeck) I’m orchestrating a data pipeline using Azure Data Factory. One of the activities the pipeline needs to execute is loading data into the Snowflake cloud data warehouse. Since Azure Data Factory currently doesn’t support a native connection to Snowflake, I’m thinking about using an Az

(Chris Webb) Following on from the series of posts I wrote last month (starting here) about testing the performance of Power BI reports in the browser, I would now like to highlight one possible cause of slow report rendering performance: the over-use of custom visuals.

(Allan Hirt) I’ve been hearing more and more from people I know as well as news stories that security is on people’s minds in one way or another. It’s a fundamental IT tenet that security should be a priority.

(Pinal Dave) Today is the last blog post of the year 2019 and this is also a final blog post in the series of Parameter Sniffing which I have been writing. I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.

(blobeater) This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error.