Archive for the ‘Sunsystems and Vision’ category

Sunsystems v 6.3 – time to upgrade.

January 14th, 2019

Infor SunSystems® delivers integrated financial, purchasing, inventory, and sales management paired with social business, analytics, and in-context business intelligence. For those on legacy versions such as v5 or even 6.1 or 6.2 there many reasons to upgrade this year to version 6.3. here are just a few:

1.ENHANCED SUNSYSTEMS CORE FEATURES
Give users a familiar, easy-to-use environment. Infor SunSystems helps you to increase productivity and to reduce training time. Employees can easily find information relevant to their jobs, and even delivers that data to them automatically.
2.MODERN USER INTERFACE
Create real-time queries and drill back to the source transaction to take immediate action. The addition of the Infor Ming.le™ social feed helps you get clear, supporting insight and links to additional information at the point of decision.
3.ROBUST BUSINESS INTELLIGENCE
SunSystems has web dashboards and a self-service front-end that allow any business user to conduct sophisticated analytics.
Centralization of data is improved, and integration to your business applications is more seamless so that you can get business insights through a variety of channels.
4.INFOR ION INTEGRATION
This version of SunSystems has expanded Infor ION® integration capabilities, which provides easy integration with a range of Infor solutions for risk management, human capital management, travel expense control, asset management, and more. You get cross-application workflows and event management, and deeper insight across application process flows, as well as proactive, preemptive control.

SunSystems in 2018 became part of the Infor OS. This brings several advantages to the product. It will become integrated with other Infor solutions. There are plans to integrate Infor Birst, HCM, HMS (Hospitality Management) and CRM from 2019. The integration of Birst may see some customers adopt the powerful BI tool and rethink their reliance on spreadsheets.

Sql 2014 Sp2 Update 15

December 15th, 2018

The 15th cumulative update release for SQL Server 2014 SP2 is available for download at the Microsoft Downloads site.
Registration is no longer required to download Cumulative updates.

CU15 KB Article: https://support.microsoft.com/en-us/help/4469137

Microsoft® SQL Server® 2014 SP2 Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=53592

Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx

RPA certifications for Synergy Software Systems, Dubai

November 25th, 2018

I am pleased to announce that following extensive training over recent weeks two of our consultants have already achieved certifications.

If you have an ROA project in mind and need support for your project from a proven, local. UAE partner then please call Synergy Software Systems on 0097143365589

Making Tax Digital (MTD)

November 19th, 2018

If you have U.K operations then be aware of Making Tax Digital (MTD), a transformational approach to taxation in the UK from HMRC. The first change is coming in 2019 and will affect every organisation from processes to how systems are set up to record and report tax.

This will affect all companies with U.K, financial operations and all financial software. From April 2019, businesses that are registered for VAT and have turnover above the VAT registration threshold of £85,000 will be required to keep digital records for VAT purposes and submit their quarterly VAT return updates to HMRC through functional compatible software

The new VAT record keeping rules requires that all applicable VAT return data is digitally linked so that transactions can be traced from source data (i.e. purchase/sales ledger) to VAT return completion and upload.

Key benefits for businesses include improved visibility over their tax situation and easier access to tax information online; enabling businesses to plan and budget more effectively, driving performance and growth

With Making Tax Digital, the new regulation from HMRC going live from 1 April 2019, it’s time to start preparing. This is similar to the legislation already implemented in the U.A.E. which we have done for both infor SunSystems, and Dynamics 365/Dynamics Ax.

Which versions of Dynamics AX will Microsoft be ‘Making Tax Digital’ compliant?

Any Dynamics product that is still under mainstream support will get an update from Microsoft to ensure full compliance. This means for Dynamics AX only Dynamics AX 2012 R3 will be automatically updated. Microsoft have not confirmed when this update will take place – there are still some further details to come from HMRC.

Receiving the Microsoft update may not be enough to guarantee full compliance – there will likely need to be a number of small updates such as capturing the right fields and updating commercial forms, and reporting format that will need to be confirmed.

