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
23Sep 2015 by richard@baronsoftware.com

How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance

Software Events, SQL Tips
Baron Software is proud to present "How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance" webinar on September 24th, 2015 during the Embarcadero DataU webinar series.  Richard Baroniunas will discuss the benefits of using Rapid SQL to prepare SQL statements to use Windows Functions and increase performance.   10:00am - 10:45am PDT How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance SQL Window Functions address a wide variety of querying tasks that encompass computations, pivoting and sorting which are applied to a set of rows that is all applied by a function. Each function can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query. Level: All Richard Baroniunas - Baron…
Read More
23Sep 2015 by richard@baronsoftware.com

Embarcadero DataU 2015 Webinar starts.

Software Events
Embarcadero Data University 2015 Online Conference September 23-24, 2015 Daily 6:00am-5:00pm Pacific / 9:00am-8:00pm Eastern The free, online conference for data professionals Today’s database environments are becoming more complex, with the addition of big data, integration of new platforms, and expansion of volume. There's so much you have to know, so much you have to do, and you're constantly being challenged to keep up with less – less time, less money, less training, and even less staff. How can you make sure you’re ready for what’s ahead? We can help you prepare for your future Join us for the Embarcadero Data University 2015 conference, a complimentary online event on September 23-24, 2015. We’re hosting two days of educational sessions for data professionals, targeted to address issues you may deal with…
Read More
25Aug 2015 by richard@baronsoftware.com

FixInsight for Rad Studio Delphi review

Rad Studio Delphi Development, Software development Concepts, Software Releases
The FixInsight software tool assists Delphi developers in finding possible coding defects that can affect the released product and this can be caught during the development process.   You can review the warnings as well as coding conventions that are part of the release.  Baron Software highly recommends the product for Delphi developers, we found that it is quick to point out various things we did not think about as well as potential issues.  You can view the product at FixInsight. The latest updated is available providing a few new rules and it was quick to install to allow work to continue.   The software is flexible for a few entries by simply opening FixInsight, right click on a option and you can modify what is allowed. It is simple to understand and…
Read More