Q. Why doesn’t SQL Server permit an ORDER BY clause in the definition of a view? A. SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard.
Author: SSWUG Research
Data Placement (v8.1 DBA Certification Prep – Part 2 of 6)
By Dwaine Snow – This tutorial discusses the creation of DB2 databases as well as the various methods used for placing and storing objects within a database. This is the second tutorial in a series of six tutorials that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Databa
Creating Web services on Windows to access DB2
By Quentin Presley – This tutorial shows how to make your DB2 data accessible through Web services using the Application Developer configuration of WebSphere Studio v.5 on the Windows platform to develop and test Web services for DB2 data.
IBM to Offer DB2 Mastery Exam
By Lisa Vaas – IBM is launching a mastery exam to help database administrators identify and resolve thorny issues, the company announced last week. The DB2 Problem Determination Mastery Exam will give DBAs the skills to investigate and isolate database issues.
A DBA’s perspective on OracleJVM security mechanisms
by Kuassi Mensah – Security is a prime concern for DBAs, CTOs, every architect and developer in between, and every end user of a system that is running software modules close to that most valuable corporate asset—your business data. In contrast to traditional JDK-based Java virtual machines, the Ora
INF: How to Write a Variance Query in SQL Server
When you need to make a comparison between a value and the average for that value in the same category, you can execute a variance query. For example, you may want to use a variance query when you want to compare the salary of an employee against the salary of other employees who hold the same title
How to Buy SQL Server 2000
This link can help you select and purchase the right SQL Server edition for your business. Pricing and licensing information is also available.
SQL Server Notification Services Developer Overview
Webcast Summary: SQL Server Notification Services is a new powerful notification application platform. The platform helps developers build centralized publish-subscribe (“pub-sub”) applications and deploy them on a large scale. These applications are often used to send notification messages to end-u
IBM nabs Web content software firm
IBM has agreed to acquire Aptrix, a maker of Web content management software, in a move to bulk up its Lotus Web development portfolio.Aptrix technology was designed to work with current Lotus Domino, WebSphere and DB2 Content Manager environments.
Sleepycat Software Launches Native XML Data Manager Built on the Proven Berkeley DB Engine
Sleepycat Software, makers of Berkeley DB – the most widely deployed application-specific data management software in the world with over 200 million deployments – announced general availability of Berkeley DB XML, a native XML database built on the most advanced version of Berkeley DB ever engineer