Sites anglophones


Digital Event: Innovate Today with Azure SQL

Publié le 12 avril 2021 sur sqlservercentral.com
 

The post Digital Event: Innovate Today with Azure SQL appeared first on SQLServerCentral.

Missing Data

Publié le 12 avril 2021 sur sqlservercentral.com
 

We don’t always have perfect knowledge of the reality we are trying to model in our database. The most general approaches to handling this missing data has been either ignore it, deduce it or impute it. Ignoring something explains itself. In SQL, we ve …

An Introduction To Kusto Query Language (KQL)

Publié le 9 avril 2021 sur sqlservercentral.com
 

Introduction In my last article, An Introduction to Azure Data Explorer, I discussed the process of creating and using Azure Data Explorer. Azure Data Explorer is mainly used for storing and running interactive analytics on Big Data. First, I need to c …

Power BI Anomaly Detection

Publié le 9 avril 2021 sur sqlservercentral.com
 

The post Power BI Anomaly Detection appeared first on SQLServerCentral.

Redgate Tool Tips

Publié le 9 avril 2021 sur sqlservercentral.com
 

The post Redgate Tool Tips appeared first on SQLServerCentral.

Pop Quiz: What Do These Things Cost Today?

Publié le 8 avril 2021 sur brentozar.com
 

Price check on Aisle 2021. My main consulting job is a 2-day SQL Critical Care® where I help turn around slow SQL Servers. Companies come to me because they’re not sure if it’s a hardware problem, a database configuration issue, bad app …

Moving from application automation to true DevOps by including the database

Publié le 8 avril 2021 sur sqlservercentral.com
 

The post Moving from application automation to true DevOps by including the database appeared first on SQLServerCentral.

Restoring Master on a Windows 2019 / SQL Server 2019 Cluster

Publié le 8 avril 2021 sur sqlservercentral.com
 

It doesn’t happen often you have to recover systems databases in SQL Server. Most articles cover restoring a master database on a local instance, if you’re lucky for a named instance, but most do not cover a clustered instance. As with ever …

Five facts about the SQL Server Model Database

Publié le 8 avril 2021 sur sqlservercentral.com
 

The post Five facts about the SQL Server Model Database appeared first on SQLServerCentral.

PowerShell editors and environments part 2

Publié le 7 avril 2021 sur sqlservercentral.com
 

The post PowerShell editors and environments part 2 appeared first on SQLServerCentral.

Never, Ever, Ever Start T-SQL Comments with Two Dashes

Publié le 6 avril 2021 sur brentozar.com
 

There are two ways you can write comments in T-SQL:–By starting a line with two dashes, or /* By framing it on both sides like this */ Never, ever use two dashes. Never. The problem is that monitoring tools and diagnostic management views often d …

3 steps to get started with Database DevOps

Publié le 6 avril 2021 sur sqlservercentral.com
 

The post 3 steps to get started with Database DevOps appeared first on SQLServerCentral.

Reading Stored Procedure Output Parameters in Azure Data Factory

Publié le 6 avril 2021 sur sqlservercentral.com
 

To facilitate native SQL code we have stored procedure support in Azure Data Factory (ADF). When we work with stored procedures, mostly we use input parameters, however, a stored procedure can also have output parameters. In this case, we need to deal …

Cherry-picking Migrations using Flyway

Publié le 5 avril 2021 sur sqlservercentral.com
 

The post Cherry-picking Migrations using Flyway appeared first on SQLServerCentral.

Query Audit data in Azure SQL Database using Kusto Query Language (KQL)

Publié le 5 avril 2021 sur sqlservercentral.com
 

The post Query Audit data in Azure SQL Database using Kusto Query Language (KQL) appeared first on SQLServerCentral.


Pages :