Sites anglophones


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 …

Choosing Between SQL Server Integration Services and Azure Data Factory

Publié le 21 janvier 2022 sur sqlservercentral.com
 

The post Choosing Between SQL Server Integration Services and Azure Data Factory appeared first on SQLServerCentral.

The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022

Publié le 21 janvier 2022 sur sqlservercentral.com
 

The post The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022 appeared first on SQLServerCentral.

Playing popular game of Wordle using T-SQL

Publié le 19 janvier 2022 sur sqlservercentral.com
 

A current frenzy surrounding the game of Wordle has swept the community. I have been playing this game as well and it is addictive. Therefore, I have decided to spice up this game with Transact SQL. With this script, you can now  play this game on …

Reporting on Changes Made by Flyway Migration Scripts

Publié le 19 janvier 2022 sur sqlservercentral.com
 

The post Reporting on Changes Made by Flyway Migration Scripts appeared first on SQLServerCentral.

SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL

Publié le 19 janvier 2022 sur sqlservercentral.com
 

The post SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for January 2022

Publié le 18 janvier 2022 sur brentozar.com
 

In this release, sp_Blitz shows some information about clusters and AGs, sp_AllNightLog and sp_DatabaseRestore get some love, and more. Wanna watch me use it? Take the class.To get the new version: Download the updated FirstResponderKit.zip Azure Data …

SQL Server Dacpac in Azure Data Studio

Publié le 17 janvier 2022 sur sqlservercentral.com
 

Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a …

Where’s the best place to live as a DBA?

Publié le 17 janvier 2022 sur sqlservercentral.com
 

The post Where’s the best place to live as a DBA? appeared first on SQLServerCentral.

Power BI Zoom and Focus

Publié le 17 janvier 2022 sur sqlservercentral.com
 

The post Power BI Zoom and Focus appeared first on SQLServerCentral.

Error Handling Quiz Week: Where Are You Handling Errors?

Publié le 14 janvier 2022 sur brentozar.com
 

This week’s series on error handling has been an eye opener for many of us. We’ve laughed. We’ve cried. We’ve screamed in horror. We’ve read the documentation. I don’t blame you. This is a really confusing topic, and …

Quantifier predicates

Publié le 14 janvier 2022 sur sqlservercentral.com
 

The post Quantifier predicates appeared first on SQLServerCentral.

Performance Tuning Using Free Tools, Part 2

Publié le 14 janvier 2022 sur sqlservercentral.com
 

Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware or paying Azure SQL bills. You can keep the cost under control by improving the efficiency of your databases. You can improve your databases usin …

A Database DevOps Workflow Using Redgate Deploy

Publié le 14 janvier 2022 sur sqlservercentral.com
 

The post A Database DevOps Workflow Using Redgate Deploy appeared first on SQLServerCentral.


Pages :