TMS Component Pack v8.8 released with 3 new components

TMS Component Pack v8.8 released with 3 new components

TMS

TMS has released Version 8.8 Component pack for VCL development using Delphi.  The components range in vast improvements that allow a Delphi developer to easily drop a component on the form to reduce the amount of coding necessary to get the application to market.

TMS Component Pack v8.8 released with 3 new components: http://www.tmssoftware.com/site/news.asp

 

  • New : TAdvDBListBox v1.0.0.0 : Listbox control with embedded filter + insert data capability that can be bound to a dataset field.
  • New : Automatic button column type when setting Columns[x].Editor := edButton in TAdvColumnGrid
  • New : Hover background, text & border color capability in TAdvResponsiveList
  • New : Name property added to TInspectorItem in TMS InspectorBars
  • New : InspectorPanel.Items.Item[Name] added to access items by name in TMS InspectorBars
  • New : Planner.GridControl.BorderColor: TColor property added in T(DB)Planner
  • New : Enabled property added at item level in TTodoList
  • New : Property EnableWheel added in TAdvComboBox
  • New : ListLeft.Caption, ListRight.Caption properties added in TAdvDualListBox
  • New : Lookup, resizable and save function in design time editor in TPictureContainer
  • New : Label added in TAdvMultiButtonEdit
  • New : Property AutoCheck added in TAdvOfficeRadioButton
  • New : Automatic button column type when setting Columns[x].Editor := edButton in TDBAdvGrid
  • New : TAdvHighLightLabel v1.0.0.0 : Label that allows to highlight specific words in the label text in different colors.
  • New : TAdvTouchSpinEdit v1.0.0.0 : Spin edit control with spin buttons left and right from the edit control to allow easy up/down button access from touch screens.

Create modern-looking & feature-rich Windows applications faster with over 400 components in one money and time saving bundle for Delphi 7, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo & C++Builder 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo

 

Chances of making a successful mobile app

Chances of making a successful mobile app

Very sad news on the changes of making a successful mobile app to make you millions of dollars is next to nothing at this point.  Check the following web page with the similar concerns of getting the first cool million dollars.  The article is stating that most mobile developers are making next to poverty amounts.

Now this is a sorry state of affairs that you cannot make an amount of cash that would help pay the mortgage.

By 2015, 60 percent of app developers were earning under the poverty line, making profits of less than $500 per month. Older statistics indicate that 80 percent of developers don’t earn enough to turn their development into viable businesses. But things are improving; more money is being paid out, so surely developers are being paid more, right? Well, as it stands, Apple’s App Store and Google’s Play Store are horribly stacked in favor of the largest players in the market, and the current trend would seem to indicate that this divide will only grow, despite the fact that barriers to entry to the market are apparently falling. After all, with a mere $124 you can get access to both the Apple and Google app stores — and with that, access to tens (soon to be hundreds) of billions of app downloads.

This brings everything to the forefront, can you survive development of a mobile app on the Apple store ?  The yearly fee must come into mind so that any profit is paying for getting the app approved and on the store.

Very sad when you take into consideration what software you are using to develop the product.

Swift 4.0 Released!

Swift 4.0 Released!

Swift 4 is now officially released! Swift 4 builds on the strengths of Swift 3, delivering greater robustness and stability, providing source code compatibility with Swift 3, making improvements to the standard library, and adding features like archival and serialization.

Swift is a general-purpose programming language built using a modern approach to safety, performance, and software design patterns.

Updates

Swift 4.0 is a major language release and contains the following language changes and updates that went through the Swift Evolution process that can be viewed by clicking here

Apple (Xcode)

For development on Apple’s platforms, Swift 4.0 ships as part of Xcode 9.  Open-source Swift can be used on the Mac to target all of the Apple platforms: iOS, macOS, watchOS, and tvOS. Moreover, binary builds of open-source Swift integrate with the Xcode developer tools, including complete support for the Xcode build system, code completion in the editor, and integrated debugging, allowing anyone to experiment with the latest Swift developments in a familiar Cocoa and Cocoa Touch development environment.

Linux

