Register for the PASS summit 2017

PASS summit 2017

The PASS summit brings you three days of inspiring, jam-packed educational opportunities focused on the Microsoft Platform, professional connections, and new skills and know-how you can put to use immediately. Don’t forget to stop by the IDERA booth for your chance to win one of 3 apple watches!

What to expect this year at the summit:

  • More than 5,000 registrants from more than 2,000 companies
  • Representatives from 52 different countries
  • Over 200 technical sessions presented by industry experts from around the world including more advanced sessions than years before
  • 70+ hours networking with MVPs, experts and peers
  • Inspiring keynote speakers that include Rohan Kumar, Rimma Nehma, and Heather Ritchie,
  • An opportunity to connect, share and learn

Pass

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

 

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.

Embarcadero Academy Debuts with Online Courses

Embarcadero Academy Debuts with Online Courses 

Delphi

A provider of cross-platform application developer productivity tools, today announced the launch of Embarcadero Academy, an online school for developers of all levels. The Academy, operated in partnership with Embarcadero by CodePower, offers a wide variety of expert-led courses in Delphi and C++Builder skills and technologies.

Finally Embarcardo / Idera have decided to get into the possible educational on line webinars to improve the software developers of Delphi or C++ Builder.

Embarcadero Academy is launching with approximately 15 courses, and has an additional 15 in development. The curriculum, which spans beginner to advanced courses, will initially focus on Delphi and C++Builder capabilities such as language and framework skills, and will continue to grow in range and scope of languages. Full courses run from several days to weeks or months, with mini-courses that last an hour to several hours.

It is worth the cost in getting tools to improve the Embarcadero user base and it is going in the positive direction. Through November 30, Embarcadero is sponsoring a free, five-week “Introduction to Android Mobile Development with Delphi,” typically a $199 value. Developers can learn more and sign up here to receive the free promo, or enter the code ANDROIDINTROFREE at any checkout screen.

About Embarcadero

Embarcadero provides tools that solve application developer productivity problems. The company’s products allow users to design, build, and run applications from a single code base across all platforms. A community of more than three million C++ and Delphi users worldwide rely on Embarcadero’s award-winning products to deliver critical enterprise applications. Embarcadero is a division of Idera, Inc. To learn more, visit www.embarcadero.com.

Advanced iPhone X Design Holds Spotlight

Advanced iPhone X Design Holds Spotlight at Steve Jobs Theater Debut

iPhone

For the first time Apple on September 12th held the iPhone X Spotlight at Steve Jobs Theater. The iPhone X is a sensational-looking iPhone  but it comes at a huge cost, and you’ll have to wait to get it.  Will Face ID become a way of unlocking the phone, but if your face truly does get ‘learned’ over time, it could work well.

  • Screen is stunning
  • New user interface is intuitive
  • Portrait Lighting is effective
  • Face ID was erratic in demos
  • Cost is so, so high

Let’s get the important bit out of the way first: the iPhone X is one of the most expensive flagship phones ever made. It’ll retail at $999 / £999 / AU$1,579 for the basic model. In terms of when you’ll be able to get your hands on it, the iPhone X release date has been set for November 3, with pre-orders going live on October 27. It’ll be coming to the major territories first, with the UK, US and Australia all tipped to be included in the first wave of shipments.

iPhone X Details

The resolution of the screen has been upgraded from the iPhone 7, as the sub-HD pixel count wasn’t really something Apple could hope to get away with in 2017 in the face of such strong competition from the rest of the industry.  The iPhone X has been upgraded to match its rivals, with a resolution of 2436 x 1125 on the new Super Retina HD display.

The ‘lip’ at the top of the phone, where a section of the ‘all-screen’ display was cut out to place the cameras.  The True Depth camera at the top is needed for Face ID, so it makes sense that a small portion would need to be kept for all the technology – but it does ruin the aesthetic somewhat. The screen is 18:9 (although that’s not been confirmed by Apple) so a movie that’s in a standard 16:9 format won’t fill the display.

The new iPhone X is easily, easily the best-looking phone Apple’s ever made.  The rear, which is now glass, doesn’t feel as premium as the almost-ceramic metal of previous models, but it still feels solid and secure in the hand. The edges aren’t sharp, instead folding into the palm in a way that’s pleasant to hold.

Face ID is the major shift here to allow the iPhone to know it’s owner but can you reset it in the event it is being resold or given away.  iOS 11 is the operating system with new features that will improve things.  The cameras also provide excellent quality and depth but the big question is battery life which sucks the life out of a user.

