Featured Blog
Empowering Law Firms: How SQL Server and Idera Tools Safeguard Legal Data
Getting the Permissions Wired-Up Properly When Attaching a Content Database to a SharePoint Farm
You’ve probably heard the latest news in the SharePoint world: SharePoint 2013 has been released to manufacturing (RTM)! We’ve been told...
BUMMER
USE mysql; SHOW FULL TABLES WHERE table_type = 'base table'; /* returns ... innodb_index_stats BASE TABLE innodb_table_stats BASE TABLE ......
Top MySQL Blogs You Should Be Reading
There's a lot happening in the world of MySQL and it's really vital to be up-to-date with the latest advancements in this field to stay ahead of the...
Powershell
Hi there, I have created a simple powershell script which I know works on my local machine running Windows 7 64bit. I have an evaluation copy of...
ORM Frameworks for Delphi…
I have just returned from my RAD Studio XE3 World Tour stops in Europe. It was great to see so many young and old developers in London, Amsterdam,...
Okay, Really – What Can I Do with a SharePoint Farm Configuration Database Backup?
I’ll cut straight to the chase: no, a configuration database backpastedimage1478188484999v3.pngup is not just a fancy paperweight. The prevailing...
Don’t Forget Application Caching to Boost SQL Server Performance
When it comes to SQL Server performance, many organizations look to their DBAs to help fine-tune hardware configurations, optimize indexes, or weed...
Tips for Optimizing XML in SQL Server
I’ve worked on a project that used XML heavily inside SQL Server. We really utilized SQL Server’s XML support almost to the full extent,...
Character sets in MySQL – still not for Windows users.
Recent MySQL versions (first the chaotic series of releases that preceeded 5.5 - 5.2, 6.0 and 5.4 - and now 5.6) adds new 'character sets'...
Delphi Training videos and tutorials – from LearnDelphi.tv
For those of you who need to learn more about Delphi programming, Alister Christie (http://learndelphi.tv/) who is one of our Embarcadero MVPs, has...
Custom FireMonkey "TSimpleTriangle" component
Have you ever written a component in Delphi? Reusable components are the corner-stone of rapid application development and important part of Delphi...
Consider Your Collations Carefully, Or Pay Later
When first installing SQL Server, many developers and DBAs new to SQL Server may have the temptation to click Next, Next, Next on the installation...
Ensure Proper SQL Server Connection Pooling
Coming to SQL Server from both a database developer and DBA background, I maintain that while tuning SQL Server’s ability to handle your application...
Getting to grips with using FireMonkey Grids
Although there is a huge amount that is the same for Delphi and C++ Builder developers between VCL and FireMonkey, one thing that has changed is the...
Monyog Custom Counters – overcoming a problem.
In this previous Blog I described an example on how to build a Custom Object in MONyog. But there is one problem you may encounter and that is, that...
Log security and log tables.
Accidentially I came across the statement "SHOW GRANTS requires the SELECT privilege for the mysql database." in MySQL documentation...
Java 6u29 bug prevents SSL connection to SQL Server 2008 R2
In Java 6u29, there was a bug introduced which prevented SSL connections to SQL Server 2008 R2. This bug was logged with Oracle as Bug ID: 7103725...
How to add a simple Custom Object in Monyog
MySQL is developing rapidly. And today it does not only happen along a single track but in multiple directions simultaneously. This is due to both...
How to Make a Copy of a Database on Windows Azure SQL Database
Windows Azure SQL Database (previously SQL Azure) offers a unique way to make a database copy to another database using the CREATE DATABASE as COPY...
Per-database information in performance_schema, please!
This is a follow-up om my first Blog on performance_schema that appeared here: One particular request that we had frequently from our users is to...
FLUSH STATUS surprise?
What does FLUSH STATUS do? We all know that it will simply reset all status variables (except for 'uptime') to same values as immediately...
Performance_schema considerations.
I have for the first time been spending some time trying to understand the performance_schema. It is not easy to understand everything unless you...
Setting per-server thresholds in Monyog.
Please note that this blog was updated on April 5th 2012. We have added(at the buttom) how to use server TAGS for defining thresholds....
Why does selecting a file in the filechooser on OSX not select the file extension with the full file name?
I run the Import Tool, and click browse to select a file to import. When I select one of my files, which has a .CSV extension, the full file name is...
I get the warning “Server returned invalid line number (0)” when debugging a Sybase procedure, am I doing something wrong?
I am not sure why I am getting the warning "Server returned invalid line number (0)" when debugging Sybase stored procedures. Response Niels Gron...
Why are certains operations of Aqua Data Studio very slow with MySQL?
I have a server registration to MySQL and other databases. When I execute queries in the Query Window for MySQL they are fast. But If I try to...
Why isn’t there a Procedure Editor for MySQL like there is for the other database vendors?
I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in MySQL this option doesn't...
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. What do I do?
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. Response Jonathan Powers over 11 years ago Unstable...
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another?
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another? Response Jonathan Powers over 11 years...
Scripts with multiple statements return errors. Some database commands or symbols do not work in Aqua Data Studio while they do work in the database vendor’s command line tool.
Scripts with multiple statements return errors. Some database commands or symbols (such as “;”) do not work in Aqua Data Studio while they do work...