Operations | Monitoring | ITSM | DevOps | Cloud

10 SQL Server Performance Tuning Best Practices

There are a large number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially when you consider the number of different database settings, SQL Server settings, coding practices, SQL wait types, and so on that can affect performance.

Facebook, Instagram, and WhatsApp Down for Over Five Hours

Did you unconsciously open Instagram, Facebook, or WhatsApp several times throughout the day on Monday, only to get a “Couldn’t refresh feed” message? Did you try again every 20 or so minutes? Did you maybe even restart your phone, not once thinking websites as large as Facebook could possibly go down and believing it must be your own technology? Rejoice: it’s not you, it’s them.

7 Best Log and Syslog Viewers

Many devices—such as switches, routers, firewalls, servers, and printers—support syslog protocol. This standard for sending log messages within a network offers critical information about your system. Consequently, monitoring your network and its syslog messages should be a top priority. Many IT professionals use log and syslog monitors or viewers to gather logs and syslog messages from across their network in a centralized location.

Put the Machines to Work for You: A Modern Approach to Increase IT Agility

Putting machines to work to enhance our everyday lives has been well-ingrained in our society for at least a couple of centuries now. IT workers use machine learning (ML) in their daily work routines, even if they don’t consciously realize it. Automated email alerts, issue escalations, and security patching are just a few examples of how ML has put the systems we rely on to work for us.

Native SQL Server Backup Types and How To Guide

When a disaster occurs, the ability to successfully restore SQL Server databases is fundamental for avoiding data loss. It’s not enough to rely on hardware and software technologies to replicate data because these technologies can go wrong or there can be multiple failures during a disaster, meaning you have to rely on backups to recover. SQL Server allows multiple types of backups, and a multitude of options to use with those backups.

SQL Server Storage Best Practices: Choosing Storage Options

Storage is one of the most critical components for any relational database management system, and getting the right storage configuration affects reliability, availability, and performance. When it comes to SQL Server storage best practices, choosing between storage hardware options has changed significantly over the last decade, but that doesn’t necessarily make choosing the correct storage options for SQL Server any easier.

Boss-Level Log Management for WordPress Site Administrators

WordPress is the most dominant content management system (CMS) in the enterprise website market today. Its open-source nature, thousands of plugins, and wide adoption by commercial hosting providers have bolstered its success. In addition, it’s highly compatible with other website technologies like web servers, database servers, or middleware.

The Questions You Should Ask Your Software Providers

Software providers everywhere are under attack by cyber threat actors. Whether it’s a ransomware, the latest zero-day exploit, or a highly sophisticated, well-resourced, and persistent supply chain like SUNBURST, our entire industry faces an increasingly treacherous threat landscape, and nearly every news day brings with it another wave of announcements and urgent system updates to be made.

Is Application Sprawl in Government Really a Big Problem?

When considering whether to add more applications or monitoring components to your IT system, the answer should always be quality over quantity. Agencies often fall into the trap of application sprawl by adding more and more to their systems—more applications, more tools—without realizing this actually has the potential to reduce system effectiveness. Instead of simply adding more apps, consider instead interoperable ones, or ones you can plug into a common platform.