Archive for the ‘Microsoft’ category

SQL 2016 Servcies packs May 2018

May 31st, 2018

SQL Server 2016 Service Pack 2 came out last month, but Microsoft also just released Service Pack 1 Cumulative Update 9, which has fixes that aren’t in Service Pack 2:
•PFS page round robin algorithm improvement
•Fixed PAGELATCH_EX and PAGELATCH_SH waits in TempDB
•Change tracking is inconsistent during an update on a table with a clustered index
•TDE database goes offline during a log flush

However, they also just released 2016 SP2 CU1! https://support.microsoft.com/en-us/help/4135048/cumulative-update-1-for-sql-server-2016-sp2

Windows 10 April update

May 28th, 2018

The Windows 10 April Update is causing stress for users, with many claiming their PCs were wiped clean after they hit OK on the update prompt.
Windows message boards were bombarded with complaints after users found that the “restart and install” prompt for the Windows 10 update led to a blank screen with a message saying:

C:\WINDOWS\system32\config\systemprofile\Desktop is unavailable. If the location is on this PC, make sure the device or drive is connected or the disc is inserted, and then try again. If the location is on a network, make sure you’re connected to the network or internet, and then try again. If the location still can’t be found, it might have been moved or deleted.

The screen has no icons and a few users were only able to remedy the problem with the help of another PC. The blank desktop issue has reached users across the world but does not appear to have affected a large number of users. If you have already installed the Windows 10 update and had no problems, then you don’t have to worry.

The problem seems to be linked to Avast Antivirus and a specific line of code. Avast released a statement denying any involvement in the issue.
“We have tested this and couldn’t identify any problems affecting Avast Antivirus consumer users specifically. …”We cannot rule out that a small number of Avast users may be having difficulties updating, too, but we don’t see any indications that this is caused by Avast.”

This month, Microsoft Surface users said they had issues with the device following the Windows 10 update. The all-in-one desktop Surface Studio and 2017 Surface Pro models repeatedly froze and disconnected from keyboards and mouses after the update.

•If you have Avast Antivirus, it may be prudent to delete it before installing the new Windows 10 update, as many users have reported losing access to all of their files after the installation.
•If you have been affected by the issue, computer repair shops have released lists of steps you can take to restore your desktop and get your files back.

Microsoft Build 2018 – AI, IoT and Edge are changing the world

May 9th, 2018

Microsoft’s annual developer conference, Build, is happening in Seattle.

Expect the products and services that emerge from the conference to have a major impact on all businesses not just those that use Microsoft products.. Azure and Microsoft 365, the announcements made at Build 2018 seem to point to key themes that will impact the enterprise.

By 2020, the average person will generate 1.5GB of data a day, a smart home 50GB and a smart city, a whopping 250 petabytes of data per day. This data presents an enormous opportunity for developers — while also giving them tremendous responsibility. That’s why this morning at Build, we don’t take our jobs lightly in helping to equip these developers with the tools and guidance to change the world. Microsoft CEO Satya Nadella described this new world view, and AI that can power better health care, relieve challenges around basic human needs and create a society that’s more inclusive and accessible.

In the next 10 years, billions of everyday devices will be connected — smart devices that can see, listen, reason, predict and more, without a 24/7 dependence on the cloud. This is the intelligent “Edge”, the interface between the computer and the real world. The Edge combines AI and cloud together to collect and make sense of new information, whether they be on the factory floor or in the operating room or areas to dangerous for humans.

What to expect:

1. AI – all pervasive
Google and facebook are not the only tech firms leveraging artificial intelligence (AI) and machine learning, Microsoft’s declared its mission to “help every developer be an AI developer.” CEO Satya Nadella called it the “era of the intelligent cloud and intelligent edge.” Microsoft announced a new architecture for neural networks, new AI SDKs, new cognitive services, and even AI-powered software development.

The firm also unveiled Windows Machine Learning, which it described in a press release as “a new platform that enables developers to easily develop machine learning models in the intelligent cloud and then deploy them offline and in high performance to the PC platform.”

2.Over the Edge
Microsoft has expanded outside of the office. Building on its efforts in AI, Microsoft launched a host of new edge computing capabilities and Internet of Things (IoT) products for developers to build solutions to support new, automated business processes.

