(Pinal Dave) Some questions never get old when working with SQL Server and recently one of my clients of Comprehensive Database Performance Health Check asked me if I know any way to open SSMS via Command Prompt. Of course, it is possible to do that in Windows.
Tag: sql server
(John Miner) There are existing on premises SQL Server Integration Services (SSIS) packages that use the Azure Blob Download and Azure Blob Upload tasks to move files between on premises and cloud storage systems.
(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
(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
(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.
(Kenneth Fisher) Demo first and then I’ll explain what happened.
(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.
(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
(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?
(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.