(Thomas Kejser and Denny Lee) This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions.
Other News
MarkLogic: Next steps with the MarkLogic Hadoop Connector (MarkLogic 5.0-1)
(Alex Bleasdale) Following on from my post yesterday, here’s a further example usage for the hadoop connector
Using MySQL, Perl and jQuery to Auto-Populate a Form Field on a Web Page
(Tony Darnell) If you have ever built a form on a web page, you might have used a drop-down menu to display the choices available for a particular field. With a drop-down menu, you restrict the choices a user may select so that the user doesn’t enter invalid data (among other reasons). If a user mis
Overview of UML diagrams
(Neeraj Kaushik) The Unified Modeling Language (UML) is a standard language for specifying, visualizing, constructing, and documenting the artifacts of software systems, as well as for business modeling and other non-software systems. The UML represents a collection of best engineering practices th
Optional Parameters
Optional Parameters Unlike many programming languages, SQL does not lend itself to optional parameters, especially when using stored procedures. I’m going to share a SQL tip today regarding different methods to implementing optional parameters. All code is written in TSQL for MS SQL Server, but may be modified to work in other SQL engines. For this demonstration I’m going to […]
DB2 & Oracle: Autonomic Comparison
(Rav Ahuja) This is a recording of the webinar titled: DB2 and Oracle – An Autonomic Computing Comparison.
Big Data Impacts Data Management: The 5 Vs of Big Data
(Dave Beulke) Big data is already here and is changing the data management dramatically within the industry, your company and its core business processes. Big data is going to impact your business and your data management practices and is going to have a significant impact within your company.
Combine Drupal, HTML5, and microdata
(Lin Clark) With Google, Yahoo, and Bing’s announcement of schema.org, microdata is quickly gaining ground as a way to create applications that rely on data from many different websites. In this article, learn how to use Drupal to add microdata to your pages. Easily make your content available for u
Linq-To-XML Style of Node Creation for C++
(Wong Shao Voon) This article discusses the new C++ Elmax XML Library feature to use Linq-To-XML node creation to write XML files. Currently, there is no plans to implement this feature for C# Elmax. C# users can use .NET Linq-To-XML to achieve the same XML writing.
Parallel Processing with DBMS_PARALLEL_EXECUTE
(David Allan) Here is another illustration of some of the powerful capabilities of the DBMS_PARALLEL_EXECUTE package in the Oracle database, carrying on from the earlier post here. One of the comments from that post was on how to insert into a different named table within each chunk and that insert