Operations | Monitoring | ITSM | DevOps | Cloud

If you’ve ever deleted records in SQL Server and then noticed your next insert doesn’t start at 1 but maybe jumps to 57, you’ve seen firsthand why it’s important to know how to reseed identity in SQL Server. Identity columns are excellent for auto-generating unique row identifiers; however, they usually don’t reset automatically. This behavior can leave frustrating gaps and disrupt your queries.

In today’s digital world, where data breaches and cyberattacks make headlines daily, protecting your database has never been more crucial. One of the most effective and often overlooked ways is using parameterized queries. This simple yet powerful technique shields your database against malicious attacks and enhances your query performance.

Undoubtedly, SSMS is a proven database management and administration tool that does its job well. Yet we all tend to expand our capabilities as much as we can, tailoring this tool to our specific needs. That’s how we get a wide range of SSMS plugins and extensions at our service—each designed to enhance specific aspects of development and administration.

Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your software delivery lifecycle risks application performance, data security and integrity. With Redgate Flyway Enterprise, you can solve this challenge with one solution built on best-in-class database comparison technology.

Data integration challenges are rising as organizations rely on data flowing across cloud, on-premise, SaaS, and legacy systems. According to Salesforce, 80% of IT leaders cite data silos as a top concern. In addition, 72% say overly entangled systems are slowing progress—making it harder to scale, adopt AI, or modernize operations. These issues disrupt real-time workflows, add friction to cross-system processes, and limit an organization’s ability to adapt at speed.

CRM migration affects far more than just your tech stack—it influences customer relationships, operational agility, and long-term growth. That’s why understanding the strategic considerations behind the process is essential for technical teams and decision-makers. When done right, migration creates a well-integrated, data-driven foundation. When mishandled, it leads to disruption and costly setbacks—and the risk is measurable.

PostgreSQL, widely regarded as the world’s most advanced open-source relational database, continues to set the standard for performance, scalability, and flexibility in modern data infrastructure. While it has always been a top contender, each new release of PostgreSQL introduces powerful features and enhancements that make it an even more compelling choice for developers, database administrators, and IT leaders alike.

One of my favorite new PostgreSQL 18 features which hasn’t had much attention yet is tracking session-level IO stats. It’s going to be really helpful for more quickly finding problematic queries in real-time – kudos in particular to Bertrand Drouvot for the work on it!