Official binaries for Ubuntu 16.10, Ubuntu 16.04 and Ubuntu 14.04 are available for download. Open-source Swift can be used on Linux to build Swift libraries and applications. The open-source binary builds provide the Swift compiler and standard library, Swift REPL and debugger (LLDB), and the core libraries, so one can jump right in to Swift development.

How to purge Microsoft SQL email Items

How to purge Microsoft SQL email Items

Purge

There are times that housecleaning older mail in your database needs to be done.  A simple scheduled task can be done every month to purge what is no longer necessary.  SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove these mail history unless it is required for auditing or other purposes.

As always make sure you have your backups done prior to running any sort of removal in the event you did something incorrectly.  By purging you are reducing the amount of wasted space in the msdb database that could be used for other things activities.

Simply running the following statement using T-SQL you can check the amount of database mails that have been processed from the catalog msdb.dbo.sysmail_allitems.   There are 3 additional  views which shows mails in their different statuses:  sysmail_faileditemssysmail_unsentitems and sysmail_sentitems.

 

SELECT  COUNT(*)  FROM  msdb.dbo.sysmail_allitems

You should get back the count of how many mail items are stored in the msdb.

How to delete mail

To delete mail items you can use system stored procedure sysmail_delete_mailitems_sp, it has below syntax:

sysmail_delete_mailitems_sp [@sent_before] [@sent_status]

You can delete mail using either of the parameters, @sent_before deletes all mail that were sent before specified date, and @sent_status deletes all mails with specified status.

For example, to delete all mails which are sent and are older than current month we can use:

EXEC  msdb.dbo.sysmail_delete_mailitems_sp

@sent_before = ‘2017-05-10 00:00:00’,

@sent_status = ‘sent’

You can modify the @sent_before to do the following:

DECLARE @PurgeDate datetime = dateadd(dd,-30,getdate());  

@PurgeDate will be the date from 30 days or older which is a good idea to remove that or you can change it to
-10 for anything older than 10 days.

So the statement would be

EXEC  msdb.dbo.sysmail_delete_mailitems_sp @sent_before=@PurgeDate;

You may choose to only delete mail items that have been successfully sent.  If that is the case then you can run the following code to delete your database mail based on the sent­_status of “sent”.

If you are not periodically deleting your mail then you might want to consider cleaning up old database mail that no longer has value.  Determine what retention period you should use for your database mail.  With your established retention period then just set up a SQL Agent job to purge your database mail based on your retention period.

Idera – Free Tool – PowerShell Scripts for SQL Server

Idera – Free Tool – PowerShell Scripts for SQL Server

Idera

Idera is offering a free tool of Powershell scripts for Microsoft SQL server.  You can simply your SQL Server Administration with 89 free Powershell scripts by simply providing some information and it is an amazing assortment of scripts.  The scripts will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.

  • 89 example scripts for managing SQL Server objects
  • Initialize PowerShell SQLPS module and work with databases
  • Scripts for Analysis, Integration, and Reporting services
  • Experimental support for SQL Server 2016
  • New scripts for exploring In-Memory databases and query store features

Powershell script break down

Database Engine

  • Connect to a server instance, manage databases and publish scripts
  • Work with policies and SQL Server logs
  • Manage security and backups
  • Create and manage SQL Server jobs
  • Get extended event information

Analysis Services

  • Connect to an Analysis Services instance
  • Get connection information
  • Get a list of databases
  • Backup databases and remove old backups
  • Restore a database

Integration Services

  • Start and stop services
  • Get package information
  • Provision a catalog
  • Publish a project
  • Modify catalog settings

Reporting Services

  • Start or stop services
  • Get instance information
  • Backup and restore encryption keys
  • Get configuration information
  • Get event log information

***NEW Scripts***
In-Memory Databases (SQL2014 and SQL2016)

  • Get overall utilization
  • Get size on disk
  • Get detailed utilization by table
  • Get checkpoint size

Query Plan (SQL2016)

  • Set Query Plan desired state
  • Set Query Plan data retention maximum size
  • Get Query Plan information
  • Get Query Store status

 

How the 9-to-5 workday has disappeared

