Blog - Post List
    • 23 May 2017

    Big Data is a Big Deal

    Data is proliferating at an accelerated rate, with all the mobile and desktop apps, social media, online purchasing, and consumer loyalty programs available today. All of these data sources have not just changed the way we operate on a day-to-day basis, but it has immensely increased the volume, velocity, and variety of data being created. Faced with this growing trend, data professionals now often have to look beyond...
    • 19 May 2017

    Announcing General Availability of SQL Secure 3.1

    We are pleased to announce the general availability of SQL Secure 3.1. Existing users may upgrade to this version through the IDERA Customer Portal . New users may download the trial version from the IDERA website . This release of SQL Secure offers new, robust cloud functionality for the Microsoft Azure ecosystem and hybrid cloud environments, as well as adding several significant new security checks which are relevant...
    • 17 May 2017

    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. Our next #SQLChat will take place on Wednesday, June 28 at 11 AM CT with William Wolf (@sqlwarewolf). William will be discussing triaging performance issues including methodologies for best practice and best results. This #SQLChat will allow members from the SQL community...
    • 16 May 2017

    Discover 10 Lesser-known Capabilities of SQL Diagnostic Manager

    Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional resources. Learn how to add custom counters and custom SQL scripts, capture deadlocks, integrate with SCOM, monitor application transactions, query waits, tempdb contention and virtualization metrics, and setup actionable responses, baselines, and custom dashboards. #1 Monitor...
    • 12 May 2017

    Monitor Microsoft Azure SQL Server Performance and Availability

    Are you using Microsoft Azure SQL Server in your application? You can use IDERA Uptime Cloud Monitor to monitor your Microsoft Azure SQL Server performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box monitoring ...
    • 12 May 2017

    Announcing General Availability of SQL Compliance Manager 5.4

    We are pleased to announce the general availability of SQL Compliance Manager 5.4. Existing users may upgrade to this version through the IDERA Customer Portal . New users may download the trial version from the IDERA website . This release includes various customer improvements and the following new features: What's New in SQL Compliance Manager? Support for Extended Events Users will be able to select...
    • 8 May 2017

    Database Migration Made Easy

    One rare task that many DBAs fear is that of a database migration, say from Oracle to SQL Server as an example. There are many reasons for this discomfort – including overall complexity and possible lack of experience with the new database platform. That’s why possessing robust multi-platform DBA tools like DBArtisan are popular – for DBAs managing many different database types. But can DBArtisan also...
    • 3 May 2017

    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 Force. With IDERA’s SQL Safe Backup, you can automate backups across all your SQL Servers and recover data from backups without restoring. This tool will also help you backup faster and save space via dynamic compression with encryption. The newest version of SQL...
    • 2 May 2017

    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 users of any level in a fun, engaging atmosphere. Join some of the industry’s top speakers to guide you through compelling content and the biggest issues present in the IT world. You can expect top-notch training, industry tips and techniques, networking, and more! ...
    • 27 Apr 2017

    Configuring custom ports to a SQL Server Instance

    Back in February 22nd 2017, I posted a blog about " Where is SQL Server Configuration Manager ". And, if you ever want to manage your SQL Server ports, this is the application we need to accomplished that tasks. As every SQL Server Administrator every knows, the default port is 1433, which in most cases can be left alone. But, you could change the default port to something different. Try to give it different...
    • 26 Apr 2017

    The best problem is no problem.

    Making time to tune Oracle, scripting maintenance, allows Oracle DBAs to be truly proactive and deliver the best possible performance to application users.
    • 25 Apr 2017

    Combine PowerShell and SQL Diagnostic Manager to Automate SQL Server Monitoring

    Run new and existing PowerShell scripts with SQL Diagnostic Manager and utilize the vast power of PowerShell via the customizable monitoring environment. Run scripts to automatically react to problems detected by the monitoring environment, deploy and manage the monitoring environment via cmdlets, connect existing scripts to the monitoring environment to automate their execution, and avoid writing certain scripts in the...
    • 24 Apr 2017

    How to run an application under an account of a different domain

    Not too long ago, I came across a scenario where a user needed to launch an application (e.g. SQL Server Management Studio) to access SQL Server, not such an unusual scenario. The catch was that the user was running the application from his personal laptop, which was not part of the domain on which the SQL instance resided on. The other catch was that the SQL instance was not configured for SQL Server Authentication....
    • 18 Apr 2017

    Why Should A Data Modeler Care About Business Processes?

    Data Modelers are responsible for creating and maintaining conceptual, logical and physical data models. These data models are used to define the data requirements that support the business goals. Data modelers work closely with business stakeholders and users of the information systems. Business stakeholders want to see how the data is used in their business processes at a high level. They frequently get lost in the...
    • 17 Apr 2017

    What are Business Processes??

    Business Processes are a set of tasks or activities that help an organization to define and communicate their goals, optimize their resources and improve productivity. Business Processes allow stakeholders to see: How the processes map to business goals and requirements How work gets accomplished How the processes throughout the organization interact with each other How value is created for the organization...
    • 13 Apr 2017

    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 implications of queries processing records with NULLS, or situations where we are expecting NULLS, but the records really contain blank values. Before we do that, a bit of trivia - what is the origin of the phrase "drawing a blank." The phrase is believed to come from...
    • 11 Apr 2017

    April #SQLChat Findings

    Jim Donahoe ( @SQLFlipFlopsDBA ) hosted a #SQLChat on Wednesday, April 5 over Career Satisfaction within the SQL Space. This was a busy conversation with over 268 tweets generated with the hashtag #SQLChat. What did we learn? Not everyone needs fancy degrees or certifications to be a successful data professional. In fact, most of our Twitter Chat participants were accidental DBAs. To be a DBA,...
    • 10 Apr 2017

    Working with Glossaries in Team Server

    Working with Glossaries in Team Server So Why Business Glossaries? A typical way of structuring glossaries is aligning glossaries to different areas of a business, focusing on terminology important to that business area. Also, structuring the glossaries in a hierarchy results in an overall corporate business glossary. [Definition of a Glossary] Glossaries are collections of terms, such as "Human Resources"...
    • 6 Apr 2017

    Announcing SQL Doctor 3.6 General Availability

    We are pleased to announce the general availability of SQL Doctor 3.6. Existing users may upgrade to this version through the IDERA Customer Portal . New users may download the trial version from the IDERA website . This release includes various small customer improvements and the following new features: What's New in SQL Doctor 3.6? Support for Cloud Environments Connect to SQL Server as deployed as an on-premise...
    • 31 Mar 2017

    Uptime Cloud Monitor - Monitor MySQL Performance and Availability

    Are you using MySQL database in your application? You can use IDERA Uptime Cloud Monitor (UCM) to monitor your MySQL database performance. As an illustration, you can configure and receive alerts for the following scenarios: Performance: alert if the MySQL performance is poor. If the slow_queries value is significantly above its normal range, that would imply that the MySQL server is under heavy load. Bytes_received...
    • 30 Mar 2017

    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, has automated certain tasks the DBA used to be responsible for, and added new features that developers have embraced. Join Jes Borland ( @grrl_geek ) on Wednesday, May 24 at 11 AM CT to learn what features are available in Azure SQL Database. Participants will discuss their...
    • 28 Mar 2017

    World Backup Day on Friday, March 31, 2017

    World Backup Day is a day for everyone to learn about the increasing role of data in our lives and how important regular backups are. This day is not only a day for backing up data, but it is also a day to discuss the massive task of preserving the increasingly digital heritage and cultural works for future generations. Apparently, the previous year produced more than 2.5 quintillion bytes or 2.5 exabytes of data. Moreover...
    • 20 Mar 2017

    Win a YETI on Twitter!

    Happy First Day of Spring! Warmer weather is among us and to celebrate we are giving away a YETI Tundra 35 valued at $299.99. (photo taken from YETI.com ) To win all you have to do is: Follow us on Twitter ( @Idera_Software ) Reply to our tweet @Idera_Software and let us know where you and your IDERA duck would take your YETI this spring Sound easy? It is! This contest is open now until March 31.
    • 16 Mar 2017

    Announcing SQL Safe 8.4 General Availability

    We are pleased to announce the general availability of SQL Safe 8.4, IDERA's premier backup tool. Existing users may upgrade to this version through the IDERA Customer Portal . New users may download the trial version from the IDERA website . This release includes a number of bug fixes and the following new features: What's New in SQL Safe 8.4? Embedded SQL Virtual Database Technology SQL Safe Backup...
    • 15 Mar 2017

    Keep Track of Database Performance with Uptime Infrastructure Monitor

    Uptime Infrastructure Monitor Uptime Infrastructure Monitor (UIM) is an enterprise tool that provides a unified view for Information Technology systems monitoring. Although comprehensive and scalable, UIM is also easy to use and deploys in minutes. Through proactive, comprehensive, and integrated monitoring, reporting, and alerting, UIM gives complete visibility and control over the availability, performance, and capacity...