Archive for the ‘SQL’ category

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.

SQL Patch Tuesday Sep 14- new performance guidelines – Dynamics Ax technical audits

September 21st, 2014

Microsoft has released SQL Server 2012 Service Pack 1 CU12 (Build 11.0.3470) and SQL Server 2012 Service Pack 2 CU2 (Build 11.0.5548). Both of these CUs many valuable hotfixes.
SP1 CU12 has 14 hotfixes,
SP2 CU2 has 50 hotfixes.

We recommend SQL Server 2012 SP2 branch don’t just go to SP2 RTM (Build 11.0.5058), but all the way to SP2 CU2.

Microsoft has also updated its guidance on performance configurations for SQL 2012.

If you are running an enterprise system on SQL then ask about our technical audits there many performance configurations, maintenance plans, and trace flags overlooked during typical erp system implementations. it is only after some time as the database fills up that users realise something is amiss as system performance starts to degrade and log files balloon. We have proven many times the benefits of such an audit for large Microsoft Dynamics Ax systems and customers will confirm the high value this gives both in performance and user and management confidence in the system.

Call Bikram on 0097143365589 for more information

SQL Server 2012 Service Pack 2 Cumulative Update #1

July 30th, 2014

SQL Server 2012 SP2 Cumulative Update #1 updates Service Pack 2 to include the fixes from SP1 CU#10 and a few from CU#11, including the fix for the online index rebuild corruption issue

•KB Article: KB #2976982
•Build # is 11.0.5532
•Currently there are 45 public fixes listed (46 total)

Relevant for builds 11.0.5058 -> 11.0.5531.
Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or SP1 (any build < 11.0.5058), or any other major version.

SQL Server 2014 Permissions: CONNECT ANY DATABASE

July 30th, 2014

In a recent blog post New SQL Server 2014 Permissions: CONNECT ANY DATABASE Edward Pollack, explains a new feature in SQL2014 which is paraphrased here.

CONNECT ANY DATABASE is a simple server-level permission that provides access to all current and future databases. When combined with:

- VIEW SERVER STATE, a login can monitor server and database metrics via a host of dynamic management views.

- or with SELECT ALL USER SECURABLES, a login can view data in all databases (read-only).

Many professions have restrictions over what employees are allowed to view, e.g. hospitals, where HIPAA greatly influences the flow of information. CONNECT ANY DATABASE provides database-level permissions without giving any access to the objects within. This also allows for scenarios where access is granted to all databases, but only for specific tasks, such as selecting all data, updating, deleting, etc. Security scenarios that used to be cumbersome to implement are now simplified. No need to create users in all databases for a login, nor to assign specific database-level permissions to ensure that a service account or monitor can do its job correctly.

for more information see – 2014/07/29 http://www.sqlservercentral.com/articles/Security/111116/

End of Mainstream support for SQL Server 2008 and SQL Server 2008 R2

July 13th, 2014

We would like to remind all customers that Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 ended on July 8, 2014.

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 to ensures that your product remains supported per the Support Lifecycle policy and for 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. Non-security hotfixes for these versions will be offered only to customers who have an Extended Hotfix Support agreement.

SQL 2014 now supports all versions of Dynamics Ax 2012

July 7th, 2014

SQL Server 2014 can now run with :
Microsoft Dynamics AX 2012 R3
Microsoft Dynamics AX 2012 R2 Cumulative Update 7
Microsoft Dynamics AX 2012 Cumulative Update 5.
This means that all Dynamics AX 2012 versions are now supported to work with SQL Server 2014.

Cumulative Update #2 for SQL Server 2014 RTM

June 28th, 2014

Fix for the index corruption issue is now available for SQL Server 2012 Service Pack 2 – available for download for via the hotfix download link in the KB article. See KB http://support.microsoft.com/kb/2969896

SQL Server 2012 SP1 CU10

May 26th, 2014

Cumulative Update 10 contains all the SQL Server 2012 SP1 hotfixes which have been available since the initial release of SQL Server 2012 SP1 and is now avaiable for download from Microsoft support.

• CU#10 KB Article: http://support.microsoft.com/kb/2954099
• Understanding IncrementalServicingModel for SQL Server