Creating and Using Inline Table-Valued Functions
In case we’ve forgotten or have never come across inline table-valued functions before, we’ll start with a quick explanation of what they are. Taking the definition of what a user defined function (UDF) is from Books Online, an inline table-valued func …
“UPDATE, INSERT, and DELETE are not normally processed in parallel”
Years ago, when troubleshooting performance, I stumbled across this Microsoft documentation on parallel query processing that says: Certain types of statements cannot be processed in parallel unless they contain clauses, however. For example, UPDATE, I …
The Social Impact of Artificial Intelligence and Data Privacy Issues
The current era of AI and Big Data is already considered by many as the start of the fourth industrial revolution that will reshape the world in years to come. Google searches, Map navigation, voice assistants like Alexa, personalized recommendations o …
Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120
I do Comprehensive Database Performance Health Check for living, I work with the SSMS most of the time. When start our consulting we start by looking at the Server and later on focus on the queries. Most of the time the queries are very complex a …
The Future of DevOps
The post The Future of DevOps appeared first on SQLServerCentral.
Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets
The post Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets appeared first on SQLServerCentral.
Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication
In this article, we will review how to join a Ubuntu 16.04 server to a Microsoft Active Directory Domain, install SQL Server, and configure the SQL Server on Ubuntu 16.04 to use Microsoft Active Directory Authentication. The following are the step …
The Curious Case of… almost online index rebuilds
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
Nonclustered Primary Key – SQL in Sixty Seconds #119
One of my clients of Comprehensive Database Performance Health Check recently faced a very interesting situation. I will describe the situation in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a no …
Introduction to Analyzing Waits using SQL Monitor
The post Introduction to Analyzing Waits using SQL Monitor appeared first on SQLServerCentral.
How to Use Parameters in PowerShell Part II
The post How to Use Parameters in PowerShell Part II appeared first on SQLServerCentral.
Downloading a CSV File from an API Using Azure Data Factory
Azure Data Factory has two different connectors that can copy data from APIs. Originally, there was only the HTTP connector. The REST connector was added later. Although there are situations where either connector would work for copying data, there are …
When was Stored Procedure Last Compiled? – Interview Question of the Week #292
Question: When was Stored Procedure Last Compiled?Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled. As a matter of fact, SQL Server does not keep this information out in the public, that is why I understand. H …
Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
What I enjoy the most is working with different clients on Comprehensive Database Performance Health Check. Every client is different and what I learn from every organization is different. Recently, I had a very interesting experience with a clie …
Full-Screen Execution Plan – SQL in Sixty Seconds #117
I spend my most of time in a day helping client improve their SQL Server Performance at Comprehensive Database Performance Health Check. The biggest performance improvement we often get by tuning the server configuration, and database deployment. Howev …