Archive for the ‘SQL’ category

Microsoft’s cloud ambitions expand with Azure stack – Hybrid cloud and Metanautix

February 7th, 2016

Microsoft unveiled its new Azure Stack offering at last year’s Ignite conference as a solution that would enable users to easily run Azure cloud services in their own on-premises datacenters, thus supporting the increasingly hybrid nature of organizations’ IT environments.

Microsoft Corporate Vice President Brad Anderson, speaking at the 2015 Ignite keynote, described Azure Stack this way:
“This is literally us giving you all of Azure for you to run in your datacenters. What this brings you is you get that great IaaS and PaaS environment in your datacenters. You have incredible capability like a unified application model that gives you a one-click deployment experience for even the most complex, multi-tier applications and then you get that cloud-inspired infrastructure. We’re giving you the same software controller that we built for our network, the name is the same, network controller. We’re giving you our load balancing. We’re giving you all the storage innovation.”

Azure Stack represents an evolution of Microsoft’s older Cloud OS solution, which also promised to give partners and organizations the ability to build Azure environments in their datacenters, but suffered from low uptake due to its complexity. Azure Stack shares a common architecture, application model and DevOps tool set with Azure, according to Microsoft. This minimizes the work that developers need to do to make sure their apps work on both Azure and Azure Stack, as well as lets IT pros extend on-premises apps to the cloud without having to drastically change the tools they use for automation or management. Microsoft has not given a specific date for Azure Stack’s release, but because it is linked with the company’s 2016 wave of server releases, it will likely become generally available by year’s end.

While Microsoft claims 100,000 new Azure subscriptions per month, it also recognizes that many enterprises “still have business concerns around moving fully to the public cloud, such as data sovereignty or regulatory considerations.” So they are in limbo between the public cloud and on-premise; hence the need for a hybrid cloud approach that provides consistency across private, hosted, and public clouds.

Among the capabilities:
• Azure and Azure Stack feature a standardized architecture (e.g., the same portal, a unified application model, common DevOps tools); thus, developers can offer the same end-user experience as Azure delivers.
• IT professionals can transform on-premise datacenter resources into Azure IaaS/PaaS services while maintaining oversight and corporate governance, using the same management and automation tools that Microsoft uses to operate Azure.

For heavily-regulated companies, control where data resides. Highly regulated companies (SOX, HIPAA, FDA, etc.) having their data hosted at a Microsoft Azure datacenter doesn’t typically meet all of their regulatory requirements. and there is a growing demand for enterprise cloud apps, with a hybrid cloud platform product that helps enterprises deploy Azure Services in a private cloud environment.

So, businesses have the freedom to decide where applications and workloads reside – overcoming one of the most vehement objections to the cloud.

Azure Stack and Dynamics
The new Dynamics AX, which will be launching on Azure first, apparently in March. The plans to bring the new AX to private cloud and on-premise customers hinge on the release of Azure Stack for the Windows Server 2016 wave of products.

Metanautix,
In December Microsoft furthered its pursuit of enterprise analytics with the acquisition of Metanautix, a company that makes it possible for businesses to pull together all their data and gain insights into it. Metanautix’s product can pull information in from a variety of private and public cloud data sources including traditional data warehouses, NoSQL databases like Cassandra and business systems like Salesforce. Once it’s aggregated, businesses can use SQL to query the resulting data pipeline in order to glean insights from the information. Microsoft isn’t saying much about its plans for Metanautix’s technology, but it can be expected to roll it into products like SQL Server and the Cortana Analytics Suite.

Why Azure anyway?
Managed Web Sites
Window Azure has a special mode of use just for 2-tier web sites, called Windows Azure Web Sites. Both Microsoft’s SQL Database or MySQL databases can be used. WAWS web sites use a shared VM pool, and provisioning happens in just seconds, not minutes. Customers can promote to reserved VMs if they choose. WAWS web sites are fast, easy, and superbly managed.

