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 presents sample code for performing SQL database backup and restore.
Other News
iAnywhere Solutions Tops Mobile Database Market
iAnywhere Solutions, Inc., a subsidiary of Sybase, Inc. (NYSE: SY), announced that it leads the mobile database market for the sixth year in a row, with overv70% market share. The company’s SQL Anywhere Studio powers mobile, remote, embedded and workgroup database solutions across a range of industr
New Products, January 2003
By Carolyn Mader – Check out the latest SQL Server-related new and improved products.
Microsoft SQL Server 2000 High Availability Series
The Microsoft® SQL Server™ 2000 High Availability Series helps you plan and deploy a highly available data center that uses Microsoft SQL Server 2000 through proper procedures that increase availability, backups help recover from catastrophic disasters, redundant components prevent downtime, and red
Introduction to Data Mining with SQL Server
by Eric Charran – In order to fully comprehend, much less implement enhanced Decision Support Systems in an organization, it is necessary to understand the basic precepts behind the requirements, methodologies and business drive to obtain information. Information about an organization gathered from
Find duplicate queries
By Dilbagh Singh – Users sometimes submit queries through an application multiple times, especially in environments where they are not in a position to maintain/manage the queries they submit. This takes up resources (i.e., temp space, CPU, IO, etc) and causes performance degradation for all users.
Viewing and Managing Job Queues in Oracle 9i
Learn how to schedule the periodic execution of user jobs using job queues in Oracle 9i. Also covered are topics on viewing job queue information and managing job queues.
100 XML Acronyms
The popularity of XML can be gauged by the number of acronyms created around it! PerfectXML team has compiled a list of 100 such acronyms that relate to XML family in some way. Be sure to bookmark this page and visit it anytime you see an acronym and can’t remember its full form or want to get more
Tip: Basics of bootstrapping with DOM, Part 3
By Brett McLaughlin – This tip explains the changes to DOM Level 3 that relate to bootstrapping, and how they improve upon DOM Levels 1 and 2.
Test Frameworks for W3C Technologies
by Dimitris Dimitriadis – Writing specifications is great. Implementing them is difficult. Specifications, at least those from the W3C, aim at interoperability and are written with wide acceptance in mind. However, they tend to be difficult to implement. Look at the various implementations of the or