Archive for the ‘SQL’ category

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.

SQL 2016 – preview of what’s new

May 28th, 2015

Three weeks Microsoft Iannounced, the next major release of Microsoft’s flagship SQL database and analytics platform, as well key innovations in the release.
The first public Community Technology Preview (CTP2) for SQL Server 2016 gives an early look into many of the capabilities
SQL Server 2016 provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud.
Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion,
Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure,
enhancements for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration.

Key Capabilities in SQL Server 2016 CTP2
Always Encrypted

Always Encrypted, based on technology from Microsoft Research, protects data at rest and in motion. With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the application in the customers trusted environment. Encryption and decryption of data happens transparently inside the application which minimizes the changes that have to be made to existing applications.
Stretch Database
This new technology allows you to dynamically stretch your warm and cold transactional data to Microsoft Azure, so your operational data is always at hand, no matter the size, and you benefit from the low cost of Azure. You can use Always Encrypted with Stretch Database to extend data in a more secure manner for greater peace of mind.
Real-time Operational Analytics & In-Memory OLTP
For In-Memory OLTP, which customers today are using for up to 30x faster transactions, you will now be able to apply this tuned transaction performance technology to a significantly greater number of applications and benefit from increased concurrency. With these enhancements, we introduce the unique capability to use our in-memory columnstore delivering 100X faster queries on top of in-memory OLTP to provide real-time operational analytics while accelerating transaction performance.
Additional capabilities in SQL Server 2016 CTP2 include:
PolyBase – More easily manage relational and non-relational data with the simplicity of T-SQL.
AlwaysOn Enhancements – Achieve even higher availability and performance of your secondaries, with up to 3 synchronous replicas, DTC support and round-robin load balancing of the secondaries.
Row Level Security– Enables customers to control access to data based on the characteristics of the user. Security is implemented inside the database, requiring no modifications to the application.
Dynamic Data Masking – Supports real-time obfuscation of data so data requesters do not get access to unauthorized data. Helps protect sensitive data even when it is not encrypted.
Native JSON support – Allows easy parsing and storing of JSON and exporting relational data to JSON.
Temporal Database support – Tracks historical data changes with temporal database support.
Query Data Store – Acts as a flight data recorder for a database, giving full history of query execution so DBAs can pinpoint expensive/regressed queries and tune query performance.
MDS enhancements – Offer enhanced server management capabilities for Master Data Services.
Enhanced hybrid backup to Azure – Enables faster backups to Microsoft Azure and faster restores to SQL Server in Azure Virtual Machines. Also, you can stage backups on-premises prior to uploading to Azure.

New with SQL Server 2016, customers will have the opportunity to receive more frequent updates to their preview to help accelerate internal development and test efforts. Instead of waiting for CTP3, customers can choose to download periodic updates to CTP2 gaining access to new capabilities and features as soon as they are available for testing.

SQL updates 2 May 2015

May 2nd, 2015

Cumulative update 5 for Build number: 11.0.5582.0) for Microsoft SQL Server 2012 Service Pack 2 (SP2).
This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP2.

https://support.microsoft.com/en-us/hotfix/kbhotfix?kbnum=3037255&kbln=en-us

Cumulative update 15 (Build number: 11.0.3487.0) for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1.

https://support.microsoft.com/en-us/hotfix/kbhotfix?kbnum=3038001&kbln=en-us

Cumulative Update 7 (Build number: 12.0.2495.0) for Microsoft SQL Server 2014. This update contains hotfixes for issues that were fixed after the release of SQL Server 2014.

https://support.microsoft.com/en-us/hotfix/kbhotfix?kbnum=3046038&kbln=en-us

SQL 2014 sp1 bug

April 18th, 2015

The Microsoft company released SQL Server Service Pack 1 (SP1) on the April 15 anniversary of the database software’s launch. A bug surfaced soon after the release of SQL Server 2014′s first service pack, forcing Microsoft to temporarily disable downloads of the update.

“The SQL SSIS team has found an issue with SP1 installation when an SSIS catalog is present in the SQL Server instance,” Currently, clicking on the Microsoft SQL Server 2014 SP1 download links generates a Website error page. When the links are restored, customers can expect to see many of their issues addressed and squeeze more performance out of their SQL Server implementations.

Power BI for Dynamics: Ax, and CRM – ask Synergy Software Systems, Dubai

January 27th, 2015

Power BI is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device.
This toolset is regularly being updated with new features e.g.: – dashboards, new visualizations, support for popular software-as-a-service applications, a native iPad app and live “hybrid” connectivity to on-premise SQL Server Analysis Services tabular models.

Dynamics Ax provides in built cubes and Power BI for Power BI use- ( see our Dynamics Ax HR and Payroll Powwr BI demonstration.)

