THIS ISSUE SPONSORED BY
PolyServe Matrix Server Clustering Software
Introducing ProClarity's New Analytics Suite 5.3
(below NEWS AND VIEWS)
SPONSOR: HOW TO FIND/REMOVE OBSOLETE MACHINE ACCOUNTS
New Application Note: "Removing Obsolete Domain Machine Accounts" shows how to quickly/easily report on the age of your machine trust accounts and delete the oldest ones (>60 days). HOLIDAY GIFT! Clean up your machine accounts today for free using User Manager Pro from Lieberman & Associates. Install our demo, make one of the 10 evaluation machines the DC, and complete the clean up within 30 days. HOLIDAY SPECIAL: For every license of UMP or Service Account Manager you purchase, get an equal number of free licenses for Task Scheduler Pro or COM+ Manager. Ends 12/31/03
December 4, 2003—In this issue:
- 'Tis the Season to Think of Yukon
2. SQL SERVER NEWS AND VIEWS
- Hotfix Solves Linked Server Permissions Problem
- Help SQL Server Magazine Celebrate Its 5th Anniversary
- Results of Previous Instant Poll: .NET Application Development
- New Instant Poll: TechNet
- 2004 Dates Announced for SQL Server Magazine Connections
- Work with SQL Server?
- What's New in SQL Server Magazine: Set-Operation Alternatives
- Hot Thread: Yukon and .NET
- Tip: Timeout for Queries
5. HOT RELEASES (ADVERTISEMENTS)
- OmniReplicator Accelerates Data Integration
- Win $25,000 with Insider Training
- Access Past, Present, and Future Articles
- Ultimate Support Resource for Local User Groups
6. NEW AND IMPROVED
- Monitor and Detect Blocked SQL Statements
- Manage Heterogeneous Databases
7. CONTACT US
See this section for a list of ways to contact us.
(contributed by Brian Moran, news editor, email@example.com)
In Yukon, the next major release of SQL Server, Microsoft is introducing several new technologies that will change the types of skills that traditional DBAs need. Although Yukon's commercial release is still almost a year away, it's time to start thinking about Yukon and preparing for the changes if you haven't already done so.
Yukon's introduction of native support for the .NET Common Language Runtime (CLR) and richer XML integration will force hard-core DBAs to learn more about the development world than they've had to in the past. Ignoring these new technologies will relegate you to the DBA dinosaur heap within a few years. The advent of .NET integration in Yukon doesn't mean that the DBA's role is about to expire, but it does mean that the tasks a DBA must master to stay current are about to expand.
You can start educating yourself by visiting Microsoft's Yukon home page at http://www.microsoft.com/sql/yukon/productinfo/default.asp . The site provides many interesting technical resources, including Microsoft's list of top 30 Yukon features. The page also includes several valuable technical articles, including:
- Overview of .NET Programming Features in SQL Server "Yukon" Beta 1
- Performance Optimizations for XML Data Type
- SQL Server "Yukon" Beta 1 Transact-SQL Enhancements
- XML Best Practices for SQL Server "Yukon"
- Introduction to SQL Server "Yukon" Relational Engine Security Features
- Reporting Services Beta Deployment Guide
A quick Internet search will reveal more Yukon information, including the following articles from SQL Server Magazine's special November Yukon coverage:
- "Exploring Yukon Territory"
- "Ready or Not, Here Comes the CLR"
- "What's New in Yukon T-SQL"
- "Top Yukon Features"
Articles and white papers give you useful information, but they don't let you get your hands dirty with the real thing. By now, you're probably wondering, "Where's the beef?" To start thinking about Yukon in a serious way, you want access to Yukon Beta 1.
Microsoft is managing Yukon's beta process in an interesting way. The company distributed more than 10,000 copies of Yukon Beta 1, considered a private beta, at the recent Professional Developers Conference (PDC) and Professional Association for SQL Server (PASS) meeting. Attendees at these conferences weren't under a nondisclosure agreement (NDA), so the beta kits that Microsoft handed out are distributable if you have colleagues or friends who attended one of those events. However, Microsoft hasn't made a version of Yukon Beta 1 publicly downloadable. You can sign up for the next Yukon beta at http://www.microsoft.com/sql/evaluation/betanominations.asp and expect a widely distributed public beta sometime next year. Given the number of copies distributed at PASS and PDC, you shouldn't have too much trouble getting your hands on the beta kit. In the meantime, you can explore SQL Server Magazine's Yukon beta forum at http://lists.sqlmag.com/cgi-bin3/DM/y/edq20FgQMn0BRZ0KQO0A3 for valuable information and ask questions of those currently evaluating the beta.
Don't worry. I'm not going to harp incessantly about Yukon over the coming months. After all, many of us will be focused on current SQL Server installations for at least the next year, and SQL Server 2000 is sure to have a wide user base for years to come. However, the major changes coming with Yukon will require you to start educating yourself sooner rather than later.
POLYSERVE MATRIX SERVER CLUSTERING SOFTWARE
Easily consolidate SQL Servers and storage. The first high availability, shared data clustering solution that helps you consolidate and centrally manage SQL Servers, eliminate data silos, and reduce TCO 50 percent. Do you have a number of non-HA, stand-alone SQL Servers on Windows 2000? Just install Matrix Server and achieve a fully HA environment with your existing servers, without any requirement to purchase additional "passive" servers. If you already have SQL Server pairs, consolidate the pairs, reducing costs 50 percent and re-deploying the extra "passive" servers to your application, file serving, or web serving tiers. Centrally manage and provide HA across all 3-tiers of your applications, for up to 16 clustered servers and their storage. FREE whitepaper and signup for upcoming demo:
2. SQL SERVER NEWS AND VIEWS
Microsoft has released a hotfix for a problem in which distributed queries using a linked server might incorrectly use the SQL Server startup account to connect to the linked server instead of using the configured linked server account. This problem might occur when both of the following conditions exist:
- SQL Server is running in fiber mode (i.e., the sp_configure stored procedure lightweight pooling option is set to 1).
- The distributed query is executed by a Windows NT login and the linked server security is configured to use the login's current security context option.
To read more about this problem and obtain the fix, see the Microsoft article "FIX: Distributed Queries May Incorrectly Use SQL Server Startup Account Permissions When SQL Server is Running in Fiber Mode" at http://support.microsoft.com/?kbid=830382.
Our 5th birthday's coming up, and we're inviting you to help us celebrate. Let us know which favorite, classic SQL Server tips from the magazine you still keep handy, or send in valuable, timesaving techniques that you've discovered on the job. We'll share the best design, administration, development, and OLAP tips and techniques with other readers in our March 2004 issue. Let us know what you've found useful! Submit your nominations and tips to firstname.lastname@example.org by December 15, 2003; be sure to include your name, email address, and daytime phone number.
The voting has closed in SQL Server Magazine's Instant Poll for the question, "What kinds of production applications are you creating through the .NET Framework?" Here are the results (+/- 1 percent) from the 418 votes:
- 45% Web or ASP.NET applications
- 17% Windows-based Visual Basic .NET applications
- 13% Windows-based C# applications
- 1% Windows-based C++ applications
- 24% I'm not using .NET for my production applications
The next Instant Poll question is "Do you subscribe to Microsoft TechNet?" Go to the SQL Server Magazine Web site and vote for 1) Yes, and I find it valuable, 2) Yes, but I don't find it valuable, 3) No, but I plan to, or 4) No, and I don't plan to.
SPONSOR: INTRODUCING PROCLARITY'S NEW ANALYTICS SUITE 5.3
You don't need more information. You need better insights into information you already have. Use ProClarity's new Analytics Suite 5.3 to rapidly turn information into understanding. Install-and-go today with the ProClarity Analytics Suite 5.3 and leverage our award-winning analytic products out of the box with the flexibility to customize at a later date, or use our analytic components and APIs to create a custom analytic application that meets your exact requirements.
(brought to you by SQL Server Magazine and its partners)
Save these dates on your calendar. Spring 2004 SQL Server Magazine Connections will be held April 18-21, 2004, at the Hyatt Regency Grand Cypress in Orlando, Florida. Early registrants will receive free access to concurrently running Microsoft ASP.NET Connections and Visual Studio Connections. For more information, call 203-268-3204 or 800-438-6720.
Subscribe to the SQL Server Magazine Master CD and get real-time, high-speed desktop access to all articles, code, tips, tricks, and expertise published in SQL Server Magazine and T-SQL Solutions. Search by keyword, subject, author, or issue. Let this helpful resource save you some time at work. Subscribe today!
ANSI SQL defines three operations—UNION, INTERSECT, and EXCEPT—that you can apply to two sets. These operations let you combine rows from different sets, locate which rows exist in both input sets, or find which rows exist in one set but not the other. However, T-SQL supports only the UNION operation. Fortunately, you have alternatives in T-SQL that you can use to provide the functionality of the missing operations. In his December T-SQL Black Belt column, "Set-Operation Alternatives," Itzik Ben-Gan shows you how to mimic INTERSECT and EXCEPT in T-SQL.
Mpp wonders if you need a thorough understanding of Microsoft .NET to fully take advantage of SQL Server's upcoming Yukon release. See what other people have said and offer your advice on SQL Server Magazine's Yukon forum at
(contributed by Brian Moran, email@example.com)
Q. I want to run a query from Enterprise Manager, but it times out at 30 seconds, generating the following message:
SQL Server Enterprise Manager \[Microsoft\]\[ODBC SQL Server Driver\] Timeout expired
I've tried to change the Query timeout option from the Tools, Options, Advanced dialog box, but the option doesn't have any effect. How can I get my query running?
A. I assume you're trying to run a query that you created through the Graphical Query Designer, available from the Query option on the Open Table menu within Enterprise Manager. Unfortunately, the timeout is hard-coded to 30 seconds for queries running from that interface, and you can't override the default timeout value. You can still use the Graphical Query Designer to build the query if you aren't comfortable with T-SQL, then simply copy the query into Query Analyzer to run it. You can control the query timeout setting in Query Analyzer's Options menu.
5. HOT RELEASES (ADVERTISEMENTS)
Lakeview Technology's OmniReplicator provides real-time changed-data replication of your cross-platform information and automates data sharing across Oracle, DB2, Informix, Sybase and SQL Server. View the NEW OmniReplicator Demo by visiting our Web site.
AFFORDABLE,QUALITY, E-LEARNING! LIVE Full MCDBA $2995, Skills
Tracks start at $995! 20% off Dec. classes. 3/2 special ends 12-15-03. Access to all materials for 90 days after training ends! Sign up for our promo or view our demo:
The SQL Server Magazine Web site is an endless library of helpful SQL Server content. Take advantage of the search box and navigation toolbar to access articles, tips, tricks, and expertise. Get answers today!
Visit SSWUG.org and get an immediacy of SQL Server support and information. You can access the latest news, tips, security bulletins and get immediate responses to issues with SQL Server, Oracle and/or XML technologies. Click here:
6. NEW AND IMPROVED
(contributed by Dawn Cyr, firstname.lastname@example.org)
Sql Power Tools announced the Stealth Blocked Process Monitor, software that lets DBAs and developers accurately monitor and detect blocked SQL statements. When a block occurs, the product shows the associated SQL text, plan description, database locks involved in the block, resource utilization, and the length of time the SQL statement was blocked. The software also maintains a history of blocks and pinpoints and ranks SQL statements that are most frequently involved in blocking so that you can solve your most common blocking problems. For more information and pricing, contact Sql Power Tools at email@example.com.
Quest Software announced Quest Central for Databases 4.0, software that lets you automate database administration, performance diagnostics, tuning, application testing, and space management across heterogeneous database platforms. The product's latest version supports SQL Server, so DBAs can manage their SQL Server databases along with databases on Oracle and IBM DB2 through one central console. The product also includes a built-in Knowledge Base for each database environment and an automated tuning methodology to help streamline performance management. Pricing for Quest Central for Databases 4.0 starts at $1500. For more information, contact Quest Software.
7. CONTACT US
Here's how to reach us with your comments and questions:
- ABOUT THE COMMENTARY — firstname.lastname@example.org
- ABOUT THE NEWSLETTER IN GENERAL — email@example.com
(please mention the newsletter name in the subject line)
- TECHNICAL QUESTIONS — http://www.sqlmag.com/forums
- PRODUCT NEWS — firstname.lastname@example.org
- QUESTIONS ABOUT YOUR SQL SERVER MAGAZINE UPDATE SUBSCRIPTION?
Customer Support — email@example.com
- WANT TO SPONSOR SQL SERVER MAGAZINE UPDATE?
Contact Richard Resnick at firstname.lastname@example.org or 800-949-4007.
SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine completely devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
Receive the latest information about the Windows and .NET topics of your choice. Subscribe to our other FREE email newsletters.