Subscribe to SQL Server Magazine:
http://lists.sqlmag.com/t?ctl=8BF5:7B3DB
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
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.
Blow Auditors Away with SQL Compliance Manager!
http://lists.sqlmag.com/t?ctl=8BF8:7B3DB
FREE SQL Server 2000 Training CD!
http://lists.sqlmag.com/t?ctl=8BF7:7B3DB
ALERT: Hackers New Trick: Search Engine Hacking/Web App Worms
http://lists.sqlmag.com/t?ctl=8BED:7B3DB
Tableau Software
http://lists.sqlmag.com/t?ctl=8BFC:7B3DB
April 28, 2005
1. Perspectives
2. SQL Server 2005 Watch
3. News & Views
4. Events and Resources
5. Featured White Paper
6. Peer to Peer
7. Announcements
8. New & Improved
Do you need to ensure compliance to Sarbanes-Oxley, GLBA, HIPAA, Basel II, or other audit standards? Do you need to track who does what, when on your SQL Servers? Then you need Idera SQL Compliance Manager--auditing and continuous compliance for SQL Server. Designed in partnership with major auditing firms and SQL Server DBAs at Fortune 500 companies, Idera's SQL Compliance Manager provides low overhead data collection, a comprehensive repository of audit data, a central management console, pre-defined compliance reports and powerful forensic analyses. What's more, it deploys quickly and even audits itself.
To find out more about SQL Server auditing and Idera's SQL Compliance Manager, download the white paper "The 7 Steps to Successful SQL Server Auditing" at
http://lists.sqlmag.com/t?ctl=8BF8:7B3DB
1. Perspectives
To GoLive!, Or Not to GoLive!
by Brian Moran, [email protected]
Last week, in "Beta Software Goes Live1" ( http://lists.sqlmag.com/t?ctl=8BEB:7B3DB ) I wrote about Microsoft's new GoLive! license, which lets users deploy the SQL Server 2005 Express Beta in a live production environment. I wondered if Microsoft might be exposing itself to some potential customer wrath and asked what you thought. I received an insightful reply from my colleague Douglas McDowell, director of business intelligence operations for Solid Quality Learning, who writes a BI-focused commentary in SQL Server Magazine UPDATE--Special Edition. Here's what he had to say:
"I think it's pretty stinkin' smart.
So my dear readers, now what do you think? Whether 'tis nobler in the mind to suffer the slings and arrows of boring old MSDE or take arms against a sea of troubles and trick your boss into rolling out beta software and the sexy new features in SQL Server 2005 Express? To GoLive! or not to Golive!, that is the question.
FREE SQL Server 2000 Training CD!
See why AppDev was voted THE BEST by readers of SQL Server Magazine...get a FREE SQL Server 2000 Training CD-ROM--a $95 value! Click the link below for your free SQL Server training CD.
http://lists.sqlmag.com/t?ctl=8BF7:7B3DB
2. SQL Server 2005 Watch
Seeing the CLR's Potential
by Matt Nunn, [email protected]
Combating a mixed reception, the SQL Server Common Language Runtime (CLR) is poised to change the way we work with databases. Data is at the core of most modern computer systems and SQL Server 2005 is set to blur the traditional boundaries of the n-tier model. A key driver that's changing the way we think about tiers in computer architecture is the inclusion of the CLR in SQL Server 2005. The SQL Server CLR is one of the most talked about features of SQL Server 2005, and it draws strong opinions from all camps--from those who want to turn it off forever to those who want to use it for everything. People's reactions to the integration of the CLR into SQL Server 2005 are interesting. One member of the SQL Server development team was giving a presentation about CLR integration when a member of the audience stood up and called out, "Is T-SQL dead?" This question prompted us to build an entire session called "No...T-SQL Isn't Dead!" In contrast, I had a conversation with an ASP programmer who had just found out about SQL Server CLR integration and immediately decided that this would not be a great place for him to store all of the .NET assemblies for his Web site. In his May Preparing for SQL Server 2005 column "Seeing the CLR's Potential," Matt Nunn talks about how the SQL Server CLR can provide security, reliability, and performance benefits that extended stored procedures can't. Read this article today at
http://lists.sqlmag.com/t?ctl=8BEA:7B3DB
Sponsor: Hackers New Trick: Search Engine Hacking/Web App Worms
Web application worms utilize a known exploit, apply worm methodology and then leverage the power of search engines to accelerate effectiveness. These attacks mark the beginning of a new generation of worms targeted at Web applications. Are your Web apps vulnerable? Easily test your applications for over 5,100 Web app vulnerabilities and attack methodologies with our complimentary WebInspect 15-day product trial, that delivers a comprehensive risk report!
http://lists.sqlmag.com/t?ctl=8BED:7B3DB
3. News & Views
Vote and Win in SQL Server Magazine's Readers' Choice Awards
It's time to cast your vote in SQL Server Magazine's 2nd annual Readers' Choice Awards! By voting for outstanding products, companies, and services, you'll have the opportunity to reward excellence and make your voice heard. The September 2005 issue of SQL Server Magazine will feature your favorite products and your choice of companies that provide the best products and services. Readers must log in to vote, so you must be a registered SQL Server Magazine Website user. Logging in to the site and completing the form is really easy this year. You can even return and complete the survey at your leisure so that you don't have to worry about completing it all in one sitting. After voting closes, we'll draw from participants winners for 2 iPod Shuffles (512MB versions) and 10 SQL Server Magazine t-shirts. Voting ends May 15 so cast your vote today!
http://lists.sqlmag.com/t?ctl=8BF1:7B3DB
Results of Previous Instant Poll: Specialization
"What area of SQL Server specialization do you think is most important?" Here are the results from the 110 votes:
New Instant Poll: Going Live?
"Will you take advantage of Microsoft's new GoLive! license and use SQL Server 2005 Express beta software in your production systems?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=8C00:7B3DB ) and submit your vote for
4. Events and Resources
Get a Quick Start In Mapping Your Oracle Database-Management Skills
Sign up now for this free, on-demand Web seminar. Learn about the similarities and differences between Oracle and SQL Server and get a preview of real-world tips and techniques for managing these associated technologies. Register now!
http://lists.sqlmag.com/t?ctl=8BDF:7B3DB
Get Ready for SQL Server 2005 Roadshow in a City Near You
Get the facts about migrating to SQL Server 2005. SQL Server experts will present real-world information about administration, development, and business intelligence to help you implement a best-practices migration to SQL Server 2005 and improve your database-computing environment. Attend and receive a 1-year membership to PASS and a 1-year subscription to SQL Server Magazine. Register now!
http://lists.sqlmag.com/t?ctl=8BEC:7B3DB
Ensure SQL Server High Availability
In this free Web seminar, discover how to maintain business continuity of your IT systems during routine maintenance and unplanned disasters. Learn critical factors for establishing a secure and highly available environment for SQL Server including overcoming the technology barriers that affect SQL Server high availability and Microsoft's out-of-the-box high-availability technologies such as clustering, log shipping, and replication. Register now!
http://lists.sqlmag.com/t?ctl=8BE1:7B3DB
See the complete Windows IT Pro Network guide to Web and live events.
http://lists.sqlmag.com/t?ctl=8BFB:7B3DB
5. Featured White Paper
Get Rapid and Reliable Data and System Recovery
Even under the best circumstances, performing a bare-metal recovery from tape is tedious and unreliable. In this free white paper, learn how you can achieve unprecedented speed and reliability in recovering systems and data.
http://lists.sqlmag.com/t?ctl=8BDE:7B3DB
6. Peer to Peer
by Brian Moran, [email protected]
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?
http://lists.sqlmag.com/t?ctl=8BE9:7B3DB
In "Native Partitioned Tables and Indexes," Itzik Ben-Gan began his coverage of native partitioning in SQL Server 2005 and the related T-SQL code. He's covered the motivation for partitioning, SQL Server 2005's enhancements, and how to create partitioned tables by creating a partition function, partition scheme, and a partitioned table or index. This month, in his T-SQL 2005 column "Partitioned Indexes and Querying Metadata," Itzik Ben-Gan continues his coverage with partitioned index considerations and querying metadata information. Read this article today at
http://lists.sqlmag.com/t?ctl=8BE8:7B3DB
As a SQL Server MVP, Kevin is exposed to a lot of talented people, many of whom have personal blogs, Web pages, or both. In this week's blog "One of My Favorite SQL Server Personal Sites," Kevin Kline praises Narayana Vyas Kondreddi's Web site, http://lists.sqlmag.com/t?ctl=8BFF:7B3DB . Kondreddi covers diverse and useful topics for the SQL Server professional. Among Kevin's favorites are Kondreddi's articles at http://lists.sqlmag.com/t?ctl=8BF0:7B3DB and the code library at http://lists.sqlmag.com/t?ctl=8BF9:7B3DB . These sections and other resources, such as a plethora of product reviews, promise to keep you busy for some time. The neat thing about these resources is that they'll either save you time on the job or extend your capabilities, and sometimes both! Let Kevin know what you think of Kondreddi's site and tell him about some of your favorite SQL Server sites today at
http://lists.sqlmag.com/t?ctl=8BEE:7B3DB
Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.
http://lists.sqlmag.com/t?ctl=8BF3:7B3DB
Development: T-SQL Mass Inserts and Error Trapping
http://lists.sqlmag.com/t?ctl=8BE2:7B3DB
Performance: Table Fragmentation
http://lists.sqlmag.com/t?ctl=8BE7:7B3DB
Administration: SQL Cluster Problem
http://lists.sqlmag.com/t?ctl=8BE5:7B3DB
T-SQL: Cursor Performance
http://lists.sqlmag.com/t?ctl=8BE4:7B3DB
DTS: Dynamic SQL in DTS Transaction
http://lists.sqlmag.com/t?ctl=8BE6:7B3DB
T-SQL: OSQL and Leading Spaces
http://lists.sqlmag.com/t?ctl=8BE3:7B3DB
Hot Spot
http://lists.sqlmag.com/t?ctl=8BFC:7B3DB
7. Announcements
http://lists.sqlmag.com/t?ctl=8BF2:7B3DB
With SQL Server 2005 right around the corner, remember that SQL Server Magazine is on target to deliver comprehensive coverage of all betas of the new product and the final release. If you aren't already a subscriber, now is the time to subscribe. Act now and save 47% off the cover price, plus get the new Reporting Services poster:
http://lists.sqlmag.com/t?ctl=8BF6:7B3DB
8. New & Improved
by Dawn Cyr, [email protected]
Have you used a product that saved you time or made your job easier? Tell us about it! If we print your story in the Hands On department, we'll send you a SQL Server Magazine t-shirt. Send your product success story to [email protected].
AdventNet announced ManageEngine Applications Manager 6.0, enterprise-ready, Web-based application-management software that facilitates monitoring of databases, servers, services, Web sites, and custom applications. The product's SQL Server Monitoring feature manages SQL Server 2000 servers and ensures optimal access to all the metrics that SQL Server exposes for the database engine and each database instance. The product monitors multiple SQL Server components, including memory utilization, buffer manager statistics, connection statistics, cache details, lock details, SQL statistics, latch details, and access method details. The software's monitoring capabilities include alert generation based on thresholds you set; performance graphing and reporting; connection tracking; and identification of locking activity by user. ManageEngine Applications Manager is priced at $995, and a free 30-day trial download is available. For more information, contact AdventNet at 888-720-9500, 925-924-9500, or [email protected].
http://lists.sqlmag.com/t?ctl=8BE0:7B3DB
BDS announced SQL Digger 2.0, a free SQL Server search engine that lets you search all your stored procedures, views, UDFs, and triggers for a word, multiple words, or a sentence. The tool finds the objects in which you used the search strings and highlights them in a preview screen to show you where the words are located in the T-SQL code. The tool also lets you drag the contents of any found object to any receiving container (e.g., Query Analyzer, Word). And the latest release comes with an added print functionality with Multi Database Search. Other new features of the tool include the ability to limit the search to a specified object type and print the T-SQL code from the found objects. The tool uses Windows authentication and requires the .NET Framework 1.1. For more information or to download the free tool, visit
http://lists.sqlmag.com/t?ctl=8BFE:7B3DB
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.
http://www.sqlmag.com/rd.cfm?code=00ep214xeb
Manage Your Account You are subscribed as #EmailAddr#. To unsubscribe from this email newsletter, click here /#Mailing:UnsubEmail
To make other changes to your email account such as changing your email address, updating your profile, and subscribing or unsubscribing to any of our email newsletters, simply log on to our Email Preference Center.
http://email.winnetmag.com/winnetmag/winnetmag_prefctr.asp
View the SQL Server Magazine Privacy Policy.
http://www.winnetmag.com/aboutus/index.cfm?action=privacy
SQL Server Magazine is a division of Penton Media, Inc., 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department
Copyright 2005, Penton Media