You have to admit that title is catchier than yet another “Death of the DBA” blog. And that was exactly the direction I was headed until I ran a...
blog
SQL diagnostic manager Secrets: Configuring Alerts
There are a lot of features in SQL diagnostic manager. In this series, I plan to let you know about features that many users never find. In...
Time for an Upgrade?
I don’t know about you, but deciding when to pull the trigger on an upgrade is not that easy for me. What is to be upgraded usually doesn’t...
Get Better Integration with SCOM using SQLdm SCOM Management Pack
It’s an age old problem in IT, one IT department has one standard and tools they use to manage their systems. Another IT department has another...
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...
Achieve Better Automation with Idera’s SQL Diagnostic Manager
A seasoned SQL Server DBA has many skills, expertise and knowledge. Unfortunately, this also means that his/her time is always on demand by many...
Best Practices for Deployment of SQL Compliance Manager
So maybe you downloaded a trial of SQL Compliance Manager and want to play around with it. Or perhaps you already purchased licenses and want to...
AWS cost saving tip: Delete unused EBS volumes
Organizing EBS volumes and deleting detached volumes on a regular basis to can help decrease AWS spend. See how easy it is to identify, tag,...
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...
Most Popular FAQs for SQL Doctor
SQL Doctor is one of the most popular products in the Idera portfolio and as such we get a variety of questions from users on how it works, where do...
New SQLyog and MONyog coming – please upgrade soon!
We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the 'Heartbleed'...
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...
Is Your SQL Server Slow? Maybe It’s Trying Too Hard
The following is a guest post by Microsoft Certified Master Robert L Davis. Find more from him at SQLSoldier.com, and follow him on twitter...
Reading StringExpand Registry Values
When you read a Registry value of type StringExpand, it will always automatically expand any environment variables contained in the text. This...
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...
Five Must-Have Tools For DBA’s
SQL Diagnostic Manager SQL diagnostic manager is a full, feature-rich monitoring solution for your SQL Server and virtualization platform with...
The Cheat-Sheet on SharePoint’s Distributed Cache
I was in Indiana this past weekend at SharePoint Saturday Indianapolis, and one of the presentations I delivered at the event was a favorite of...
Manipulating File System Paths (Part 3)
In previous tips we illustrated how you can turn file system paths into arrays and then create new paths by changing or excluding parts of the...
Manipulating File System Paths (Part 2)
When you turn a path into an array to manipulate parts of the path, if you access path elements by fixed index numbers, then this approach will only...
Manipulating File System Paths
PowerShell lets you access multiple array elements. With the help of -split and -join, you can easily manipulate file system paths this way. To...
Writing DWORD-Values to Registry
In PowerShell 2.0, Set-ItemProperty by default always creates REG_SZ (String) values. PowerShell 3.0 is smarter. When you submit a numeric value,...
Importing Website Tables into Excel
Sometimes, you might see interesting information on websites. For example, navigating to http://www.ssa.gov/OACT/babynames/index.html will open a...