Subscribe to SQL Server Magazine | See More Products / Software Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Product Watch
by Blake Eno, products@sqlmag.com

Leverage the Power of Microsoft BI
ICS announced that its business intelligence (BI) solution, RSinteract, extends its reach to support SQL Server Analysis cubes and the SQL Server 2005 Unified Dimensional Model (UDM). RSinteract builds on SQL Server Reporting Services (SSRS) to put information in the hands of non-technical users. As a server-based Web application, RSinteract requires no client software or plug-ins. RSinteract lets anyone with a standard Web browser build new SSRS reports or customize existing reports on any relational or OLAP data source defined in SQL Server 2005/2000. For more information, contact ICS at info@rsinteract.com.
http://www.rsinteract.com

Quest Releases .NET Application Management Solutions
Quest Software announced two .NET application management solutions-- which are both powered by AVIcode's .NET management technology--to help discover, diagnose, and resolve .NET application performance and availability problems. Quest Management Pack for .NET works with Microsoft Operations Manager (MOM) 2005, and Foglight for .NET is part of Quest's Application Advantage strategy for managing complex application environments and expands to monitor and manage .NET applications. Both of these solutions proactively monitor your applications and inform you of looming performance and availability problems. For more information, contact Quest Software at 949-754-8000.
http://www.quest.com

3. Hot Articles

Tip: SQL Server Profiler: 2005 vs. 2000
by Brian Moran, brian@solidqualitylearning.com

How you work with Profiler is different in SQL Server 2005 and 2000. Learn about this difference--and how you can use it to your advantage--by reading this tip at
http://www.sqlmag.com/Articles/ArticleID/50260/50260.html

T-SQL 2005: Exploring Changes Made to SQL Server 2005’s UDF Options
A new and possibly overlooked user-defined function (UDF) option, RETURNS NULL ON NULL INPUT, helps speed up the processing of NULL input and the new list of non-deterministic system functions allowed in a UDF. In his August T-SQL 2005 column "Exploring Changes Made to SQL Server 2005’s UDF Options," Itzik Ben-Gan shows you how this option works. Read this article today and post your comments at
http://www.sqlmag.com/Article/ArticleID/53886/sql_server_53886.html

Puzzled By T-SQL: Cross Country
Often when I meet collogues and friends in IT events we hang out in the bar and share stories over beer about our travel ordeals. I’m inviting you to such a get-together, only this time it’s virtual (although the beer I’m having at the moment is real). I’ll share a story about the unusual way I got to one of our customers. If you wish, share stories from your experience…
http://www.sqlmag.com/Article/ArticleID/93211/93211.html

In a Nutshell: CodePlex Coolness
Kevin Kline gives you the scoop on CodePlex, a Microsoft community development site that provides useful extensions to SQL Server (and other Microsoft products) and example source code for people looking to write their own stored-procedure code. Everything in CodePlex is put together by volunteers, for public consumption. Learn about the site and check out the Analysis Services Stored Procedure project today at
http://www.sqlmag.com/Article/ArticleID/93287/93287.html

Hot Threads:
SQL Server 2005 Development: Running a 2005 Stored Procedure on a 2000 Database
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=87&threadid=48922&enterthread=y
Security: Login Errors
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=63&threadid=48844&enterthread=y

4. Events and Resources

Cross-Platform Data Roadshow
Oracle professionals will cover key concepts about Oracle and SQL Server in enterprise database computing. This event provides invaluable information, including benefits of 64-bit computing on the Windows platform, SQL Server BI for Oracle, high-availability proof points for SQL and Oracle, and much more.
http://www.windowsitpro.com/roadshows/sqloracle/?code=0823emailannc

Microsoft Tech-Ed: Developers
Four days will take you months ahead of the game! Get deep-dive technical training, information, and community resources that focus on building software solutions with Microsoft development tools. Visit the Website for more information, and register before the Early Bird deadline of 29 September 2006 to save 300 euros. 7-10 November 2006, Barcelona, Spain.
http://www.microsoft.com/europe/teched-developers

Consolidating SQL Server Deployments
Does your SQL Server deployment suffer from low utilization rates, suboptimal availability, and management challenges? Learn how to overcome these difficulties by deploying a database utility that can not only help lower your cost of ownership by 70% but can react to changes within 30 seconds. Live Web Seminar: Tuesday, August 22.
http://www.sqlmag.com/go/seminars/polyserve/consolidatesql/?partnerref=0821emailannc

Test your SQL Server 2005 backup and recovery skills--you could win a $100 American Express Gift Card! Take the quiz now!
http://popquiz.sqlmag.com/quest

See the complete Windows IT Pro Network guide to Web and live events.
http://www.winnetmag.com/events

5. Featured White Paper

Integrating Fax Servers in MFP Environments
Did you know that wasteful processes can drive the cost of document management and output to as high as 10%-15% of your company's annual revenues? Download this free white paper today and find out how you can use fax solutions to achieve cost control, security, compliance, increased workflow, and more.
http://www.windowsitpro.com/go/whitepapers/Faxback/faxing?code=0821featwp

Hot Spot: Neverfail
SQL Server Guide to Clustering Alternatives
Want the convenience of a server cluster without the expense? Learn about server cluster alternatives that provide high availability, preventative maintenance, and fallover capabilities at pricing that fits your budget.
http://www.sqlmag.com/go//whitepaper/neverfail/sqlclustering/?code=SQLHot0824

6. Announcements

SQL Server Performance Tips, Articles, and Forums
Get hundreds of free tips and articles on SQL Server performance tuning and clustering. And get quick and accurate answers to your performance- and cluster-related questions in our forum. All from the SQL Server performance and clustering authority: SQL-Server-Performance.com.
http://www.sql-server-performance.com

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:
https://store.pentontech.com/index.cfm?s=9&promocode=eu2168us

7. Web Community

Hot Threads
http://sqlforums.windowsitpro.com/web/forum/default.aspx?forumid=10

Reader-to-Reader
http://www.sqlmag.com/Departments/DepartmentID/731/Reader%20to%20Reader.html

New Instant Poll
http://www.sqlmag.com/

Blogs
http://www.sqlmag.com/blog

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.

End of Article

Prev. page     1 [2]     next page -->



Post Your Comments Here

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now

 
 

ADS BY GOOGLE