At Build, Microsoft:
- open sourced the Azure IoT Edge Runtime for easier debugging,
- enabled its Custom Vision cognitive service to run on the Azure IoT platform,
- worked with DJI to build a drone SDK for Windows 10 PCs,
- highlighted mixed reality, with two new apps for irst workers to interface with customers and triage problems: Microsoft Remote Assist and Microsoft Layout. Microsoft Remote Assist enables remote collaboration via hands-free video calling, letting firstline workers share what they see with any expert on Microsoft Teams, while staying hands on to solve problems and complete tasks together.
In a similar vein, Microsoft Layout lets workers design spaces in context with mixed reality, using 3D models for creating room layouts with holograms.
- With Qualcomm Technologies Inc., announced a joint effort to create a vision AI dev kit running Azure IoT Edge, for camera-based IoT solutions.
Other advancements include a preview of Project Brainwave, an architecture for deep neural net processing, available on Azure and on the edge. Project Brainwave makes Azure the fastest cloud to run real-time AI today.
. Microsoft is integrating Visual Studio App Center with GitHub for iOS and Android developers to support DevOps process automation,
- Microsoft is also embracing blockchain with the Microsoft Azure Blockchain Workbench, to streamline the process for building blockchain applications.
- Project Kinect for Azure — a package of sensors from Microsoft that contains unmatched time-of-flight depth camera, with onboard compute, in a small, power-efficient form factor — designed for AI on the edge. Project Kinect for Azure brings together this leading hardware technology with Azure AI

3. Microsoft 365 is here to stay

Microsoft 365, the company’s enterprise bundle offering of Office 365, Windows 10, and enterprise mobility and security, was also a focus of Build,
“Microsoft 365 is where the world gets its best work done,” said Joe Belfiore, corporate vice president of Microsoft,. “With 135 million commercial monthly active users of Office 365 and nearly 700 million Windows 10 connected devices, Microsoft 365 helps developers reach people how and where they work.”

The Microsoft 365 offering, is boosted by:
- new support for Power BI Visualizations in Excel,
- Microsoft Teams APIs in the Microsoft Graph,
- Fluent Design System updates, .
- NET Core 3.0, and Azure Machine Learning and JavaScript custom functions for Excel.

Total meltdown – patch now and revisit patches mnay are bugged

April 27th, 2018

A person known as XPN, whose blog lists identifies as a hacker and infosec researcher, posted details of a working exploit that takes advantage of Total Meltdown on Monday. The source code for Total Meltdown, a vulnerability created when Microsoft tried to patch the initial Meltdown flaw, is available on GitHub.

XPN describes Total Meltdown as a “pretty awesome” vulnerability in that it allows “any process to access and modify page table entries.”

XPN also noted that the goal was to create an exploit that could “elevate privileges during an assessment,” but it was only to help other people understand the exploitation technique, not to create a read-to-use attack.

Total Meltdown was originally created from a botched patch Microsoft issued for the original Meltdown flaw–of the Spectre/Meltdown vulnerabilities reported earlier.

Whereas the original Meltdown flaw was read-only, Total Meltdown also provides write access. This only affects 64-bit versions of Win7 and Server 2008 R2.

See the Woody on Windows column in Computerworld, https://www.computerworld.com/article/3269003/microsoft-windows/heads-up-total-meltdown-exploit-code-now-available-on-github.
There have been a series of flawed patches and its not pretty reading so take tiem to check out the article in full.

To tell if you’re protected from Total Meltdown, you’ll have to check your patch history. If you have no patches from 2018, you should be good, according to Woody on Windows. If you do have patches, KB 4100480, 4093108, or 4093118 installed, you should also be protected. Without those, Woody on Windows noted, you’ll need to rollback your machine, manually install KB 4093108, or use “Windows Update to install all of the checked April Windows patches.”

However there is lot more cautionary advice to read.

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

April 9th, 2018

The newest update to Microsoft Dynamics 365 for Finance and Operation, now version 8.0 (specifically build number 8.0.30.8020).comes with release notes fthat run to 222 pages,

https://docs.microsoft.com/en-us/dynamics365/unified-operations/fin-and-ops/get-started/whats-new-changed-8-0-april-2018

