Hi! Dan Hotka here with more knowledge about Rapid SQL. I’ll address the auto replace feature of this tool and how you can use this feature to...
Blog
Rapid SQL Query Builder Tips and Techniques by Dan Hotka
Hi! Don’t you just love a good SQL query builder? I found this tool in Rapid SQL easy to learn and easy to produce the SQL I desired. You start it...
SQL Traffic Accelerator as a DB performance tool
We get questions from time to time from folks asking what SQL Traffic Accelerator does for DBAs since it sounds like a network monitoring tool....
Mission Impossible? Effective Database Backup Strategies
Mission Impossible? Effective Database Backup Strategies Organizations use multiple strategies when working with backups. An effective restore...
Enterprise Data Confusion – Did We Bring This Onto Ourselves? – authored by David Loshin, Knowledge Integrity, Inc.
This is the first in a series of six posts from David Loshin. Read his next post. A few years back, I had the opportunity to work with...
SQL Syntax in Rapid SQL by Dan Hotka
Abstract: Guest blog post from Dan Hotka, Oracle ACE Hi! Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your...
3 Leadership Tips defining Success
Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a number...
Solution for the EditorLineends.ttr issue
During the month of August 2014, Microsoft issued a security patch for Windows (http://support.microsoft.com/kb/2993651). This update had an impact...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...