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
DDL Invalid – Missing event types in Compliance Manager
If you are auditing a SQL server that is running extended event traces, you may be seeing events come through in SQL Compliance Manager of category DDL and event type “DDL INVALID”. When you see an invalid type, that means it isn’t a type currently listed in our...
Data Breaches: A Shift from Pure Prevention to Monitoring and Collaboration
It’s every Database Administrator’s nightmare to see your company’s name in the headlines in connection with a high profile data breach. Breaches can happen to businesses of all sizes and across industries. According to the Verizon’s report, 2015 Data Breach...
ISQL Editor in DBArtisan and Rapid SQL – DBA and Developer Skill Sprints
In this skill sprint we cover ISQL editor features in DBArtisan and Rapid SQL. Learn about the options available in the ISQL window for different database platforms and for Auto Format and Code Assist. Then see some examples of Oracle and SQL Server queries, how to...
MSSQLTips Reviews Top New SQL Free Tools from Idera
Most of you are aware of the variety of free tools Idera offers to the SQL community to help with SQL Server tasks. Some of you have even mentioned those you have found helpful in your blogs, tweets, etc. (to which we are extremely grateful). Idera offers 14 free...
Finding Your Top Offending Statements with Extended Events
Finding the top offending statements for a specific workload can be hard if you are not using the best tool in your toolbox. On SQL Server 2012 and going forward you are able to leverage extended events which are included inside of SQL Server Manager Studio (SSMS) to...
Continuous Delivery in the Database
What is Continuous Delivery? Agile Software development deals with the shorter development cycles and frequent releases. This development process offers great benefits to organizations by reducing the overall risk associated with software development. ...
O controle de versão: Comece a trabalhar com Git, repositórios remotos e RAD Studio XE8
Em uma das mais recentes pesquisas entre os desenvolvedores do RAD Studio, percebemos que ainda há uma parte significativa da comunidade que não utilizar qualquer sistema de controle de versão, um surpreendente 32%. Há muitas razões para usar um sistema de controle de...
Контроль версий: Начните с Git, удаленных репозиториях и RAD Studio X Е8
В одном из последних исследований среди разработчиков RAD Studio, мы поняли, что есть еще значительная часть сообщества, которые не используют какой-либо системы управления версиями, удивительное 32%. Есть много причин, чтобы использовать систему контроля версий,...
Version control: Get started with Git, remote repositories and RAD Studio XE8
In one of the latest surveys among RAD Studio developers, we realized that there is still a significant part of the community that doesn’t use any version control system, a surprising 32%. There are many reasons to use a version control system, no matter if you're...
El control de versiones: Primeros pasos con Git, repositorios remotos y RAD Studio XE8
En una de las últimas encuestas entre los desarrolladores de RAD Studio, nos dimos cuenta de que todavía hay una parte importante de la comunidad que no utiliza ningún sistema de control de versiones, un sorprendente 32%. Hay muchas razones para utilizar un sistema de...
Aligning Your Models for Master Data Management – by David Loshin
In my last post, I suggested that the conventional “facet” approach to designing master data models (in which each master domain is modeled, designed, and implemented in isolation from the others in the enterprise) creates gaps in the ability to effectively build...
Creating Custom Multi-Device Preview Devices
In RAD Studio XE8, we introduced the Multi-Device Preview. The Multi-Device Preview provides a design time view of what your application is going to look like on a wide range of devices. In RAD Studio XE8, you can easily add your own device...
Video: ER/Studio Support for Hadoop Hive
Since data stored in Hadoop is almost always used for analytics, and because of its immense volume and wide variety, the need for data modeling has never been greater. Watch this short video to see how Hadoop Hive tables can be reverse and forward engineered using...
Life of a DBA in GIFs
A Database Administrator experiences a wide range of emotions. It could be one those endless meetings, friendly disagreements with fellow developers, getting something approved from managers or preparing your junior DBAs for bigger battles. Each day is a challenging...
Model Your Hadoop Hive Databases with ER/Studio
With round-trip database support, data modeling professionals can use ER/Studio Data Architect to easily reverse-engineer, compare and merge, and visually document data assets residing in diverse locations from data centers to mobile platforms. A variety of database...
Improve Agility and Collaboration with ER/Studio XE7
On April 28, 2015, Embarcadero announced the XE7 release of our award-winning ER/Studio data modeling and architecture suite, with new features to improve agility and collaboration in enterprise data landscapes. Let’s highlight them, and for more details and a...
CORS on DataSnap REST Server
Cross-origin resource sharing (CORS) is a mechanism that enables resources to be shared across domains. Typically this isn’t allowed to prevent security issues. To enable on your DataSnap REST server you can use the following code per MVP Nirav...
Detecting memory leaks with Precise
Memory leaks in java and .NET can cause major performance issues with the application. Precise helps you to detect those memory leaks. In java, Precise monitors the jvm heap size and usage. It indicates when the heap size grows as shown in the screenshot below. It can...
Business-Oriented Conceptual Modeling for Master Data Entities – by David Loshin
In my previous post, we examined some of the challenges associated with developing data models for master data entities managed within an MDM environment, and I implied that achieving the holy grail of MDM, namely the (elusive, if not purely mythical) “golden record”...
The Evolution of Data Modeling – by Ron Huizenga
When we review the evolution of new data architecture and development methodologies, along with the corresponding changes in corporate culture, we can see that there have been numerous approaches over the years. In the earlier days of traditional / waterfall processes...