• IBM Consulting

    DBA Consulting can help you with IBM BI and Web related work. Also IBM Linux is our portfolio.

  • Oracle Consulting

    For Oracle related consulting and Database work and support and Migration call DBA Consulting.

  • Novell/RedHat Consulting

    For all Novell Suse Linux and SAP on Suse Linux questions releated to OS and BI solutions. And offcourse also for the great RedHat products like RedHat Enterprise Server and JBoss middelware and BI on RedHat.

  • Microsoft Consulting

    For Microsoft Server 2012 onwards, Microsoft Client Windows 7 and higher, Microsoft Cloud Services (Azure,Office 365, etc.) related consulting services.

  • Citrix Consulting

    Citrix VDI in a box, Desktop Vertualizations and Citrix Netscaler security.

  • Web Development

    Web Development (Static Websites, CMS Websites (Drupal 7/8, WordPress, Joomla, Responsive Websites and Adaptive Websites).

23 February 2014

DB2 11 Technical Overview (Part 1 and 2)


DB2 11 Technical Overview Part 1 and 2


DB211 is here with More Cost savings and Critical Business Analytics


DB2 11: The Database for Critical Transactions & Analytics


Speed, Simplicity, Savings

DB2 11 for z/OS delivers new innovations: Save money, save time, reduce cost Enhanced continuous availability, scalability, and security for business-critical information Sophisticated Critical business analytics Simpler, faster migration for faster ROI Deep integration between DB2 and System z






DB2 11 Major Themes

Out-of-the-box CPU Savings*
• Improving efficiency, reducing costs, no application changes
• Up to 10% for complex OLTP
• Up to 10% for update intensive batch
• Up to 40% for queries
• Additional performance improvements through use of new DB2 11 features
Enhanced Resiliency and Continuous Availability
• Improved autonomics which reduces costs and improves availability
• Making more online changes without affecting applications
• Online REORG improvements, less disruption
• DROP COLUMN, online change of partition limit keys
• Extended log record addressing capacity (1 yottabyte)
• BIND/REBIND, DDL break into persistent threads
Enhanced business analytics
• Expanded SQL, XML, and analytics capabilities
• Temporal and SQLPL enhancements
• Transparent archiving
Simpler, faster DB2 version upgrades
• No application changes required for DB2 upgrade
• Access path stability improvements
• Product quality/stability: support pre GA customer production








Watch this presentation for more information on DB2 11 Technical Overview and Performance improvements:

Performance “Sweet Spots”

Write-Intensive Batch Queries:
- With compressed tables
- With access path improvement
- With sort-intensive workload Accessing multiple DPSI partitions IDAA
- With large result sets Online transactions

Write-intensive transactions: 
- With large number of partitions (>200 partitions )
- With RELEASE(COMMIT)
- With large buffer pools
- With queries returning a large number of columns

-  “Chatty” DDF applications with z/OS Communications Server PM80004 / UK92097
-  Cost saving from zIIP-eligible address space SRB time
-  DBM1 address space in data sharing
-  MSTR address space for update intensive workloads 7

DB2 11 Technical Overview Part 1 




DB2 11 Technical Overview Part 2







Why IBM i? DB2 for i

Mark Anderson, distinguished engineer and chief architect of DB2 for i talk about why IBM i for DB2. More about IBM i @ Why IBM i? DB2 for IBM i

If you are a midsize business take a look at this ITG report on IBM i for midsized business. Offer registration is required. Download the report @ http://bit.ly/IBMiformidsize1







DB2 for z/OS Best Practice: Health Check Operations

This presentation is from a set of recommendations developed by reviewing multiple DB2 customers environments. Many customer environments can benefit from these lessons learned. This specific presentation deals with operating your DB2 environment. Topics include: preventative software maintenance, using virtual and real storage, and performance and exception-based monitoring.





IBM DB2 for i SQL Performance Workshop - IBM Training

This short video describes the IBM DB2 for i SQL Performance Workshop which covers the best practices for monitoring, tuning, and developing SQL applications on IBM i. Students who attend the course will learn how the SQL query optimizer works, how to use indexes and statistics to improve query performance, how to implement efficient SQL applications, and how to use the SQL performance analysis tools.



Brought to you by IBM Training: http://www.ibm.com/training






DB2 for z/OS RUNSTATS Profiles Skill Builder

This video introduces RUNSTATS Profiles, and demonstrates how to set, use, update, and delete.



Course Links:
DB2 10 for z/OS Database Administration Workshop Part 1 (CV831)
DB2 10 for Z/OS Database Administration Workshop Part 1

DB2 for z/OS - New Functions and Features in Version 10 (CV311)
DB2 for z/OS - New Functions and Features in Version 10

DB2 for z/OS - New Features in Version 10 Workshop (CV312)
DB2 for z/OS - New Features in Version 10 Workshop


Other links:
Training Paths: http://www.ibm.com/services/learning/ites.wss/zz/en?pageType=page&c=a0007973 
DB2 for z/OS Training Path: http://www.ibm.com/services/learning/ites.wss/zz/en?pageType=page&c=a0000400
Certification Program: http://www-01.ibm.com/software/data/education/certification.html
DB2 10.1 Fundamentals (Test #000-610): http://www.ibm.com/certify/tests/ovr610.shtml 
DB2 10 DBA for z/OS (Test #000-612): http://www.ibm.com/certify/tests/ovr612.shtml
IM Certification and Skills : http://www.ibm.com/software/data/education


For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting website:           http://www.dbaconsulting.nl
blog:              DBA Consulting blog
profile:            DBA Consulting profile
Facebook :       DBA Consulting on Facebook
email:              info@dbaconsulting.nl 

02 February 2014

Sharepoint 2010 and 2013 and Sharepoint Online




Sharepoint 2010 and 2013 and Sharepoint Online
SharePoint Online, part of the Microsoft Office 365 suite for online productivity solutions, and the successor to Business Productivity Online Services (BPOS), provides a platform for large organizations to enhance and extend the functionality of existing "on-premises" SharePoint deployments using a cloud-based service. SharePoint Online provides a single, integrated location where people can:
Collaborate with team members and external parties
• Find organizational resources
• Look up corporate information
Glean business insights for better-informed decisions
Watch this small video for IT Pro's to learn more:
Exploring SharePoint Online for IT Professionals


What's new in business intelligence in SharePoint Server 2013
Excel BI
Excel BI provides the capabilities to analyze and visually explore data of any size, and to integrate and show interactive solutions. In SharePoint Server 2013, Excel BI offers certain new features to support business intelligence applications.
These include the following:
In-Memory BI Engine (IMBI): The In Memory multidimensional data analysis engine (IMBI), also known as the Vertipaq engine, allows for almost instant analysis of millions of rows and is a fully integrated feature in the Excel client.
Power View Add-in for Excel: Power View ("Crescent") enables users to visualize and interact with modeled data by using highly interactive visualizations, animations and smart querying.. Users can present and share insights with others through rich storyboard presentation capabilities. PowerView is powered by the BI Semantic Model and the VertiPaq engine.
Decoupled PivotChart and PivotTable reports: Users can now create PivotChart reports without having to include a PivotTable report on the same page.
Excel Services
Excel Services enables people to view and interact with Excel workbooks that have been published to SharePoint sites. Users are able to explore data and conduct analysis in a browser window just as they would by using the Excel client. For more information about Excel Services in Microsoft SharePoint Server 2010, see Excel Services overview (SharePoint Server 2010) on Microsoft TechNet.In SharePoint Server 2013, Excel Services offers certain new features to support business intelligence applications. These include the following:
Data exploration improvements: People can more easily explore data and conduct analysis in Excel Services reports that use SQL Server Analysis Services data or PowerPivot data models. For example, users can point to a value in a PivotChart or PivotTable report and see suggested ways to view additional information. Users can also use commands such as Drill Down To to conduct analysis. Users can also apply the Drill Down command by using a single mouse click.
Field list and field well support: Excel Services enables people to easily view and change which items are displayed in rows, columns, values, and filters in PivotChart reports and PivotTable reports that have been published to Excel Services.
Calculated measures and members: Excel Services supports calculated measures and calculated members that are created in Excel.
Enhanced timeline controls: Excel Services supports timeline controls that render and behave as they do in the Excel client.
Application BI Servers: Administrators can specify SQL Server Analysis Services servers to support more advanced analytic capabilities in Excel Services.
Business Intelligence Center update: The Business Intelligence Center site template has been streamlined. It not only has a new look, it is easier to use.
PerformancePoint Services
PerformancePoint Services enables users to create interactive dashboards that display key performance indicators (KPIs) and data visualizations in the form of scorecards, reports, and filters. For more information about PerformancePoint Services in SharePoint Server 2010, see PerformancePoint Services overview (SharePoint Server 2010) on Microsoft TechNet.In SharePoint Server 2013, PerformancePoint Services offers certain new features to support business intelligence applications. These include the following:
Dashboard Migration: Users will be able to copy entire dashboards and dependencies, including the .aspx file, to other users, servers, or site collections. This feature also allows the ability to migrate single items to other environments and migrate content by using Windows PowerShell commands.
Filter Enhancements & Filter Search: The UI has been enhanced to allow users to easily view and manage filters including giving users the ability to search for items within filters without having to navigate through the tree.
BI Center Update: The new BI Center is cleaner, and easier to use with folders and libraries configured for easy use.
Support for Analysis Services Effective User: This new feature eliminates the need for Kerberos delegation when per-user authentication is used for Analysis Services data sources. By supporting Analysis Services Effective User feature, authorization checks will be based on the user specified by the EffectiveUserName property instead of using the currently authenticated user.
PerformancePoint Support on iPad: PerformancePoint dashboards can now be viewed and interacted with on iPad devices using the Safari web browser.
Visio Services
Visio Services is a service application that lets users share and view Microsoft Visio Drawing (*.vsdx) and Visio 2010 Web drawing (*.vdw) files. The service also enables data-connected Visio Drawing (*.vsdx) and Visio 2010 Web drawing (*.vdw) files.to be refreshed and updated from various data sources.
Maximum Cache Size: A new service parameter, it is located on the Central Admininstration Visio Graphics Service Application Global Settings page. The default value is 5120 MB.
Health Analyzer rules: New corresponding Health Analyzer rules have been added to reflect the new Maximum Cache Size parameter.
Updated Windows PowerShell cmdlets, Set-SPVisioPerformance: This cmdlet has been updated to include the new Maximum Cache Size parameter.
Commenting on drawings supported: Users can add meaningful comments to a Visio Drawing (*.vsdx) collaboratively on the web via Visio Services in full page rendering mode.
And off course Share Point 2013 couldn't work without Server 2012 the platform from Microsoft:

Windows Server 2012 Overview

What's New in Windows Server 2012 Hyper-V, Part 1
What's New in Windows Server 2012 Hyper-V, Part 2
Securing Windows Servers in 2014: What You Need to Know 

Every year we see constant change and evolution in Windows vulnerabilities. As we prepare for 2014, it's a good reminder to note that it's not just the vulnerabilities that evolve but the tools that help harden security for Windows servers, as well.
Please join us for this 60 minute live webinar with Darren Mar-Elia, Group Policy MVP and Contributing Editor at Windows IT Pro Magazine, who will talk about the free Security Compliance Manager tool from Microsoft, when and where it's effective and useful, and the best practices for securing your Windows Servers. BeyondTrust's Senior Director of Product Management, Morey Haber, will then briefly show you how tools from BeyondTrust can verify hardening procedures.





For more information please contact me at:


Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook
email:          info@dbaconsulting.nl