Sites anglophones


“UPDATE, INSERT, and DELETE are not normally processed in parallel”

Publié le 8 septembre 2020 sur brentozar.com
 

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

Publié le 8 septembre 2020 sur simple-talk.com
 

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

Publié le 8 septembre 2020 sur journey to sqlauthority
 

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

Publié le 8 septembre 2020 sur sqlservercentral.com
 

The post The Future of DevOps appeared first on SQLServerCentral.

Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets

Publié le 8 septembre 2020 sur sqlservercentral.com
 

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

Publié le 8 septembre 2020 sur sqlservercentral.com
 

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

Publié le 7 septembre 2020 sur sqlskills.com - paul randall
 

(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

Publié le 7 septembre 2020 sur journey to sqlauthority
 

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

Publié le 7 septembre 2020 sur sqlservercentral.com
 

The post Introduction to Analyzing Waits using SQL Monitor appeared first on SQLServerCentral.

How to Use Parameters in PowerShell Part II

Publié le 7 septembre 2020 sur sqlservercentral.com
 

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

Publié le 7 septembre 2020 sur sqlservercentral.com
 

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

Publié le 6 septembre 2020 sur journey to sqlauthority
 

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

Publié le 5 septembre 2020 sur journey to sqlauthority
 

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

Publié le 4 septembre 2020 sur journey to sqlauthority
 

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 …

Transfer data from SQL Server to MySQL

Publié le 4 septembre 2020 sur sqlservercentral.com
 

The post Transfer data from SQL Server to MySQL appeared first on SQLServerCentral.


Pages :