How the 9-to-5 workday has disappeared

 

Work has changed dramatically over the last few decades, according to a report in The Wall Street Journal recently release it has become more time-consuming, less stable, and more flexible.

In 1973, 6% of Americans said they worked excessive hours while in 2016, 26% said they worked more than 48 hours a week.

Insurance coverage by employers has also dropped since 1973, although companies now provide more benefits to aid work-life balance, such as paid parental leave and remote work options.

Businesses are spending less on employees, both in terms of compensation and capital investment, while investors get triple the payout from 30 years ago.

This has all contributed to workers increasingly acting like free agents in the job market.  While they have more control and flexibility, the “safety net that once came with full-time work has frayed.”

Don’t worry be happy

Americans are happier at work, but they might just be settling for less.

For the first time since 2005, more than half of U.S. workers say they’re satisfied with their jobs, according to the Conference Board, a research group. Employment is up, wages are finally rising and layoffs are near record lows, resulting in a more optimistic, contented workforce.

That buoyancy is giving Americans confidence to pull out their wallets.  Depending on whether the tax plan for 2017 gets implemented the middle class will continue to get hammered with taxes to maintain the social programs such as social security, ACA and other various programs.

There is no such thing as a free lunch but employers are looking to try and maintain a profit.  Small business owners will gain from the tax overhaul plan by not getting double taxed for corporate and personal income.  This fact is not known by most Americans.

Hopefully the work place will improve over the next few years putting wages back into a reality check.

10 Most Important Feature Improvements to Apple’s iOS 11

10 Most Important Feature Improvements to Apple’s iOS 11

iOS

Apple iOS 11 is now available to download and install from the Apple store.  There is a new update released 11.0.1 so most likely there were some software glitch that needed immediate repair.

List of 10 improvements

  1. Apple’s iOS 11 includes a new Files app that brings together all of the files and folders stored across a user’s Apple devices, Dropbox accounts and more. The app provides access to iCloud Drive, the company’s cloud data storage service, and can help users find files on other devices.
  2. Apple’s iPad support gains several improvements in iOS 11, including a better Dock app. The Dock now can stretch across the screen to include more apps that can be swapped out when users swipe across the Dock. It also displays apps that have been opened recently and used on the iPhone or Mac.
  3. Apple iOS 11 has improved Apple Pencil support, making it easier to mark up files and folders and access notes. iOS 11 also includes support for inline drawing on e-mails that can be sent to others. Also, scanning and signing support comes standard.
  4. Apple’s App Store gets a revamp in iOS 11. The App Store’s new design, the company says, will make it easier for find apps and search for programs related to specific topics. There’s also a dedicated Games tab, suggesting video games still are an important attraction for Apple’s mobile users.
  5. Apple’s Camera app has a modified design that includes new filters to add flair to photos. According to Apple, the Camera app enables better portrait photos with skin tones “more natural.” Photo compression is also improved, reducing file sizes by 50 percent without sacrificing image quality.
  6. Apple’s virtual assistant Siri has gotten an update in iOS 11. Siri now can immediately translate words or phrases from English to several different languages including Spanish, Italian and Mandarin. Siri also can learn user music preferences and play only tracks that it knows the user will like. Also, Siri can better anticipate what users want and proactively deliver content and make suggestions.
  7. Apple’s Control Center has been rebuilt in iOS 11. Users can customize Control Center to include access to apps used most often and remove apps they don’t use. Control Center also now works with Apple’s 3D Touch feature, so users can access more controls by varying the amount of pressure they place on the screen.
  8. The Lock Screen also has been reworked in iOS 11 to provide better access to the notifications users care about. By swiping up from anywhere on the screen, users can see their most recent notifications as well as missed notifications from both Apple and third-party apps.
  9. In a nod to the one-thumbed typist, Apple has added one-touch support to its keyboard. Users simply touch and hold the emoji or globe keys and the keyboard will shift to a one-handed mode. Apple says it should be easier to type with only one finger, with all the keys close enough to type out messages.
  10. The upcoming iPhone X doesn’t have a physical home button, and iOS 11 has been designed with that in mind, including new gestures. Any gestures that relied on the home button are gone in the iPhone X version—accessing iOS 11 for iPhone X’s multitasking feature now requires swiping up from the display. Swiping down now brings up the Control Panel, and screenshots are done differently.

 