In addition, by April 2020 you will need to ensure all of your processes are fully digital.

IFRS 9

November 7th, 2018

The Standard includes requirements for recognition and measurement, impairment, de-recognition and general hedge accounting. This standard has replaced IAS 39 and responds to the criticisms that IAS 39 was too complex,
inconsistent with the way entities manage their businesses and risks, and defer the recognition of credit losses on loans and receivables until too late in the credit cycle.

The new standard is based on the concept that financial assets should
be classified and measured at fair value, with changes in fair value recognized
in profit and loss as they arise (“FVPL”). That is unless restrictive criteria are met for classifying and measuring the asset at either Amortized Cost or Fair Value Through Other Comprehensive Income (“FVOCI”) subject to a special
FVOCI designation option for investments in equity instruments, only
loans, receivables, investments in debt instruments and other similar
assets ( “loans and receivables”), can qualify for measurement at Amortized Cost or FVOCI. The key questions are whether:
• The objective of the entity’s business model is to hold assets only to collect
cash flows, or to collect cash flows and to sell (“the Business Model test”),
and
• The contractual cash flows of an asset give rise to payments on specified
dates that are solely payments of principal and interest (“SPPI”) on the
principal amount outstanding (“the SPPI test”).

Both of these tests determine whether to account for an instrument at
Amortized Cost or FVOCI

IFRS 9 specifies how an entity should classify and measure financial assets, financial liabilities, and some contracts to buy or sell non-financial items. IFRS 9 , deals separately with the classification and measurement of financial assets, impairment and hedging.

IFRS 9 requires an entity to recognise a financial asset or a financial liability in its statement of financial position when it becomes party to the contractual provisions of the instrument. At initial recognition, an entity measures a financial asset or a financial liability at its fair value plus or minus, in the case of a financial asset or a financial liability not at fair value through profit or loss, transaction costs that are directly attributable to the acquisition or issue of the financial asset or the financial liability.

So why does it matter if you are not in the Financial services sector?
Any entity with long-term loans, equity investments, or any non-standard financial assets, or only holding short-term receivables may find that it requires
significant changes to its financial reporting as the result of this standard.

Possible consequences of IFRS 9:
Income statement volatility. More assets will
have to be measured at fair value with changes in fair value recognized in
profit and loss as they arise.

Earlier recognition of impairment losses on receivables and loans,e.g. trade receivables. Entities will have to provide for possible
future credit losses in the first reporting period that a loan goes on the books
– even when it is highly likely that the asset will be fully collectible.

New disclosure requirements—the more significantly impacted may even need new systems and processes to collect the necessary data.

IFRS 9 is an opportunity for balance sheet optimization, enhanced efficiency of
the reporting process and cost savings.

Before your year end audit consider the possible impact on financial statements, systems, processes, controls.

Financial assets

When an entity first recognises a financial asset, it classifies it based on the entity’s business model for managing the asset and the asset’s contractual cash flow characteristics, as follows:

Amortised cost—a financial asset is measured at amortised cost when both of the following conditions are met:
◦ the asset is held within a business model whose objective is to hold assets in order to collect contractual cash flows; and
◦ the contractual terms of the financial asset give rise on specified dates to cash flows that are solely payments of principal and interest on the principal amount outstanding.

Fair value through other comprehensive income—financial assets are classified and measured at fair value through other comprehensive income when these are held in a business model whose objective is achieved by both collecting contractual cash flows and selling financial assets.

Fair value through profit or loss—any financial assets that are not held in one of the two business models mentioned are measured at fair value through profit or loss.

When, and only when, an entity changes its business model for managing financial assets it must reclassify all affected financial assets.
Financial liabilities

All financial liabilities are measured at amortised cost, except for financial liabilities at fair value through profit or loss. Such liabilities include derivatives (other than derivatives that are financial guarantee contracts or are designated and effective hedging instruments), other liabilities held for trading, and liabilities that an entity designates to be measured at fair value through profit or loss (see ‘fair value option’ below).

