To be an effective database programmer, you need to master SQL for the database you’re going to be using. This book will teach you the concepts, terms, and skills you need for designing and working with any database.
Other News
admin db – Track Procedures In Use on a SQL Server :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 only Description:
Installation prerequisite for Query Patroller, Version 8
Installation prerequisite information for Query Patroller Version 8 with DB2 UDB Version 8.
Protecting DB2 against Non Concurrent Application Code
DBAs have learned that performance of an application can be influenced by many factors, which in turn can influence database performance. In this article, Marin Komadina explores a real-world example of an application with a locking problem.
DB2 System Performance Metrics Revisited
By Joel Goldstein – DB2 is a complex database management system that has a major impact upon your overall processing environment. Installations are constantly looking for ways to measure, analyze, and control its resource consumption. It addresses the origins and data available for analyzing, tuning
Build a Servlet-based Application That Executes SQL Statements Via the Web
by Joel Murach – Learn how to use a Java servlet, a JavaServer Page, and a static Java class to create a SQL gateway application that enables users to interactively execute SQL statements against a database running on a server. This application allows you to work with a database as you’re developing
Understanding Clustering
By Nirav Chanchani – Learn about the benefits of distributed applications. Learn unit-testing basics using one of the most popular open-source testing frameworks.
Battling the blaster worm?? Help is out there at www.Shavlik.com
From SQLSecurity.com – For any of you that have spent the better part of today patching machines that STILL haven’t got the MS03-026 patch installed, I recommend you take a look at HFNetChkLT at www.shavlik.com. It’s been a lifesaver for me (I actually use the Pro version for sending out SQL Server
Member-Properties Boot Camp
By Russ Whitney – Member properties let you store additional information about dimension members, but they can do much more. Are you getting all you can from your member properties? Here are 10 ways to pump up member-property effectiveness. (R, $)
mssqlXpress
Product Announcement – mssqlXpress is the latest full-featured integrated development environment (IDE) for MS SQL.