In This Issue:
If a rising tide floats all ships, database professionals on the good ship SQL Server should see their own fortunes rising on the strength of Microsoft's database platform.

New Instant Poll: Notification Services
"Are you using Notification Services?" Go to the SQL Server Magazine home page and submit your vote for:

  • Yes, for months now.
  • Yes, but we're just getting started.
  • No, but we plan to.
  • No, we don't need it.
  • Do I even have that?

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:


November 9, 2006

1. Perspectives

  • Follow the Money

2. SQL Server Watch

  • Publish SQL Server Databases for Web-Based Development
  • This Month's Theme: Management Tools: SQL Server 2005 Management Tools
  • Product Watch: Killer Bite Software, KeyStone Learning Systems

3. Hot Articles

  • Reader to Reader: Prove That the Database Isn't to Blame
  • SELECT TOP(X): Virtual Labs for SQL Server 2005
  • In a Nutshell: The New Tool Time Column
  • Hot Threads: SQL Server 2005 Management Tools and Performance

4. Events and Resources

  • Attend TechX World
  • Optimize Your Resources with Server Consolidation
  • Top 5 Reasons for Storage Consolidation
  • Test Your Disaster Recovery Skills
  • Tips for Safeguarding Your System

5. Featured White Paper

  • Extend Windows Rights Management Services

6. Announcements

  • SQL Server Performance Tips, Articles, and Forums
  • Save $40 off SQL Server Magazine

7. Web Community


Sponsor: Double-Take Software
Enhance SQL Reporting Services with Double-Take

SQL Reporting Services is an exciting way for organizations to gain access and insight into their important business data stored in SQL Server. Get an overview of how to increase your production server's performance by offloading Reporting Services to a secondary server. Download your free copy today!


1. Perspectives

Follow the Money
by Brian Moran, brian@solidqualitylearning.com

Follow the money: That's one of the catch phrases in detective novels or books when the good guys are trying to track down the bad guys, right? The phrase also works in politics when you're trying to understand motivation, and it often works in business when you're trying to understand where a company will be putting its priorities.

I don't typically talk about Microsoft finances from my editorial soapbox, but Microsoft's recent announcement about its earnings for the first quarter of its fiscal year 2007 (July through September 2006) caught my eye. The company's announcement focuses heavily on SQL Server and the fact that strong sales of SQL Server are one of the brightest spots in overall company growth. Here are a few quotes, and some supporting data from the recent announcement:

"Server & Tools revenue increased 17% over the comparable quarter in the prior year, reflecting healthy performance for offerings such as SQL Server 2005, Windows Server, Visual Studio 2005 and BizTalk Server. SQL Server experienced revenue growth of over 30%, as customers are increasingly deploying SQL Server for their mission critical, transaction-oriented databases."

You can find the entire earnings report, with supporting documentation at http://www.microsoft.com/msft/earnings/FY07/earn_rel_q1_07.mspx#Channel. I know—boring, right? Well, you'll better understand Microsoft if you understand what Microsoft is telling Wall Street and the financial markets. Peruse the data (including a nice, easy-to-follow PowerPoint summary at http://www.microsoft.com/msft/download/FY07/Q1-FY07Slides.ppt), and you'll see that Microsoft reports its income across just five major product divisions. SQL Server is part of the Servers and Tools group, which came in at number three in terms of total revenue. But Servers and Tools was the clear winner in terms of year-over-year growth for the past quarter. And SQL Server's revenue increase of more than over 30 percent over the last year was the biggest component of that growth. As an aside, SQL Server's 30 percent growth rate in revenue was ahead of all other major database competitors, in addition to being one of the driving forces behind Microsoft corporate growth over the last year.

What does that mean to SQL Server professionals? Well, for one, you can surmise that Microsoft corporate thinks that SQL Server is a pretty darn important part of the company, and you can expect resources to be allocated accordingly to ensure SQL Server's strong growth continues. Even nicer, a rising tide tends to float all ships. Are you a SQL Server professional? Well, if the market for SQL Server is vibrant and growing at rates faster than its competition, you can rest assured that the phrase "follow the money" is relevant to your own personal financial health if you're savvy about managing your SQL Server career in this growing and financially healthy market.


Sponsor: XOsoft
How to Incorporate Virtual Machines into Your Disaster Recovery Plan

Join us for this free web seminar to learn how incorporating virtual machines into your disaster recovery plan can reduce your TCO by 50% or more, reduce hardware cost, and simplify management. Attend the live web seminar and get your questions answered by industry leaders from VMware and CA XOsoft. Live Event: Tuesday, September 19.


2. SQL Server Watch

Publish SQL Server Databases for Web-Based Development
If your SQL Server development team is working in a geographically dispersed environment, you might want to provide access to development databases through the Internet. However, deploying development databases to a Web-hosted SQL Server instance can be challenging. To make the task easier, Microsoft has created the Database Publishing Wizard. The new wizard, currently in its first Community Technology Preview (CTP) release, creates a SQL script that you can use to recreate your database in a hosted environment. You can download the Database Publishing Wizard CTP at http://www.microsoft.com/downloads/details.aspx?familyid=16d8c1e9-a6a3-43a2-9ba7-916c6eb5023b&displaylang=en.

This Month's Theme: Management Tools
The release of SQL Server 2005 has brought lots of changes in every aspect of the product. Join Kalen Delaney and Ron Talmage on an exploration of the new management tools: SQL Server 2005 Management Tools.

Product Watch
by Blake Eno, products@sqlmag.com

