Subscribe to SQL Server Pro Digital Editon


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.

This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.

Consolidate Your SQL Server Infrastructure

Breakthrough Solution for SQL Server Consolidation

Register Now before PDC05 Sells Out


August 11, 2005

1. Perspectives

  • Baby Steps to SQL Server 2005
  • 2. SQL Server 2005 Watch

  • Microsoft Provides Hands-On Labs for Visual Studio 2005
  • 3. News & Views

  • Results of Previous Instant Poll: Windows Vista
  • New Instant Poll: Migration Preparation
  • 4. Reader Challenge

  • August Reader Challenge Solution: August Reader Challenge: Partitioning Tables
  • September Reader Challenge: Defining Extended Properties
  • 5. Events and Resources

  • Sort Through Sarbanes-Oxley, HIPAA Legislation and More--Quicker And Easier!
  • The 15-Minute Failover Solution for Exchange
  • Microsoft SQL Sever 2005--For Every Tier Of Your BI Application
  • Compliance vs. Recovery: Can You Have Your Cake and Eat It Too?
  • 6. Featured White Paper

  • Converting a Microsoft Access Application to Oracle HTML DB
  • 7. Peer to Peer

  • Hot Tip: Setting Autogrow Properties
  • Hot Article: DML with Results
  • Hot Threads
  • 8. Announcements

  • SQL Server Magazine Gives DBAs and Developers What They Need
  • Try a Sample Issue of Windows Scripting Solutions!
  • 9. New & Improved

  • Get Continuous Data Protection for the Enterprise
  • Search for Unsearchable Data
  • Make Database Comparisons a Snap
  • Sponsor: Consolidate Your SQL Server Infrastructure
    Shared data clustering is the breakthrough consolidation solution for Microsoft Windows servers. In this free white paper, learn how shared data clustering technology can reduce capital expenditures by at least 50 percent, improve management efficiency, reduce operational expense, ensure high availability across all SQL Server instances, and more! Find out how you can reduce the overall Total Cost of Ownership (TCO) for SQL Server cluster deployments by as much as 60 percent over three years!

    1. Perspectives

  • Baby Steps to SQL Server 2005
  •     by Brian Moran, brian@sqlmag.com

    Some of you have dutifully been ramping up for SQL Server 2005 throughout the long beta cycle. Others of you barely have enough time in the day to keep up with your current production and development needs. Playing with new versions of SQL Server months before it ships would be great, but who has the time?

    If you fall into that latter group, the trick to ramping up might be to learn in bite-sized amounts. Don't have time to dedicate a full week or even a few days to playing with and learning about SQL Server 2005? How about 1 hour at a time? Microsoft has publicly released more than 30 on-demand Webcasts that provide a great way to bone up on SQL Server 2005. You can browse a comprehensive list of all the current SQL Server 2005 Webcasts--as well as some new ones scheduled for August and later months--at http://lists.sqlmag.com/t?ctl=10AEB:7B3DA .

    Another great resource is a series of nine Microsoft e-learning classes. Microsoft has valued them at $99 each, but they're available right now for free download. I don't know when or if Microsoft will start charging for them, but I've always been a big fan of free stuff, so I suggest you grab them while you can from the Get Ready for Microsoft SQL Server 2005: Microsoft Learning Resources site at http://lists.sqlmag.com/t?ctl=10AEA:7B3DA . If you want to learn about SQL Server 2005 administration, you can check out these three classes:

  • 2936: Installing and Securing Microsoft SQL Server 2005
  • 2937: Administering and Monitoring Microsoft SQL Server 2005
  • 2938: Data Availability Features in Microsoft SQL Server 2005
  • Developers can ramp up their SQL Server 2005 knowledge with these three classes:

  • 2939: Programming Microsoft SQL Server 2005
  • 2940: Building Services and Notifications Using Microsoft SQL Server 2005
  • 2941: Creating the Data Access Tier Using Microsoft SQL Server 2005
  • And anyone who works with business intelligence (BI) can tune in to these three classes:

  • 2942: New Features of Microsoft SQL Server 2005 Analysis Services
  • 2943: Updating Your Data ETL Skills to Microsoft SQL Server 2005
  • Integration Services

    If you're not sure which classes to try first, three online skills assessments are available to help you understand what you do and don't already know about SQL Server 2005. You can take the classes entirely online, and you can also download the course content so that you can review the classes while you're disconnected from the Internet. The classes that I downloaded show an expiration date of November 2, so presumably Microsoft may begin to charge for the classes after that date.

    The resource site points out that you might encounter a compatibility problem when viewing the material if you've installed the June SQL Server 2005 Community Technology Preview (CTP). According to the site:

    "If you downloaded the SQL Server June 2005 Community Technology Preview (CTP) in mid-June, you, you may encounter difficulty in accessing the e-learning courses due to a compatibility issue between the e-learning player and the MSXML parser that shipped with the Beta. If you do experience this difficulty, please access the e-learning courses from a computer that does not have the SQL Server 2005 Beta installed until Microsoft can implement a fix."

    This is the first time I've experimented with the Microsoft e-learning classes. It's actually a nifty model. You can navigate through the slides, access various demonstrations and videos, and the classes include a section to take notes about each slide as you progress.

    Feel swamped and still don't think you have time to take this route? Let's face facts: You have to learn SQL Server 2005 because sooner or later your job will probably depend on it. Rome wasn't built in a day--and you won't learn SQL Server 2005 overnight. But do yourself a favor and start learning about SQL Server 2005 one baby step at a time. You'll be glad you did!


    Breakthrough Solution for SQL Server Consolidation
    With ARMTech for SQL Server workload management technology from Aurema, you can improve system utilization and performance, lower TCO and say goodbye forever to the days of "one app, one server." The only workload management solution specifically designed to enable SQL Server consolidation, ARMTech delivers increased reliability, improved performance, and higher system utilization in Windows server environments. Download your free evaluation copy of ARMTech for SQL Server and start saving today!


    2. SQL Server 2005 Watch

    Sponsor: Register Now before PDC05 Sells Out
    Join the conversation this September at PDC05, where the next wave of Microsoft platform technologies, including the latest on Windows Vista and Microsoft Office System developer capabilities will be unveiled. Space is limited, and registration is filling up quickly so be sure to register if you haven't yet.

    3. News & Views

    Results of Previous Instant Poll: Windows Vista
    "Will your company upgrade to Windows Vista when the final version ships?" Here are the results from the 36 votes:

    New Instant Poll: Migration Preparation
    "Do you feel prepared to migrate to SQL Server 2005?"

    4. Reader Challenge

    Congratulations to Michael Fan, a software developer for Americall Group in Naperville, Illinois, and Stephen Tregidga, a BI analyst and developer, and his colleague Ken Chenery, a DBA, from Auckland, New Zealand. Michael won first prize of $100 for the best solution to the August Reader Challenge, "Partitioning Tables." Stephen and Ken won second prize of $50.

    Here's the challenge: Michael is a database administrator in a company that hosts Web sites and databases. Every customer gets a separate database, and the databases are hosted on Microsoft SQL Server 2000. As part of the setup process for each database, Michael's company defines and stores some additional properties by using the extended properties feature. The properties can be string, integer, or date types. The following sample script shows some examples (from the Northwind and Pubs databases) of properties that Michael defines.

    DECLARE @v sql_variant;
       EXEC northwind.dbo.sp_addextendedproperty N'Prop1', N'Value1'
       EXEC northwind.dbo.sp_addextendedproperty N'Prop2', 1
       SET @v = cast('2005-7-1' as smalldatetime);
       EXEC northwind.dbo.sp_addextendedproperty N'Prop3', @v;

       EXEC pubs.dbo.sp_addextendedproperty N'Prop1', N'Value2'
       EXEC pubs.dbo.sp_addextendedproperty N'Prop2', 2
       SET @v = cast('2005-7-2' as smalldatetime);
       EXEC pubs.dbo.sp_addextendedproperty N'Prop3', @v;

    Michael needs to write a stored procedure that can search these extended properties and return the values. Help him do the following tasks:

    1. Write a stored procedure to search the databases on a server for a specific property and value.
    2. Be sure the stored procedure returns a list of the databases with the property name and value.
    3. Specify string values as a pattern and search for it.
    4. Search only for the specified value of other types.

    5. Events and Resources


    6. Featured White Paper


    7. Peer to Peer

    Q. When setting the autogrow properties for a SQL Server data file, is it better to use a fixed size or a percentage growth?

    Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.

    T-SQL: Can I Use T-SQL Code to Search a Directory?
     
    OLAP/Data Warehousing: MDX Formula for Estimating Growth Over Time

    Development: .NET Developers Denied Access

    Administration: Transforming Oracle Text File Data to SQL Server

    Database Design: Best Way to Track Scheduling
     
    Replication: Problems with the Distribution Job
     

    8. Announcements

    9. New & Improved