Oracle Sequences: RAC
Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.
2021-05-31
Additional Articles
Constraints and declarative referential integrity
Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.
2021-05-28
Introducing the PASS Data Community SUMMIT
Join the world’s largest gathering of data professionals at this year’s free online PASS Data Community SUMMIT. Connect and network with 1000s of your peers and learn from some of the brightest minds in the data industry. This year’s must-attend online event is completely free, so sign up now to be notified when registration opens.
2021-05-28
Creating Deep and Shallow Delta Clones in Azure Databricks
In this article we will look at how to create deep and shallow clones of source data when using Azure Databricks.
2021-05-26
Save the date: PASS Data Community Summit 2021
Simple Talk editor Kathi Kellenberger announces this year's free global online conference will take place on November 8 - 12. Save the date, and stay tuned for the Call for Speakers coming soon.
2021-05-26
Database DevOps: 10 Trends for 2021
What do you think the top 10 Database DevOps trends in 2021 are? Redgate has condensed 3,200 survey responses from IT professionals worldwide into a handy infographic. Discover insights such as the top challenge in improving software delivery performance and the correlation between DevOps adoption and high-performing teams.
2021-05-24
SQL Server security – Providing a security model using user-defined roles
Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.
2021-05-24
Creating Idempotent DDL Scripts for Database Migrations
How to write idempotent DDL scripts that Flyway can run several times on a database, such as after a hotfix has already been applied directly to the production database, without causing errors.
2021-05-21
SQL Server plan cache mining – Plan attributes
Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues.
2021-05-21
How to choose between SQL and NoSQL databases
Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL and NoSQL databases.
2021-05-19
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers