As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

According to recent data from the SolarWinds "State of Monitoring and Observability Report," 51% of IT pros believe database performance would benefit from better observability. Oftentimes, database ...

“Free” is a term rarely associated with Microsoft offerings, especially at the server end of the spectrum. Exchange Server, SQL Server, SharePoint, Hyper-V — IT admins know functionality comes at a ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...