You can even get a fast charger – 50% within 30 minutes from dead – but only with a USB-C cable. A USB-C to Lightning Cable retails for $25 (£25 / AU$35) on Apple.com, while a USB-C Power Adapter is available in a few sizes: 29W, 61W and 87W. And if you want it, the price of the cheapest adapter (29W) is $49 (£49 / AU$69) from Apple.

Pumping at the heart of the iPhone X is the new A11 Bionic chipset, designed to handle the heavy lifting the new iPhone is calling on it for.

Final verdict is whether you really want to drop $1,000.00 on a phone or wait for the prices to drop when the ‘s’ version is release in the September of 2018 as it has been done before.  The iPhone 7 still does the job for most folks as well as the iPhone 6s so you get a new tool at a high price.

 

 

 

Veeam Agent for Microsoft Windows FREE

Veeam Agent for Microsoft Windows FREE

Veeam

Veeam Agent for Microsoft Windows is a simple, standalone agent that delivers backup and recovery for Windows servers and workstations running in the public cloud, for physical Windows servers and workstations, and endpoints running on‑premises.

It delivers all-new functionality to give you features and capabilities unheard of in a FREE desktop backup, and data recovery solution:

Active full backups: Meet your company policy by scheduling the periodic active full backup in backup job
Direct Restore to Microsoft Azure: Restore or migrate on‑premises, Windows-based physical server and endpoint backups directly into Microsoft Azure
Windows Server 2016 support: Get full support for Microsoft Windows Server 2016

You can visit the web site to read more on this amazing tool. Full support for Windows 10 and Windows Server 2016.  Free Windows backup for desktops and laptops.  So much more is available for you and your business.

Now just to be clear, for extra functionality, Veeam Agent for Windows must be coupled with their  Backup & Replication, which adds complexity and extra cost. Yes, these agents could be used as standalone solutions, but their functionality is limited by design.  That is where the word free comes in.  You get what you paid for but it is a start to test out and see if Veeam does fit your business as well as budget.

Now you can go with Acronis or Unitrends but as you add on servers, workstations, etc. the cost alone can hit you hard.  You must test out the software for the best overall solution and security for your business.  Backups are extremely important in this time of need due to the amount of computer hackers and thieves.  Our recommendation is to test out each piece for your location to see what is the best overall solution.

New Build 4 Now Available for Version 2.26 of ElevateDB from Elevate Software

New Build 4 Now Available for Version 2.26 of ElevateDB from Elevate Software

ElevateDB

Elevate Software is  pleased to announce that build 4 for version 2.26 of ElevateDB is now available. The software release provides the following:

  1. Altering a Table in a Database with Dependent Views Can Result in a Table Checksum Mismatch
  2. COMPARE DATABASE Generating Incorrect Statement Terminators for ALTER Statements

If you own the subscription model or are looking for a database manager that works with Delphi this is the package to go with.

ElevateDB is licensed per-developer, and includes royalty-free distribution. License management isn’t required at all, and the money that you used to pay to the database engine vendor is now your profit to keep.

What does ElevateDB do ?

You don’t need to use a feature-crippled “free” product in order to avoid licensing fees anymore. With Elevate Software, you are backed by a company that has over a decade of experience in highly-distributed and pre-packaged database application software.

ElevateDB is designed to be included in a pre-packaged database application and can be installed very quickly and easily. The ElevateDB Server is a single EXE (~2MB), only requires a single INI text file for configuration, and can be run as an application or Windows service. Source code to the ElevateDB Server is included with every purchase, so it can be customized and re-branded, if necessary. The ElevateDB client-side code can be compiled directly into Delphi, C++Builder, and Lazarus applications, and consists of a single assembly (~2MB) for .Net applications. ElevateDB client code can also transparently switch between local, single-user and client/server, multi-user usage.

ElevateDB automatically creates all necessary files when they are needed. For example, you can distribute a single database catalog file with your application, and ElevateDB will automatically create the the table files as they are opened by sessions. In addition, ElevateDB provides reverse-engineering facilities that allow you to easily create creation and upgrade SQL scripts that can be run during installation to transparently create any necessary system or database objects.

Once installed, ElevateDB is not fragile and cannot be made inoperable by another application’s installation process. Many database engines are extremely sensitive to configuration changes and require constant attention by an administrator.

Meet FMS President Luke Chung

Meet FMS President Luke Chung

FMS

Access

