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.
- 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 and easier to quickly find files.
- Mail is improved for touch screens and brings up full screens for better mobility
- Notes can handle images and checklists putting the nice touch on the document.
- Photos increased performance and better management.
- Safari, improved with pin sites to allow quick access to your favorite web sites, manage web sites that have sounds to quickly mute them.
- Language support.
Best of all it is free to all OS X users. As always you need to check if your current Mac can support the OS before you install it but by tomorrow most Mac users will be using El Captain.
Read the details on Apple Web Site
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 & non monitoring)
- Performance IQ (Available as a paid add-on for DBArtisan 2016 & Rapid SQL 2106)
- Embedded Performance Metrics & Analytics
- Embedded performance metrics & analytics across DBArtisan to provide deeper database insights
- Understand the top SQL statements impacting IO, table and index growth history
- SQL Analytics
- SQL editor shows you how SQL has performed over time in its various revisions
- Why performance variances are occurring
- New indexes are suggested should SQL performance benefit from such additions
- 24/7 Wait-based Monitoring & Alerting
- 24/7 wait-based observations to help you proactively manage your database environment
- Time travel to allow you to rapidly travel back in time to dissect issues as they occurred
- Baselines to more fully understand deviations from the normal trends
- User configurable alerting so there are no surprises
- DB Change Manager and DB Optimizer 2016 continues to be supported and sustain currency
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 surveyed developers had 5 or more years of experience.
- Around 57 percent said they were interested in “staying current” about development technology.
- A full 75 percent used open-source software.
- Some 83 percent considered themselves “self-reliant,” using online forums and search engines to get job-related help.
The most popular databases and platforms include MySQL (64 percent of respondents), Microsoft SQL Server (49 percent), SQlite (39 percent), Oracle DB (37 percent), and ProgresSQL (23 percent).
A lot of developers who read the survey will likely see themselves reflected in the results.
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.
Richard Baroniunas – Baron Software