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
Knowing Your Storage Basics – 2 Life Lessons
In the software world, it is often the case where everyone wants to learn and master everything. The problem with this approach is that we land into a zone of being master of nothing by the end of the day. The best way to learn, is to learn one thing at a time. The...
Data Governance Trends
The volume of data continues to increase and is coming from more data sources. With more data comes increased opportunity, but also increased risk of data miscomprehension and non-compliance with mandatory regulations. Every organization today has to determine how to...
FireMonkey Styles, Part 2: Creating a custom style for TSwitch
Holiday Time Resources
Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many web sites that provide SQL Server information, Idera has a Resource Center at www.idera.com/resourcecentral available for...
OpenSSL and HTTPS Support for iOS Devices
For the iOS Device target platform, which does not support dynamic libraries, you need a static version of these library files (libcrypto.a and libssl.a). To obtain these library files, do either of the following: Download the pre-compiled libraries from Github. Build...
Automating Data Modeling Tasks
Finding ways to automate common tasks can make your data modeling more productive. By investing a little bit of time initially, you can save time later over trying to make changes manually. In addition, your models will be more consistent and it can be easier to make...
Proof of Concepts made Easy with The Cloud
As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your own data center to facilitate the same. Well thanks to the Cloud, Pre-Sales Engineers, Solutions Engineers and Architects...
Data Modeling for Agile Environments
Agile Development has always been at the forefront of new ways of developing software. So why should Data Modeling be left behind? In this short post, we will cover some of the basic workings of an Enterprise Collaborative Data Modeling environment. In the next...
Consistent Data in Distributed Systems
This is a video replay from the DataU online conference. Data types that are not consistent across multiple systems where data movement occurs could result in loss of data or inconsistent data. Learn how to make sure that objects across multiple systems are consistent...
Integrated cross-platform SQL IDE for increased database development efficiency
Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL XE6, it gives you the ability to code and debug SQL for some of the most demanding platforms like Microsoft SQL Server...
2 Ways to identify that we have a bad plan in SQL Server
SQL Server is a complex RDBMS with a lot of capabilities in it. I am sure most of us have just scratched the surface when it comes to working with SQL Server (including myself). In this article, I thought to take a more complex topic and will try to demystify some of...
3 soft skills that you want to have in an interview
It was couple of years back that my friend had written this article on my blog - Interview Questions and Answers – Perspectives of an Author. I know a lot of that content is like golden words. All of us have been through the rigors of giving an interview and I am sure...
Top 3 Sample Databases for PostgreSQL
If a developer is attempting to learn a new process or test some code, it’s best to utilize a test environment such as a sandbox rather than the production server. A sandbox environment is the place where there are scenarios like the real world but no real world data....
Создание БД PostgreSQL для новичков
Даже если вы никогда ранее не работали с СУБД PostgreSQL, не представляет трудностей создать, заполнить и управлять БД на этой платформе, если у вас есть средства для работы с базами данных от компании Embarcadero. Допустим, у вас уже есть проект. Это может быть...
The #1 Data Modeling Issue – Being ‘Dead’ Right – By Len Silverston, Universal Data Models, LLC
While many data modelers are very open minded and not righteous at all in their attitudes, over the years, I have heard the following statements (paraphrased) from data modelers numerous times: ‘There is one and only one best way to model a data modeling requirement.’...
How to Connect your Applications to your Data
This is a video replay from the DataU online conference. An Application Programming Interface (API) brings your own applications closer to your critical business data, allowing you to access and control your business glossaries, terms and model data quickly and...
Cloud Databases – A Primer
Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases in the Cloud or Cloud Databases are being used synonymously. Cloud Database as defined by Wikipedia is "A cloud...
Exploring Microsoft SQL Server System Databases
The Microsoft SQL Server System comprises of four key System Databases master model msdb and tempdb The following table outlines the key points System database Description master Database Records all the system-level information for an instance of SQL Server....
Empower your Applications with Embarcadero Team Server APIs
The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. Team Server provides a way to connect your database tools to your data sources with a centralized glossary. You can define your...
Result Cache Using Rapid SQL
Hi! The Result Cache is a newer structure for Oracle11 and newer databases. This feature remembers the invariables and return values across sessions for your applications! This feature can seriously cut down on repeat executions to common...