Tips for using SQL Server 2014 file and filegroups Set the reasonable sizes for the database and transaction log. First of all, before database creation, you should estimate how large your database will be. To estimate the reasonable database size, you should estimate the size of each table individually, add some additional space (10-20%) and then add the values obtained....
Other News
New Skills Required of Internet DBAs
(Craig S. Mullins) When DBAs transition from supporting internal applications only, to Internet-exposed applications, there are a lot of additional skills required to ensure success. Some of these skills are obvious, like the need to understand the protocols of the Internet including HTTP and FTP an
IBM Datacap 9.0 Developer Kit
(Robert Ferin) The IBM Datacap 9.0 Developer Kit provides applications and files that allow unlimited extension and customization of the product. These customizations can be used to tailor your application to perform unique functionality or operate in a manor specific to the needs of your organizati
Why JSON Triumphed Over SOAP
(Bill Doerrfeld) In recent years, JSON has prevailed as the leading protocol of choice for web-based APIs. However, this wasn’t always so. Cloud computing developer Keith Ballinger explains that in 2000, SOAP & XML protocols for distributed computing were the rage, gaining much popularity endorsed b
Online multiple javascript compression tool
(Gilly Barr) Minifying/compressing javascript files has become a standard for a while already when developing websites. It is very important to save as much space as you can and have your users downloading as little as possible to improve the performance of your site.
How To Set EAR Upload Size for Oracle Enterprise Manager
(Andrejus Baranovskis) By default, there is a limit for EAR upload size (~40 MB) in Enterprise Manager. If your ADF application is fairly big, you may face this limitation and will not be able to deploy through Enterprise Manager.
EM12c Management Agent, OutOfMemoryError and Ulimits
(Kellyn Pot’Vin) While enjoying the lovely Liverpool, UK weather at Tech14 with UKOUG, (just kidding about that weather part and apologies to the poor guy who asked me the origin of “Kevlar” which in my pained, sleep-deprived state I answered with a strange, long-winded response…. :)) a customer con
Using Apex Authorization schemes in PL/SQL
(Jan Willems) The problem with using APEX authorization schemes in PL/SQL has been addressed several times in blogs and forums, but we occasionally still get questions on how to solve this:
GDB Tips: Inspecting MySQL Plugin Variables in Core File
(Annamalai Gurusami) Recently I had a need to determine the session value of a MySQL plugin variable in a core file. Here I use the word plugin variable to refer to MySQL system variables provided by plugins.
Select * from yourtable… How bad is it?
(Chris Shaw) Have you heard and understand why processing a ‘select * from any table’ can be negative on the performance impact?
