Exploring the Flyway Schema History Table
The post Exploring the Flyway Schema History Table appeared first on SQLServerCentral.
How to replace an identity column with a sequence number
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
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
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
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
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
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
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
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
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?
The post Where’s the best place to live as a DBA? appeared first on SQLServerCentral.
Power BI Zoom and Focus
The post Power BI Zoom and Focus appeared first on SQLServerCentral.
Error Handling Quiz Week: Where Are You Handling Errors?
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
The post Quantifier predicates appeared first on SQLServerCentral.
Performance Tuning Using Free Tools, Part 2
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 …