In This Issue:
As a SQL Server professional, your job is to use SQL Server to develop creative solutions to your organization’s business problems. Why not get some credit for your creativity? SQL Server Magazine is giving you the chance to show off your innovative work!

New Instant Poll: Database Interoperability
"Other than SQL Server, what database platforms does your organization use?" Go to the SQL Server Magazine home page and submit your vote for:

  • Oracle
  • IBM DB2
  • Sybase
  • MySQL
  • Other
  • More than one of the above

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:


August 31, 2006

1. Perspectives

  • Get Kudos for Your SQL Server Innovations

2. SQL Server Watch

  • Regional Events Cover Four Key Interoperability Topics
  • Product Watch: Vista Software and Lattix

3. Hot Articles

  • Q&A: Easy Reading: See Backup Date and Time
  • Feature: Solving Merge Replication Performance Problems
  • In a Nutshell: Survey of Opinions About Semi-Structured Data
  • In a Nutshell: CodePlex Coolness
  • Hot Threads: SQL Server General Discussion and SQL Server 2005 General Discussion

4. Events and Resources

  • Gear up for TechX World Roadshow
  • Be Prepared for E-Discovery
  • Email Discovery and Compliance
  • How to Simplify Exchange Troubleshooting

5. Featured White Paper

  • Making Information Work for SMBs

6. Announcements

  • Invitation for VIP Access
  • Save $40 on SQL Server Magazine

7. Web Community

  • http://www.sqlmag.com

Sponsor: SPI Dynamics
Alert: “How Hackers Launch Web App Attacks”

Learn why 70% of today's successful hacks involve Web Application attacks such as: SQL Injection, XSS, Cookie Manipulation and Parameter Manipulation. All undetectable by Firewalls and IDS! Download *FREE* white paper from SPI Dynamics for a complete guide to protection!


1. Perspectives

Get Kudos for Your SQL Server Innovations
by Brian Moran, brian@solidqualitylearning.com

Are you a SQL Server innovator? If you think so, you might want to submit a solution you’ve developed during the past year to the fifth-annual SQL Server Magazine Innovators Awards contest. I’m ashamed to admit that the summer has slipped away from me and I should have remembered to encourage you to participate in this contest a few weeks ago. You must have your contest entry in by September 1, which is tomorrow—assuming you’re an avid SQL Server Magazine UPDATE reader and are reading this editorial on August 31!

How will the contest be judged? Well, the word “innovator” in the name should be a big clue. This contest doesn’t necessarily award the biggest SQL Server implementation. Instead, it pays homage to teams and individuals in the SQL Server community who are doing new and interesting things with SQL Server and its related products. The contest Web site’s description explains what matters in your entry. You might be a SQL Server innovator if your solution:

  • uses Microsoft SQL Server technology
  • blends technical know-how with creative, innovative problem solving
  • solves a tough business challenge
  • has brought tangible benefits to your organization, such as cost savings, improved user productivity, better customer service, or help in achieving regulatory compliance

What can you win? Needless to say, you’ll win the praise and admiration of your peers in the SQL Server community—and who could possibly ask for more than that? However, to sweeten the pot, three grand-prize winners will receive:

  • a complimentary conference pass to SQL Server Magazine Connections (including airfare), which will be held in Las Vegas November 6-9
  • a one-year VIP subscription to SQL Server Magazine
  • a writeup about your solution, which will appear in the January 2007 issue of SQL Server Magazine
  • and most important, a really cool trophy!

Three runners up will receive:

  • discounted registration for SQL Server Connections in Las Vegas this fall
  • a one-year print subscription to SQL Server Magazine
  • and a really cool T-shirt

You’ll find more information about the contest, including a complete list of all the rules and entry requirements at http://www.sqlmag.com/awards . But you’d better hurry! Enter today—and good luck!


Sponsor: Double-Take Software
Protect Your MS-SQL Server: What Every IT Manager Should Know

Learn what every IT Manager should know about protecting SQL Server, and identify the costs, risks, and advantages of each. Make sure that your disaster recovery and high availability solutions match your business needs.


2. SQL Server Watch

Regional Events Cover Four Key Interoperability Topics
Are you a Windows fan, a UNIX diehard or a Linux lover? Brought to you by people who understand the world you live in never fits the textbook IT infrastructure, TechX World is an OS-agnostic event that will give you insider tips for coping with your “Windows Plus” world. TechX World is a four-track, one-day event featuring information about OS interoperability, data interoperability, directory and security integration, and virtualization. Technical experts Michael Otey, Gil Kirkpatrick, Dustin Puryear and Randy Dyess will present interoperability tips to help make disparate systems work well together.