After initial recognition, an entity cannot reclassify any financial liability.

Fair value option

An entity may, at initial recognition, irrevocably designate a financial asset or liability that would otherwise have to be measured at amortised cost or fair value through other comprehensive income to be measured at fair value through profit or loss when doing so will either eliminate, or significantly reduce a measurement or recognition inconsistency (sometimes referred to as an ‘accounting mismatch’) or will otherwise result in more relevant information.

Impairment

Impairment of financial assets is recognised in stages:

Stage 1—as soon as a financial instrument is originated or purchased, 12-month expected credit losses are recognised in profit or loss and a loss allowance is established. This serves as a proxy for the initial expectations of credit losses. For financial assets, interest revenue is calculated on the gross carrying amount (ie without deduction for expected credit losses).

Stage 2—when the credit risk increases significantly and is not considered low, full lifetime expected credit losses are recognised in profit or loss. The calculation of interest revenue is the same as for Stage 1.

Stage 3—when the credit risk of a financial asset increases to the point that it is considered credit-impaired, interest revenue is calculated based on the amortised cost (ie the gross carrying amount less the loss allowance). Financial assets in this stage will generally be assessed individually. Lifetime expected credit losses are recognised on these financial assets.

Hedge accounting

The objective of hedge accounting is to represent, in the financial statements, the effect of an entity’s risk management activities that use financial instruments to manage exposures arising from particular risks that could affect profit or loss or other comprehensive income.

Hedge accounting is optional. An entity applying hedge accounting designates a hedging relationship between a hedging instrument and a hedged item. For hedging relationships that meet the qualifying criteria in IFRS 9, an entity accounts for the gain or loss on the hedging instrument and the hedged item in accordance with the special hedge accounting provisions of IFRS 9.

IFRS 9 identifies three types of hedging relationships and prescribes special accounting provisions for each:

fair value hedge: a hedge of the exposure to changes in fair value of a recognised asset or liability or an unrecognised firm commitment, or a component of any such item, that is attributable to a particular risk and could affect profit or loss.

cash flow hedge: a hedge of the exposure to variability in cash flows that is attributable to a particular risk associated with all, or a component of, a recognised asset or liability (such as all or some future interest payments on variable-rate debt) or a highly probable forecast transaction, and could affect profit or loss.

hedge of a net investment in a foreign operation as defined in IAS 21.

When an entity first applies IFRS 9, it may choose to continue to apply the hedge accounting requirements of IAS 39, instead of the requirements in IFRS 9, to all of its hedging relationships.

IFRS 9 is effective for annual periods beginning on or after 1 January 2018.

End of Support for SQL Server 2008 and 2008 R2 on July 9, 2019

November 2nd, 2018

End of Support for:
- SQL Server 2008, and 2008 R2, on July 9, 2019
and
- Windows Server 2008, and 2008 R2, on January 14, 2020

Risks with an outdated data platform include:
• Non-compliance with GDPR and other market standards
• Exposure to unexpected attacks and security breaches
• Higher costs and inefficient data management
• Incompatibility with modern releases of business applications
• Missed opportunities for innovation and business intelligence

Options:
Upgrade to SQL 2012 or 2017
Ask us about our Advanced SQL database tools – and our special discounted bundled price offer to year end to support GDPR compliance.

Migrate to the azure cloud platform
If it also time to upgrade your servers then now might be a good time to look at a move to the cloud.

Azure Hybrid Benefit
• Save up to 40% on windows Server with Azure Hybrid benefit
• Save up to 55% on migration to Azure SQL database with Azure hybrid benefit
• Go at your own pace – move a few workloads or entire datacenters
• Maximize your investment in Microsoft software.

Paths to Upgrade and Stay Protected
Migrate apps to Azure VMs: get free extended security updates for Windows Server 2008 and 2008 R2 VM’s for 3 years after deadline.

