Marcin Policht’s latest article in the ‘SQL Server Management with WMI’ series continues a discussion on using Windows Management Instrumentation (WMI) for managing SQL Server and includes sample scripts for several SQL Server and database maintenance tasks.
Other News
At Oracle, Simplicity Rules All
By Jane Black and Olga Kharif – Integrating data within heterogeneous systems is a task that that large software vendors are tackling, as clients demand simpler solutions for more complex environments. This case study looks at how Oracle made life easier for one CTO, and examines the way major ERP p
Oracle Touts Linux Support
By Lisa Vaas – Oracle Corp. Vice President of Marketing Rene Bonvanie opened the Enterprise Linux Forum Conference & Expo 2002 by demonstrating a simulation of an "unbreakable" eight-node cluster running the company’s Oracle9i RAC (Real Application Cluster) technology on top of Linux.
XHTML is the best wireless dev tool
By Puneet Gupta – The focus for much of wireless development so far has been on wireless Internet technologies like WAP 1.x and Wireless Markup Language (WML), which present content to the mobile users adhering to the bandwidth and memory limitations of mobile devices.
Making Sense of Direct Internet Message Encapsulation (DIME)
by Matt Long – DIME addresses the difficulties involved in embedding binary data into XML documents. DIME is a specification submitted by Microsoft and IBM to IETF, and it defines a lightweight, binary message format that can be used to encapsulate one or more application-defined payloads of arbitra
Thinking XML: Manage metadata with MusicBrainz
Since its emergence in the mid-1980s, digital music has seen plenty of controversy, and even the management of digital music metadata has been subject to its own share of drama. But sometimes out of political dust-ups, good technical solutions emerge. In this article, Uche Ogbuji introduces MusicBra
7 Steps to SSL Encryption
By Gary Zaika – Information about setting up server-requested SSL encryption in a clustered SQL Server environment is hard to come by. But these clear steps pave the way to a straightforward implementation.
Using Stored Procedures to Manage SQL Server Security
by Brian Lockwood – Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures, you can ensure that your data can be accessed i
XML Takes a Step Forward, Hits Snag on Another Front
By Lisa Vaas – While support for XML grew as IBM released DB2 Universal Database 8 with support for the language, support of a limited query language from a standards group could limit the broad use of XML.
How To Retrieve XML Data Using an XPath Query with ADO in Visual C++
XPath.exe demonstrates how to extract an XML stream from a SQL Server 2000 database by using an XPath query and ADO in Visual C++.