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
Managing Database Security and Compliance
When managing database security and compliance, the DBA can't take a chance on anything falling through the cracks. In this session, you'll learn how to set up a change control process for your databases that will provide the coverage needed to ensure your...
The DBA and Developer Career Tips eBook
The DBA and Developer Career Tips eBook Author:Pinal Dave Like in any profession, DBAs and developers face competition in the workforce for job opportunities, promotions and prestige. Getting and staying on top of your game is critical. Are you...
What You Know but Don't Know
How To Know What You Don’t Know - Path to the DBA World As a new DBA to a company it can be overwhelming and sometimes confusing on knowing where to start and whom to approach. One is tasked to managing and administering databases either from a new environment or...
Integrating Data from Multiple Sources: Inferring Source Metadata – by David Loshin, Knowledge Integrity
This is the second post in this series. Read the previous post and the next post. In my last post, we began to review the data element conformance challenges associated with integrating data from a variety of original sources. The biggest issues have to do with...
Congratulations You're a DBA…Now What?!
This is a guest article by SQL Server MVP Mike Walsh (www.straightpathsql.com | www.linchpinpeople.com), based on an Embarcadero sponsored webinar by Mike Walsh and John Sterrett (www.johnsterrett.com). Introduction Being a DBA can be challenging and frustrating....
Solving Performance Problems on Oracle DB
DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are responsible for; it can be very difficult, frustrating, and expensive. Given the complex interactions of applications, users and...
Bind Variables and Application Performance
Not many people are familiar with Bind Variables or how they can be used. Find out how bind variables can be used effectively to make your SQL perform more efficiently and why they can achieve this performance. This is a video replay from the DataU online conference....
Integrating Data from Multiple Sources: The Challenge of Data Element Conformance – by David Loshin
This is the first post in this series. Read the next post. The continued fascination with expanding an organization’s analytics capabilities often centers on the desire to identify interesting and new data sources originating outside the enterprise that can be...
Achieving Database Schema Compliance at a UK Finance Institute
The requirement to maintain and prove schema compliance within the organization's database inventory continues to expand. The key objective is to discover and report on schema anomalies in the production database landscape. The use of DB Change Manager enables...
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for individual servers. The reasons are varied: some people want to get health checks more frequently, but quite often they...
Solving Common DBA Tasks at a Leading German Bank with DB PowerStudio
A leading German bank uses DBArtisan to manage hundreds of databases in their organization. This case study will show how many common DBA tasks are solved using DBArtisan at large enterprises and how DBAs perform these tasks to keep the database operational, such as...
True Type Font Iconography for Android and iOS Apps
. Download Project Files Download the project files. How to Deploy a Custom True Type Font First create a new Multi Device Application in either C++ or Object Pascal. Save the project to a folder on your filesystem. From the FontAwesome downloaded archive,...
Beginning Joins with SQL
Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data from more...
Documenting Your Data Landscape For The Organization
When it comes to making informed decisions, data is the most critical asset an organization possesses. In this session, you'll see how to create documentation of organizational data, which is easily understood and readily available to anyone within the...
How to centrally manage enterprise data definitions in your data mangement projects?
One of the key issues in a Data Warehouse, Master Data Management or BI project is the lack of a centralized and easily accessible Data Definition or Metadata Repository. Mostly, business users are using word and excel documents placed on a shared folder....
Getting Physical – Using automation to build robust, high-fidelity schemas from your logical models
High-fidelity database schemas capture essential business rules and help ensure data quality, but can be very time-consuming to produce and maintain. Enterprise-grade data modeling tools excel in automating the construction and maintenance of robust database designs...
Top 3 Development Environments for PostgreSQL
PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any other advanced RDBMS, PostgreSQL does more than retrieving or updating data. PostgreSQL is a very popular database...
The Intrinsic Value of Data Modeling
Maybe you're using Visio, Excel, or a proprietary tool with limited functionality to create a data model. Perhaps you are expanding your job scope to include data modeling and aren't sure where to start. Or you might be very experienced with data modeling, but...
How do I get INSERT/UPDATE/DELETE, Table Data Editor and Import to work with Hive?
How do I get INSERT, UPDATE, DELETE, the Table Data Editor and Import to work with Hive? Response Jonathan Powers over 8 years ago With Aqua Data Studio v15.0.11-9 and above, tables now require ACID to do INSERT UPDATE and DELETE transactions. This is described here...
Taming the Wild West of Data
Prior to joining Embarcadero, Ron was a consultant who used ER/Studio as well as a variety of other data modeling suites throughout his career. Referencing the Astron Technologies case study, he will discuss some of the data management challenges faced in large...