By Sushil Srivastava – Sometimes its quite essential to know and use the database name on which your SQL is being executed.
Author: SSWUG Research
Quest consolidates Oracle database tools
By James Niccolai – Quest Software has consolidated several of its Oracle database management tools into a unified product called Quest Central for Oracle, a move that one analyst said could make life easier for database administrators.
Provisioning: Use Web Services Provisioning to Control Access, Usage, and Billing on Your Site
Chandu Thota explains how to design and implement a Web Service provisioning system using the .NET Framework and SQL Server 2000, and then outlines various scenarios for putting this system to work.
Securing Your SQL Server
A growing consciousness of security has brought Microsoft SQL Server database security into focus as never before. Planning for database security should begin early in the development process and there are important vulnerabilities that you need to prevent in your application’s SQL Server.
Most efficient way to remove duplicate rows
By Pau Fores – This script uses a hash join — the most efficient way of joining huge tables — to find duplicate rows. It has been tested on Oracle 6.0 to Oracle 9i v2, and it works in all of those versions.
Microsoft Talks Up Office 11 Developers Tools
By Gregg Keizer – Microsoft answered questions about how developers were supposed to take advantage of Office 11’s new functionality, particularly its XML expertise, by unveiling a set of development tools, code-named Visual Studio Tools for Office.
Introduction to SQL Server 2000 Analysis Services: Exploring Virtual Cubes
Join author Bill Pearson in a hands-on introduction to virtual cubes in the SQL Server 2000 Analysis Services series. Learn how virtual cubes provide options to extend cube functionality, act as an adjunct to security strategy, and otherwise add value to information products.
Handling database file growth
By Peter Schmitz – Scripts to automatically get notified if a database grew due to the autogrowth option being turned on. I wrote this after searching all over the web for something like this, but didn’t find anything.
How to Manage Multiple Developers Using the System Administrator Account
Because you’re working in a development environment where SQL Profiler and server tracing are suitable for use (that is, the potential performance impact doesn’t affect production), you could set up a server trace to log information to a table in the background. Then, you could search this table to
Oracle seeks to align Eclipse with Sun’s Java
An IBM-backed Java tools initiative could be yanked back into Sun Microsystems Inc’s sphere of influence, to heal a potential community rift, through efforts lead by Oracle Corp, writes Gavin Clarke.