Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to...
SQL Server
How to monitor and diagnose SQL query performance
Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL...
January #SQLChat: SQL Server New Year Resolutions – Breaking SQL Bad Habits for 2018
The New Year is almost here! Have you made any resolutions for 2018? Participate in our next #SQLChat on Wednesday, January 3rd at 11 AM CT with...
Diversity within Tech – Community Findings
Diversity is a huge topic of discussion, especially as of late. Rie Irish (@IrishSQL) partnered with the PASS Women in Technology (WIT) Virtual...
Download and Complete our SQL Server Crossword!
This fun puzzle, created by Kenneth Fisher, is primarily focused on SQL Server but also includes some IDERA terms. Up for the challenge? Download...
Updated Free Tool: PowerShell Scripts for SQL Server 4.0: Added 13 Scripts
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release supports SQL Server 2016 and 2017, and Windows Server...
The SQL Song That’s About to Hit The Billboard Hot 100 Chart
Homer McEwen, aka Killa DBA, has always loved music – from his early years in the church choir to today's gigs as a singer and songwriter....
3 Critical Tasks DBAs Wish They Had More Time to Complete
People are constantly asking me what to do to make money. My answer is, “I spend time with people who have trouble with SQL Server Performance...
HIPAA Compliance for Data Professionals
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...
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...