In This Issue:
Microsoft MVPs don’t just help spread the news about upcoming products and cool features; they also help shape the future of the products that Microsoft produces. And knowing what’s coming can help you, too, as you plan your future career moves!

New Instant Poll: Looking for PerformancePoint
"Are you aware of Microsoft's new PerformancePoint Server 2007?" Go to the SQL Server Magazine home page and submit your vote for:

  • Yes, and I’d like to learn more about it.
  • Yes, but it’s not relevant to my job.
  • Yes, we’re testing it.
  • No, and I’m not interested.
  • No, but I’d like to learn more.

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:


March 22, 2007

1. Perspectives

2. SQL Server Watch

  • Product Watch: Altova and Embarcadero Technologies

3. Hot Articles

  • Q&A: Tempdb Affects Query Performance During Autogrow
  • T-SQL Black Belt: DATETIME Calculations, Part 2
  • Puzzled by T-SQL: Deadlocks with Custom Sequence
  • In a Nutshell: Support Insights
  • Hot Threads: Get a free tool to copy multiple DTS packages to a file, and help a user solve a sticky capacity-planning problem in SQL Server 2005.

4. Events and Resources

  • Deploy Exchange Server 2007 Without a Hitch!
  • SQL Server Magazine Connections
  • Get Ready for the Windows Server Longhorn Roadshow!

5. Featured White Paper

  • The Email Management Crisis

6. Announcements

  • Introducing a Unique Security Resource
  • SQL Server Performance Tuning Articles and Tips

7. Web Community

  • http://www.sqlmag.com

SPONSOR: Microsoft

Protect SQL Server with Microsoft’s Data Protection Manager

Learn how you can use Microsoft System Center Data Protection Manager (DPM) v2 to extend the native SQL Server feature set to provide continuous data protection with byte-level replication and integrity checking. From business case to recovery scenarios, this whitepaper demonstrates how DPM v2 will integrate with your SQL Server infrastructure. Download your version of the white paper now.


1. Perspectives

Microsoft MVPs: Always Looking Ahead
by Brian Moran, brian@solidqualitylearning.com

Here are the 10 most exciting changes that will be happening in Katmai.

Just kidding. That information is kept secret under the non-disclosure agreements (NDAs) that constrain MVPs. But at last week’s Microsoft MVP Summit, participants did get a lot of cool new information that they can share in upcoming months. The MVP program does a world of good for the Microsoft community at large and the SQL Server community in particular. Let’s ignore the fact that MVPs answer a tremendous number of questions on the newsgroups. That contribution is easy to focus on. A contribution that’s not as obvious is the reliance of the Microsoft product teams on feedback from the MVP teams.

Read the full article at:
http://www.sqlmag.com/Article/ArticleID/95547/sql_server_95547.html


SPONSOR: Quest Software

Have a SQL Backup and Recovery Question? Ask SQL Stan!

Want to learn how to recover only the SQL data you need? No matter what your question about SQL Server backup and recovery, Quest Software and SQL Stan have the answer. Who is SQL Stan? Find out, and get answers to your SQL Server questions!


2. SQL Server Watch

Product Watch
by Blake Eno, products@sqlmag.com

Visually Design Application Models
Altova announced Altova UModel 2007, software you can use to visually design application models and generate Java or C# code or to reverse engineer existing programs into Unified Modeling Language (UML) diagrams. This release supports four newly added diagram types (interaction overview, timing, communication, and package) and adds the capability to model XML Schema files in UML. The software features additional support for reverse engineering of Java and C# binary files and the ability to hyperlink elements of UML diagrams to other diagrams or external files. Altova UModel 2007 can also automatically generate sequence diagrams from communication diagrams. Single-user licenses for Altova UModel 2007 start at $129. For more information, contact Altova at 978-816-1600.
http://www.altova.com

Identify Relationships Between Data and Processes
Embarcadero Technologies announced EA/Studio Business Modeler Edition, a business process and conceptual modeling tool that connects data models with business processes to align IT with business objectives. The software shows how data architectures and the database applications in the enterprise directly affect business processes and vice versa. EA/Studio can tell you what processes create, read, update, and delete data. Business models created in Microsoft Visio can be imported into EA/Studio to associate business process models with data models. Pricing for EA/Studio starts at $495 per seat. For more information, contact Embarcadero Technologies at 415-834-3131.
http://www.embarcadero.com


3. Hot Articles

Q&A: Tempdb Affects Query Performance During Autogrow
by Brian Moran, brian@solidqualitylearning.com

Q. The execution time for a particular stored procedure increases 500 percent when we restart SQL Server. Our tests account for the effect of data caching, and the stored procedure's execution plan doesn't change. We don't see drops in performance from our other stored procedures, and the slow procedure's performance returns to normal eventually. How can we tune the slow procedure's performance?

Read the answer to this question today at
http://www.sqlmag.com/Articles/ArticleID/45154/45154.html

T-SQL BLACK BELT: DATETIME Calculations, Part 2
Learn techniques for calculating a certain period's start and end datetime values--for example, given an input datetime value, returning the corresponding first day of the month--and for calculating a language-independent weekday. Read this article today and post your comments at
http://www.sqlmag.com/Article/ArticleID/94819/sql_server_94819.html

PUZZLED BY T-SQL: Deadlocks with Custom Sequence
Recently someone posted a question in a public SQL Server programming newsgroup. He got deadlocks when multiple sessions running concurrently were executing a similar stored procedure while working with the serializable isolation level, and he was wondering how could this happen. It’s easy to reproduce such deadlocks, and if you trace the locks acquired and released during the activity, you can figure out how the deadlocks evolve. Read this blog entry and post your comments today at:
http://www.sqlmag.com/article/articleid/95538/sql_server_blog_95538.html

IN A NUTSHELL: Support Insights
This week, Kevin Kline points to a fascinating interview with SQL Server support team member Bob Dorr. Among other interesting facts, Kevin was impressed by the fact that the team had hired a statistical engineer to perform a wide variety of manipulations against the data concerning bugs and errors, including assigning each incident a value on a customer pain index. Although this might seem like a great idea, even an elementary idea, Kevin is surprised at the number of high-end ISVs that don’t employ such a technique to improve their support systems. Read the interview and let Kevin know your opinions today at
http://www.sqlmag.com/article/articleid/95422/sql_server_blog_95422.html

HOT THREADS: Join the discussions and share your expertise with your peers on our forums! New this week:


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. 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.
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.
http://www.windowsitpro.com/roadshows/longhorn/?code=epromo

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


5. Featured White Paper

Learn the 7 critical email problems to watch for and how to prevent them. Find out how to better manage your email environment, including disaster recovery, compliance, data storage, security, and wireless devices. Download this free white paper today.


Hot Spot: NetSuite

CRM Success: Fast Growing Companies. Free Report
Discover the newest solutions to the largest CRM-based, technical, value chain barriers facing rapidly growing SMBs today. Learn the real secrets of how to seamlessly integrate your partners, vendors, suppliers and employees so your company can realistically achieve real customer focus and value.


6. Announcements

Introducing a Unique Security Resource
Security Pro VIP is an online information center that delivers new articles every week on topics such as perimeter security, authentication, and system patches. 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!

SQL Server Performance Tuning Articles and Tips
Check out the Net's largest site dedicated to SQL Server performance tuning. Get the most out of SQL Server with thousands of performance tuning articles/tips/FAQs for SQL Server 2000 and 2005. To join the forums and chat with more than 18,000 advanced SQL Server DBAs and developers, click here.

 


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.