SQL Server Magazine UPDATE, February 22, 2007--SP2 Offers Unlimited Virtual Licenses

SQL Server Magazine UPDATE, February 22, 2007--SP2 Offers Unlimited Virtual Licenses

In This Issue:
On Monday, Microsoft released SQL Server 2005 Service Pack 2, which offers SQL Server customers plenty of goodies, including a new Feature Pack, Data-Mining Add Ins for Microsoft Office 2007, and unlimited virtual licenses.

New Instant Poll: SQL Server 2005 SP2
"When will you deploy SQL Server 2005 SP2?" Go to the SQL Server Magazine home page and submit your vote for:

  • We already have it.
  • We are getting ready to deploy it right away.
  • We are getting ready to deploy it right away.
  • Sometime in the next year.
  • Not until we're sure the bugs are worked out.
  • We don't have plans to deploy SP2.

To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add [email protected] to your list of allowed senders and contacts.

Our Sponsors, Who Help Support the Free Delivery Of This Newsletter:

February 22, 2007

1. Perspectives

  • SP2 Offers Unlimited Virtual Licenses

2. SQL Server Watch

  • Bug Fix List Covers SP2
  • Product Watch: ConvertU2 and Mike Murach and Associates

3. Hot Articles

  • Q&A: Stored Procedure Runtime
  • T-SQL Black Belt: DATETIME Calculations, Part 1
  • Hot Threads: Administration and T-SQL 2005s

4. Events and Resources

  • Deploy Exchange Server 2007 Without a Hitch!
  • SQL Server Magazine Connections
  • Get Ready for the Windows Server Longhorn Roadshow!
  • Build or Re-Engineer Your Business Applications

5. Featured White Paper

  • Protect Against Emerging Risks Today!

6. Announcements

  • Introducing a Unique Scripting Resource

7. Web Community

  • http://www.sqlmag.com

Sponsor: SPI Dynamics
ALERT: How Hackers Use SQL Injection to Steal Your Data and Bypass Authentication

It's as simple as placing additional SQL commands into a Web Form input box giving hackers complete access to all your backend systems! Firewalls and IDS will not stop such attacks because SQL Injections are NOT seen as intruders. Download this *FREE* test guide from SPI Dynamics to check for SQL Injection vulnerabilities.

1. Perspectives

SP2 Offers Unlimited Virtual Licenses
by Brian Moran, [email protected]

On Monday, Microsoft released SQL Server 2005 Service Pack 2 (SP2) to manufacturing. I hope that you've already completed your deployment strategy because you reviewed the contents of the SP2 Community Technology Preview (CTP). If you haven't, it's time to get busy so that you'll know how to answer the questions that come from your bosses, users, and developers. Not sure if you should bother? Take a look at some of the goodies that SP2 offers before you make up your mind.

Read the full article at:

Sponsor: Polyserve
Consolidating SQL Server Resources

Learn how you can optimize your SQL Server environment in multiple ways: reduce the number of servers you need by 50%; decrease storage requirements and software images; provide failover and disaster recovery services; reduce server management time, storage, and OS patches; and quickly react to capacity changes for online scalability. On-Demand Web seminar.

2. SQL Server Watch

Bug Fix List Covers SP2
With the release of SQL Server 2005 Service Pack 2 (SP2), Microsoft published a list of the bugs that the new service pack fixes. The extensive list includes links to hotfixes for bugs that have been fixed since SP1 and also includes a link to the cumulative hotfix package that was released last September. You can read the full list at http://support.microsoft.com/default.aspx?scid=kb;en-us;921896

Product Watch
by Blake Eno, [email protected]

Automatically Convert Access Databases to SQL Server
ConvertU2 announced 2SQL, software that automatically converts Microsoft Access databases to SQL Server by using the Microsoft Access Project model. 2SQL converts Access queries to views or stored procedures, Data Access Objects (DAOs) to ADOs, Access functions to SQL Server equivalents, and Access functions that don't have SQL Server equivalents to user-defined functions (UDFs). 2SQL uses the Access Upsizing Wizard or SQL Server Migration Assistant to upsize data and tables. 2SQL is licensed as a service. Your Access database is scanned for conversion problems, then you pay for the number of conversion units needed to convert to SQL Server. For more information, contact ConvertU2 at 617-335-6679 or visit http://www.convertu2.com.