Visualize What's Happening Within Your Database and SQL Code
Killer Bite Software announced SQL Visualizer, a Windows client-based database query and management tool that helps developers create and maintain SQL Server code. The software features IntelliSense, custom object scripting, data scripting, code snippets and code regions. SQL Visualizer enables you to navigate around your database objects and lets you visualize what's happening within your database and SQL code. The software searches for database objects and content across multiple databases and servers and is able to override server connections properties at the database level. You can also view the history of previously executed queries maintained between sessions. A free 30-day trial of SQL Visualizer Premium Edition is available at Killer Bite Software's Web site. A free, Select Edition with reduced functionality is also available.

Implement, Maintain, and Troubleshoot SQL Server 2005 Databases
KeyStone Learning Systems released its latest instructor-based video courseware, "SQL Server 2005 Implementation and Maintenance". This training course starts with the processes of installation, configuring, and upgrading to SQL Server 2005. Creating new database instances and configuring SQL Server 2005 security will also be covered. This course will then guide your through supporting database clients, importing and exporting data, and working with XML data. "SQL Server 2005 Implementation and Maintenance" also explains how to create and manage various database objects, including tables, views, triggers, functions, and stored procedures. The training course also provides tips to monitoring and troubleshooting SQL Server 2005 performance. A single-user license starts at $499. For more information, contact KeyStone Learning Systems at 800-949-5590 or visit http://www.keystonelearning.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 pun, but it really is as simple as that. Download our 14 day Free Trial.


3. Hot Articles

Reader to Reader: Prove That the Database Isn't to Blame
Share your SQL Server code, comments, discoveries, and solutions at r2r@sqlmag.com.

If you've ever had users call to tell you that a SQL Server database is slow, you'll likely find sp_Now a handy tool. This stored procedure determines what processes are currently executing and consuming resources on a database server. Read this article today at http://www.sqlmag.com/Article/ArticleID/93150/sql_server_93150.html.

SELECT TOP(X): Virtual Labs for SQL Server 2005
Using Microsoft's virtual labs, you can get hands-on experience with SQL Server 2005—but which of the 17 SQL Server 2005 virtual labs should you try first? Here's a quick preview of 5 of the most useful. Read this article today and post your comments at http://www.sqlmag.com/Article/ArticleID/93362/sql_server_93362.html.

In a Nutshell: The New Tool Time Column
This week, Kevin Kline introduces his new column, Tool Time with Kevin Kline, which will appear monthly in the print magazine. The column dovetails with an online forum. Check out Kevin's new ventures and post your favorite tools today http://www.sqlmag.com/Article/ArticleID/94107/sql_server_blog_94107.html.

Hot Threads:


4. Events and Resources

Attend TechX World
No IT pro today works in a completely heterogeneous environment, and with virtualization, your chances of dealing with multiple OSs is increasing. Attend TechX World—available online December 14—and find out about virtualization, OS interoperability, directory and security integration, and data interoperability. Register today for free!

Optimize Your Resources with Server Consolidation
Learn from industry expert Mike Otey about different approaches to server consolidation and how to stop server sprawl by using consolidation and virtualization. Find out how to use virtualization to run legacy OSs, make Linux and Windows coexist, and more. You'll even get step-by-step instructions for building a virtual machine for Windows Server 2003. On-demand Web seminar.

Top 5 Reasons for Storage Consolidation
Information is the "I" in "IT." Do you know where your information is? Is it protected? Backed up? Download this free podcast today to find out the top 5 reasons that you should be considering storage consolidation.

Test Your Disaster Recovery Skills
When disaster strikes, do you feel like you're digging for buried treasure to recover your data? Test your disaster recovery skills, and you could win! Each week we'll give away a USB flash drive to one lucky treasure hunter. You'll also be entered to win the full treasure chest, including Bose headphones! Test your skills now!

Tips for Safeguarding Your System
Your business, like most today, relies upon its computing systems to store financial information, house proprietary data, and maintain communications channels. This increasing reliance also increases the dangers to your systems from security breaches, including viruses, spyware, spam, and hackers. Visit the Windows Protection Site at http://www.windowsitpro.com/go/protection for the latest tips on safeguarding your system.

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


5. Featured White Paper

Extend Windows Rights Management Services
Does your business require collaboration to get projects done? If so, you're at risk for having your valuable business data accidentally transferred to outside parties. Using enterprise rights management can help mitigate this risk and allow your users to work with confidence. Learn to extend Windows Rights Management Services to protect your digital information today!


Hot Spot: Polyserve
IT Consolidation: Maximizing the Potential of Your Windows Environment

Optimize your existing Windows Server infrastructure with the addition of server and storage consolidation software and techniques, including tips and guidelines to evaluate your current infrastructure and determine what segments of your environment are suitable for consolidation.


6. Announcements

SQL Server Performance Tips, Articles, and Forums
Get hundreds of free tips and articles on SQL Server performance tuning and clustering. And get quick and accurate answers to your performance- and cluster-related questions in our forum. All from the SQL Server performance and clustering authority: SQL-Server-Performance.com.

Save $40 on SQL Server Magazine
Subscribe to SQL Server Magazine today and SAVE $40! Along with your 12 issues, you'll get FREE access to the entire SQL Server Magazine online article archive, which houses more than 2,500 helpful SQL Server articles. This is offer expires on November 30, 2006, so order now: https://store.pentontech.com/index.cfm?s=9&promocode=eu216bus.


 

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.