Power BI dashboards
Users can create personalized dashboards to monitor their most important data. A dashboard combines on-premises and cloud-born data in a single pane of glass, providing a consolidated view across the organization regardless of where the data lives.

Users can easily explore all their data using intuitive, natural language capabilities and receive answers in the form of charts and graphs. They can also explore data through detailed reports that target specific aspects of their business. Visuals from these reports can also be pinned to their dashboards for continuous monitoring. As part of this experience new visualizations have been added including combo charts, filled maps, gauges, tree maps, and funnel charts.

What is Power BI Q&A?
Use natural language queries to find answers in your own data.
With instantaneous natural language querying, Q&A interprets your question and immediately serves up the correct answer on the fly—in the form of an interactive chart or graph. And these visualizations change dynamically as you modify the question, creating a truly interactive experience with your data
Start with a question, and have fun traveling through your data refining or expanding your question, uncovering trust-worthy new information, zeroing in on details and zooming out for a broader view.
You’ll be delighted by the insights and discoveries you make.

Power BI Q&A presents your answers in the form of visualizations. As you type a question, Power BI Q&A picks the best visual to display your answer; and the visual changes dynamically as you modify the question.

The experience is truly interactive…and fast! Powered by an in-memory storage, response is almost instantaneous.

Connectivity to New Data Sources
• Exchange: Support for connecting to your Microsoft Exchange account and retrieving information about your Mail, Calendar, People, Tasks and Meeting Requests.
• Dynamics CRM Online: Power Query’s OData support to consume OData feeds from Dynamics CRM Online.

also Facebook, Salesforce, Sybase etc.

Connect live to on-premises Analysis Services models

With the new Power BI connector for SQL Server Analysis Services, customers can realize the benefits of a cloud-based BI solution without having to move their data to the cloud. Customers can now create a secure connection to an “on-premises” SQL Server Analysis Services server from Power BI in the cloud. When users view and explore dashboards and reports, Power BI will query the on-premise model using the user’s credentials.

With this hybrid solution, organizations can continue to retain, manage and secure their data on-premises, while securely enabling users to benefit from that data via Power BI.

Mobile Apps
A wave of native mobile apps for Power BI. These apps will allow users to access their Power BI dashboards and reports through immersive mobile experiences for iPad, iPhone, and Windows tablets. The first of these – the iPad app is available today and can be downloaded from the Apple App Store, with other platforms following in the coming months. All Power BI mobile apps enable users to share insights and collaborate with colleagues so that they can take immediate action, from anywhere, anytime.


Power maps

Power Bi Designer preview

January 22nd, 2015

The Power BI Designer is a new companion application for Power BI.

It is a standalone Windows Desktop application that can be downloaded from the Power BI site.

This application combines Power Query, Power Pivot Data Model and Power View into a seamless experience that will allow customers to build their Power BI elements in an offline fashion and then upload to the Power BI Service.

The Add-ins for Excel 2013 and later are still available and customers can continue to use that to model their data and build reports.

The Power BI Designer will be another option and allow customers with an older version of Office to be able to create reports.

SMB erp survey of buyers – what really matters

January 20th, 2015

