07Jan 2016 by richard@baronsoftware.com

Embarcadero and Baron Software Powerstudio case study which monitors SQL Performance

Rad Studio Delphi Development, Software development Concepts, Software Events, Software Releases, SQL Tips
Embarcadero and Baron Software has issued a case study that demonstrates the benefits of using Microsoft SQL Powerstudio product line.  Powerstudio is a robust package that monitors SQL performance and can provide assistance for clients to update or create tables, stored procedures, etc. for various SQL servers some being Oracle, Microsoft SQL and many more.  The detailed report can be view by clicking here.  
Read More
24Sep 2015 by richard@baronsoftware.com

Embacadero releases DB PowerStudio® 2016

SQL Tips
Embarcadero has released DB PowerStudio 2016 during the DataU Webinar 2 day conference.   Product installation is simple and quick.  The new features that provide DBAs the ability of checking SQL Server performance by using the add-on Performance IQ. Only Rapid SQL and DBArtisan 2016 have been released, not sure what the status is on DB Change Manager and DB Optimizer since they were not part of this release.    The packages are getting more robust but the add-on cost is big for smaller firms.   Key Enhancements for DBArtisan and Rapid SQL 2016 Deep performance integrations into DBArtisan & Rapid SQL Significant SQL IDE enhancements to detect poor SQL performance Cardinality problems Data skew issues Substandard SQL syntax Inefficient index usage & index suggestions Full alerting package (+blackouts &…
Read More
23Sep 2015 by richard@baronsoftware.com

Developers always looking to keep with the current market based on their skills.

Software Events
Software developers have always fought to keep up with the skills necessary to make themselves marketable.  A new survey has been created by IDC / Application Developers Alliance that provides the insight on the tools used as well as organizations.   As always a survey is conducted by taking a sample from people of where they are working.  So take it with a grain of salt because certain software tools are used in particular areas of the country. The survey, conducted by research firm IDC and commissioned by the Application Developers Alliance, drew responses from 850 developers—not a massive cross-section of the world developer population, which easily numbers in the millions, but certainly enough to bring certain trends to light. Here are some highlights from the study: Some 68 percent of…
Read More
18Aug 2015 by richard@baronsoftware.com

Android SQLite Essentials Book Review

Book Reviews
  I recently had the pleasure of reading Android SQLite Essentials by Vikash Kumar Karn / Sunny Kumar Aditya. The book details about using SQLite with your android and some tips about accessing the database from multiple applets on your android device. The book is rather small about a little over 90 pages which I do not understand how Amazon comes up with 127 pages unless they are counting certain sections twice.  The chapters are simple concepts that anyone can understand and within an hour you can have a pretty good idea on what to expect as well as how to use SQLite. The chapters are listed below, you can complete the book within an hour and get developing.   The source code is available from their web site and…
Read More