(Pinal Dave) I have been recently writing about Memory Grant Feedback a lot and I have received a lot of questions about it. I have been answering each of them personally but some questions are so good that I feel like answering them on the blog will help more people.
Tag: sql server
Seamless Monitoring and Reporting for SQL Server
(Scott Murray) Fully monitoring your SQL Server and its related environment can be quite a chore. The SolarWinds Server and Application Monitor (also known as SAM) provides a one-stop method to easily and seamlessly implement a top tier monitoring and reporting system for your SQL Servers.
SQL SERVER – Row Mode and Memory Grant Feedback
(Pinal Dave) Earlier this year, I had a great time writing on the Memory Grant Feedback. I have received a lot of questions about this feature and I have tried my best to answer each of them. One of the questions, which really caught my attention did this feature work with Row Mode like it does with
Create a SQL Server Linked Server to Azure SQL Database
(Nisarg Upadhyay) How can I create a linked server between a local SQL Server instance and an Azure SQL Database?
Why Don’t People Use Columnstore Indexes?
(Grant Fritchey) I saw this question on SQL Server Central the other day and had an immediate, visceral reaction. I know why.
Entity Framework Core Disconnected Entities with TrackGraph
(Joydip Kanjilal) The TrackGraph method in Entity Framework Core (EF Core) can be used for handling complex data in disconnected scenarios. This article presents a discussion on how we can work with this method in EF Core.
Azure SQL Database – Automatic Tuning – Have you enabled it?
(blobeater) Do you enable this setting to allow automatic tuning to care of all your performance needs?
Testing Performance Of Power BI Reports In The Browser, Part 2
(Chris Webb) In the first part of this series I talked about why you might want to test the performance of a Power BI report in the browser, as opposed to using Performance Analyzer in Power BI Desktop, and the different factors you have to take into account when doing this kind of testing.
Create an Azure Function to Connect to a Snowflake Database – Part 1
(Pinal Dave) At our company, we use the cloud Snowflake database to host our data warehouse. We are heavily invested in the Azure data platform and we like to create data pipelines in Azure Data Factory. However, it seems there’s no native connector in Data Factory for Snowflake.
Azure Synapse Analytics & Power BI performance
(James Serra) With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very compelling reporting performance options when combined with Power BI.