Announcing the General Availability of IDERA SQL Safe Backup 9.3
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
Setting up Oracle for Embarcadero ER/Studio – Part 1
In this blog post, I will be covering how easy it is for one to setup Oracle, in order to successfully work with Embarcadero's leading Enterprise Data Modeling Tool, ER/Studio. [Pre-requisites] Oracle Database 32 / 64 bit Server Edition ER/Studio Data Architect 32...
Data Modeling Tip for DBAs – by John Sterrett
Database Administrators (DBAs) are given so many different tasks from creating maintenance plans, upgrading databases, fighting performance problems, and more. With so many tasks to be completed, some tasks tend to not get the attention to detail they deserve. ...
Getting Started with the new Windows 10 VCL UI Controls in RAD Studio 10 Seattle
With the RAD Studio 10 Seattle release, we introduced 5 new VCL UI controls. These controls were specifically designed for Windows 10 and address common UI paradigms on Windows 10. While they were designed for Windows 10, the new VCL controls will also work with older...
7 Dangerous Myths DBAs Believe about Data Modeling
How much does your DBA really know about data modeling? Data modeling can simplify routine tasks and provide valuable context for a database implementation – every data architect knows this. However, DBAs often have some preconceived notions of what they think...
Aggregating Logs And Monitoring Them With up.time and logstash
Log monitoring is an important part of understanding your systems’ and applications’ health and are a valuable tool for troubleshooting when there are issues. Traditional endpoint monitoring can tell you if something is up or down, and performance metrics...
Setting up Windows 10 before installing RAD Studio
One of the prerequisites for RAD Studio is the Microsoft .NET Framework 3.5, but there is no Windows 10 .NET 3.5 installer to add this feature to the system. So I'm going to describe the few steps necessary to get .NET 3.5 into Windows 10 before installing RAD...
Monitoring your Amazon Aurora Databases using Monyog
We're excited to announce the general availability of Monyog for Amazon Aurora. Amazon Web Services' (AWS) latest offering, the Aurora database combines the speed and availability of commercial databases with the cost-effectiveness and simplicity of open...
C++ IDE code editor structure windows is blank on Windows 10 machine – workaround
Several developers reporting an issue where the C++Builder IDE code editor structure window was blank after they upgraded their Windows machine to Windows 10. The issue is reproducible on these scenarios: The user has a machine with a Windows version lower than...
The Hidden Elephant in ‘Big Data’ Modeling – by Len Silverston
The Elephant “We must understand the data and therefore continue to develop data models, even in this 'Big Data' era." exclaimed the data warehouse lead. "You traditional guys! We are in a new age and we have new technologies and tools that allow us to immediately...
Breaking Down Business Barriers with Enterprise Architecture – Slide Presentation
Below is the slide presentation from our recent webinar Breaking Down Business Barriers with Enterprise Architecture. See the companion webinar at: http://forms.embarcadero.com/Breaking-Down-Business-Barriers Learn more about ER/Studio at...
How Do You Collaborate on Enterprise Data?
As enterprise data environments become more complex, the need for full understanding of what the data means becomes more apparent. When you’re trying to integrate data from different sources, you have to ensure that information doesn’t get tagged incorrectly, or it...
Monitoring High Availability on Galera Clusters for MySQL using Monyog
For every online business, there are millions of transactions happening every second including crucial revenue bearing transactions. Therefore downtime, both planned and unplanned has a cost attached to it and results in lost revenue every second. As the technology...
Working with DBArtisan’s Performance Analyst
In this video, Scott Walz covers DBArtisan's Performance Analyst, a cross-platform real time performance tool. Try DBArtisan free See more DBA and Developer Skill Sprints...
Enabling Enterprise Agility Through Model-Driven Data Design
There is a growing need to integrate diverse databases with each other and with new data sources. This is accomplished through integration of data models and their associated metadata across the workflows associated with database design, development and integration....
Introducing actionable charts in Monyog MySQL Monitor
While Monyog MySQL Monitor is being embraced by DBAs and DevOps around the world, we are constantly adding more features to make MONyog the most complete MySQL monitoring tool. Monyog ships 40+ MySQL and system metric charts. It also lets you add custom charts. With...
Creating and Identifying Deadlocks in SQL Server
This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health extended event....
Top 4 Ways to Intelligently Automate DBA Activities
Being a DBA is one of the most challenging job. Why do you think we are saying so? Think of a normal situation, I have seen developers say this is the easiest life if you are a DBA. They never do know what all a DBA does in his day job. Most people think taking a...
Tips of the Week for SQL Server DBAs
Here are 10 quick SQL Server tips and tricks for DBAs compiled by SQL Server expert Pinal Dave. RAISERROR in the format RAISERROR integer 'string' is discontinued from SQL Serevr 2012. SQL Server should be behind the firewall not exposed to Internet. We can...
10 Quick Tips & Tricks for SQL Server Developers
Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check for issues with bad cardinality estimates. The maximum degree of parallelism can be limited server-wide by using the max...
10 Consejos y trucos rápidos para SQL Server Desarrolladores
Aquí hay 10 consejos de SQL Server rápidas y trucos para los desarrolladores de bases de datos recopilados por expertos de SQL Server Pinal de Dave. Para los planes de consulta ineficientes: Compruebe si hay problemas con las estimaciones de cardinalidad malos. El...