The Dynamics technology platform now has easier integration from Dynamics 365 Enterprise to other Dynamics products such as : Dynamics Talent, Field Service and Project Service Automation.
In addirion to the Common Data Service (CDS) for Apps which includes templates that are easily configured rgere is also a new Data Integrator tool for Dynamics 365 Enterprise provides thtat makes it easier way to work with the Common Data Service .

Microsoft is leveragign the scalaeability and data mining powers of the clud to use Telemetry acorss ts products. We will now get knowledge-base (KB) recommendations that help Microsoft support to understand how well hotfixes have solved an issue and rhen to proactively push out hotfixes to customers. This proactuve approach will allow customers to spend less timesearching for hotfixes for solutions to problems that already have a published hotfix. after all isn’t that the job of the software author – to provide code that works and for support to fix it when it doesn’t? Aggod example of how Aiis alreaqdy changign things.

Previous posts have hgihglighted of Business Productivity Improvements. Let’s recap:

Alerts – As with Ax 2012 client-based alert functionalityis now availbale for a user to define alert rules on business events, such as when master data is changed or an invoice is paid or a customer changes an address.
Optimization advisor – Uses telemetry to analyze customers’ business processes, finds optimization opportunities,and uses application data to quantify the opportunities, and then recommends solutions.
Project timesheet mobile – Employeescreate and submit project timesheets. Out-of-box mobile app for submitting timesheet. Nnow we have saved favorites. We can also copy from a previous timesheet ffir mire raOid entry rapid, accurate time entry.
Project resource managers can edit the default hours as part of the project booking fulfillment process. Thhey can also now eserve project resources past the task end date
A Person search report – to find a person and their personal data in Finance and Operations.
Data sharing for customer and vendor tables – Data can be shared across customer and vendor tables and many related tables across multiple legal entities.
One voucher deprecation – One voucher is turned off by default, through a General ledger parameter.

Supply Chain Management Updates

Vendor collaboration – RFQ process – Enhancements to tell who entered a bid (a vendor or a procurement department).
Partial shipment of a load (split load) – Allows single loads or multiple loads to be fully or partially loaded.Immediate replenishment of locations – Used during wave execution wjen allocation fails for a location directive line that has a replenishment template.
Add Reason codes to warehouse counting and adjustment – Users can add a reason code when performing counts and when making an adjustment for better control and audit
Batch balancing is enabled for advanced warehouse module processes.
New Cost administration and Cost analysis Power BI workspaces/

Power apps
Ability to embed PowerBI and PowerApps directly in forms without writing code using a host control. User select in form from the menu bar.an option to add PowerApps

There are also improvements regarding Lifecycle Services and environment management. There is also a new channel to report production outage to escalate a support issue with Microsoft should your Production environment not be available. Financial reporting enhancemtns for (Management Reporter) is alo included.

Another important change is upgrade automation- to upgrade non-production environments.

Dynamics 365 Business Applications Spring 2018

April 3rd, 2018


Take a look into new PowerApps capabilities added during Business Applications Spring 2018 Launch

Office 2019 and Office 365

April 2nd, 2018

After Office 2019 is released in the 2nd half of this year – that will be the last version of Office sold without an office365 subscription.

Microsoft will shorten the lifecycle for all the existing versions of office so everyone who wants to use office tools will need to buy an Office365 subscription at some point.

In 2017, Microsoft slashed the rights of users running non-subscription Office when it announced that perpetual-licensed versions of Office 2016 will be barred from connecting to Microsoft’s cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business) after Oct. 13, 2020. Under the new rules, owners of a perpetual license for Office 2016 can use those services only during the first half of their 10-year support lifecycle, the portion Microsoft dubs “mainstream.” Office 2016′s mainstream support ends Oct. 13, 2020.

By releasing Office 2019 this year, Microsoft will give enterprises a year or so to migrate from Office 2016 (or an earlier edition) before the cloud service cutoff. Rather than the usual decade of support – the first five in what Microsoft dubs “Mainstream,” the second five as “Extended,” which provides security-only updates – Office 2019 will get only seven years. “Office 2019 will provide 5 years of mainstream support and approximately 2 years of extended support,” said Spataro in the Feb. 1 announcement. “This is … to align with the support period for Office 2016. Extended support will end 10/14/2025.”