TechSmith Camtasia 9.1 is now available!

Camtasia

Camtasia 9.1 is now available

The latest Camtasia is here with faster video rendering, free video assets, and new features that make it easy for anyone to create professional-looking videos.  One of the best video capturing software tools available to create webinars or technical videos for internal usage.

The Camtasia product has gotten mature and better over the years. The latest upgrade has the features listed below but based on experience you can do so much with the software and a Blue Yeti Microphone.

It is worth the investment if you have decided to bring your company’s knowledge into a new realm of possible business.  There is a free trial that is available that you can use for 30 days.  This allows you to create a webinar to grasp what Camtasia can do for you.  Highly recommended from Baron Software.

 

Faster rendering

Camtasia now takes full advantage of your computer’s 64-bit processor. Get more responsive performance, faster rendering times, and improved stability—even on your most complex projects.

Drag-and-drop editing

Now, what you see is what you get. Every effect and element in your videos can be dropped and edited directly in the preview window.

PowerPoint import

Import an entire PowerPoint presentation or specific slides into your video projects. Turn your presentation into a polished video that can be viewed over and over again.

Windows and Mac—better together

Camtasia now has one, fresh design across both platforms. It’s easier than ever to work on videos with others since recordings and projects can be shared between Windows and Mac.

TechSmith Motion

Bring static images on your mobile device to life by highlighting your product or brand with video effects and text overlays.

TechSmith Capture

Record your iOS screen for training and app demos and share them directly to Camtasia for video editing.

 

PaintShop Pro an Intro to working with scripts

PaintShop Pro an Intro to working with scripts

scripts

 

Scripts are a series of commands that can be recorded and played back at any time, to automate changes to an image or design, or to perform other multi-step actions. Scripts can save you significant time, especially if you repeat the same steps over and over again.

PaintShop Professional, Carole Asselin, has a wealth of knowledge in building and using scripts to speed up her PaintShop Pro workflow.

In this webinar, Carol will teach you the basics of scripting, including:

  • A walk-through of PaintShop Pro’s Script toolbar
  • How to install scripts
  • How to run scripts
  • How to record scripts for basic tasks.

Scheduled webinar is Monday, October 2nd 2017 from 12 PM to 1 PM eastern time. Click on the Corel logo to register for this impressive seminar.

PaintShop Pro 2018 is your affordable photo editing and graphic design software—without the restrictions of a subscription. Enhance your photos with professional image editing tools, or create impactful designs using new color palettes, brushes, gradients, patterns and textures. Enjoy a simplified user interface for faster navigation, improvements to your most used tools, and new workspaces to match your level of expertise.

Hackers hid malware in CCleaner software

Hackers hid malware in CCleaner software

Hackers have successfully breached CCleaner’s security to inject malware into the app and distribute it to millions of users. Security researchers at Cisco Talos discovered that download servers used by Avast (the company that owns CCleaner) were compromised to distribute malware inside CCleaner.

CCleaner Version 5.33 being distributed by Avast also contained a multi-stage malware payload that rode on top of the installation of CCleaner.  CCleaner has been downloaded more than 2 billion times according to Avast, making it a popular target for hackers.

CCleaner is a software utility that wipes out application leftover garbage, can view the registry for entries no longer wanted, remove applications, etc.   Piriform believes that all users are now safe but the real question is how was this even possible to happen.

Trusted by consumers and businesses, CCleaner will lose some of the trustworthiness they have built over the years. The malware itself appears to have been designed to use infected PCs as part of a botnet.

The hackers have proven that this could lead to other companies not securing their software.  The danger is that anyone who allows their people to not protect their workstations from the outside world can affect millions others.  Similar things have happened to Equifax and Sony, if you do not have the latest Anti-Virus software on your workstation you need to make sure you are protected today.

A end user can remove the CCleaner application for now and run a malware check on your machine for protection.