Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

What is Dynamic SQL in SQL Server?

Dynamic SQL in SQL Server is built for scenarios where queries can’t be fully defined in advance. It’s the method of choice when structure depends on user input, variable schemas, or runtime conditions, cases where static SQL falls short. However, without proper structure, this flexibility introduces security and maintenance challenges. To make it work at scale, you need a disciplined approach.

What is Database Change Management (DCM)?

Database change management is the foundation for building a stable, secure, and high-performing application. In today’s fast-paced technological landscape, where agile and DevOps are the go-to for developing database application, rapid releases and continuous iteration are the norms. But with frequent deployments comes the risk of untracked database changes.

Alerting Best Practices

A firing alert is like someone ringing your doorbell - it demands your immediate attention, interrupting whatever else you’re doing. It requires focus and a quick response. But imagine trying to live in an apartment where the doorbell never stops ringing. You could put in earplugs to block the noise, but that only masks the problem - it doesn’t solve it. On the other hand, disconnecting the doorbell entirely isn’t a solution either.

Grafana Mimir: 3 reasons to run the TSDB for Prometheus on bare metal

Wilfried Roset is an engineering manager who leads an SRE team and he is a Grafana Champion. Wilfried currently works at OVHcloud where he focuses on prioritizing sustainability, resilience, and industrialization to guarantee customers satisfaction. Whether it’s for efficient resource allocation, flexibility, high availability, or scalability, it makes a lot of sense to run Grafana Mimir on Kubernetes—but it’s not the only way to deploy Mimir.

Vector Database Explained: Architecture, Use Cases & Examples

Vector databases are rapidly becoming the cornerstone of modern AI applications—and for good reasons. If you are very familiar with AI technologies like ChatGPT, you have already seen what vectors can do. When you ask ChatGPT a question, such as, “What’s the weather like today?” to provide an accurate answer, the AI would first convert your question into a vector, which implies a series of numbers that capture the intent and context of your sentence. The cool part?

Simple Talks Podcast | S3, Episode 1 - Coffee chat with Mike Bowers

To kick off Season 3, host Steve Jones is joined by Mike Bowers, Chief Architect at data technology company FairCom. The conversation includes an overview of Mike’s background, the work he does at FairCom, plenty of SQL talk, and advice on getting into the industry.

dotConnect for PostgreSQL: Advanced .NET Data Access with Full ORM Support

Supercharge your.NET applications with dotConnect for PostgreSQL — a fast, feature-rich ADO.NET data provider tailored for modern PostgreSQL development. In this video, explore how dotConnect for PostgreSQL simplifies data connectivity, enhances developer workflows, and empowers scalable, high-performance applications within the.NET ecosystem. What you’ll see: From SaaS platforms to data-driven enterprise systems, dotConnect for PostgreSQL offers the speed, reliability, and flexibility your applications need.

The Real Cost of Choosing the Wrong Database

Data is more than a record of what happened—it shapes what happens next. Across industries, connected devices continuously stream time-stamped data that reflects the current state of machines, environments, and systems. This steady flow gives organizations a live view of operations and the ability to catch issues early, adjust quickly, and operate more efficiently. However, capturing data alone does not create value.