Migrate Data to Azure managed instances or VMs
Azure SQL Database Managed Instance offers a version-free option.
Get free Extended Security Updates for SQL Server 2008 and 2008 R2 in Azure VM’s for three years after the deadline

Modernize when ready
Upgrade in Azure when ready
Or transform apps and data with Azure services

To reduce the cost of on premise servers ask about our Firewall Solutions that provides may other integrated features. Reduce the number of servers needed and the cost of supporting multiple server systems, vpn, sms, ftp, anti virus, and more all in one solution.

To discuss your options contact Synergy Software Systems a Microsoft partner since 1993.
If you are considering a Microsoft Dynamics solution on the cloud then when comparing costs do’t forget that the subscription includes not only the hardware platform but also the significant cost savings of the database, Windows server, and firewall and anti-malware software licenses, but also the savings in server rooms and electricity boils both to power the servers and the server room air conditioning. Nor is there any extra cost is for license enhancements fee for continuous upgrade versions of the ljcences. That also redcues yoru GDPR compliance challenges.

If your SQL database, or your servers, or your Windows Server licenses are due for renewal, or its time to move an any time anywhere, any device new business system then call Synergy Software Systems to discuss your options

Microsoft partner since 1994
Dynamics Partner since 2003

VAT in Bahrain – Update your Sunsystem financials with Synergy Software Systems

October 23rd, 2018

Bahrain will be the next country to implement five per cent value-added tax (VAT) after the UAE and Saudi Arabia as part of the GCC framework agreed between the six states, according to tax experts. Bahrain’s parliament in an extraordinary session ordered by royal decree. has approved the introduction of 5 percent value-added tax (VAT) in the kingdom from January 1 2019. The move must also be approved by Bahrain’s upper house.

The introduction of VAT will be a big challenge for the local Bahrain market, and businesses now have less than 3 months to be prepared for these changes. This announcement of a definitive date for the tax to become effective means that businesses should accelerate their VAT readiness preparations. Last week, Bahrain announced a fiscal overhaul meant to balance its budget by 2022, backed up by a $10 billion economic support package from Saudi Arabia, the UAE and Kuwait. The plan aims to raise $2.1 billion a year as Bahrain looks to curb its debt after years of lower oil prices.

At the start of 2018 VAT was introduced in both K.S.A, and the U.A.E. Synergy Software Systems has extensive experience of VAT implementation in business systems like Dynamics 365 Finance and Operations, Dynamics Ax, and Infor SunSystems in both K.S..A and the U.A.E, across almost 200 customers in varied vertical sectors.

VAT Registration
• The compulsory VAT registration threshold in Bahrain is BHD 37,000 per annum.
• A voluntary registration for businesses below this threshold is permitted, although this has its own minimum threshold of BHD 18,850 per annum.
• There is scope for related businesses to apply for a single, Group VAT registration.
• There is no threshold for non-resident businesses, which must register prior to their first supply. Foreign registrations may be either direct, or via a local Fiscal Representative.

Bahraini VAT rates
Generally, Bahrain follows the terms of the Agreement, including the harmonised standard VAT rate of 5%, but has a wider range of zero and reduced VAT rates to provide subsidies to the less well off in society.

Which goods or services, at what rate?:

% Zero Basic foodstuffs; domestic and international transport; new properties; healthcare; exports of goods and services; high-value metals; oil and gas; education; and medicine and medical equipment.

Exempt: Sale and lease of real estate; and financial services.

5% Standard From 1 January 2019: All other supplies of goods, or services, including imports, in accordance with the Unified VAT Agreement.

Bahraini VAT invoices
VAT invoices must contain the following information as a minimum:
• Date of invoice (and date of supply if different)
• Unique, sequential invoice number
• Tax ID number of the supplier
• Name and address of the supplier and customer
• Description and quantity of the goods supplies; nature of services provided
• Gross, VAT and net values of supply
• VAT rate applied, and explanation where not the standard rate
Invoices must be issued within 15 days following the month of supply of the taxable goods or services.

