(Pinal Dave) After reading my yesterday’s blog post on Azure Data Studio- Export Any SQL SERVER Query As JSON, I got a question from my regular client of Comprehensive Database Performance Health Check. The question was about is there any way we can see SQL Server Execution Plan in Azure Data Studio
Tag: sql server
Error Message: The RPC server is unavailable during SQL Setup
(Jack Vamvas) Question: I have received a server from the server build team and I’ve started a Server set up. During the set up process , I’m getting an error message
SQL Server Concepts
(Jeremy Kadlec) Every industry has it – jargon. As a professional new to SQL Server, I am interested in learning about SQL Server terminology, what it all means and how I can learn more.
I created a table and SQL created a schema and a user.
(Kenneth Fisher) Demo first and then I’ll explain what happened.
Interpreting execution plans of T-SQL queries
(Esat Erkec) In this article, we will analyze a simple T-SQL query execution plan with different aspects. This will help us to improve our practical skills instead of discussing theoretical knowledge.
Azure Data Studio- Export Any SQL SERVER Query As JSON
(Pinal Dave) In the industry, I see that Azure Data Studio (ADS) is getting adopted along with SQL Server Management Studio (SSMS). I will still say that ADS is not the replacement of SSMS and for the near future it seems that they will co-exist. Recently, one of my clients’ Comprehensive Database P
Running SQL Server in Google Cloud Platform
(Daniel Janik) On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows Phone of cloud providers” and what I meant by that is they have a great product that little market share when compared to Azure and AWS; but, should you be looking at GCP?
Set Statistics Time Examples for Tuning SQL Server Queries
(Rick Dobson) Please provide examples using the set statistics time statement for tuning queries. In addition to a review of the set statistics time statement, present a general framework for assessing the parse, compile, and execution times of any query.
Combining DMVs, Query Store and Extended Events Is Challenging
(Grant Fritchey) I was recently asked a question on a forum by a person who was frustrated with all the tool choices we have for measuring performance.
Loading and Managing Data within Microsoft Power BI
(Ben Richardson) This article will cover off importing data, manipulating data, and finally managing relationships within Power BI.