Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
SQL Server Magazine UPDATE, July 15, 2004--Profiler for Developers
Brian Moran encourages developers to integrate SQL Server Profiler into their unit-testing strategies, learn what pageiolatch values in sysprocesses mean, get the results of our latest instant poll, and more!
ITPro Today Contributors
July 14, 2004
12 Min Read
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.
This Issue Sponsored By
Introducing the VIP Site--Now with SQL Server Content
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BJEb0Ad
Does IT Matter?
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BJwQ0AC/p>
July 15, 2004—In this issue:
Sponsor: Introducing the VIP Site--Now with SQL Server Content The Windows & .NET Magazine VIP Web site/Super CD subscribers are used to getting online access to all of our publications, plus a print subscription to Windows & .NET Magazine and exclusive access to our banner-free VIP Web site. But now we've added even more content from the archives of SQL Server Magazine! You won't find a more complete and comprehensive resource anywhere--check it out! http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BJEb0Ad
1. SQL Server Perspectives
Microsoft has released an article that tells you how to move a SQL Server 2000 Reporting Services database from a computer that's running Reporting Services to another computer. You might want to move a Reporting Services database from one computer to another for several reasons. For example, if you use Reporting Services to create reports on a computer that's used in an application's development environment, you might want to move those reports to a computer that's used in the production environment. To do so, you must move the Reporting Services database. You don't have to deploy the reports again if you move the Reporting Services database from one computer to another. You also don't have to reconfigure Reporting Services on the destination computer. To learn more, read the Microsoft article "How to move a Reporting Services database from a computer that is running Reporting Services to another computer" at http://support.microsoft.com/?kbid=842425
The SQL Server Magazine Master CD offers portable, high-speed access to a library of searchable article archives, endless code listings, timesaving tips and tricks, and valuable expertise published in SQL Server Magazine and T-SQL Solutions. Let this helpful resource save you some time anywhere you are. Subscribe today and get 25% off!
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BJZB0AS
This year's competition, sponsored by Idera, is calling for a cutting-edge SQL Server solution that solves a real-world problem and/or improves performance. One grand-prize winner will win a free trip to the 2004 SQL Server Magazine Connections Conference in Las Vegas, Nevada, and get a special trophy. Fill out an entry form today to get the recognition you deserve!
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC02hN0AO4. Resources
T-SQL programmers often use user-defined functions (UDFs) to encapsulate algorithm implementations. However, several aspects of UDFs constrain programmers' capabilities. In his July T-SQL Black Belt column, "More UDF Back Doors," Itzik Ben-Gan continues his coverage of UDFs by looking an aspect of UDFs--related to their atomicity-that limits programmers' capabilities and a couple of back doors that circumvent this limitation. He also discusses a supported UDF feature that most people don't know about: modifying data through inline UDFs. Read this article today at
http://www.sqlmag.com/articles/index.cfm?articleid=42747
Craig HB uses SQL Server 2000 Reporting Services to develop reports on his PC and deploy those reports to a server. His PC has only Reporting Services' client components, whereas the server he's deploying to has the client and server components installed. When Craig HB deploys his reports to the server, he receives the error message "The underlying connection was closed: Could not establish trust relationship with remote server." But that's not Craig HB's only problem. He created an ASP.NET application on his PC that runs reports on the server using Reporting Services' Web Service. When Craig HB tries to render a report, he receives the error message "The request failed with HTTP status 404: Not Found." Offer your advice and see what other people have said on SQL Server Magazine's Reporting Services forum at
http://www.winnetmag.com/sqlserver/forums/messageview.cfm?catid=1741&threadid=123399
by Brian Moran, [email protected]A. Searching SQL Server Books Online (BOL) turns up five hits for latches, and none of the hits provides much detail. The most detailed entry says that "latches are very lightweight, short-term synchronization objects protecting actions that need not be locked for the life of a transaction. They are primarily used to protect a row when read for a connection." We're all familiar with SQL Server locks and how they can affect concurrency if they start to block other processes. What most people don't understand is that SPIDs can wait a long time for different types of latches. As you said, latch wait times show up for a SPID in master..sysprocesses, but they don't cause a SPID to appear as blocked in the output of sp_who or similar investigative tools. Let me be clear about the distinction between a latch that's blocked and a latch that's waiting. A blocked connection generally means that another connection is holding a lock that the first connection needs. When processes wait on each other for locks to be released, it's called blocking. A process that's waiting doesn't involve a lock. I'll explain the pageiolatch_sh waittype so you can see what I mean...
Read the full answer to this question at
http://www.winnetmag.com/article/articleid/42902/42902.html5. New and Improved
Red Gate Software announced SQL Packager, software that packages SQL Server databases as executables so that you can deploy the new or updated databases locally or at remote sites. The software, which relies on engines in Red Gate's SQL Compare and SQL Data Compare products, guides you through four basic packaging steps: deciding on the schema and data you want to package, scripting schema and data to preserve dependencies, packaging the database as an executable or .NET project, and creating a utility that lets administrators or customers at the new location install the database. Video demos, a PowerPoint presentation, a walkthrough, and a fully supported, 14-day trial version of SQL Packager are available for free on the Red Gate Web site. Pricing for SQL Packager starts at $690 for a single-user license, and discounts are available for multi-user versions. For more information, contact Red Gate Software at 866-733-4283, 44-870-160-0037, or [email protected].
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BEZP0Ab
Enterprise Blocks announced Enterprise Blocks 2.0, an integrated set of ASP.NET Web controls, Web services, and Windows services that serve as the building blocks for developing analytic applications. The latest release features a new service provider for accessing SQL Server tables directly from Enterprise Blocks clients. The service provider uses the .NET managed provider classes in the System.Data.SQLClient namespace to communicate with SQL Server and support cross-tab and table analysis directly against tables and views in SQL Server. The software uses the field relationships defined in the database to support cross-tab analysis, and you can use SQL Server extended properties to set up additional field relationships; specify field formatting, aggregation functions, and visibility; and set up user-friendly names for fields, tables, and views. This capability lets you develop OLAP-style applications directly against SQL Server data or as a complement to using Analysis Services. Enterprise Blocks 2.0 costs $495. For more information, contact Enterprise Blocks at [email protected].
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BDsc0AK
Addison-Wesley Professional announced "A First Look at SQL Server 2005 for Developers," a book by Bob Beauchemin, Niels Berglund, and Dan Sullivan that shows developers how to take advantage of innovations in SQL Server 2005. The book includes practical explanations of SQL Server 2005's new data model, built-in .NET hosting, improved programmability, and SQL-99 compliance. Chapter topics include writing procedures, functions, and triggers in .NET languages; using T-SQL enhancements; the XML data type and XML query languages; SQL Server 2005 as a Web services platform; client-side coding; and using SQL Server 2005's built-in application server capabilities. "A First Look at SQL Server 2005 for Developers" costs $40.49. For more information or to purchase the book, contact Addison-Wesley Professional at 617-848-6000.
http://lists.sqlmag.com/cgi-bin3/DM/y/eA0FgQMn0BVC0BJwV0AHSQL 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.
http://www.sqlmag.com/sub.cfm?code=ssei211x1yContact Us:
Manage Your Account
You are subscribed as #EmailAddr#.To unsubscribe from this email newsletter, send an email message to mailto:#Mailing:UnsubEmail#.
http://www.winnetmag.com/email
Copyright 2004, Penton Media, Inc.
Read more about:
ITPro TodayAbout the Author
You May Also Like
