Problem: You're an admin in SQL Server Reporting Services. You want to see everybody's subscriptions on all reports. Yet you can only see your own.  Solution: You can do this easily. You just can't do it in Report Manager. But remember that Report Manager is just a front end to a SQL Server database called ReportServer. There you will find the subscriptions you seek. You can query...
Read More About SSRS: View all subscriptions »

  As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA.  In fact, a recent survey reported that 45% of IT personnel responsible for managing their company’s SQL Server instances are not trained database administrators instead...
Read More About The Value of Expertise »

  When we focus on IO performance for SQL Server it is vitally important to understand the architecture of the disk subsystem.  Typically, a DBA will focus on Disk Queue Length as the primary measure of IO performance; however, in a Storage Area Network (SAN) environment the Disk Queue Length metric may not provide reliable results.  In a SAN environment a...
Read More About IO, IO it's off to work we go. »

I've been running into several issues lately doing a WebSphere Portal v6.0.1.1 migration to WebSphere Portal v6.1 on the same server.  This should be a relatively straightforward process as far as WebSphere Portal migrations go, but we've run into several issues that I wasn't able to find much or any info about.  Here are a few of the things I found while running the ...
Read More About WebSphere Portal v6.0.1.1 to v6.1 Migration Notes »

Overview This is a multi-part series of how to integrate Liferay v6.x with an existing Active Directory server at your organization.  It's a fairly simple process if you know what to enter into the various fields, but one key thing that doesn't come through on the configuration interface is that you will probably need to add a couple of properties to your portal-...
Read More About Liferay v6.x Active Directory Integration - Part 1 »