One of my pet peeves is the use of RECONFIGURE WITH OVERRIDE in scripts to change server options. Am I being unreasonable or is this justified? All...
Is Using RECONFIGURE WITH OVERRIDE dangerous?
read more
Blog
Delphi Labs: DataSnap code samples updated to XE3
It seems that it is my very first post in the New Year 2013, so I wish You all the best and great time writing all kinds of programs. I'm sure...
Increase SQL Server Performance Using Multiple Files
By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to...
Unix Log Scanner
After the installation of the Unix Log Scanner using the uptime plugin manager I try to create a service monitor. But every time I run the test I...
XE3 Visual LiveBindings: User defined objects
The adapter components TListBindSourceAdapter and TObjectBindSourceAdapter enable LiveBindings with user defined TObjects. Here is a user defined...
Installing Sonar for Delphi
On 15th of November the HTML5 Builder QA Team was in the VLCTesting where we learned very good experiences and shared knowledge, amongst this was...
Why isn’t there a Procedure Editor for Sybase ASE 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 Sybase ASE this option...
Can we export data from Oracle using UTL_FILE or the SPOOL command?
How can we do this? Response Niels Gron over 10 years ago You can accomplish this functionality in Aqua Data Studio with the same or similar...
DB2 iSeries SQL and System Naming
I have a question about using "system" naming with the iSeries driver. Usually this allows you to provided a list of schemas that may contain your...
Why does Table Data Editor ask me to disambiguate column names?
When I enter a query into ADS which contains a join and the tables have common column names, the database server will not execute the query if the...
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...