What's a Lot of Money?
Handling a budget can be an interesting experience for many technical professionals. Today Steve wonders if you treat this differently than your budget at home.
Customizing Database Deployments using Flyway Callbacks and Placeholders
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log.
Partitioned Tables Cause Longer Plan Compilation Times
Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.
Query Optimizer Suggests Wrong Index and Query Plan -- Why?
A good example where the Query optimizer picks the wrong query plan and suggested index.
UX Matters
User interface is a part of software development that many technical people pay little attention to during the process of building something. However, it can be a problem for your customers.
Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
Reteaming
Many organizations will change their teams around over time, but not all do this regularly. Steve talks about how Redgate does this every year.
Comparing and Syncing Data using SQL Data Compare Command Line
Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes.
Learning SQL Server
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
Discussion on Normalization and Database Design Concepts
Introduction Relational database design helps to create a set of relations and tables, which are connected with each other through some defined relationships. The main purpose of relational database design is to preserve the information and minimize data redundancy. We need to follow some design guidelines for relational schemas to maintain the quality of the […]
Blogs
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
The Burrito Bot: AI-Powered Search in SQL Server 2025
A while back I posted about a couple of side projects that I’ve been...
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers