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
Designing App Navigation with TMultiView
In RAD Studio XE7, we introduced a new smart menu component called TMultiView. With TMultiView, it is really easy to create app navigation that automatically adjusts itself depending on form factor, orientation and target platform using our new behavior services....
Visual Analytics, Visual Query Builder, Amazon Redshift and VoltDB are now part of Aqua Data Studio 15!
We have been hard at work this year with the development of Aqua Data Studio (ADS) version 15.0. Our new version focuses on making ADS the one stop shop for your data needs with the addition of the new Visual Analytics component. Not only can you easily manage and...
SQL diagnostic manager Secrets: When is a report more than a report?
SQL diagnostic manager provides many different views of the data it collects. This lets you explore all available data when diagnosing tricky problems as SQL DM provides many graphs, lists and views to let you explore your SQL environment. It also provides reports on...
Preparing for Data Centric Interviews by Pinal Dave
These days the fundamentals of taking an interview have not changed much. The more experienced you are, the greater the likelihood of getting into multiple rounds of interviews. If you have been in the industry for close to a decade, when do you start preparing for...
Performance Improvements with SQL Server 2014
Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make it superior from previous model. If the features are appealing, generally customers are positive and forthcoming to pay...
FireUI Multi-Device Designer and working with Views
In RAD Studio XE7, we introduced the FireUI Multi-Device Designer. FireUI makes it easy to create user interfaces across multiple devices using a master form to share all user interface code, and then optimize inherited views for each target platform and device. ...
Rapid SQL Code Templates by Dan Hotka
This is part of a series of guest posts by Dan Hotka. Hi! This week I want to show how Rapid SQL can improve your coding productivity and technique by using its templates. A template saves me from having to look up the exact syntax. To use, simply put your cursor on...
What Are SQL Elements Health Checks?
I have recently received a number of questions regarding Health Checks in SQL Elements, what are they, how often do they run, and what do I do with them? Health checks are a great way to get a holistic view of the performance, availability and other critical issues on...
Server Change Over
I am looking to upgrade my up.time server from a virtual Windows Server 2008 R2 running mysql to a physical Windows Server 2012 R2 running sql server 2012. Â I don’t want to lose my current configurations and I wasn’t sure if a switch from mysql to sql...
New Free Tool – SQL Update Statistics is available now!
Table statistics maintenance is an important part of overall SQL Server administration. DBAs understand a common cause of query performance problems come from rapidly changing data. By design, databases have an option to auto update statistics, but when data is...
Upgrade Errors with 8.5
Hi, I’m new to SQLdm. I’ve been tasked to upgrade from 8.01 to 8.5. During the upgrade process I get an error stating that it can’t create a log file because the log file already exists. When we looked for the log file, we found that it’s...
Bluetooth LE support in RAD Studio XE7
RAD Studio XE7's integrated wireless support (Bluetooth and Wifi) works with thousands of consumer and industry specific devices. RAD Studio's approach makes it easy to integrate virtually any device into the app user experience, and even support multiple...
Metadata Overview, by Ron Huizenga
What is Metadata? The term “Metadata” arises frequently when discussing Data Architecture. In short, it is “data about data.” However, interpretation can be rather ambiguous, since it is used in different contexts. The most common context is known as...
Granting Namespace Rights to DM Service Account
community.idera.com/.../Granting-Namespace-Rights-to-Service-Account-for-SQldm-Web-Console-Services.docx Useful document describing how to grant minimal rights to the service accounts used by the new SQL Diagnostic Manager web dashboard.
SQL Server – Server Node Reports for Troubleshooting
This is a guest post from Pinal Dave. For many DBAs, restless nights start when end users complain that the application using SQL Server is too slow. Most SQL Server workloads begin running slow when the DBA is not monitoring them. There are many tools available...
Monitoring Disk Queue Length
Recently, I wrote a blog post about performance counters and why the threshold depends (Performance Counters: Why It Depends). In this post, I talked about why the counter Disk Queue Length is no longer a valid counter to use. Today, I want to elaborate on that and...
Executing Explain Plans Using Rapid SQL by Dan Hotka
This is a guest post from Dan Hotka, Oracle ACE Director. Learn more at his webinar Explain Plan Tips and Techniques. Hi! My name is Dan Hotka. I am an Oracle ACE Director. One of my many charters with this group is to help spread the good word and technical knowledge...
SQL Heatmap is here – Idera’s newest free tool
Idera strives to bring helpful tools to the market for DBAs and Developers to complete daily tasks and a variety of these are free. Today we announce our latest free tool, SQL Heat Map, which displays SQL Server capacity utilization in one simple snapshot view. A...
Seven Deadly Sins of Database Design
If you don’t get the data right, nothing else matters. However, the business focus on applications often overshadows the priority for a well-organized database design. Addressing some simple data modeling and design fundamentals can put you on the right path. Here are...
Solution: How to register SQL2014 in Defrag if it does not support this version?
I have registered SQL 2008, SQL2012 in my Defrag to monitor them. Then I tried to register SQL Server 2014 instance too. Defrag cannot register it because it does not support SQL2014 at all. What to do? 1. Exit Defrag application 2. Run SSMS, connect to Defrag...