Bahraini VAT Returns
Registered tax payers must submit their periodic returns each month.
Returns must be filed by the last working day of the month following the reporting period.

Penalties for non-compliance
Timely preparation is critical because VAT is generally a self-assessed tax, and errors are often subject to severe penalties and business disruption.
Businesses that have been operating in a largely non-tax environment should already have started to prepare and to analyze in detail what the implications of the new tax will be for example on: their pricing, contracts and IT systems.
The following penalty regime for non-compliance is in place, with financial penalties and potential prison terms:
• BD10,000 for failure to register for VAT within 60 days of the required date
• Failing to issue a VAT invoice within 15 days of the month following the taxable supply
• Failing to submit a VAT return and/or pay any VAT due by the end of the month following the reporting month,

Transition rules
The following rules will apply to supplies contracted and supplied over the introductory period:
• Where invoices were issued, or payments made, prior to 1 January 2019 for post-implementation supplies, then VAT is still due. In this case, a debit note for the original invoice should be issued with the correct VAT indicated.
• Initially, goods supplied to other GCC states that have also implemented VAT (Saudi Arabia and UAE) will be treated as exports. There are plans to introduce zero-rating with reverse charge supplies to eliminate import VAT, but this is dependent on the introduction of an Electronic Services System transaction reporting platform, which has yet to be developed.
• For pre-January 2019 contracts which are silent on the VAT treatment, then the price will be VAT inclusive. This presents a cash flow risk for the supplier.

Other GCC Countries
The Sultanate of Oman announced that VAT would be introduced in 2019, most likely mid-2019.
The Kuwaiti parliament is yet to vote on the VAT bill which should be introduced in the upcoming session before the year-end. The expected timeline of introduction of VAT in Kuwait is late 2019 or 2020.

EY, estimated that a five per cent VAT rate will produce revenues of over $25 billion per annum for the six GCC countries.

Contact:
Synergy Software Systems: 009714 3365589/ 33734282
Deyafa Systems: 009714 3240066

Gitex 2018- See Filehold DMS with Synergy Software Systems

September 30th, 2018

Meet us with Globalis to see how advanced cheque scanners and a modern DMS solution work together.

Talk to us about how repetitive automation can help you match hundreds of thousands of invoices, or to reconcile claims, or to reconcile multiple bank accounts.

Let us show you how easy it is to drillback from any key field in any application, back to the source doument and all related documents in Filehold.

SQL Server 2016 SP2 CU2, SP1 CU10

July 18th, 2018

Fixes and improvements:
• DAG improvement – automatically seed replicas – when you add a database to an existing AG, SQL Server can automatically seed it across the secondary replicas. .
• AGs – configurable session_timeouts
• AGs – slow transactions with 1 sync and 1 async secondary
• AGs – on cross-data-center AG failover, you get a non-yielding scheduler and a crash
• AGs – queries on secondary take twice as long
• AGs – VSS backups fail on secondary replicas in a Basic Availability Group (which technically you’re not supposed to do, but you can still back up the entire secondary VM, and that’s where the problem looks like it’s coming in)
• AGs – fixing error 19432 for duplicate log blocks
• Log shipping – add support for Transparent Data Encryption by configuring MAXTRANSFERSIZE.
• Dynamic data masking doesn’t
• SSAS crashes when Process Full follows Process Clear –“you will notice that the SSAS may crash.” .
• Memory dump when you merge partitioned temporal tables .
• Stats updates can get a “corrupted index” message and a disconnect
• Assertion error when you add a database
• Slow performance when Query Store is enabled
• Non-yielding schedulers require a reboot – not the most informative KB article ever. “Assume that you have a Microsoft SQL Server 2016 installed.” .

See KB articles for more information . Download SQL 2016 SP2 CU2 and/or SP1 CU10.

