Announcing the General Availability of IDERA SQL Compliance Manager 7.0
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Lesser Known SQL Server Backup Practices by Pinal Dave
One of the most critical responsibility of a Database Administrator (DBA) is to make sure that the databases are backed up on regular basis. What are your thoughts on creating backup strategies for your production environments? We would surely want to learn and...
Tips Developers Must Know Reading Query Plans
Guest post by Pinal Dave If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding those “problems” which DBA might be talking about. We would talk about tips which can help a...
3 Leadership Tips That Define Success by Pinal Dave
Check out this guest post by industry expert Pinal Dave who provides 3 leadership tips to define success in any industry. Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a...
Understanding Database Backup Strategies by Pinal Dave
Backup is one of the driest topics and it seems to be something non-negotiable for a DBA role. If we look into the fine prints of why someone should take a backup, then it is fundamentally for business continuity and to recover from disaster. The last mile of defense...
5 Common Mistakes Every Database Developer Must Avoid
Being a developer is an awesome experience – trust us. You are an architect and the builder of your dreams. A developer shapes the way the requirements get translated into a working product which customers will enjoy using it. Most developers are passionate in the...
Building Your Very First Data Model From Scratch
Section 1: Creating a Data Model In this section, we will be learning how to create a data model from scratch using ER/Studio Data Architect. See also: IDERA's Guide to the Three Types of Data Model: Conceptual, Logical and Physical Launch ER/Studio Data Architect...
What Policy Guidelines are Required for your SQL Environment?
As adherence to regulations continues to be pressed upon organizations by industry and government regulators, the ability of the organizations to comply in a timely manner becomes more difficult. By addressing this demand Idera’s SQL Secure and SQL Compliance...
Three Facets of Metadata: Structure, Content, Meaning – by David Loshin, Knowledge Integrity, Inc.
Metadata Integration
The operational culture of the enterprise has gradually shifted towards a more business-centric model, one where business users and front line information consumers desire better access to enterprise data assets, and need to have a comprehensive view of the...
Big Data the BuzzWord by Pinal Dave
The talk of the town these days is around Big Data if you are in a data-related domain. Most of the top CIOs are trying to get onto this bandwagon of Big Data and want to implement the same within their organization. Organizations have had data and loads of data...
5 Things Developers Must Know for Working with their Databases
This article by Pinal Dave looks at some of the developer traits that one must keep in mind while working with databases Being in the databases field one of the most rewarding experience and at the same time the most demanding. As developers, we get an opportunity to...
The Metadata Conundrum – by David Loshin
This is the second in a series of six posts from David Loshin. Read the previous post and the next post in the series. In my last post, I suggested that over time, organic yet siloed application development focused on functional requirements has...
Auto Replace in Rapid SQL by Dan Hotka
Hi! Dan Hotka here with more knowledge about Rapid SQL. I’ll address the auto replace feature of this tool and how you can use this feature to create customized shortcuts that should benefit your coding projects and style. The auto replace feature of Rapid SQL has...
Rapid SQL Query Builder Tips and Techniques by Dan Hotka
Hi! Don’t you just love a good SQL query builder? I found this tool in Rapid SQL easy to learn and easy to produce the SQL I desired. You start it from the menu item Tools à Query Builder. This opens a new tab that contains the available objects on the left,...
SQL Traffic Accelerator as a DB performance tool
We get questions from time to time from folks asking what SQL Traffic Accelerator does for DBAs since it sounds like a network monitoring tool. Let’s get that out of the way first. This tool is not a network monitoring tool at all. If you take a closer look, you...
Mission Impossible? Effective Database Backup Strategies
Mission Impossible? Effective Database Backup Strategies Organizations use multiple strategies when working with backups. An effective restore strategy is acutely ‘mission critical’ to ensure that your backup is of value. Read this guest post...
Enterprise Data Confusion – Did We Bring This Onto Ourselves? – authored by David Loshin, Knowledge Integrity, Inc.
This is the first in a series of six posts from David Loshin. Read his next post. A few years back, I had the opportunity to work with Embarcadero Technologies, having been invited to put together some white papers and participating in some web seminars on the...
SQL Syntax in Rapid SQL by Dan Hotka
Abstract: Guest blog post from Dan Hotka, Oracle ACE Hi! Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your fingertips when using an IDE tool such as Rapid SQL? Well, the answer is yes…you can have SQL syntax with the click of your...
3 Leadership Tips defining Success
Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a number of leaders who have influenced the way they run their business or even life. Be it in Politics or in social circles –...
Solution for the EditorLineends.ttr issue
During the month of August 2014, Microsoft issued a security patch for Windows (http://support.microsoft.com/kb/2993651). This update had an impact on past versions of our development tools, including RAD Studio, Delphi, and C++Builder from version 2007 to version...