Sites anglophones


Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

Publié le 31 janvier 2022 sur sqlservercentral.com
 

The post Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant appeared first on SQLServerCentral.

PostgreSQL in Azure Data Studio

Publié le 31 janvier 2022 sur sqlservercentral.com
 

Azure Data Studio (ADS) comes with an extension to access a PostgreSQL database. In this article, we will talk about Postgres, install the Windows version On-premises and then connect with ADS and create some objects like a table, view, and select some …

Is Your SSIS Catalog Migration Ready

Publié le 28 janvier 2022 sur sqlservercentral.com
 

Are you planning to migrate your SSIS Catalog to a newer version of SQL Server? You might like to know if your SSIS Catalog has any issues. Some of the most common issues in SSIS catalog could be: SSIS projects have orphan environment references. …

SQL Server Monitoring Using Free Tools

Publié le 28 janvier 2022 sur sqlservercentral.com
 

Do you sometimes wonder how the pieces of your SQL Server systems are doing over time? Do you often wonder how they are doing in the moment? You can monitor the health and activity of your instances and databases using SQLFacts, a FREE suite of to …

Install SQL Server and Oracle using PowerShell and Windows Containers

Publié le 28 janvier 2022 sur sqlservercentral.com
 

The post Install SQL Server and Oracle using PowerShell and Windows Containers appeared first on SQLServerCentral.

Debugging Flyway Callbacks and Migrations that Use Placeholders

Publié le 28 janvier 2022 sur sqlservercentral.com
 

The post Debugging Flyway Callbacks and Migrations that Use Placeholders appeared first on SQLServerCentral.

[Video] Office Hours: Ask Me Anything About SQL Server in Cabo

Publié le 27 janvier 2022 sur brentozar.com
 

I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Student: Hi Brent! Why is full backup sometimes slow and sometimes fast …

How to Integrate Azure DevOps with Azure Synapse Studio

Publié le 26 janvier 2022 sur sqlservercentral.com
 

There are two ways you can develop and execute code in Azure Synapse Studio: Synapse live development Git enabled development. By default, Synapse Studio uses Synapse live, as shown in Fig 1. With Synapse live you can’t work in a group for the same cod …

Testing a Flyway Database Migration

Publié le 26 janvier 2022 sur sqlservercentral.com
 

The post Testing a Flyway Database Migration appeared first on SQLServerCentral.

Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing?

Publié le 26 janvier 2022 sur sqlservercentral.com
 

The post Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing? appeared first on SQLServerCentral.

When Should You Use DESC in Indexes?

Publié le 25 janvier 2022 sur brentozar.com
 

The short answer is that if your query orders columns by a mix of ascending and descending order, back to back, then the index usually needs to match that same alternating order. Now, for the long answer. When you create indexes, you can either cr …

Working with Fail Activity in Azure Data Factory

Publié le 24 janvier 2022 sur sqlservercentral.com
 

Introduction In this article, we will talk about a newly introduced activity in Azure Data Factory, which is the fail activity. The fail activity is very useful to stop or fail the pipeline at the specified point. For example, a lookup activity might r …

Exploring the Flyway Schema History Table

Publié le 24 janvier 2022 sur sqlservercentral.com
 

The post Exploring the Flyway Schema History Table appeared first on SQLServerCentral.

How to replace an identity column with a sequence number

Publié le 24 janvier 2022 sur sqlservercentral.com
 

The post How to replace an identity column with a sequence number appeared first on SQLServerCentral.

Prevent Accidental Data Deletion in Azure Storage Container with Soft Delete Features

Publié le 21 janvier 2022 sur sqlservercentral.com
 

Introduction While working with Azure Storage, data might be accidentally or erroneously deleted. We can prevent the total loss of data by enabling soft delete features in Azure Storage. The system will store soft-deleted containers and its item for a …


Pages :