Don’t Forget to Watch The Latest SelectViews
New show posts tomorrow – a special how-to show.
– Watch the current show here
Business Intelligence Can’t Be Smart if it Doesn’t Deliver
Once you’ve built the perfect reports, done the great queries, figured out the things you need to watch for your company, you need a way to reliably get that information out to your users, in a format they need. Could be Excel, PDF or something else, but you need to make sure they have it when they need, it how they need it. You really need to take a look at SQL-RD. RD makes sure you get the information out and lets you manage the schedules, deliver formats and other steps from a great interface that literally walks you through the setup steps. Get more information here, including a free trial to give it a workout.
Data Management
I was talking last week about tagging and managing corporate data with that type of tool. This assumes, of course, that you’re keeping data around. There are entire camps, consultants and processes dedicated to the idea though that data should be scrubbed, archived and removed from your active systems on a regular basis.
But, how do you select what stays, what goes?
And… if you make the wrong choice, how to re-integrate that information that you’ve removed, into the overall data store?
These are dicey questions. With disk space so relatively cheap, I think more people are opting to keep it all online, but even if disk is nearly free, you still have issues of overwhelming storage requirements. So, it’s not an answer to simply keep adding disk. Data segmentation may help, but again – you’re really moving around the issue, rather than solving for the right storage solution.
How do you approach the "mass data storage" puzzle? When is data moved offline? Who decides what’s kept? What’s the process like for making that decision?
Featured White Paper(s)
10 Steps to a Successful Modernization Project, Legacy Database or Application Upgrade
The goal of a modernization project is to transform aging applications to more-modern architectures while preserving the busi… (read more)
Microsoft SQL Server Cluster Vs Standby Server
This paper discusses specifically two out of various options available for SQL Server high availability, Microsoft SQL Server… (read more)
Enterprise Strategies to Improve Application Testing
Reliable applications come from reliable testing – and realistic test data plays a key role. Many organizations clone or copy… (read more)
Ensuring Modern Database Service Standards with Online Reorganizations
This whitepaper discusses how performing online data reorganization in Oracle environments would greatly assist in maintainin… (read more)
Enterprise Search for E-Discovery Compliance
Our paper on e-discovery compliance discusses enterprise search software’s role and the key functionality required to truly a… (read more)