Learn How to Become a Better SQL Server Developer
Mike Murach and Associates announced "Murach's SQL Server 2005 for Developers," a book that teaches application developers how to query a database and take advantage of cursors, views, and stored procedures. The book also covers SQL statements for XML data handling and error processing, SQL Server Management Studio (SSMS), and the CLR integration feature that lets developers create database objects in .NET languages. "Murach's SQL Server 2005 for Developers" has a list price of $52.50 and right now, you can purchase the book at Marach's Web site for $36.75. For more information, contact Murach at 800-221-5528 or visit http://www.murach.com.

3. Hot Articles

Q&A: Stored Procedure Runtime
by Brian Moran, [email protected]

Q. During performance tests in both single-user and multiple-user modes, I received some confusing results. A particular stored procedure generally runs in 5 seconds; however, when multiple users run the query at the same time, it takes nearly five times as long to run all the queries. After the first user receives the results, the others come back one right after another. Does SQL Server let only one person execute a stored procedure at any given time?

Read the answer to this question today at

T-SQL Black Belt: Datetime Calculations, Part 1
This first part of a series about datetime challenges and calculations focuses on the use of trimming techniques to return only the date or the time of a given datetime value. Read this article today and post your comments at http://www.sqlmag.com/Articles/ArticleID/94487/94487.html.

Hot Threads:

4. Events and Resources

Deploy Exchange Server 2007 Without a Hitch!
This one-day technical training event teaches you how to preempt pitfalls and avoid corrupting your infrastructure. You'll learn how to effectively install, manage, and secure Exchange Server 2007 in a 64-bit environment. You'll also get a peek into the integration of Outlook, SharePoint Server 2007, and Exchange Server 2007. Register today!

SQL Server Magazine Connections
March 25-28, 2007, Orlando World Center Marriott. Dive into SQL Server 2005 and train with Microsoft architects and world-renowned developers and DBAs. Choose from 40 in-depth, no-hype sessions. Register early to save $100 and attend sessions of the co-located Visual Studio Connections and Microsoft ASP.NET Connections for FREE. For details, call 800-438-6720 or 203-268-3204 or visit http://www.sqlconnections.com.

Get Ready for the Windows Server Longhorn Roadshow!
Seize control of your Windows infrastructure with Microsoft's biggest server release since Windows 2003. Get a live, under-the-hood look at Longhorn virtualization, deployment, Web services, and breakthroughs in core reliability. This one-day event is filled with demonstrations and in-depth discussions designed for IT pros who want a deep understanding of Windows Server Longhorn. More info at http://www.windowsitpro.com/roadshows/longhorn/?code=epromo.

Tired of outdated and incomplete data modeling solutions? Build or re-engineer your business applications quickly, cost-effectively, and consistently with Sybase PowerDesigner 12. Download this free white paper today and learn how you can easily transfer your ERwin skills and start taking advantage of all of PowerDesigner's features. http://www.windowsitpro.com/go/whitepaper/sybase/erwin/?code=0219e&r

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

5. Featured White Paper

Prevent installation and execution of unauthorized software on the computers on your network. Download this free white paper today for a comparison of different techniques for detecting and preventing unauthorized code. Protect against emerging risks today!

Hot Spot: Hewlett-Packard
Top 5 Reasons Storage Consolidation Should Be on Every IT Department's Short List

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. http://www.windowsitpro.com/go/podcast/hp/consolidation/?code=SQLHot0222

6. Announcements

Introducing a Unique Scripting Resource
Scripting Pro VIP is an online information center that delivers new articles (and downloadable code!) every week on topics such as ADSI and PowerShell. Subscribers also receive tips, cautionary advice, direct access to our editors, and a host of other benefits! Order now at an exclusive charter rate and save up to $50!


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 2007, Penton Media, Inc. All Rights Reserved.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.