30Sep 2015 by richard@baronsoftware.com

Apple OS X El Capitan is being released today.

SQL Tips
Starting on September 30th, everybody will be able to install Apple's latest OS X update, El Capitan, on their Macs. It'll be free, and given that Apple claims its predecessor had "the fastest adoption ever" of any PC OS, it'll be popular too. El Capitan is the small one in Apple's big-then-small OS update cadence, which means that we have just a few core changes, a bunch of app updates, and a healthy pile of bug fixes. Major updates: Start-up will be faster. Split View which automatically will fill the screen with another application. Mission control has been vastly improved.  Windows will be in a single layer, no stacking and set up relative to each other. Spotlight is improved to quickly gather weather, stocks, sports faster. File searching is smoother…
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

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
30Dec 2014 by richard@baronsoftware.com

Simple Steps to successfully moving a WordPress Web site to another web hosting firm.

SQL Tips
To move a WordPress web site from one web hosting company to another sometimes can be very stressful due to the unknowns on how WordPress has been saved at the older location. The following step by step will provide you with the best method to verify your work and keep maintenance limited. The following was done using a Windows 7 machine and extracting a web site from a Linux web server as well as moving it back to a Linux web server. 1. Getting the files from the web hosting machine. You will need an FTP account to download the entire web site to your local machine. A great software tool to use is FileZilla which is free and can be downloaded from http://www.download.com. All you need is the client…
Read More