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

Delphi Developer Skill Sprints: Short, Cool, Quick Tips, Tricks and Techniques for 2016

Rad Studio Delphi Development, Software development Concepts, Software Events
Skill Sprints are open to the public by Embarcadero again in 2016.  Follow this link to register for the free webinars that deal with the Delphi - Firemonkey application development or on Thursdays they are having the sessions using C++.  Register for Skill Sprints These are webinars scheduled for about 30 minutes, dealing with the topic and a follow-up Q&A.  The instructors are pretty solid in their knowledge so well worth the time spent.
Read More

Everything Search Engine free Windows Utility is worth a look!

Computer PC Tips - bits and bytes
[powr-twitter-feed label="Everything Search Engine"] Recently I downloaded a Windows utility for file searching that is extremely fast locating any type of file on my machines.  The software tool is called "Everything" and can be downloaded from Voidtools.  The software was created by David Carpenter and you can install either a 32 or 64 bit version. Installing Everything is very simple, you download either the 32 or 64 bit Windows version, it takes a few seconds to index and locate all hard drives or USB clips that are known by the operating system.  You will have a shortcut on the desktop and when it comes to locating any type of file you can use the filter to reduce what you are looking for or just put the title in the search box…
Read More

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

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