The most recent content from our members.
In this monthly mission, go ahead and flex on ‘em; we won’t stop you. Show off your ultimate DBA skills or use this time to learn how to impress with your new database observability knowledge. If you manage to stun with a month of shiny green check marks, you could win an Apple iPad (10th Generation)! While we know…
One of my favorite consulting questions to ask when dealing with a scalability problem is, “If you could change the system design with the knowledge you have today, what would/wouldn’t you change and why?” Sometimes it’s best to ask this question on a one-on-one basis with different developers, DBAs, report writers, and…
On September 09 2021, I presented a webcast on How to Troubleshoot SQL Server CPU Problems. If you missed it, you can watch the webcast on demand at https://www.sentryone/webinars. This session covers industry best practices and workflow for finding and fixing CPU problems on SQL Server and Azure SQL data platforms. I'd…
In today’s world of constant cyberthreats from terrorism, hackers, and viruses, public and private sector organizations need to assemble a strong, experienced team of security experts. But finding a talented and trained staff becomes a problem when, according to a June 2019 Forbes article, there are nearly three million…
Background This blog initially started out as an examination of how SolarWinds uses Database Performance Analyzer (DPA) within our own production environment. It now includes not only how our DBA uses DPA, but how other business units within SolarWinds use it and why. It isn’t surprising to find people in IT operations and…
Briefly written step by step Solarwinds Database monitoring guide.
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
In my previous posts about Building a Culture of Data Protection (Overview, Development, Features, Expectations) I covered the background of building a culture. In this post, I'll be going over the Tools, People, and Roles I recommend to successful organizations. Tools Given the volume and complexity of modern data…
In the past year I have earned a couple of certificates from the Microsoft Professional Program. One certificate was in Data Science, the other in Big Data. I’m currently working on a third certificate, this one in Artificial Intelligence. You might be wondering why a database guy would be spending so much time on data…
Since SolarWinds acquisition of Confio back in October 2013, customers have asked about the differences between Server & Application Monitor AppInsight for SQL and Database Performance Analyzer (formerly Confio Ignite). Although both products monitor SQL Servers, their purposes are unique and different, two sides of the…
It looks like you're new here. Sign in or register to get started.