TEMP is A Four Letter Word

TEMP is A Four Letter Word

It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taught record oriented or “record at a time”...

3D Credits Scroll with Delphi

3D Credits Scroll with Delphi

A little fun with Delphi for today’s Star Wars day! This is a pretty simple 3D form with a 3D layout at an angle, and then a 2D layout with text and images is animated up the 3D layout. The only code is populating the labels as the animation kicks off...

Database Execution Plans Can Lie

Database Execution Plans Can Lie

Quote: Do not put your faith in what statistics say until you have carefully considered what they do not say.  ~William W. Watt. I started this blog with that quote because I find that database execution plans can sometimes behave very much like statistics...

The Evolution of Database Tuning Approaches

Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per hour. The database schema design is complex with approximately 1,000 tables and 1,500 indexes. Moreover the application...

Managing Mountains of Data with the Cloud

Managing Mountains of Data with the Cloud

When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was simply based on what the company was willing to pay for relatively expensive onsite disk space. So while a company might...

Removing the Community toolbar

Removing the Community toolbar

The RAD Studio IDE contains a toolbar allowing you to log on to Community, and see messages sent to you by other users, questions and answers, and other notifications. Recent website upgrades have caused issues with this toolbar for some users (now resolved), and...

Copy of Google Book APIを使ってISBNコードから書籍情報を取得する

Copy of Google Book APIを使ってISBNコードから書籍情報を取得する

筑木です。今回はWebAPIへのアクセスの例として、Google Books APIsを使ってISBNコードから書籍情報を取得してみます。 応用として、TCameraComponentとZXingを使って画像のバーコードから書籍のISBNコードを読み取り、Google Books APIsで書籍情報を取得、それをDBに登録して蔵書管理アプリみたいなものが作れます。 Google Books...

Webinar Replay: C++ Software Security Sins

In the world of software development, we are up against new cyber security threats each day, and the risks and consequences of un-secure software is too great to be unaware of.   Join presenter, Mary Kelly, to address the key security sins related to C++...

C++ Free Compiler Updated to 10.2.3

Embarcadero has had a free download of our C++ compiler and RTL (capable of making Win32 apps) for many years, going back into the Borland days. (In fact, Idera as a company likes providing free tools - check out some of the others here.) We aim to keep...

Database Needs in The Cloud – May #SQLChat

Database Needs in The Cloud – May #SQLChat

Movement to the cloud is in full swing! Regardless of the cloud provider, you will need a migration strategy and the knowledge to make choices unique to your database. Please join us for a community discussion on the Cloud during our next #SQLChat on Wednesday, May 9...

Improve MariaDB Performance using Query Profiling

Query profiling is a useful technique for analyzing the overall performance of a database. Considering that a single mid-to-large sized application can execute numerous queries each and every second, query profiling is an important part of database tuning, both as a...

Copy of 未来日を和暦で扱うアプリは Windows 10 1803 で影響が出ないことを確認しましょう

Copy of 未来日を和暦で扱うアプリは Windows 10 1803 で影響が出ないことを確認しましょう

和暦を扱うシステムが2019年5月1日以降の未来の日付を扱う場合は、暫定的にレジストリの修正が必要かもしれませんよ? Windows 10 1803 でレジストリに追加されるレースホルダは "2019 05 01"="??_?_??????_?" のように、2019年5月1日の改元日に対して仮設定を追加するものです。新しい元号は公示されていませんから ? で表記されているわけですね。このような設定は、現在の日付や過去の日付を西暦和暦変換する場合には当然ながら全く問題がありません。...

RAD Studio 10.2.3のパッチと情報の要約

RAD Studio 10.2.3のパッチと情報の要約

この記事は、MARCO CANTUによるRecap of RAD Studio 10.2.3 Patches and Informationの抄訳です。   4月初旬にPMチームによって行われたウェビナーはYouTubeで公開しておりますので下記のリンク先でご視聴頂けます。 https://community.embarcadero.com/blogs/entry/10-2-3-webinar-replay 本コミュニティサイトの10.2.3関連ブログ投稿を下記URLで閲覧することもできます。...

1 64 65 66 67 68 124