Sites anglophones


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.

Automating Migrations for Multiple Databases using Flyway

Publié le 2 avril 2021 sur sqlservercentral.com
 

The post Automating Migrations for Multiple Databases using Flyway appeared first on SQLServerCentral.

Exploring Four Simple Time Series Forecasting Methods with R Examples

Publié le 2 avril 2021 sur sqlservercentral.com
 

The post Exploring Four Simple Time Series Forecasting Methods with R Examples appeared first on SQLServerCentral.

SQL Server Security – Fixed server and database roles

Publié le 1 avril 2021 sur simple-talk.com
 

Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to provide access for logins and database users to resources within SQL Server. SQL Server has both server and database resources where access might n …


Pages :