Product Watch
by Blake Eno, products@sqlmag.com
Red Gate Gives You Easy Access to All its Tools
Red Gate Software launched a new service, SQL Professional Toolbelt, which gives you access to all of Red Gate's tools through an annual subscription. You get access to current and new Red Gate tools. An annual subscription, with 12 months of support and upgrades, is $1995. Subscription renewal is $995 per year. You can download a free trial of SQL Professional Toolbelt at Red Gate's Web site.
3. Hot Articles
Q&A: Choosing SELECT Statements
by Brian Moran, brian@solidqualitylearning.com
Q. What's the difference between the following SELECT statements?
SELECT * FROM tableA, tableB
WHERE tableA.a1 = tableB.b1
and
SELECT * FROM tableA JOIN tableB
ON tableA.a1 = tableB.b1
Someone told me the first statement isn't ANSI standard, but a lot of my existing code uses that syntax. Do I need to change the non-ANSI standard SELECT statements? Does one format perform better than the other?
Read the answer to this question today at http://www.sqlmag.com/Article/ArticleID/44719/sql_server_44719.html.
Feature: SQL Server Pros Keep On Innovating
The winners of this year's SQL Server Magazine Innovators contest epitomize ingenuity, developing fresh solutions to business problems ranging from change management to scheduling overtime. Read this article today and post your comments at http://www.sqlmag.com/Articles/ArticleID/94156/94156.html.
Puzzled by T-SQL: Partial Aggregate
Itzik Ben-Gan gives you the details about an interesting way that the SQL Server 2005 query optimizer optimizes aggregates. Read this blog entry and post your comments today at: http://www.sqlmag.com/article/articleid/94760/sql_server_blog_94760.html.
In a Nutshell: Erland Sommarskog's Dynamic Search Conditions Article
Kevin Kline highlights the updates to this valuable SQL Server resource. Read the blog entry and post your comments today at http://www.sqlmag.com/article/articleid/94731/sql_server_blog_94731.html.
Hot Threads:
4. Events and Resources
Are you an Oracle professional who has cross-platform responsibilities, or do you need to transfer your skill set to SQL Server? If so, register for free to attend the Cross Platform Data online event January 30 and 31 and February 1, 2007. In a seminar featuring SQL Server and Oracle experts Andrew Sisson from Scalability Experts and Douglas McDowell from Solid Quality Learning, you'll learn key concepts about SQL Server 2005, including how to deploy SQL Server's BI capabilities on Oracle, proof points demonstrating that SQL Server is enterprise-ready, and how to successfully deploy Oracle on the Windows platform.
Find the buried treasure by uncovering the secrets to Web filtering. Complete this quiz correctly and you could be a winner! Find the buried treasure by uncovering the secrets to Web filtering. Complete this quiz correctly and you could be a winner!
When your systems go down, your users’ productivity grinds to a halt. User downtime is one of the fastest growing concerns among businesses. This free Web seminar teaches you how to keep your users continuously connected and your business up and running. View the On-Demand Web Seminar now!
Integrate fax services with business applications for major increases in ROI. Find out how fax technology can benefit your bottom line and improve business processes. Download the free ebook today!
See the complete Windows IT Pro Network guide to Web and live events.
5. Featured White Paper
Disaster recovery isn’t just a theory for most businesses—it’s a harsh business reality. Improve your own disaster recovery efforts today and learn from real life disaster survivors. Make sure that your plan is ready before a disaster strikes—download this free whitepaper today!
Hot Spot: Neverfail
HA Solutions for Windows, SQL, and Exchange Servers
When disaster strikes your servers, you need answers, whether the servers are dedicated to Windows, SQL, or Exchange. Make sure that if an emergency occurs, you’re prepared. Get the full eBook and get started on your recovery plan today!
6. Announcements
Special Invitation for VIP Access
Become a VIP subscriber and get continuous, inside access to ALL the content published in Windows IT Pro magazine, SQL Server Magazine, Exchange & Outlook Pro VIP, Scripting Pro VIP, and Security Pro VIP. Subscribe now and SAVE $100: https://store.pentontech.com/index.cfm?s=1&promocode=eu2771uv.
Ring in the New Year with SQL Server Magazine
Don't miss SQL Server Magazine in 2007! As a subscriber, you’ll have full access to must-have coverage relating to high availability, SQL Server and Microsoft Office integration, business intelligence, clustering, Reporting Services and much more. Order now and get 58% off the cover price: https://store.pentontech.com/index.cfm?s=1&promocode=eu2171us.
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.
End of Article
Prev. page
1
[2]
next page -->
