(Cathy Dumas) In part 1 of this article, I showed how to use a hierarchy in a pivot table when row security is applied to a tabular model. In that example, I showed you a measure that displays the head count for all employees in the organization, regardless of the security model.
Other News
Data Bind OData in Web Apps with Knockout.js
(Julie Lerman) As a data geek, I spend quite a lot of time writing back-end code and miss out on a lot of the fun stuff on the client side. John Papa, who used to pen this column, is now writing a column on client technologies for this magazine, and he’s been doing a lot of work on a hot […]
Manage hierarchical data with MySQL stored procedures
(Ronald Speelman) Below you will find all code to create the table and the stored procedures to manage hierarchical trees in MySQL.
SOA governance using WebSphere DataPower and WebSphere Service Registry and Repository, Part 1: Leveraging WS-MediationPolicy capabilities
(Mario E. De Armas, Thomas Burke, Evan Jardine-Skinner and Dave Spriet) Starting with the release of IBM WebSphere DataPower firmware V5.0 and WebSphere Service Registry and Repository V8.0, IT service developers and policy administrators can now attach and affect ESB behavior related to Service Lev
Verify SQL Server Stored Procedures are the same on multiple servers
(Burt King) I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.
Slow Drain Devices
SSWUGtv With Stephen Wynkoop Watch or listen (pod casts are available too) as Steve interviews Laura Rose on the show today talking about micro-managing… and specifically how and why to avoid it. Watch the Show Slow Drain Devices This is not a term I dreamt up. While surfing the web for causes of high SQL Server disk queue wait times […]
SSWUGtv: Paul Zikopoulos – Querying big data stores – declaritive languages for working with big data – IBM has some new approaches and ideas…
Video Programming for IT Professionals
Troubleshooting problems with SQL Server 2008 R2 roles
Troubleshooting problems with SQL Server 2008 R2 roles If you have problems with roles in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 role bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...
SharePoint: Common problems when creating a new ‘Send To’ location
(Steven Andrews) SharePoint 2010 introduced the ability for SharePoint administrators to create a new “Send To” connection, which is a facility that allows a user to send a document to another location via its action menu.
Remove Empty Attributes in XQuery
(Rohan Lopes) Here is how you can remove empty attributes while xQuery mapping.

