Following Dbi Blog's news feed is very easy. Subscribe using the "follow" button on the top right and if you want to, choose the updates by topic or tag.
We will deliver them to your inbox, your phone, or you can use follow.it like your own online RSS reader. You can unsubscribe whenever you want with one click.
Keep up to date with Dbi Blog!
Dbi Blog: Home - dbi services
Is this your feed? Claim it!
This summer I start a series of blog posts on the ‘green SQL Server DBA’, as it’s a topic that continues to interest me and one that hasn’t been covered very much so far. I hope you’ll enjoy my tips, starting with this one on unused indexes.
When discussing SQL Server performance, we often hear our performance tool say, ‘An index is missing’, but never ‘
Recently, I had to renew an SSL certificate on an SQL Server Reporting Services (SSRS) server. The task seemed straightforward: replacing an expired certificate with a new one containing the same configuration. However, once the change had been made, HTTPS wasn’t working anywhere — neither via the usual DNS names nor even when accessing the server directly. Only HTTP remained...
A production instance, mid-afternoon, nothing unusual on any dashboard. An engineer opens a transaction to patch a single row while investigating a data issue:
BEGIN TRANSACTION; UPDATE dbo.Orders SET Status = 'Reviewed' WHERE OrderId = 482193;No COMMIT. No ROLLBACK. The tab gets buried under three others, the investigation moves on, and the lock is st...
When organizations evaluate an Enterprise Content Management (ECM) solution, the conversation usually revolves around Artificial Intelligence, workflow automation, and integrations.
Yet the feature employees use more than any other is rarely the one showcased in demonstrations or marketing brochures: search.
The reality is simple. Most...
The Zabbix Agent 2 service on a Windows server was repeatedly becoming unresponsive and eventually crashing. The issue caused intermittent monitoring interruptions and required further investigation through Event Viewer messages and Zabbix Agent 2 logs to better understand why the service was no longer responding properly.
While monitoring a ...