(Pinal Dave) One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I get to learn every single day something new while working with my client on Comprehensive Database Performance Health Check. Recently I got a very unique situation where I had to Remove All Query Cached
Tag: sql server
Import Databases to Azure SQL Database
(John Sterrett) I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database.
Different Ways to Write a Cursor in SQL Server
(Simon Liew) Can you provide different examples of how a cursor can be written in SQL Server?
Visualising Power BI Premium And Azure Analysis Services Query Parallelism
(Chris Webb) In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful.
Considerations for Deploying Azure SQL Database Managed Instances
(Marcin Policht) Microsoft provides a number of different deployment options for its Azure SQL Database offerings. We have reviewed a number of them on this forum, including the recently introduced Azure SQL Database Serverless.
SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights
(Pinal Dave) As a part of my work, I also provide consultancy to fix the issues. In my recent engagement with a client, they were getting an error while installing SQL Server 2019. In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have ad
Power BI Sharing
(James Serra) There are many ways to share the dashboards, reports, and datasets that you create in Power BI. Below I’ll compare all such options (there are twelve!).
Azure Data Factory Multiple File Load Example – Part 2
(Koen Verbeeck) In this two-part tip, we are created a metadata-driven pipeline which will copy multiple flat files from Azure blob storage to an Azure SQL Database. The flat files can have different delimiters and are stored in different folders and there are multiple destination tables as well.
Extended Events: system_health and a Long Running Query
(Grant Fritchey) Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but, without actually doing any work to capture query metrics?
SQL SERVER – Truncating Data and ANSI_WARNINGS
(Pinal Dave) Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Database Performance Health Check. Let us talk about the topic.