While medical facilities are most at risk for a HIPAA violation, most organizations in the United States have to comply with the law and can be hit...
SQL Server
New Free Tool: SQL Data Profiler
IDERA released a new free tool, SQL Data Profiler, designed to provide quick visibility into data patterns contained in SQL Server databases. Its...
October #SQLChat – Adult Learning
IT is a fast moving profession. If you aren't keeping up you are falling behind. Participate in our next #SQLChat on Wednesday, October 18 at 11...
Logical to Physical Data Modeling
In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to...
Fireproof Your DBA Career in our Next Twitter Chat!
Is your DBA career fireproof? Let’s discuss the things that can get you fired and make sure you’re not doing them. Our next #SQLChat...
Database Continuous Delivery – It’s Not as Scary As You Think
Database continuous delivery can be a scary topic for database administrators. This requires the DBA to start trusting tools & processes,...
Join the Team – Talk Back
Those of you who have endured a product roadmap session with me know that the insight into our direction comes with a price. That price is me...
Getting the Most from Your Software Vendor
This topic is relevant to more than just Idera and it comes from experience working for and with multiple software vendors in multiple...
Modeling Graph Data Stores in ER/Studio
Modeling Background Enterprise data environments have become increasingly complex due to a proliferation of different technologies and data...
How Do You Approach a Performance Problem?
We all see performance problems on a regular basis. Some look to hardware first, some look to logical design. We all turn to IDERA and other tools....
May the 4th Be With You!
Do. Or do not. There is no try. May the 4th is National Star Wars Day and IDERA is excited to celebrate. Keep your database universe Safe with the...
Attend our Virtual Conference to Win Big!
Be a part of history and attend IDERA’s first Virtual Conference! IDERA Live is our first Virtual Conference designed to educate and inform...
Is your SQL drawing a blank? It’s NULL a surprise!
The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance...
Azure SQL Database – What a DBA Needs to Know
Moving your databases to "the cloud" won't eliminate the DBA job - but it will change it. Microsoft Azure SQL Database, in particular,...
2017: A New Year with new projects?
2017: A New Year with new projects? I’m not big into new year’s resolutions. Too often they are just words that we never act on. When...
How Do You Create a Disaster Recovery Plan?
Get 2017 on a healthy start and participate in our January #SQLChat! Our next Twitter Chat will take place Wednesday, January 11th at 11 AM CT with...
How to Build the Essential SQL Server Administration Tool Chest
A well-equipped tool chest is essential for completing jobs around the home — everything from hanging a picture frame to putting together...
RETRIEVE ALERT STATISTICS SQL DM
Dear All, I am trying to understand if there is a procedure to retrieve alert stats from past one month. scenario : lets say we are...
Must Have DBA Resource: 5 Costly DBA Mistakes
We've has published many popular white papers that have become the go-to guide on best practices and insider reports for database...
New Free Tool: Rapid Database Extractor
IDERA released a new free tool, Rapid Database Extractor, designed to help you gain quick visibility into SQL Server and Oracle databases from a...
Challenge Accepted
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting...
The Role of DBA in Data Protection
IDERA recently released a Database Management Report Survey with interesting industry trends such as “nearly 90% of enterprise IT respondents...
The Most Powerful Reaction in IT
Lately, I’ve been seeing a particular video depicting simple yet amazing chemical reactions making its way through my social media feeds....
New Free Tool: SQL Query Store Optimizer
IDERA released a new free tool, SQL Query Store Optimizer, designed to help you improve the performance of SQL Server 2016’s Query Store....