Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

dotConnect for SQLite: Fast .NET data access with ORM and encryption support

Supercharge your.NET applications with dotConnect for SQLite — the high-performance data provider trusted by thousands of developers. Whether you're building lightweight apps or enterprise-scale solutions, dotConnect delivers secure, encrypted access to SQLite with seamless Visual Studio integration, powerful ADO.NET architecture, and full ORM support, including Entity Framework Core. Chapters: Try it free for 30 days and see why thousands of developers trust dotConnect for SQLite in mission-critical environments.

What is Database Monitoring

Database monitoring transforms from a reactive troubleshooting exercise into a proactive optimization strategy when you have the right tools and approaches in place. This blog shares practical ways to choose monitoring solutions, set up observability for different database platforms, and design workflows that scale in modern distributed systems.

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.