Between October 24 and November 2, the regional event series will visit four cities: Washington, DC; Chicago; Dallas, Texas; and San Francisco. Attendees who register before August 31 will receive early-bird pricing and a one-year subscription to Windows IT Pro magazine. At $129 per person for four tracks and a full day of learning, it’s worth sending the entire team to make sure you cover all the sessions. For complete agenda and speaker details, go to http://www.techxworld.com.

Product Watch
by Blake Eno, products@sqlmag.com

Get a Fully Managed .NET Database for Application Development
Vista Software announced the Community Technology Preview (CTP) of VistaDB 3.0, a fully managed SQL database engine for building WinForms and ASP.NET applications based on the Microsoft .NET Framework. The product can run natively on desktops, mobile devices, and Web servers. VistaDB 3.0 provides 4TB of storage per database and is fully CLR-compliant. StoredCode support lets you store .NET functions and procedures written in managed C# or Visual Basic .NET directly into a VistaDB database. For a complete list of all VistaDB 3.0 features and the official product release schedule, visit Vista Software on the Web or contact them at 858-922-2268 or 800-653-2949.

Manage .NET Application Lifecycle
Lattix announced Lattix LDM for .NET, Lightweight Dependency Models that help you visualize and maintain an architecture during .NET application development. By using the LDM approach, you can analyze your architecture in detail, edit the structure to create test scenarios, and specify design rules to formalize and communicate that architecture to the rest of your organization. Lattix LDM for .NET provides a high-level view of your architecture and lets you drill down to a subsystem and examine code associated with its dependencies. The product can also remove unwanted dependencies and rename subsystems to reflect the intended architecture. Lattix LDM for .NET starts at $495 for the Professional Edition. For more information, visit Lattix on the Web or contact them at 978-474-5022.


3. Hot Articles

Q&A: Easy Reading: See Backup Date and Time
by Microsoft’s SQL Server Development Team, questions@sqlmag.com

 

Q: I want to be able to see when a backup file was created. Does SQL Server provide a way to add the current date and time to my backup file filenames?


A: Read the answer to this question today.

 

Feature: Solving Merge Replication Performance Problems
Pointing LAN and mobile users to different instances of an application database on different servers helped one organization improve performance for LAN users without major application or database changes. In his August article “Solving Merge Replication Performance Problems,” Gary Zaika tells you how. Read this article today and post your comments.

In a Nutshell: Survey of Opinions About Semi-Structured Data
Christian Kleinerman, the Microsoft Program Manager for XML and several other SQL Server features. Kleinerman has been soliciting opinions about future directions for SQL Server—in particular, defining and querying semi-structured data. In this week’s blog, Kevin Kline lets you know how you can send Microsoft your opinion on the subject. Read about the choices Microsoft is considering and let Kevin know what you think today.

Hot Threads:
SQL Server General Discussion: Backing Up Individual Tables in SQL Server 2000
SQL Server 2005 General Discussion: Creating and Connecting to a New Server


4. Events and Resources

Gear up for TechX World Roadshow
Hear first-hand from leading interoperability experts, vendors, and peers at this exclusive one-day event. You'll learn about managing OS interoperability, directory migration, data interoperability, and much more. This event provides in-depth information on how Windows and other systems cooperate with each other.

Does your company have $500,000 to spend on one email discovery request? Join us for this free Web seminar to learn how you can implement an email archiving solution to optimize email management and proactively take control of e-discovery—and save the IT search party for when you really need it! Live Event: Tuesday, September 12

You know you need to manage your email data; how do you do it? What steps are you taking? What additional measures should you enact? What shouldn't you do? Learn the answers to these questions and get control of your vital messaging data. Download the free eBook today!

Dramatically simplify Exchange troubleshooting with an in-depth look at built-in troubleshooting tools and third-party applications. Join us as we analyze a typical troubleshooting process, address the problems with using standard tools, and learn how automated troubleshooting can solve these challenges. Live Event: Thursday, September 14

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


5. Featured White Paper

Help your small or midsized business protect one of its most valuable assets—business information. Easily store, manage, protect, and share information by using hardware designed with the needs of your business in mind. Manage IT without the large staff and extensive training—learn how today!


Hot Spot: Polyserve
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! Download your free copy now.


6. Announcements

Invitation for VIP Access
For only $29.95 per month, you'll get instant VIP online access to ALL articles published in Windows IT Pro, SQL Server Magazine, and the Exchange and Outlook Administrator, Windows Scripting Solutions, and Windows IT Security newsletters—that's more than 26,000 articles at your fingertips. Sign up now.

Save $40 on SQL Server Magazine
Subscribe to SQL Server Magazine today and SAVE up to $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,300 helpful SQL Server articles. This is a limited-time offer, so order now.


 

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.