That’s the same day Office 2016′s support expires.

The simultaneous retirement of the two perpetually-licensed suites is the strongest signal yet that Microsoft plans to shut down the one-time purchase option after Office 2019. By shortening 2019′s support lifespan – something Microsoft has never done to Office for Windows – it will be able to wash its hands of both suites at the same time, ending the decades-old purchasing option and making the subscription-based Office 365 the only way to license the applications.

Office 2019 will be supported only on Windows 10.

February release update for Dynamics AX 2012 R3 CU13 – ask Synergy Software Systems

March 27th, 2018

The February release for Dynamics AX 2012 R3 version is now available in LCS on the updates tile inside your R3 project.
This update is a collection of smaller functional improvements and technical fixes.
Bugs were fixed in all areas, with enhancements found in Warehouse & Transportation, Master planning, Service Management, Procurement, Sales, Client, Server, SI, Project Accounting, Inventory, Retail, DIXF, APAC, Europe and LATAM localizations, Production, Cash and Bank, Expense, and Tax updates

This release is a cumulative package including all other fixes released in the prior CU13 update as well as the recent monthly updates.

• Primary Build: 6.3.6000.4901
• Number of Application hotfixes: 121
• Number of Binary hotfixes: 16

Details of the install process can be found here: https://technet.microsoft.com/en-us/library/hh538446.aspx#PackageR3

for more information contact Synergy Software Systems tour Dubai based Dynamics Ax partner.

#Dyn365FO Spring 18 release

March 24th, 2018

The release is due out in April and brings many new features:

Business productivity
Alerts – Client-based alert functionality enables a user to define alert rules based on business events, such as when an invoice is paid or a customer changes an address.
Optimization advisor – Uses telemetry to analyze customers’ business processes, finds optimization opportunities, uses application data to quantify the opportunities, and then recommends solutions.
Project timesheet mobile - Employees can create and submit project timesheets. The use of saved favorites and the ability to copy from a previous timesheet facilitates rapid, accurate time entry.
Edit default project fulfillment hours – Project resource managers can edit the default hours as part of the project booking fulfillment process.
Reserve project resources past the task end date – Project resource managers can fulfill resources on tasks past the current task planned end date..
Person search report - You can find a person and their personal data in Finance and Operations.
Data sharing for customer and vendor tables –share Data across customer and vendor tables and related tables across multiple legal entities.
One voucher deprecation – One voucher is turned off by default, through a General ledger parameter.

Extensibility and customization
Customizations through extensions only - Migrating customizations from one release to the next has been simplified by moving away from over-layering to the use of extensions.
Extensibility requests - Customers can submit a request to Microsoft for extension support to be added to the product for a needed scenario. The Spring ’18 release enhances this feature by moving it to Lifecycle Services.
Extensible project work breakdown structure – Enables customization of the project work breakdown structure using extensions. This replaces the hierarchical grid control used for the project work breakdown structure with a standard grid that supports hierarchical data.
Embedding PowerApps in workspaces and forms – Use PowerApps to embed data from external sources into Finance and Operations data.
Custom fields - Organizations can add custom fields to tailor their application to their business requirements, using a no-code extensibility experience.

Integration
Integration with Common Data Service (CDS)
Integration with Dynamics 365 for Field Service - Provides data integration to support scenarios where Field Service activities are done outside Finance and Operations, leveraging the data integrator.
Integration with Dynamics 365 for Project Service Automation - Supports scenarios where project and resource management activities are done outside Finance and Operations, and the project accounting activities are done in Finance and Operations, leveraging the data integrator.
Integration with Dynamics 365 for Talent (Public Preview) – Provides data integration of the appropriate HR information into Finance and Operations.

Improved support experiences
Telemetry-based KB recommendation - Telemetry from a production environment can be used to identify the application hotfixes that apply to a tenant.
• KB recommendations when entering a support case - LCS provides telemetry-driven KB recommendations.
Report production outage – Provides a quick and effective channel to escalate issues to Microsoft Support if the services in a production environment are degraded or become unavailable.