WEB FRAMEWORK SUPPORT
Window Azure Web Sites also support common open source frameworks, including DotNetNuke, Drupal, Joomla, Orchard, and WordPress. Web developers can quickly provision web sites with their desired framework.

WEB DEPLOYMENT FREEDOM
Web developers work in different ways, and there’s no single way to deploy. Windows Azure Web Sites support several popular methods of deployment, including Web Deploy, FTP, Git, and TFS. In addition, the deployment is conveniently always to a single “server”, even when running multiple server VMs in the cloud. WAWS takes care of distributing new and updated deployment files to the individual VM instances.

IAAS
Window Azure now has Infrastructure-as-a-Service (IaaS) support, to complement the Platform-as-a-Service (Paas) support. IaaS Virtual Machines are based on VHDs which are fully portable between cloud and on-prem and those are also persistent, making Windows Azure viable at last for single-server solutions and for running server products such as AD, SQL Server, or SharePoint Server.

Non-Microsoft OS & Database support

Traditionally, Microsoft has offered platform services based on Windows Server and SQL Server. With the new platform there is support for Linux virtual machines and MySQL databases. This means a broader range of software can now run in the Microsoft cloud even SAP.

VM Image Gallery
When creating Virtual Machines, select from a gallery of pre-configured images. For example, install Windows Server 2008 plain, or with SQL Server also installed or add your own VM images to the gallery.

VM Composition

Window Azure virtual machines is easily provisioned, configured, and managed in the Windows Azure portal. Once you connect to and set up a VM, capture its disk to create a reusable image that is added to your VM image gallery.

Cloud Services

The traditional Platform-as-a-Service (PaaS) mode–now known as Cloud Services–not only remains, it’s getting new and updated services. An expanded virtual networking capability can interface with enterprise VPN appliances to enable hybrid cloud scenarios where segments of your local network are joined to your cloud assets. Windows Azure Media Services, a new service in limited preview right now, will allow uploading, transcoding, and delivery of media content such as video. A new identity service is coming that will extend the identity federation we currently have in the Access Control Service with expanded capabilities.

The New Portal

Window Azure gets a huge usability boost in a cutting-edge new . HTML-based, management portal that can also be used on mobile devices such as iPads and Windows 8 slates. The new portal also provides a view of built-in metrics for WAWS, Cloud Services, and Virtual Machines.

New Data Centers

Two new data centres were added recently (West US and East US), bringing the number of Windows Azure data centers to 8 (four in the US, two in Europe, and two in Asia). In addition, there is supporting worldwide infrastructure including a 24-node edge cache CDN network.

Ax 2012 R3 CU 10 compatible with SQL 2012 Sp3

January 24th, 2016

Microsoft Dynamics AX 2012 R3 Cumulative Update 10 and AX 2012 R2 Cumulative Update 9 are now compatible with SQL Server 2012 SP3.

The Microsoft Dynamics AX 2012 System Requirements are updated to reflect this change.

SQL Server 2005 – supports ends April 2016 – are you ready?

January 24th, 2016

Microsoft SQL Server 2005 will reach the end of extended support on April 12, 2016.
With the end of support, security updates and hotfixes will no longer be available from Microsoft
Note also that Windows 2003 support ends in July 2016

Microsoft Bi momentum continues with December 2015 releases.

December 26th, 2015