Software Advice (http://www.softwareadvice.com/ERP/), a review firm that specializes in ERP software, recently wrote to advise us of the key findings of a random sample of 250 SMB inquiries.

Since purchasing and implementing ERP software can be an intensive process that can take up to a year for companies to complete, its important to work with a company that takes the time to understand how software matches your current and future needs and alleviates the most important pain points in 2015.

For SMBs used to owner management, the time comes when a more formal command control structure to delegate work and to get feedback becomes essential to continued growth.

The owner manger who is used to having all the key knowledge and decision making authority needs to spend more time looking outward and evaluating different scenarios and less time micro managing systems, e.g. by using: budget controls, kpi dashboards, alerts, workflows and exception reports.

Knowledge has to be codified and stored so that the business can transition to the next generation of managers. Investors and auditors want to see formal controls, robust scalable platforms, with automation that allows the business to grow and manage acquisitions, or expand into new territories, or lines of business while reducing the relative % administrative overheads and better utilize the management skills

The UAE has a lot of owner managed companies, and also small sales offices of international companies that have outgrown their initial start up days. New technologies offer different competitive advantages – cloud, mobility, any time anywhere decisions- more powerful BI. Different licensing modules now put powerful enterprise solutions within their affordability range.

The key factor to consider is not the cost but what is the right rate of adoption for the available cash flow.
- What are the real business priorities and ROI, and will this be an investment in my balance sheet that adds value to my business?
- Will customers rate more highly if I deliver more consistent service and can demonstrate improved operational controls?
– If I cut down my estimation time can I get out more proposals?
- If I am already breaking even and making a profit and increase my business just 10% how significant is that to my total annual profit% if all my fixed costs are already paid?
- Will my business be more saleable, or more attractive to investors, or for an ipo, and at a higher price when it comes with a proven enterprise system for managing operations, IFRS compliance and statutory reporting, ?

Implementation cycles these days need to be shorter than buying cycles. Agile user friendly systems with a familiar interface that works in the same was other office tools points towards Microsoft-office 365, Dynamics CRM ,Dynamics Ax, Share Point. Learning curves are reduced and user acceptance and productivity increased. The modern architecture of these solutions allows rapid adaptation to the changing business needs that leverage an integrated technology stack all from a single vendor.

Some Key Findings:
1.Two-thirds of buyers do not currently use an ERP system, and 44 percent rely on a combination of disparate systems to execute ERP processes.
2.Fifty-nine percent of buyers cite the need to improve the integration of data between different business processes as a top reason for seeking an ERP system.
3.Forty-seven percent of all buyers cite the need to improve their customer relationship management (CRM) database as a reason for wanting to purchase an ERP system.
4.Among buyers currently using ERP systems, 24 percent cite lack of support and 19 percent cite cost as their primary reasons for wanting to switch to a new system.
5.Twenty-seven percent of buyers who do not currently use an ERP system cite company growth as their reason for wanting to implement one.

http://www.softwareadvice.com/erp/buyerview/report-2015/

Prophix 11 Service Pack 3

December 17th, 2014

BI4Dynamics – new release. Wow! Ask Synergy Software Systems

October 21st, 2014

Biggest BI4Dynamics release in the history includes:
• Smartest self-service Cube Wizard in the market
Easily create custom cubes in 4 simple steps. Download the Manual and watch How to Videos.
• BI4Dynamics SQL framework refactored and upgraded
o Improved performance (30 to 50% performance improvement with incremental processing).
o Faster and easier custom development (more than 50% less custom code needed when creating new modules).
o Improved logging in the SQL framework (more detailed execution information for each procedure are available).
o Easier debugging of incorrect data in custom development (data references that connect fact and stage records have been added).
• NAV2013 R2 multitenant and NAV 2015 support
• SQL Server 2014 support
• Log window improvements
Better and easier tracking of log entries

Note: BI4Dynamics v4 and v5 can run simultaneously in separate folders.

And of course you still get prebuilt dashboards and reports and direct access to your data for ad hoc reports and inquires from Excel -just pick the fields you need – tis that easy and very fast because the KPIs and total and summary calculations are already defined and processed in the underlying data warehouse. No other BI solution implements a s fast and no other provides anything like the same prebuilt content.

If you are either a Dynamics Nav partner, or a Customer then contact us – you must take a look.

Special cube and report pack also for NAV Retail.

Dynamics Ax ? Yes BI4Dynamcis is also available and updated content packs for 2012 R3 will be released shortly.

Ask about our special post Gitex offer. Invest in BI4Dynamics with us and also get a free training place on our 2 day Management Reporter course in November.

SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4

October 6th, 2014

SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4 . Service Packs are available for download on the Microsoft Download Center.

SQL Server 2008 R2 SP3 and SQL Server 2008 SP4 contain fixes to issues Hotfix solutions provided in SQL Server 2008 R2 cumulative updates up to and including Cumulative Update 13, and SQL Server 2008 cumulative updates up to and including Cumulative Update 17.

The Service Packs also include the security bulletin MS14-044. SQL Server 2008 and 2008 R2 are now in extended support, which means there will not be Cumulative Updates for these Service Packs.

Miocrsoft will not release Cumulative Updates for SQL Server 2008 R2 SP3.

Dynamics Ax lifecycle – Ax 2009 and Ax 2012

September 23rd, 2014

Dynamics AX 2012 mainstream support was recently extended by two years to October 2018.

Please be aware that Dynamics AX 2009 will go into Extended Support in April 2015. This means support is only provided if an extended support agreement is in place and deliverables are limited to security updates and non-security hotfixes (specific bug fix for a critical issue).

Therefore, the goal of the Servicing strategy should be to keep all products within their mainstream support.

Servicing Windows: Review all windows security patches bi-weekly and push update accordingly. Service pack and major update need to be tested before applying to production.

These patches shouldn’t impact AOS however it is recommended to first run sanity check on User Acceptance Test (UAT) environment. Any major update (.Net Framework and Windows SP) may impact system so put in place a control windows update using Windows Server Update Service for all servers in Production.

Servicing SQL Server: Our recommendation is always to keep the build up to date in regards to the latest CU available of the latest Service Pack officially supported.

For example, as of August 2014, SP2 was strong>not yet officially supported with AX 2012.

Lifecycle of SQL Server 2008 is now in extended support since July 2014

Windows Server 2008 and Visual Studio 2010 mainstream support will end in January 2015.