Supply chain management
Vendor collaboration – RFQ process – Enhancements make it easy to tell who entered a bid (a vendor or a procurement department).
Partial shipment of a load (split load) - Allows single loads or multiple loads to be fully or partially loaded.
Immediate replenishment of locations – Used during wave execution if allocation fails for a location directive line that has a replenishment template.
Reason codes added to warehouse counting and adjustment – Users can add a reason code when performing counts and when making an adjustment.
Batch balancing enabled for advanced warehousing processes.
Analytical workspaces with embedded Power BI for Cost management – new Cost administration and Cost analysis workspaces

Globalization
India localization – project and upgrade – Users can manage India Goods and Services Tax (GST) for the Project management and accounting module, and AX 2012 customers can upgrade to Dynamics 365 for Finance and Operations.
Enhanced configurability - New features include import and testing scenarios, and also broader support for configurability without coding.
Translation Service - In addition to supporting user interface translation, Dynamics Translation Service (DTS) now supports documentation translation in Microsoft Word and HTML formats (.docx, .html). DTS features can also be accessed directly from various development environments by using the DTS API.
• Regulatory service – configuration (available at the end of April) – Regulatory service targets a no-code programming approach, allowing users to configure electronic reporting formats or tax rules rather than write code for them in the underlying application.
Integration

Servicing, performance, and deployment
Improved delivery of platform and financial reporting updates – Enhancements to how software updates are provided, to improve deployment time and the reliability of servicing.
Upgrade automation – Upgrade automation makes major version upgrades a self-service operation for the customer, using LCS for non-production environments.
Service hardening – Added service monitoring and alerting for core business processes, and improved form load performance of the most commonly used forms.
Lifecycle Services sandbox self-service automation and RDP lockdown.
On-premises deployment updates. Much awaited!

Compliance
General Data Protection Regulation (GDPR) – Investments address the European privacy law’s requirements. Go to the Trust Center to learn more and find resources to help you comply. See our previous posts on the importance of this new legislation.
Accessibility enhancements – Go to the Trust Center to learn about industry-leading accessibility standards.

Finance Insights: Credit and collections

Credit and collections insights provides analytics that help organizations effectively manage their credit and collections processes. It provides:
• Aggregate views of credit and collections across all designated companies.
• Data broken down by company, customer group, and customer.
• Credit overview report.
• Collections report.
• Credit and collections details for a variety of dimensions.
• Predictive analytics to help identify trends.

Lots lots more : Retail, cds, flow, Power bi etc

For more information contact your Dynamics 365 Dubai partner Synergy Software Systems 009714 3365589

Dynmaics 365 Finance and Operations Enterprise 7.2 platform 12 on-premise enhancements

March 19th, 2018

The much anticipated release of on-premises deployments of Dynamics 365 for Finance and Operations, Enterprise edition 7.2 with platform update 12 includes features that will enables you to keep your on-premises deployment up-to-date at cloud speed.

Major improvements in this release include:
• Apply Microsoft-released platform and application updates, and code customizations, to your environment post-deployment through Lifecycle Services (LCS) for on-premises customers.
• Infrastructure setup automation improvements that enable much faster setup for most common topologies.
• Optionally disable experiences that depend on internet connectivity on the client machine, even when the client is connected to the internet . To enable this via a simple configuration update from the application functionality, you must download KB 4091763 from LCS.

We also expect the release 7.3 and Data import/export framework (DIXF) for recurring integration support to be released soon.

As always, there may be some changes in the release schedule.

Microsoft public preview of Azure SQL Database Managed Instances – running SQL Server workloads in the cloud

March 10th, 2018

Microsoft released the public preview of Azure SQL Database Managed Instances – a new option for running SQL Server workloads in the cloud.