https://support.microsoft.com/en-us/help/4341569/cumulative-update-10-for-sql-server-2016-sp1

End of life for SQL 2008 and 2008 r2 is only a year away

July 14th, 2018

On July 9, 2019, Microsoft will end Extended Support, for SQL Server 2008 and 2008 R2hich means no more updates or support of any kind, potentially leaving you vulnerable to security and compliance issues.
Some considerations:
That is only a year away. So time to start planning and to get it into your 2019 budget.
What applications are affected? With what new SQL version are they compatible?
Will you need to rebuy licenses? The SQL license cost is now core based and it might prove lot higher than last time so take the time to consider all options.
Should any of your applications move to the cloud?
Should you also look at upgrades to Hardware? Windows, Office, Exchange, or Business finance/erp systems in conjunction with SQL?
Is now the time to review your security solutions?
Are you going to expand, or implement heavy new processes like consolidation, budgeting, BI in then next 2-3 years?
Is your mobile network growing?

There are major enhancements at QL 2016 sp1 so we recommend you should not consider any version lower than that. By next year SQL 2017 will also have settled down.

To discuss options callus o 0097143365589

Infor Sunsystems 6.3 ask Synergy Software Systems why its time to upgrade.

July 7th, 2018

If you have not yet upgraded to SunSystems 6.3 from Infor it is time to consider what major benefits are available for existing SunSystems clients. Infor has for many years provided ongoing support for a range of SunSystems versions. This has been great for clients to maximise their investment in the solution over extended time frames, but it can cause difficulty when assessing when and why to upgrade to the latest version. This comprehensive, updated financial management system is particularly significant because it not only delivers mnay new features and enhancements but also runs on Infor Xi, the latest and most innovative enterprise technology platform from Infor.

Let’s have a look at the various top level versions in use today:
SunSystems v4 (The current production release is v4.4)
Pros: A proven, self-contained system that operates on minimal IT infrastructure and demands little support and maintenance effort. Continues to be patched and upgraded with new features and Microsoft technology framework compliance.

Cons: Its been around a long time with an aging user interface, some operating limitations on modern technology platforms and is not integrated to the Infor Platform Xi enterprise framework.
SunSystems v5 (The final version is v5.4)
Pros: Still covered under the support framework.
Cons: This version is effectively at end-of-life from an extension point of view. There are no new patches or updates being released, it will not be kept compliant with future versions of Microsoft Windows and SQL Server and it is not possible to purchase additional user licences.

SunSystems v6 (v6.3)
Pros: Significant increase in power and scalability from the original Sun 4.
A complete re-visioning of the system :more agility, flexibility, and control for companies with complex financial management requirements, multi-company operations, multi-currency trading.
Modern user interface stemming from Infor’s in-house user experience and design team, Hook and Loop.
Cons: SunSystems itself and the broader Infor Platform Xi framework demands more computing power and hardware than v4 or v5 did.

Why upgrade now to SunSystems v6.3?
User experience and usability – the screen designs and operation are revised to enhance user experience. Think “apps” on smartphones and tablets that require little or no user training, Infor has a vision of enterprise grade software usability going the same way. Every new release take steps towards that goal using content feeds, visual triggers and graphics to help people navigate rather than menus and options.
SunSystems users can now replace their Favorites menu page with a customizable homepage—available through Infor Ming.le® or directly within SunSystems. Users can also select the graphical content that best reflects their roles and daily tasks with drag-and-drop widgets. Widgets allow users to create links to relevant SunSystems functions, reports, and records, to help speed up routine tasks and navigation

Integrated Document Management Repository – best practice financial management is underpinned by substantiating documents from many sources. The integrated document management repository lets you attach a PDF or other document to the exact transaction or reference data it relates to and to easily find and view that document again at any time. Documents can be searched and retrieved directly from within the web-based IDM application.

