(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
Tag: sql server
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.
SQL SERVER – QDS_LOADDB Wait and Asynchronous Load of Query Store
(Pinal Dave) Today I am going to share a very interesting behavior discovered during Comprehensive Database Performance Health Check. The client who has SQL Server 2017, recently was facing a very high wait type of QDS_LOADDB.