Managed Instances (or Azure SQL Database Managed Instances, are a new PaaS database offer that joins the Azure SQL Database and Elastic Pool services. Within this PaaS family, Managed Instances take care of operational aspects like ensuring: high availability, backups, and applying patches, making these simpler and less time-consuming to administer.

While many organizations have benefited from using Azure SQL Database for new applications, it has been a significant challenge to migrate existing workloads because of key functionality gaps versus on-premises SQL Server.

Managed Instances address that problem, by providing vastly improved compatibility. Organizations can therefore more easily migrate existing on-premises SQL Server workloads to the cloud while retaining many of the manageability benefits of a PaaS offering.

Managed Instances require less operational oversight compared to traditional on-premises SQL Server,. Use of the service however, doesn’t free you from the responsibility for checking availability or ensuring that security is configured appropriately. It also remains the DBA’s responsibility to optimize performance, and to handle other operational concerns like making sure jobs complete successfully, or general troubleshooting – its platform as a service. High availability, automated backups, point-in-time restore, automatic plan correction, threat detection, vulnerability assessment, and other intelligent features are built-in into service without any additional charge. OS patching and database upgrades are handled automatically and do not require any action.

In addition to built-in monitoring and maintenance features, you can use any 3rd-party tool to monitor and manage your instance, because most of the system views are exposed.

Connectivity

Azure SQL Managed Instance is not a service on public endpoint. Azure SQL Managed Instance is placed on private IP address in your VNET. It is just hosted and managed by Azure cloud.

Currently, Azure SQL Database PaaS has two main offers for the customers who use SQL Server database and want to migrate to PaaS:
1.Managed Database – isolated and self-contained database service that has database scoped functionalities.
2.Elastic pool – a group of Azure SQL databases that share the same resource.

However, current Azure SQL Database offers don’t provide entire SQL Server “Instance as a Service” as PaaS model. As a result, some of the instance-level features in Azure SQL Database PaaS such as SQL Agent or linked servers are not supported because they are not applicable on the database level.

Currently, the only way to get the full SQL Server instance in Azure is to use Azure SQL VM that handles underlying infrastructure (e.g. disks), but still not have some SQL PaaS features as Azure SQL Database.

Managed Instance is a SQL Server Instance in Azure cloud that shares the same code with the latest version of SQL Server Database Engine and has the latest features, performance improvements, and security patches. It has most of the SQL Server 2017 features (excluding some on-premise Windows features such as Windows logins or potentially harmful features such as extended stored procedures) and enables you to put almost any database that you have in on-premises SQL Server instance. Every instance is fully isolated from the other customer instance and placed in your dedicated subnet with assigned private ip addresses.

Security/Isolation. Managed Instance is a resource in your network hosted by Azure cloud. You have to create Azure VNET and a dedicated subnet where the instance should be deployed. There are networking constraints for the VNET/subnet that you should review before you create a managed instance.

There is no public IP address dedicated to the Managed Instance. Only applications in customer network can access Managed Instance. Network administrators have the full control and can configure access to Managed Instance using standard methods such as Network security Groups and firewalls.

Choose how many CPU cores to use and how much storage you need. You can create a Managed Instance with 16 cores and 500GB storage, and then increase or decrease these numbers depending on your needs. Changing CPU or storage in instance can be done via Azure portal using simple slider.

Managed Instance has split compute and storage components. There are compute nodes with 8, 16, or 24 cores, that work with database files stored on Azure Premium disk storage. Every database file is placed on separate Azure premium disk, that guarantees that database files cannot be lost. Although Managed Instance relies on Azure Premium disks, it also has separate backup mechanism that ensures that even if something would happen with the files, platform would still be able to restore files from backups.

SQL 2008 Extended support ends July 2019

March 4th, 2018

A remdnder that Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 ended on July 8, 2014. – Support Lifecycle policy, found in http://support.microsoft.com/lifecycle.

Customers are encouraged to prepare and execute on their upgrade and/or sustained engineering plans as early as possible for these SQL versions. Remaining current on your SQL Server version ensures that your product remains supported per the Support Lifecycle policy. Additionally, your software benefits from the many enhancements, fixes, and security updates provided through the latest releases.

For both SQL Server 2008 and SQL Server 2008 R2, Microsoft will continue to provide technical support which also includes security updates during the duration of extended support. See the table below for extended support end date. Non-security hotfixes for these versions will be offered only to customers who have an Extended Hotfix Support agreement.

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.

February 24th, 2018

Dynamics 365 Finance and Operations Enterprise is Microsoft’s flagship cloud-based ERP system, Dynamics 365 for Finance and Operations is optimized to deliver improved global visibility, scalability and digital intelligence.

Overview

Financial dimensions

Workflows

Journals