Since FMS started in 1986 they have assisted countless individuals and organizations make better data driven decisions. As database experts, FMS help our clients improve accuracy, efficiency, and costs. FMS give managers better control of their processes, provide data to key decision makers, and help developers add features and gain insight into their applications. Collecting, analyzing, and presenting data in ways that empower individuals is what they provide.

Having used their tools for various Microsoft Access Projects and applications Baron Software highly recommends visiting the FMS web site as well as stopping at this event to listen to Mr. Chung.

Meet FMS President Luke Chung at the Microsoft Access User Group Meeting in New York City

September 11, 2017, 6:30 PM
Microsoft Headquarters, New York City

FMS President Luke Chung is the featured presenter at the Microsoft Access User Group meeting in New York City.

Learn from his experiences with Microsoft Access, SQL Server, Azure cloud computing, and techniques to improve your productivity. He’ll answer your questions and demonstrate FMS products.

Includes FMS product giveaways.

We look forward to seeing you at this Free Event.

For more info: read the User Group Announcement

Location

11 Times Square, East side of 8th Ave. between 41st and 42nd Streets (nearer 41st) Belasco Room on the 6th Floor.

The building is across the street from the Port Authority bus terminal. Subway: A, C, or E train to 42 Street-Port Authority Bus Terminal.

Bring Picture ID to get thru security.

How to fix setup errors with SAP Crystal Reports 2016

How to fix setup errors with SAP Crystal Reports 2016

SAP

It is always a small burden to install or execute the SAP Crystal Reports 2016 updates or service packs on a Windows 10 machine.  Things that just drive you crazy to put in a simple update or patch throws you off the track in so many minor ways.

Using Crystal Reports 2016 with Visual Studio is a robust reporting tool that you can access information from your SQL database or even Microsoft Access.  You can also purchase the standalone tool allowing you to build custom reports that you can load into the Crystal Server for multiple users to gain reporting.

A few fixes for updating

Some of the minor “dumb” things that can be fixed in seconds to complete your task are :

  1. Always execute the patch or service pack with Administrator rights otherwise you will get the misleading “Ports … must be opened”.  At first you think the AntiVirus or Firewall are using the ports but the error is very misleading.
  2. After you start the update the next possible problem could be the “suppressed reboot” error thus failing the update.  This is another misleading problem and this could be left over from any previous problems with executing the update.  Following the steps below to solve this issue

The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system. Use the Registry Editor at your own risk. It is strongly recommended that you make a backup copy of the registry files before you edit the registry. For information on how to edit the registry key, view the ‘Changing Keys And Values’ online Help topic in the Registry Editor (Regedit.exe).

  1. Click Start > Run. The Run Dialogue box appears.
  2. Type “regedit” in the Open field. Click OK. The Registry Editor appears.
  3. Navigate to \HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\
  4. Double click on the PendingFileRenameOperations
  5. Delete the content of this value
  6. Click OK > Yes > OK
  7. Launch the installer and no reboot is required

So this resolves installing any Crystal Reports 2016 update/patch/service pack.

Now if SAP can only get the patch or service pack to install quicker.

Coding Boot Camps should they go or be used ?

Coding Boot Camps should they go or be used ?

Boot Camp

Within the past week, two well-known and well-established coding bootcamps have announced they’ll be closing their doors: Dev Bootcamp, owned by Kaplan Inc., and The Iron Yard, owned by the Apollo Education Group (parent company of the University of Phoenix).  Not the most strongest places to learn how to code but some industry observers have suggested that the market may be merging in the coming months.

It appears that there are simply more coding bootcamps – almost 100 across the US and Canada – than there are students looking to learn to code.   Remember these courses are geared for a quick turnaround in studying and learning how to program.  I never mentioned that these were gifted academic schools since on average they are charging $11,000 for a 12 weeks of intensive training in a programming language or framework.

College or Bust ?

Does a person who goes thru this actually know the basics, sure but can they develop software that could possibly be used by millions, most likely not.  They stand a chance of getting a low entry level position at a software house.  They could have simply saved the money, learn the piece they needed from the vast amount of knowledge on the internet, or webinars.  Writing software is an art form as well as a love fest.  There are times a software developer will stay up long hours going over code to make it better.

In December of last year, Bloomberg published a warning to prospective students: “Want a Job in Silicon Valley? Keep Away From Coding Schools.”

The article contended that many companies have found coding bootcamp grads unprepared for technical work.   A tech recruiter told the publication. “My clients are looking for a solid CS degree from a reputable university or relevant work experience.” Google’s director of education echoed this sentiment: “Our experience has found that most graduates from these programs are not quite prepared for software engineering roles at Google without additional training or previous programming roles in the industry.”