External web portal – this new module allows secure access to SunSystems documents to for additional stakeholders to engage electronically with the financial arm of the business. Get your suppliers to upload their own invoices and maintain their own details; let your clients access their own statements and order history, or let your employees access their expenses history. Reduce the number of queries into the finance team and the rekeying of data when external stakeholders could choose to serve themselves.

Automated master data management – for larger companies running multiple sites or business units the administration of managing common reference data between systems and entities can be centralised. Define a primary business unit for your supplier register and any moves/adds/changes/deletes applied to this primary data can be automatically applied to any nominated secondary entities.

Configuration
Infor SunSystems 6.3 consolidates all configuration settings, over 400 of these, into a single web-based console and makes complete control of all aspects within the system much easier.

Performance
Allocate memory capacity in Ledger Import caching, to speed up the process – up to 2 – 3 times faster.
For many processes system’s memory is now dynamically allocated for maximum performance. The caching limits can be set in the Configuration Manager and a task is completed, all allocated memory will be freed immediately. Similar web-enabled enhancements are extended to functions like Transfer Desk, Business Unit Administration, and SunSystems Connect portal.

Currency Rate Type
Multicurrency functionality has always been a key strength of Infor SunSystems. In the 6.3 release, users wcan create different sets of exchange rates for different purposes and have control of when and how they can use a specific rate type. Use one exchange rate that is different from the default monthly rate for a specific collection run. Use a different rate for evaluation than the rate used for day-to-day transactions. These rate types are defined at business unit level.

Withholding tax
Now a core function. SunSystems can now automatically calculate withholding taxes for payment and invoice posting directly from within the core, SunSystems application

Form management
Currently, when users want to make some changes to a form, they need to check out that form, make necessary changes, and check it in again. Sometimes, users check out forms and forget to check them back in again. With SunSystems 6.3, the check-in and check-out process is performed entirely in the background. Users only need to open the form and make amendments using Forms Designer.

For more information contact Synergy Software Systems, your SunSystems U.A.E. partner, supporting clients across MEA for over 20 years, 0097143365589

SQL Server 2016 Service Pack 2

April 25th, 2018

SQL Server 2016 Service Pack 2 is released. This SP2 release includes the hotfixes from all released 2016 cumulative updates: SQL Server 2016 CU1 through SP1 CU8.

SQL Server 2016 Updates
Each update is linked to its Microsoft knowledge base article with the download and the list of hotfixes included. The dates show the end of support date

SP2 2018/04/24 13.0.5026.0 2026/07/14
CU8 2018/03/19 13.0.4474.0 2019/04/24
CU7 2018/01/04 13.0.4466.4 2019/04/24
CU6 2017/11/22 13.0.4457.0 2019/04/24
CU5 2017/09/18 13.0.4451.0 2019/04/24
CU4 (w/MDS bug) 2017/08/08 13.0.4446.0 2019/04/24
CU3 2017/05/15 13.0.4435.0 2019/04/24
CU2 2017/03/20 13.0.4422.0 2019/04/24
CU1 2017/01/18 13.0.4411.0 2019/04/24
SP1 2016/11/16 13.0.4001.0 2019/04/24
CU9 2017/11/22 13.0.2216.0 2018/01/09 – out of support
CU8 2017/09/18 13.0.2213.0 2018/01/09 – out of support
CU7 2017/08/08 13.0.2210.0 2018/01/09 – out of support
CU6 2017/05/15 13.0.2204.0 2018/01/09 – out of support
CU5 2017/03/28 13.0.2197.0 2018/01/09 – out of support
CU4 2017/01/18 13.0.2193.0 2018/01/09 – out of support
CU3 2016/11/17 13.0.2186.6 2018/01/09 – out of support
CU2 (see note 1 and note 2) 2016/09/22 13.0.2164.0 2018/01/09 – out of support
CU1 2016/07/25 13.0.2149.0 2018/01/09 – out of support
None (RTM) 2016/06/01 13.0.1601.5 2018/01/09 – out of support

