Blog

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…

by DavidI

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?

by Liz Stephens

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

by Liz Stephens

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

by Liz Stephens

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.

by Ritesh

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

by DavidI

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

by Pawe Gowacki

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

by Liz Stephens

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

by Liz Stephens

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

by Stephen Ball

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.

by Ritesh

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.

by Ritesh

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

by Niels Gron

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

by Ritesh

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

by Liz Stephens

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!

by Ritesh

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?

by Ritesh

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.

by Ritesh

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.

by Ritesh

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?

by Niels Gron

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...