Archive for the ‘SQL’ category

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.

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:

SQL Server 2016 release notes:

What’s new in SQL Server, September Update:


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


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

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

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 : +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.

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.

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.

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.