(Michael Miller) As the first post in Integrigy’s blog series on OBIEE security, it makes sense to first look at WebLogic. As a Fusion Middleware 11g product, OBIEE 11g uses Oracle WebLogic for centralized common services, including a common security model. WebLogic itself is a scalable, enterprise-
Author: SSWUG Research
Real-time query access with PDW
(James Serra) The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and the Tabular model (In-Memory and DirectQuery modes). The big benefit of using ROLAP or DirectQuery is you get real-time query access to
SQL Server XQuery: MORE deleting nodes using .modify()
(Stuart Ainsworth) So after my last post, my developer friend came back to me and noted that I hadn’t really demonstrated the situation we had discussed; our work was a little more challenging than the sample script I had provided. In contrast to what I previously posted, the challenge was to delet
Oracle Parallel Processing: ‘New’ and Improved
(David Fitzjarrell) In Release 11.2, Oracle has provided three improvements to the earlier attempts at controlling parallel execution. These improvements make this feature more manageable, more scalable, and less likely to saturate server resources, such as memory and CPU, than earlier releases of t
Creating and Using an ASP.NET Web Service (Part 3)
(Ged Mead) This initial post walked through in detail how to create a simple ASP.NET Web Service. Then this second post described how to replace the default HelloWorld web method with something more real and how to pass instances of domain classes from the service to the client. In this post, I’ll
Performance Tuning with AWR & ASH in #em12c
(Bobby Curtis) Oracle monitoring and performance tuning has grown over the years. With every release of the Oracle database the monitoring capabilities that have been provided have evolved. In Oracle11g, monitoring with statpack has given way to Automatic Workload Repository (AWR) and Active Sessi
formating XML files on command line
(Volker Benders) To quickly reformat a xml file you could use the command xmllint:
ASP.Net Custom session timeout
(Pramod Kumar) Here I will explain how to set session timeout in web.config,IIS and in application using asp.net manually.
Using RDLC with ASP.Net MVC to export report in PDF/Excel format
(Santosh Singh) To export a report in PDF/Excel format using RDLC.
Pushing the Limit: Using Very Large Database Capabilities with DB2 for i
(Tracy Schramm) In IBM i 7.1 with the latest Technology Refresh updates, the maximum size of an SQL index increased to 1.7 TB, allowing users to take advantage of Very Large Database (VLDB) capabilities. This IBM Redpaper publication shows you how to view your IBM i 7.1 database file sizes from both