What happened? On Monday, June 12, 2017, a security researcher discovered that sensitive personal data of nearly all the 200 million registered...
Vicky Harp
SQL Server 2016 Has a Little Something for Everyone
This Thursday, June 23, IDERA is sponsoring a virtual Windows IT Pro event to discuss what’s new with SQL Server 2016 — which was released on June...
Thinking Strategically about SQL Server on Linux
People all over the database world were in for a stunner this week when Microsoft announced that they will be supporting SQL Server installations...
Configuring Query Monitoring in SQL Diagnostic Manager 10.0
The SQL Diagnostic Manager Query Monitor is a powerful feature that has the capability of greatly reducing the time that it takes to identify...
T-SQL Tuesday #67: Introduction to Idera SQL XEvent Profiler
This month’s #tsql2sday is hosted by the delightful Jes Borland over at Less Than Dot, on the topic of XEvents. When I saw this come up on...
Identifying the cause of tempdb autogrowth using SQL Diagnostic Manager
Autogrowth in your tempdb database may not seem like such a bad thing, but it can cause quite a headache if it’s uncontrolled. Unplanned...
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for...
Altering wait categories in SQL Diagnostic Manager
SQL Diagnostic Manager ships with built-in categorization of wait types which are encountered in monitoring. These categories are used on both the...
Changing the Max Concurrent Service Connections for SQL Diagnostic Manager
SQL Diagnostic Manager automatically limits the number of connections that a collection service may make to an individual monitored server. This...
Quickly grouping events in SQL XEvent Profiler
As you may know, Idera has a number of free tools for SQL Server and we’re always coming out with new ones. Earlier this year we debuted SQL...
Survey: Oracle in your environment
A recent survey indicated a significant number of our customers use Oracle in their environment. Please help us better understand how we can help...
Survey: What database platforms are you using?
We are always looking for feedback to ensure we produce products that make your job easier. We’d very much appreciate if you’d take this short...
Survey: Idera’s new SQL Server job management solution
We are currently working on a new SQL Server agent job monitoring and management tool, to become available later this year. This first release will...
Counter calculations in SQL Diagnostic Manager
Probably the three most common questions I get about counters in SQL Diagnostic Manager are: “How can I prevent alerting on temporary noise...
Custom counter – deadlocks in the past X hours
In response to a couple of requests, here’s a custom counter that allows you to alert on the total number of deadlocks which happen in a...
Five tiny features of SQL Diagnostic Manager you may not know about
SQL Diagnostic Manager has been around for a long time, and many of you have been using it for years. For today’s topic I thought it might be fun to...
Idera SQL XEvent Profiler – a free tool for XEvent monitoring
The Extended Events technology added to SQL Server in SQL 2008 and expanded upon greatly in SQL 2012 is a powerful mechanism for monitoring activity...
Deep Dive: SQL Diagnostic Manager Availability Checks
One of the frequent questions I get about SQL Diagnostic Manager pertains to one of the most fundamental features of the product – exactly how is...
Copying instance lists between SQL Elements and SQL Diagnostic Manager
If you’re a user of both SQL Elements and SQL Diagnostic Manager, it’s a reasonable bet that you’ll have some overlap of instances being monitored...