Sites anglophones


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.

[Video] Office Hours: Open Q&A About SQL Server

Publié le 3 septembre 2020 sur brentozar.com
 

Office Hours Podcast For those of you who miss our old Office Hours webcasts and feel lonely during the quarantines, I’m doing my part to help with free weekend webcasts. For the next couple of Saturday & Sunday mornings from 6AM-8AM Pacific …

Recover Crashed Query in SSMS – SQL in Sixty Seconds #116

Publié le 3 septembre 2020 sur journey to sqlauthority
 

Has it ever happened to you when you are working on a large SQL Server query and suddenly your SQL Server Management Studio (SSMS) crashes? Honestly, it has happened to me quite many times and it is indeed frustrating. Today we will learn about how we …


Pages :