Archive for the ‘SQL’ category

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

Microsoft Analytics Platform System

April 27th, 2014


At the Accelerate your Insights event last week, Satya Nadella introduced the new Microsoft Analytics Platform System (APS) as Microsoft’s solution for delivering “Big Data in a box.”

Unifying the data in SQL Server Parallel Data Warehouse with data in Hadoop is PolyBase, a ground breaking query technology developed by Dr. David DeWitt and his team in Microsoft’s Grey Systems Labs.

SQL updates April 2014

April 27th, 2014

SQL Server 2014 Cumulative Update #1 was issued and then pulled.

Cumulative Update #12 for SQL Server 2008 R2 Service Pack 2 is released. Build number is 10.50.4305

•KB Article: KB #2938478
•13 fixes listed

Windows Server 2012 R2 Update and SQL

April 14th, 2014

If you are or will be running SQL Server 2012 or SQL Server 2014 in the near future, then you should be running Windows Server 2012 R2 as your operating system.

If you are already running Windows Server 2012 R2, then make plans to install the latest update as soon as possible. According to Microsoft, “Future updates as of the patch Tuesday in May, including security fixes, will be based on Windows Server 2012 R2 Update as the baseline.”

SQL patches March 2014

March 23rd, 2014

The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #9.
• KB Article: KB #2931078
• Build # is 11.0.3412
• Currently there are 29 public fixes listed (33 total)
Relevant for builds 11.0.3000 -> 11.0.3411.
Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any other major version

March 2014 Cumulative Update for SQL Server 2008 SP3

Microsoft has also released SQL Server 2008 Service Pack 3 Cumulative Update #16
•Build # 10.00.5852
• KB Article: KB #2936421
• 2 public fixes
• Relevant for builds 10.00.5500 -> 10.00.5851
• NOT for SQL Server 2008 R2 (10.50.xxxx)

The small number of fixes (and zero fixes for the engine) is telling: this is almost certainly the last service pack for SQL Server 2008, support for this version ends in July. If you’re still on 2008 (and I know some of you are still on 2005 and even 2000, and ), its time to start considering moving on