SQL Server Magazine UPDATE—brought to you by SQL Server Magazine
THIS ISSUE SPONSORED BY
Need to Configure a Server for Microsoft SQL Server?
FREE Oracle9i Unbreakable e-Kit
Macromedia MX Seminars Are Coming to a City Near You!
(below NEWS AND VIEWS)
SPONSOR: NEED TO CONFIGURE A SERVER FOR MICROSOFT SQL SERVER?
Check out the new online ProLiant Transaction Processing Sizer for
Microsoft SQL Server 2000 from the new HP. This automated tool will
help you determine an optimum hardware configuration for your database
server — based on YOUR requirements. Through an interview process, a
set of hardware configurations is developed using patented system
sizing and configuration technology. Specific configuration
information and performance recommendations are provided for each
configuration. Developed by HP in our software integration lab, this
tool supports the ProLiant server family and appropriate options.
June 27, 2002—In this issue:
2. SQL SERVER NEWS AND VIEWS
- Buffer Overrun Vulnerability in SQL Server 2000
- Microsoft Posts New Web Development Tool
- Results of Previous Instant Poll: Enforcing Data Integrity
- New Instant Poll: Defective Software
- Are You Wasting Time Searching for SQL Server Answers?
4. HOT RELEASE (ADVERTISEMENT
- Panorama Software Systems
- What's New in SQL Server Magazine: Guard Your Data with Kerberos
- Hot Thread: Unable to Connect to SQL Server 2000 Through Access
- Tip: Retrieving a Database's Stored Procedures and Change Dates
6. NEW AND IMPROVED
- Integrate Your E-Business Project
7. CONTACT US
- See this section for a list of ways to contact us.
(contributed by Brian Moran, news editor, [email protected])
Have you deployed SQL Server technology in a creative and innovative way to solve a thorny technical or business problem? Do friends walk into your server room and sigh, "Wow, I wish I had a SQL Server setup like that"? Do you yearn to stand on top of your server, arms out stretched, and proclaim, "I'm king of the SQL Server world"? Would you like to win $1 million and your own private Caribbean island?
I can't help out with the million bucks or the island, but you might still be interested in entering the first annual SQL Server Magazine Innovator Awards. SQL Server Magazine and Microsoft are jointly sponsoring this year's SQL Server Innovator Awards. Outstanding entries will receive a cool pewter mug trophy that can be filled with the beverage of your choice. In addition, the top prizewinner will receive bragging rights, an all-expenses-paid round-trip to the SQL Server Magazine LIVE! Fall 2002 conference in sunny Orlando, Florida, and the prestigious SQL Server Innovator's Cup traveling trophy for an entire year. Who cares about the World Cup when you can take home this beauty!
So how do you win? If you work with SQL Server and have created a technical solution to a problem or enhanced a program or system feature to improve performance or Return on Investment (ROI), you qualify to enter this awards program. Entering is easy. SQL Server Magazine is accepting entries until August 15. Select members of the SQL Server Magazine editorial staff and Microsoft representatives will evaluate the entries and will contact finalists for in-depth phone interviews. You'll find more information and an entry form at http://www.sqlmag.com/awards.
What are we interested in? Here are a few of the sample, guiding questions we've posted on the entry form to give you some ideas:
But heck, these are the Innovator Awards. Innovation means that you might be the only person who's thought of the solution. That's why all applicants need to summarize in 300 words or fewer (No. 2 pencil optional) the problem you solved, key points of your solution, and the measurable benefits from the solution. Go ahead, impress us.
FREE Oracle9i Unbreakable e-Kit
Oracle9i combines Reliability and Security for Lower Costs. Your IT
department can lower costs while increasing reliability and security.
With Oracle's unique clustering technology, you can reduce the number
of servers needed to run your business while protecting against server
failures. Click here for your FREE Oracle9i Unbreakable e-Kit.
2. SQL SERVER NEWS AND VIEWS
(contributed by Ken Pfeil, [email protected])
Mark Litchfield of Next Generation Security Software (NGSSoftware)
discovered a vulnerability in SQL Server 2000 when used in conjunction
with the Microsoft Jet 4.0 database engine that can lead to an
attacker executing arbitrary code on the vulnerable system. This
vulnerability stems from a remotely exploitable buffer overrun in the
OpenDataSource function. Microsoft recommends that affected users
apply the patch mentioned in the Microsoft article "ACC2002: Updated
Version of Microsoft Jet 4.0 Available in Download Center," which you
can read at the first URL below.
(contributed by Paul Thurrott, [email protected])
ASP.NET coders will want to check out a free new development tool
called Web Matrix, which includes a WYSIWYG development environment,
SQL Server management capabilities, and mobile-application creation
features, all wrapped up in a tiny 1.2MB download of managed code
goodness. While I was at Microsoft for a technical workshop, I learned
that the company will use Web Matrix to test features intended for the
next Visual Studio (VS) version. For more information, see the ASP.NET
Sponsored by BMC Software
The voting has closed in SQL Server Magazine's nonscientific Instant Poll for the question, "Where do you usually enforce data integrity?" Here are the results (+/1 percent) from the 407 votes:
- 10% At the client
- 41% At the server
- 35% At the client and the server
- 12% Varies according to efficiency
- 2% I don't give much thought to data integrity
The next Instant Poll question is, "Do you think Microsoft should be held financially liable for defective software?" Go to the SQL Server Magazine Web site and submit your vote for 1) Yes, 2) No, or 3) Not sure.
SPONSOR: MACROMEDIA MX SEMINARS ARE COMING TO A CITY NEAR YOU!
Macromedia has just announced the New MX product family:
- Macromedia Flash MX,
- Macromedia Dreamweaver MX,
- Macromedia Fireworks MX, and
- Macromedia ColdFusion MX!
Come check out our new seminar series that's focused around these
new and exciting products. We will be in a city near you soon! For
more information visit:
(brought to you by SQL Server Magazine and its partners)
The SQL Server Magazine Master CD gives you realtime, high-speed access to all the articles, code, and expertise from every issue of SQL Server Magazine ever published. Unique search features let you find what you need fast. Order your copy today!
4. HOT RELEASE (ADVERTISEMENT)
Advanced e-BI solutions enabling executives and analysts to streamline decision making, generate higher profits and increase shareholder value. Our technologies are 100% compatible with Microsoft's Enterprise Solutions. Panorama -Business Intelligence. Make it simple.
Running SQL Server 2000 on Windows 2000 offers great flexibility in how you manage logins, how you secure both the authentication process and the channel between the client and server, and how you limit access to services enterprisewide. Kerberos authentication, the default authentication protocol in Win2K, improves on Windows NT's authentication protocol in several ways and offers identification of both the client and the server. Examine how you can use Kerberos to protect the data on your SQL Server 2000 servers by reading Morris Lewis's article "Guard Your Data with Kerberos," which appears in the July 2002 issue of SQL Server Magazine and is available online at the following URL:
KellyB is working with customers who are unable to connect to SQL Server 2000 through Microsoft Access. The customers receive an error message that might point to an ODBC driver problem; KellyB suspects the error might also be related to the version of Microsoft Data Access Components (MDAC) in use. Offer your advice and read other users' suggestions on the SQL Server Magazine forums at the following URL:
(contributed by the Microsoft SQL Server development team)
Q. In SQL Server 2000, how can I list a database's stored procedures and their change dates?
A. The data you're looking for is stored in SQL Server 2000's system tables. Because Microsoft discourages users from querying the system tables directly (the tables change from release to release), we recommend that you retrieve this information from the ANSI-standard information schema views for each database. The following statement uses an information schema view to return the data you want:
USE <mydatabase> -The database that holds the stored procedures -and functions. GO SELECT specific_catalog, specific_schema, routine_type, routine_name, created, FROM INFORMATION_SCHEMA.ROUTINES ORDER BY 1 asc, 2 asc, 3 asc, 4 asc
Note that SQL Server retains only the created date for stored procedures, so to capture the date of the latest version, you need to drop, then create the procedure instead of using ALTER to modify or update the procedure.
Send your technical questions to [email protected]
6. NEW AND IMPROVED
(contributed by Carolyn Mader, [email protected])
PolyVista announced PolyVista, analytical software that features data-mining algorithms to automate the process of discovering anomalies or hidden relationships in the data. The software integrates OLAP directly with interactive 2-D and 3-D graphics. The deviation algorithm discovers statistically interesting data anomalies and ranks the result list for you. The summary algorithm discovers combinations of dimensions that yield the greatest or least measure values. PolyVista supports SQL Server. For pricing, contact PolyVista at 713-521-1101.
Data Junction announced the Data Junction Integration Suite, software for e-document integration and message-based integration for your e-business project. The suite comprises Data Junction, Content Extractor, and Integration Engine. Data Junction is a Windows-based graphical design tool. The Content Extractor is a visual interface that automates the creation of extraction rules and conditions for extracting unstructured data. The Integration Engine enables rapid deployment, multithreaded parallel processing, and XML support. The Data Junction Integration Suite lets you access SQL Server data through XML and HTTP. For pricing, contact Data Junction at 800-580-4411.
7. CONTACT US
Here's how to reach us with your comments and questions:
- ABOUT THE COMMENTARY — [email protected]
- ABOUT THE NEWSLETTER IN GENERAL — [email protected]
(please mention the newsletter name in the subject line)
- TECHNICAL QUESTIONS — http://www.sqlmag.com/forums
- PRODUCT NEWS — [email protected]
- QUESTIONS ABOUT YOUR SQL SERVER MAGAZINE UPDATE SUBSCRIPTION?
Customer Support — [email protected]
- WANT TO SPONSOR SQL SERVER MAGAZINE UPDATE?
More than 102,000 people read SQL Server Magazine UPDATE every week. Shouldn't they read your marketing message, too? To advertise in SQL Server Magazine UPDATE, contact Beatrice Stonebanks at [email protected] or 800-719-8718.
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.
Receive the latest information about the Windows and .NET topics of your choice. Subscribe to our other FREE email newsletters.