Note 1: CU2 has a known issue with Filestream not working when SecureBoot is enabled. If you’re on Windows Server 2016 or Windows 10, and using SecureBoot (which is enabled by default with Hyper-V Gen2 VMs), and your database has Filestream, then either need disable SecureBoot, or skip CU2 for now.

Note 2: columnstore index users should consider the on-demand hotfix update 13.0.2170.0, which includes serious performance and reliability fixes.

Warnin read the bottom note about “Uninstalling SQL Server 2016 SP2 (Not recommended): there some new features which once installed may give issues if you then try to uninstall.

https://www.microsoft.com/en-us/download/details.aspx?id=56836

SQL Server 2017 Cumulative Update 4

March 4th, 2018

Last month Microsoft released SQL Server 2017 Cumulative Update 4, which is Build 14.0.3022.28.

There are 55 hotfixes in the public fix list. Run the special T-SQL script in the release notes if you are using Query Store and previously ever had SQL Server 2017 CU2 installed (and you were using Query Store on any of your databases at that time). The script will look for any plans that were forced while you were running SQL Server 2017 CU2, and if it finds any, it will unforce those and then clear those from Query Store.

There are several updates both for Columnstore indexes and for Availability Groups.

There will not be any Service Packs for SQL Server 2017, so test and deploy SQL Server 2017 Cumulative Updates as they become available.

SQL Server 2017 and later versions will no longer receive SPs
The Modern Servicing Model (MSM)

Starting from SQL Server 2017:
• SPs will no longer be available. Only Cumulative Updates (CUs) and critical updates (GDRs) will be provided.
• CUs will contain localized content if it’s necessary as what SPs have done.
• CUs will be delivered more frequently at first and then less frequently: every month for the first 12 months, and then every quarter for the final four years of the five-year mainstream lifecycle.

Note The MSM only applies to SQL Server 2017 and later versions.

Earlier versions of SQL Server are not affected by this SP policy change. Service Packs (SPs) will continue to be provided for the reminder of mainstream support for SQL Server 2014 and SQL Server 2016.

“Meltdown” and “Spectre and azure.”

February 10th, 2018

Last month as reported on this blog, Intel revealed two critical vulnerabilities they found in Intel chips. These vulnerabilities allow cyber-attackers to steal data from the memory of running apps. This data can include passwords, emails, photos, or documents. Intel dubbed these as: “Meltdown” and “Spectre.”

Microsoft released a patch for Azure the very next day. Just as well because Microsoft Azure is a shared-computing environment by default. One server hosts applications and development of applications, and various Virtual Machines tap into the server to allow employees to and others to access these applications. As such, the Meltdown vulnerability allows an attacker to compromise the host and read all the data from every operating system tapping into it. Around 3-10 million physical servers host Azure, and these servers in turn host tens of millions of Virtual Machines. So impressively Microsoft developed deployed a patch for these vulnerabilities in less than a week’s time. Azure is a cloud-based application and so Microsoft could focus their security team to work on the cloud servers and only the cloud servers. This way, these millions of servers and users had a patch and all applications hosted on the Azure cloud-platform were immediately protected.

A good business case example for business to move to Azure cloud services.

Malware developers are still out there. German antivirus testing firm AV-Test reported 139 samples of malware trying to attack the Meltdown vulnerability in January to exploit those who have not patched.

Microsoft patched their cloud servers, but non-Azure users (as well as all Windows users, period) still need to apply their operating system patches to ensure complete protection. This is one vulnerability you definitely don’t want cyber-attackers to exploit, whether it’s your personal computer or your business’s server.

Infor Ming.le and the Xi platform from Infor partner Synergy Software Systems, Dubai

January 8th, 2018

Infor Ming.le™—the beautiful entralized platform for collaboration, business process improvement, and contextual analytics. Use with Sunsystems ask Synergy Software Systems an implementation partner of Sunsystems for 20 years.

See the new features of Infor Ming.le™ 12 to improve business processes using the new Xi platform.