Microsoft has released the December update of Power BI Desktop and several updates of the Power BI service.
Microsoft is moving quickly to take the cloud market of BI services, which is still relatively unexplored (most companies still keep their data on premises), and is the only mainstream player providing a credible story of integration between cloud and on premises BI services,
Microsoft is leveraging many assets (the Tabular engine, Power Pivot, Power Query, Power View, and many other Azure’s based services. Its weak point has always been where other BI vendors focus the “last mile” of data visualization and presentation. That is being addressed with acquisitions like Datazen.
Microsoft SQL Server 2016 will be a huge release for the BI services. SQL Server Analysis Services is a very important release, being the first major upgrade since SQL Server 2012 for Analysis Services Tabular. There are many new features that will make Tabular a more “enterprise ready” platform. The magic key will be “Hybrid BI”.
SSRS will play an important role of the on-premises BI portal. integration between SSRS 2016 and Power BI will allow users to pin SSRS report items to Power BI dashboards. You can test pinning reports items to Power BI with SQL Server 2016 CTP 3.0 and later. The newly released CTP 3.2 also features the new sleek SSRS portal. Power BI is has become a focal point for cloud hosting of the main MS report artifacts i.e.: Power BI reports, Excel reports, and SSRS reports.
Last week Microsoft introduced mobile reports along with SQL Server Mobile Report Publisher, a new desktop app to to design and publish reports. You can now download a preview version of Mobile Report Publisher.

SQL Cumulative updates December 2015

December 26th, 2015

SQL Server 2014 SP1 is now available for download at the Microsoft Support site.

To learn more about the release or servicing model, please visit: CU#4 KB Article: https://support.microsoft.com/en-us/kb/3106660

SQL Server 2014 RTM CU11 is now available for download at the Microsoft Support site.
To learn more about the release or servicing model, please visit:•CU#11 KB Article: https://support.microsoft.com/en-us/kb/3106659

SQL Server 2016 – 10 things Synergy Software Systems likes.

October 31st, 2015

Microsoft announced the release of SQL Server 2016 in May 2015. Since that time a number of Community Technical
It will not be too long until SQL Server 2016 tili ts ready for shipping.

There are many new features , here a few we like:

Always Encrypted
With the Always Encrypted feature enabled SQL Server data will always be encrypted while within SQL Server. Always Encrypted enables client application owners to control who gets access to see their applications confidential data. The client application has the encryption key and that key is never passed to SQL Server.

If you want to store confidential data in a cloud managed database then it can be always encrypted even to your cloud provider.

Dynamic Data Mask
Dynamic data masking can obscure confidential columns of data in a table to SQL Server for users that are not authorized to see the all the data. For instance for define a masking rules so that unauthorized logins can only read the last four digits of a credit card number, whereas authorized logins can see all of the credit card information.

JSON Support
JSON – Java Script Object Notation. SQL Server 2016 can interchange JSON data between applications and the SQL Server database engine. This gives SQL Server the ability to parse JSON formatted data to be stored in a relation format. With JSON support also turn relational data, into JSON formatted data. .

Multiple TempDB Database Files
It has been a best practice to have more than one tempdb data file when running on a multi-core machine. In prior tSQL Server versions , you had to manually add the additional tempdb data files after you installed SQL Server. With SQL Server 2016 you can configure the number of tempdb files while installing SQL Server.

PolyBase
Use PolyBase to write adhoc Transact SQL statements queries to join relational data from SQL Server with semi-structured data stored in Hadoop, or SQL Azure blob storage. Get data from Hadoop without knowing the internals of Hadoop. Leverage SQL Server’s on the fly column store indexing to optimize queries against semi-structured data

Query Store
Prior versions of SQL Server can see existing execution plans by using dynamic management views (DMVs) but, those DMVs only allow you to see the plans that are actively in the plan cache. You can’t see any history for plans once they are rolled out of the plan cache. The Query Store feature, saves historical execution plans. and also saves the query statistics for those historical plans.

Row Level Security
With Row Level Security the SQL database engine can restrict access to row data, based on a SQL Server login. Security policies will ensure the filters get executed for every SELECT or DELETE operation. Implementing row level security at the database layer means application developers will no longer need to maintain code to restrict data from some logins, while allowing other logins to access all the data. With this new feature, when someone queries a tables that contains row level security they will not even know whether or not any rows of data were filtered out.

R Comes to SQL Server
Revolution Analytics is now available inside of SQL Server to support advance analytics against big data. This will eliminate the need to export your SQL server data to perform R processing

Stretch Database
Stretch the storage of your On-Premise database to Azure SQL Database. The stretch database feature allows you to have your most frequently accessed data stored On-Premise, while your less accessed data is off-site in an Azure SQL databases.
When you enable a database to “stretch”, the older data starts moving over to the Azure SQL database behind the scenes. When you run a query that might access active and historical information in a “stretched” database the database engine seamlessly queries both the On-Premise database as well as Azure SQL database and returns the results to you as though the data comes from a single source. This feature will make it easy for DBA’s to archive information to a cheaper storage media without having to change any actual application code. Maximize performance on those active On-Premise queries.

Temporal Table
A temporal table is table holds old versions of rows within a base table. Use temporal tables in SQL Server to automatically move old row versions to the temporal table every time a row in the base table is updated. The temporal table is physically a different table then the base table, but is linked to the base table. This simplifies the management of row versioning.

Where to find Additional Informationabout SQL Server 2016.

SQL Server 2016 data sheet: http://download.microsoft.com/download/F/D/3/FD33C34D-3B65-4DA9-8A9F-0B456656DE3B/SQL_Server_2016_datasheet.pdf

SQL Server 2016 release notes: https://msdn.microsoft.com/en-US/library/dn876712.aspx

What’s new in SQL Server, September Update: https://msdn.microsoft.com/en-US/library/bb500435.aspx

Summary

Microsoft SQL Server 2005 end of life.

October 22nd, 2015

Microsoft SQL Server 2005 Extended Support will end on April 12, 2016. With the end of support, security updates and hotfixes will no longer be available from Microsoft.

Unsupported software means increasing vulnerability to data issues and exposing other devices and applications of SQL Server to these same vulnerabilities.

– Plan now to upgrade and end the business disruptions caused by slow-performing databases and downtime.
– Take advantage of the powerful database functionality now available with SQL 2014.

Dynamics Dubai Careers – Synergy Software Systems

October 4th, 2015

Synergy Software Systems is a member of the Microsoft President’s Club and has provided stable employment since we were founded in 1991. Synergy is also the also the oldest Microsoft Dynamics partners in the region and has an experienced stable consulting team that is respected globally for its knowledge delivery and support. This is reflected in our membership for several years as the Middle East partner for Ax Pact a global alliance of some of the best Dynamics partners.

Our practise continues to thrive and to expand into new verticals and geographies. If you are a seasoned consultant with 10 years or more professional and consulting experience and at last 5 years in Dynamics, or at the start of your career have strong academics in relevant subjects. Even better if you have proven documentation skills, product exposure, and can speak good English and ideally also Arabic or French and lot more! We provide an excellent learning and support environment but there is also strong peer expectation (and competition). The result is one of the most senior and stable consulting Dynamics teams, and customer bases (many with us more than 15 years).

Next year the future includes Dynamics CRM 2106, Dynamics Ax 7, Sql 2016, Edge browser, Windows 10 Office 2015, Cortana Analytics, Holo lens, and much, much more with an azure platform that is built to dominate the cloud. Where is your future. We also have other world class practices fr example Enterprise Time and Attendance.

Do you have what it takes to be a Synergy consultant? Don’t expect to start at the top – without the credentials but Synergy on our cv will give your worthwhile experience. There is still a global recession there are many troubled areas and refugees – try Dubai and Synergy Software Systems for challenging work, ongoing career enhancement and stable employment.

Power BI now released – try it with Syenrgy Software Systems, Dubai!

July 25th, 2015

Microsoft released Power BI as a beta earlier this year, and the new service is finally ready to exit preview and become generally available this month.
Microsoft built Power BI around three essential components: datasets, reports, and dashboards.
Power BI can draw content from a firm’s data, and leverage connections to multiple sources such as: Azure SQL Data Warehouse, Azure SQL Database, SQL Server Analysis Services and more.
Power BI currently supports 44 languages and will also work on multiple platforms.
Preview builds are already available for Android and iOS, as well as Windows, and the final release will hit mobile versions as well.

Power BI Freemium Model:
Interested customers can try out Power BI for free if they sign up with their business email address, but the free tier comes with a 1 GB data cap per user and allows users to update their data only once a day. A Power BI Pro subscription will be available for $9.99 per month for each user, boosting data capacity to 10 GB and allowing users to refresh their data every hour, in addition to other benefits.


Power BI with Dynamics CRM


Inventory aging in Dynamics Ax

WPC 2015 summary – and a sneak peek at Ax 7

July 20th, 2015

Microsoft CEO Satya Nadella reinforced Microsoft’s bold mission: To empower every person and every organization on the planet to achieve more. “Together with our partners we are transforming the business world for the next era.”

Microsoft and partner speakers outlined how this will be accomplished. Create more personal computing, reinvent productivity and business processes, and continue to build, strengthen, and evangelize the intelligent cloud. Throughout the keynote, Microsoft executives thanked partners for the essential role they play in executing on this vision to foster mutual success.

Microsoft is investing in tools, resources, and product offerings to enable its partners to take advantage of the rapidly expanding markets for cloud and mobile technologies. The imminent release of Windows 10 will ushers in a new era of personal computing with one operating system that spans all platforms and devices.

As CEO Satya Nadella said,”What makes Microsoft unique is the people in this room, this partner ecosystem.” Together, we are on the frontlines of transforming business around the world.

we saw how , Autodesk, will use HoloLens, the world’s first fully untethered holographic computing device powered by Windows 10, to fundamentally change how design professionals create, communicate, visualize, and work.

Project GigJam: empowers business workers to spontaneously summon, assign, and track information from their line of business and SaaS apps. Project GigJam breaks down the barriers between people, devices, and apps to expedite business tasks.

Cortana Analytics Suite: is a fully managed and comprehensive set of services to help businesses transform data into intelligent action, will be available this Fall as a monthly subscription, as well as through third party solutions. The Suite brings together leading technology infrastructure with perceptual intelligence to enable businesses of any size to transform themselves through the power of data.

COO Kevin Turner outlined a plan of action for reinventing business productivity and owning the cloud. “It’s an exciting moment to be in technology,” A new Microsoft-commissioned IDC study shows that 80% of business customers buy through channel partners for cloud services. The study indicates that customers of all types look for a partner who can play the role of a trusted technology advisor – the most important criteria customers look for in a solution provider. Microsoft partners are a massive competitive advantage, and this research is a validation of the critical importance of partners in the cloud era.

A peek at Ax 7


WPC 2016 will be Toronto, Ontario, Canada

SQL Server Management Studio 2015 – new version (June) – with Check for Updates!

June 27th, 2015

Today, Microsoft announced a new standalone SQL Server Management Studio download

“This is our first effort to release SQL Server Management Studio (SSMS) in a mechanism outside of the SQL Engine releases. Our goal is to update this frequently with new features, fixes and support for the newest SQL Server features in SQL Server Engine and Azure SQL Database.”

Microsoft might start shipping updates to SSMS outside of the regular SQL Server Service Pack scenario! This telegraphs a couple of interesting things: first, surely they have to do it because Azure SQL Database ships updates much faster than SQL Server does. So this gives Microsoft a way to enable those updates in SSMS without releasing a separate service pack.

This implies that SQL Server Management Studio is now considered The Way to Manage Azure SQL Database. There isn’t a separate tool coming, nor will designer/developer tools like Visual Studio become a management tool. That sounds good news.

SQL Server 2014 – Latest Builds end June 2015

June 27th, 2015

Since Service Pack 1
Regardless of your branch or patch level, be sure to check KB #2964518 : Recommended updates and configuration options for SQL Server 2012 / 2014, which is full of useful advice. Please always perform full regression testing before installing any SQL Server update in production. It’s becoming more and more clear that you might find an issue Microsoft missed.

SQL Server 2014 Service Pack 1 was re-released after being pulled on April 15th due to an issue described in this post. The initial build number was 12.0.4050 but that has been updated to 12.0.4100. The official knowledge base article has been moved to KB #3058865,

Service Pack 1 includes a number of enhancements; these were the most interesting to us:
•The behavior of trace flags 1236 (see KB #2926217) and 9024 (see KB #2809338) will now be enabled by default.
•Several fixes for buffer pool extensions, including the ability to use instant file initialization.
•Improvements in columnstore performance and new extended event coverage for columnstore inserts.

SP1 Cumulative Update #1 includes 141 fixes, including all of the fixes from the RTM Cumulative Updates published up to and after SP1 was released (CU #6, CU #7, and CU #8 – One of the more important fixes is one that involves partial (and thus incorrect) results from a clustered columnstore index with a corrupted rowgroup (more gory details in this blog post and KB #3067257).

Recommendation: Install this Cumulative Update.

Service Pack 1 12.0.4100 KB #3058865 2015-05-15 29 (29)
Service Pack 1 (pulled) 12.0.4050 N/A

RTM Branch

If you are on the RTM branch, SQL Server 2014 is now at Cumulative Update #8 (including well over 400 fixes and enhancements). If you are applying Cumulative Updates at all, or want any of the interim fixes, we highly recommend using the latest update
The Build is 12.0.2546. This cumulative update has 38 public hotfixes . This CU may be less attractive now that Microsoft has also released SQL Server 2014 SP1 CU1. I because many people may get onto the SP1 branch, now that the first CU on top of SP1 has been released, and the branches are back in synch.

Build Name

Build #

KB Article

Date

New fixes (public)

Cumulative fixes (public)

RTM Cumulative Update #8 12.0.2546 KB #3067836 2015-06-22 40 (38) 486 (432)


One of the more important fixes here is one that involves partial (and thus incorrect) results from a clustered columnstore index with a corrupted rowgroup (more gory details in this blog post and KB #3067257).

Recommendation: Install this Cumulative Update.

COD Hotfix for Azure Premium Storage Support 12.0.2506 KB #3063054 2015-05-19 1 (1) 450 (398)
COD Hotfix for intraquery parallel deadlock 12.0.2505 KB #3052167 2015-05-19 1 (1) 449 (397)
COD Hotfixes for SSIS / CCI 12.0.2504 KB #3058512 2015-05-05 2 (2) 448 (396)


A hotfix has been issued to address two completely different issues: (1) a problem with the Unpivot transformation task in SSIS (for more info, see KB #3058512), and (2) a problem with join performance when using a clustered columnstore index (see KB #2999809 for more details).

Recommendation: Install this hotfix only if you are using SSIS with Unpivot or clustered columnstore indexes.

RTM Cumulative Update #7 12.0.2495 KB #3046038 2015-04-23 47 (41) 446 (394)
COD Hotfix for Parallel Batch-Mode Deadlock 12.0.2488 KB #3048751 2015-04-01 1 (1) 401 (355)


A hotfix has been issued to address a potential problem where a parallel, batch-mode scan may lead to a deadlock, and the deadlock cannot be automatically resolved. This should only affect customers using Columnstore indexes. The hotfix can be downloaded from KB #3048751. It is included in Cumulative Update #7 (under a slightly different KB article: KB #3048752).

Recommendation: Install the latest cumulative update above, which includes this fix.

COD Hotfix for Availability Groups with CLR UDTs 12.0.2485 KB #3042370 2015-03-16 1 (1) 400 (354)


A hotfix has been issued to address a problem with CLR UDTs in Availability Group databases. The hotfix can be downloaded from KB #3043788 and is described in KB #3042370.

Recommendation: Install the latest cumulative update above, which includes this fix.

RTM Cumulative Update #6 12.0.2480 KB #3031407 2015-02-16 64 (55) 399 (353)
COD Hotfix for Availability Groups NOT SYNCHRONIZING 12.0.2474 KB #3034679 2015-02-04 1 (1) 338 (301)


A hotfix has been issued to fix Availability Groups reporting as NOT SYNCHRONIZING, an issue caused by CU #5 below. That issue is documented in KB #3033492 and explained further in this SQL Server blog post.

Recommendation: Install the latest cumulative update above, which includes this fix.

COD Hotfix for SSMS (Azure SQL Database) 12.0.2472 KB #3032087 2015-01-28 1 (1) 337 (300)
COD Hotfix for query compile waits 12.0.2464 KB #3024815 2015-01-05 1 (1) 336 (299)


A hotfix has been released that helps alleviate RESOURCE_SEMAPHORE_QUERY_COMPILE waits during concurrent compilation of large queries. A trace flag is also required (-T6498).

Recommendation: Install the latest cumulative update above, which includes this fix. The trace flag is required whether you apply the COD hotfix or the Cumulative Update.

RTM Cumulative Update #5 12.0.2456 KB #3011055 2014-12-17 54 (48) 335 (298)


Cumulative Update #5 has a known issue with Availability Groups reporting as NOT SYNCHRONIZING.

Recommendation: Avoid this update if you use Availability Groups. Apply the latest cumulative update above instead.

COD Hotfix for Availability Groups remote hardening 12.0.2436 KB #3014867 2014-11-27 1 (1) 282 (251)


A hotfix for an issue involving exception handling for remote hardening issues in Availability Groups was released on November 27, 2014.

Recommendation: Install the latest cumulative update above, which includes this hotfix. Install this specific hotfix only if you are using Availability Groups and your applications use OLEDB or JDBC (ODBC / SNAC are unaffected) and you don’t want any of the additional fixes in more recent CUs.

RTM Cumulative Update #4 12.0.2430 KB #2999197 2014-10-21 66 (54) 281 (250)
RTM Cumulative Update #3 12.0.2402 KB #2984923 2014-08-18 40 (32) 215 (196)
MS14-044 QFE Security Update 12.0.2381 KB #2984340 2014-08-12 1 (1) 175 (164)


A denial of service / privilege escalation vulnerability was identified and patched August 12, 2014.

It is described in Security Bulletin MS14-044 and KB #2984340.

Recommendation: Install the latest cumulative update above, which includes this QFE update.

RTM Cumulative Update #2 12.0.2370 KB #2967546 2014-06-27 52 (48) 174 (163)
RTM Cumulative Update #1 12.0.2342 KB #2931693 2014-04-21 121 (114) 122 (115)
MS14-044 GDR Security Update 12.0.2254 KB #2984340 2014-08-12 1 (1) 1 (1)


A denial of service / privilege escalation vulnerability was identified and patched August 12, 2014.

It is described in Security Bulletin MS14-044 and KB #2984340.

Recommendation: Install this GDR update only if you are at a build less than 12.0.2254 and only if you *don’t* want all of the fixes from the latest cumulative update above.

RTM 12.0.2000 2014-04-01 – –

Share this post:

Management Reporter Updates and tips – Synergy Software Systems, Dubai

June 18th, 2015

This video describes how to create side by side reports with Management Reporter

Management Reporter offers a variety of formatting tools to automate reporting and to quickly put reports in the hands of stakeholders. This video introduces the ability to add dynamic report headers to calculated columns to avoid having to manually edit report headers prior to generating a report. Especially useful for consolidated information and rolling fiscal reports

This video describes how to suppress drill down on specific lines of a report in Management Reporter.for example you may not want to allow drilldown on salary details.

MR CU12 was initially released for the USA in April and is now available for all regions.
It contains all of the enhancements and bug fixes from hotfixes 1-4, including:
• Indication of currently active reporting tree node
• Added the ability to use BASE+1:12 in the column definition
• Report generation performance improvements
• Additional fixes for product defects

HF1, HF2, HF3, HF4
As well as the additional fixes that were added post-HF4:
•Ability to exclude NP rows from exporting to Excel by disabling the export of formulas
•Ability to export NP rows at the Account and Transaction detail levels
•Additional fixes for exporting to Excel where you would receive an operand error when exporting with formulas enabled
•Additional fixes for product defects
Version Information: Management Reporter CU12 RTM – 2.1.12000.26

Management Reporter bugs are now visible in Lifecycle Services (LCS) Issue search. Issue search is another great tool within LCS to help with troubleshooting. Currently both Microsoft Dynamics AX and Management Reporter bugs are searchable.

For Management Reporter, bugs will be visible through LCS when they are triaged to be fixed. Additional updates in LCS will occur when either a cumulative update or hotfix is available to fix the issue. To see a list of current known issues, you can search for “known issue” and restrict the product to Management Reporter 2012.

In order to access Issue search, you can do the following:

1. Navigate to http://lcs.dynamics.com

2. Click Sign in

Note: You must use the same credentials that you use to access CustomerSource or PartnerSource. If you don’t have access to CustomerSource, then you will only have access to an evaluation version of LCS, which does not include Issue search

3. Accept the Microsoft Online Services Agreement if you haven’t already signed in before

4. Create a project

5. Click the + button under Recent projects to create a new project

6. Fill out the project details including Name, Product name, Product version, Industry, and Methodology. Any settings should be fine as long as you don’t select a pre-sales type of project

7. Scroll to the right and select Issue search

8. Begin searching

Synergy Software Systems, Dubai – in top 5% of Microsoft Enterprise Resource Partners

June 17th, 2015

We received confirmation from Microsoft of our attainment of the new Enterprise Resource Competency which has been by less than 5% of Microsoft Global Partner Network.

That ‘s why you can be assured of a successful, Synergy Software Systems Implementation – a 100% track record of successful projects with Dynamics Ax since we started the practice in 2003. Its also why the Highest Customer Satisfaction Award for 2014 also has Synergy’s name on it.

We are proud of our professionals.

We receive similar accolades across our solutions- for years the word in the hospitality industry is “go with Synergy and sleep a night” and why many of our Sunsystems customers have been loyal for over 15 years.

Value ultimately comes from competence and attitude and the results consistently shows that the right partner will give the right solution, service, support and price and deliver the right value.

WMS – Bitlog Launch Seminar, Dubai 15 June 2015

June 10th, 2015

Attend our free breakfast seminar and network with local industry logistics and WMS professionals.
FAST ROI for Distribution and Retail
Monday15th of June, 2015 , 08:00~11:00Microsoft Gulf, Building 8 Dubai Internet City, UAE

EVENT SCHEDULE
08:30 Registration & Breakfast
09:00 Introductions
09:05 Market and industry changes and WMS selection
How to choose the Right Product + Right Partner
Stephen Jones, Director, Synergy Software Systems
09:30 Next Generation WMS, Fred Boström, Bitlog
10:00 Reach fast ROI with Bitlog WMS, Hultafors Group case study
10:15 Bitlog GCC Launch offer
10.30 Discussion & Coffee

Bitlog WMS Launch event benefits :

Current trends that impact warehousing operations
How to select a warehouse management system,
Meet a proven new, innovative player in the GCC-market,
Meet the implementation partner
Find out how you can optimize your warehouse management,
to reduce cost, increase on time fulfillment and create more profit
A great opportunity to network during breakfast and coffee
Find out about the exclusive Bitlog WMS launch offer for seminar participants

For more information or to register contact :
sales@synergy-software.com +971 (0)55 7186133

Note there are only a few seats left.