In This Issue:
Is Swivel, the “YouTube” for data, just another way to fritter away time on the Internet? Or is it really the way that BI will become available to the masses?
New Instant Poll: Swiveling Your Data?
"Would your organization use the BI services offered by Swivel?" Go to the SQL Server Magazine home page and submit your vote for:
- Yes, we'd be very interested in taking advantage of the ability to combine our data with data from others in our field.
- Sure, we could try it, but we'd want to see some preliminary results before we pay for it.
- We'd be skeptical at best.
- No, we need to work with internal data only.
- No, we have no need for the kind of data analysis that Swivel offers.
- What is Swivel and is it related to Elvis?
To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.
Our Sponsors, Who Help Support the Free Delivery Of This Newsletter:
December 14, 2006
1. Perspectives
- Swivel Puts a New Twist on BI for the Masses
2. SQL Server Watch
- Microsoft Launches SQL Server Best Practices Web Site
- Product Watch: GoldenGate Software and Idera
3. Hot Articles
- Reader to Reader: Summarize All the Constraints for a Table
- SELECT TOP(X): SQL Server 2005 System Databases
- In a Nutshell: Who’s Administering SharePoint?
- Hot Threads: T-SQL and SQL Server 2005 Administration
4. Events and Resources
- Maximize Your Investment In Your VoIP Network
- Protect Your Data in the Event of a Disaster
- Overcome Availability and Management Challenges
- Get Up to Speed on Database Design and Hierarchy
5. Featured White Paper
- Streamline the Compliance Lifecycle
6. Reader Challenge
- December Reader Challenge Solution: Improve T-SQL to Prevent Deadlocks
- January Reader Challenge: Converting a Hexadecimal String to a Varbinary Value
7. Announcements
- Holiday Offer—Save $40 on SQL Server Magazine
- Make Your Mark on the IT Community!
8. Web Community
Sponsor: Dell Computers
SQL Server 2005 in a Virtualized Environment
The Dell scalable enterprise architecture uses industry-standard components to help simplify operations, improve resource utilization, and scale cost-effectively. Virtualization technology is advancing IT infrastructure standards by abstracting software from hardware, which can facilitate deployment and management of software in the scalable enterprise. To demonstrate this, the Dell Scalable Enterprise Technology Center deployed Microsoft SQL Server 2005 software in a virtualized environment.
1. Perspectives
Swivel Puts a New Twist on BI for the Masses
by Brian Moran, brian@solidqualitylearning.com
This week’s commentary is a bit non-traditional; it’s all about data, but has little to do with SQL Server. My thoughts this week were sparked by an email message that one of my business colleagues sent with the subject line “This could put ‘BI for the masses’ in a new light.” I’ve always been a big fan of the concept of BI for the masses and have written about the idea many times because I think that it will happen one day. So a message with that subject line is bound to get my attention.
To get us all on the same page about what the message referred to, I’d like you start by reading the news article “Swivel Aims to Become the Internet Archive for Data” and the supporting user comments at http://www.techcrunch.com/2006/12/05/swivel-to-launch-this-week-communitize-your-data. Yes, I know that’s more homework than is typically necessary to absorb my commentary. Humor me.
Done reading? Good.
Calling Swivel “The internet archive for data” and saying it’s a “bit like YouTube for data” might sound like lofty aspirations for a site that is just in the preview stages. In fact, I had a hard time justifying to myself the need to write about Swivel before anyone has evaluated whether the service really works. But it’s such an interesting idea that I simply couldn’t resist thinking out loud about the potential effect. To me, the idea of “BI for the masses” has always implied more of a corporate slant. I never really expected Great Aunt Suzzie to be “doing BI.” But, what if BI, data-mining—or whatever fancy techno-terms we use to describe visual data analysis—does become truly mainstream, adopted by the masses?
The article quotes an unidentified PhD student working in bioinformatics as saying, “For me this sounds potentially very interesting. It would be useful to share data for collaborative research, especially if they make it easy to access the data via APIs. I could even release alongside a publication the means to fully reproduce the calculations via this site. Others could quickly build on the publication with access to the data and analysis.”
Ok, so I don’t think Swivel is going to put corporate IT out of work anytime soon. The data privacy and security problems are simply too complex to deal with. But what if something like Swivel made it easy for people who aren’t functional experts to “do BI” without dedicated IT support? What if these unwashed masses, lacking the benefit of corporate IT, could publish, analyze, and understand complex data sets in a holistic interrelated manner? Might that create a vast, almost unimaginable, increase in the level of complex data analysis that happens worldwide? Might it work in almost the same way that the simple Internet browser coupled with search engines creates a vast encyclopedic collection of content that includes random junk as well as exactly the right thing you were looking for and that would have otherwise been impossible to find? Interesting.
I’ve talked about the idea of spreadmarts in past editorials (“Spread the Love: The Challenge of Corralling Scattered Data” at http://www.sqlmag.com/Article/ArticleID/50607/Spread_the_Love_The_Challenge_of_Corralling_Scattered_Data.html and “Can the Spreadmart Beast Be Tamed?” at http://www.sqlmag.com/Article/ArticleID/50661/Can_the_Spreadmart_Beast_Be_Tamed.html), and I’ve talked about some of the acquisitions, partnerships, and new-product offerings that Google has announced over the past six months or so. I wonder whether Google has its long-term sights on being an aggressive, data-oriented platform for corporate America.
I also wonder whether something like Swivel will be part of the ultimate solution that unlocks the data and insight stored in the world’s spreadmarts. Or maybe this is simply a neat idea that will never even get off the ground. Swivel might seem like a silly idea to hard-core data professionals, folks who would wonder and doubt about the accuracy of any data captured and published in such a non-controlled manner. I share those doubts as well. But then again, I was pretty surprised when Google bought YouTube for a zillion trillion dollars (or what ever the crazy, unimaginable number was). I have a much easier time seeing Google being interested in an idea like Swivel as part of a comprehensive, long-term plan to create a robust data-analysis empire. I’m just sad that I didn’t think of it first.
Sponsor: AppDev
Start Learning SQL 2005 Business Intelligence—Free CD or Download
Start learning BI with 3 FREE hours of training from our new SQL 2005 Reporting Services course. You'll receive step-by-step instruction by industry experts, plus printable courseware, hands-on lab exercises and sample code—a $115 value. Visit http://www.appdev.com/promo/RN00537 now for your free CD or download.
2. SQL Server Watch
Microsoft Launches SQL Server Best Practices Web Site
In a blog post last week (http://blogs.msdn.com/sqlcat/archive/2006/12/08/check-out-the-exciting-new-sql-server-best-practices-website.aspx), the SQL Server Customer Advisory Team (SQLCAT) announced the launch of the new SQL Server Best Practices Web Site. The site provides links to real-world guidelines and tips provided by Microsoft developers and engineers. These SQL Server gurus share their expertise in a variety of formats, including white papers, top-ten best-practices lists, a “Best Practices Toolbox” that features scripts and tools for SQL Server performance tuning and troubleshooting, and links to best-practices topics in SQL Server Books Online (BOL). Check out the new site at: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx.
Product Watch
by Blake Eno, products@sqlmag.com
Ensure Continuous Data Uptime
GoldenGate Software announced GoldenGate 9.0, software that improves the availability, accessibility, and performance of a company's mission-critical data. GoldenGate extends its heterogeneous database support to include SQL Server 2005 and IBM DB2 z/OS. GoldenGate works by moving data from the source to target in real time without a middle tier. The software reads the SQL Server database log, encrypts the committed transactions, and moves them across the network to one or many targeted systems. To ensure continuous uptime to your data, GoldenGate moves the data bi-directionally while maintaining transaction integrity, and during a primary system outage, users are pointed to a second fully synchronized system. For more information, contact GoldenGate Software at 415-777-0200 or visit http://www.goldengate.com.
Defragment SQL Server Indexes
Idera announced SQL defrag manager, an automated analysis and defragmentation solution for SQL Server databases. The software improves SQL Server database performance by continuously analyzing fragmentation levels and automatically defragmenting indexes in which performance has eroded. SQL defrag manager's management console gives you a real-time window into fragmentation levels, and can manage and control automated analysis and defragmentation activity across hundreds of servers and thousands of databases. SQL defrag manager determines the best-fit approach and schedule for defragmentation to ensure optimal results with the least possible effect on critical production servers. The software also provides reporting on the analysis and defragmentation activity. For more information, contact Idera at 713-523-4433 or 877-464-3372 or visit http://www.idera.com.
Sponsor: Innovartis
ISV? Database Version Upgrades Painful?
DB Ghost Packager Plus enables ISVs to develop an installer for their customers containing the new version of their product that will automatically bring any target database to the same level as the source database. ISV customers just launch the Packager Plus installer.exe, choose the location and name of the database, set the basic settings, and click—it is done. Excuse the cliche, but it really is as simple as that. Download our 14-day Free Trial.
Prev. page
[1]
2
next page 
