How to replace an identity column with a sequence number
SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.
2022-01-24
Additional Articles
Choosing Between SQL Server Integration Services and Azure Data Factory
In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
2022-01-21
The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022
Read what Grant, Steve and Kathi predict will be the biggest challenges for data professionals to overcome this year.
2022-01-21
Reporting on Changes Made by Flyway Migration Scripts
Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations.
2022-01-19
SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
Power BI Zoom and Focus
In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.
2022-01-17
Where's the best place to live as a DBA?
Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here!
2022-01-17
A Database DevOps Workflow Using Redgate Deploy
Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy. It allows branch-based database development, using disposable databases (clones) and version control tools, promotes continuous integration and testing of changes and automates the build and deployment processes so that they are repeatable, fast and reliable.
2022-01-14
Quantifier predicates
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
Automating Flyway Undos
How to auto-generate first-cut undo scripts for every Flyway migration. For every new version of a database created by a Flyway versioned migration, we compare it to a 'source' directory containing object-level build scripts for the previous version. The SQL Compare engine does the rest, producing the associated undo script that will revert the database to the previous version, if required.
2022-01-12
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers