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

  • http://www.sqlmag.com

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.


3. Hot Articles

Reader to Reader: Summarize All the Constraints for a Table
Send your SQL Server code, comments, discoveries, and solutions to r2r@sqlmag.com.

The sp_showConstraints stored procedure is an alternative to using sp_helpconstraint when you need to find all the constraints for a table. Read this tip today at: http://www.sqlmag.com/Articles/ArticleID/93600/93600.html.

SELECT TOP(X): SQL Server 2005 System Databases
Get a better idea of how SQL Server 2005 works by looking behind the scenes at the six system databases that help it function. Read this article today and post your comments athttp://www.sqlmag.com/Articles/ArticleID/93730/93730.html.

IN A NUTSHELL: Who’s Administering SharePoint?
Kevin Kline wants to know how your organization is managing the explosive growth of Sharepoint. Read the blog and let Kevin know your opinion today at http://www.sqlmag.com/Blog/Index.cfm?action=BlogIndex&DepartmentID=965#94573.

In a Nutshell: New Book on Reporting Services
In this week’s blog, Kevin Kline recommends a new Reporting Services book that’s full of useful example code and case studies. Read this week’s entry and post your own thoughts today at http://www.sqlmag.com/Article/ArticleID/94179/sql_server_blog_94179.html.

Hot Threads:


4. Events and Resources

Maximize your investment in your VoIP network by using all of its capabilities. Learn to integrate Fax for IP to reduce the TCO and increase ROI for your investment. On-Demand Web Seminar.

Discover a wealth of information about how to protect and secure your data in the event of a disaster. You may not be able to predict the exact details of a disaster, but you can be prepared with a solid response for when one strikes. Disaster can strike anywhere—not just where severe weather can hit—so make sure you’re ready when it does. Download your free copy of this eBook today!

Does your SQL Server deployment suffer from low utilization rates, sub-optimal availability, and management challenges? Learn to overcome these difficulties by deploying a single database utility that can help lower your cost of ownership by 70% and react to changes within 30 seconds. On-Demand Web Seminar.

Got information? Good! Now, can you use it? Get up to speed on database design and hierarchy, including columns and data types, creating databases, and using the Query Editor. Download your free copy today!

See the complete Windows IT Pro Network guide to Web and live events.


5. Featured White Paper

The average enterprise spends nearly $10 million annually on IT compliance. Download this free white paper today to streamline the compliance lifecycle, and dramatically reduce your company’s costs!

Bonus: Register for any whitepaper from Windows IT Pro during December — you could win a Nintendo Wii! View the full whitepaper listing at http://www.windowsitpro.com/whitepapers — and remember, the more you download, the better your chances of winning.


6. Reader Challenge

December Reader Challenge Solution: Improve T-SQL to Prevent Deadlocks
by Umachandar Jayachandran, challenge@sqlmag.com

Congratulations to John T. Keller, who won first prize of $100 for the best solution to the December Reader Challenge, "Improve T-SQL to Prevent Deadlocks" and to Bill Twomey who won second prize of $50. John is a database developer for Softek Solutions, and Bill is a SQL Server DBA for Database Solutions. You can read a recap of the problem and the solution to the December Reader Challenge at http://www.sqlmag.com/Article/ArticleID/94572/sql_server_94572.html.

January Reader Challenge: Converting a Hexadecimal String to a Varbinary Value
Now, test your SQL Server savvy in the January Reader Challenge, "Converting a Hexadecimal String to a Varbinary Value" (below). Submit your solution in an email message to challenge@sqlmag.com by December 21. Umachandar Jayachandran, a SQL Server Magazine technical editor, will evaluate the responses. We'll announce the winner in an upcoming SQL Server Magazine UPDATE. The first-place winner will receive $100, and the second-place winner will receive $50.

Here's the challenge:
Bart is a DBA who maintains several data warehouses, which are hosted on SQL Server 2000. One data warehouse has a table called ExtFeeds that periodically receives data as flat files loaded from an external source. One of the columns in the flat file has a hexadecimal string value, ranging from 4 to 32 bytes, which is stored in the ExtFeeds table's DataHdr column. The external source can't be modified easily, and other applications rely on the DataHdr values to be strings, so Bart can't manipulate the value or convert to binary data. Instead he loads the files directly into the table by using the bcp utility.

However, Bart needs to periodically write queries against the ExtFeeds table that involve accessing the DataHdr column. The queries perform various operations such as converting the hexadecimal string value to varbinary and joining the ExtFeeds table with other tables. Help Bart design a solution that helps convert the hexadecimal strings to varbinary values. He would need to perform the conversion in the SELECT list of queries, in the logic in stored procedures, and in INSERT and UPDATE statements. The solution should be able to support values ranging from 4 to 32 bytes and perform efficiently.


Hot Spot: SPI Dynamics
ALERT: “How a Hacker Launches a Blind SQL Injection Attack Step-by-Step!”—White Paper

The newest web app vulnerability: Blind SQL Injection! Even if your web application does not return error messages, it may still be open to a Blind SQL Injection Attack. Blind SQL Injection can deliver total control of your server to a hacker, giving them the ability to read, write, and manipulate all data stored in your back-end systems! Download this *FREE* white paper from SPI Dynamics for a complete guide to protection!


6. Announcements

Holiday Offer—Save $40 on SQL Server Magazine
Don't miss SQL Server Magazine in 2007! As a subscriber, you’ll have full access to must-have content covering high availability, SQL Server and Microsoft Office integration, business intelligence, clustering, Reporting Services and much more. Order now and save $40: https://store.pentontech.com/index.cfm?s=1&promocode=eu216cuw.

Make Your Mark on the IT Community!
Nominate yourself or a peer to become an "IT Pro of the Month." This is your chance to get the recognition you deserve! Winners will receive more than $600 in IT resources and be featured in Windows IT Pro magazine and the TechNet Flash email newsletter. It's easy to enter—accepting January nominations now for a limited time! Submit your nomination today: http://www.windowsitpro.com/go/itpromonth.


 

7. Web Community

 


Contact Us

SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today!

SQL Server Magazine is a division of Penton Media, Inc.
221 East 29th Street, Loveland, CO 80538
Attention: Customer Service Department

Copyright 2006, Penton Media, Inc. All Rights Reserved.