(Gregory A. Larsen) If you have yet to find out about the little extended stored procedure gem known as “xp_cmdshell”, then this article is for you. In this article, I will cover what “xp_cmdshell” is and different things you can use it for. If you already know something about “xp_cmdshell” then
Other News
Start developing CCXML applications
(Susan Jackson and Hannah Parker) This tutorial offers an insight into the new Call Control XML (CCXML) language. This language enhances the telephony industry by allowing development of call control functionality, irrespective of the base proprietary telephony system. (R)
Don’t Get Left Behind
(Brian Knight) Do you consider yourself solely a SQL Server production DBA? You know, the DBA whose job is to make requested changes in production and fix problems if they occur. If so, watch out. That hearse outside your cube may be for your career soon. Much of this is market forces and a lot of t
Oracle/PLSQL: Primary Keys
A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key.
IBM creates a Google for corporations
(Kristi Heim) In the red-hot market for search technology, IBM hopes to do for corporate data what search engines like Google have done for the Web.
SVG and Typography: Animation
(Fabio Arciniegas A.) In the last part of our exploration of SVG and Typography, we turn our attention to effects with animated type, exploiting SVG declarative animation features. Instead of just using individual samples showcasing each technique, I decided to finish these series with a summari
Securing Your Microsoft SQL Server Databases in an Enterprise Environment
If you are running Microsoft SQL Server databases to support critical enterprise applications, you are part of a growing trend. The low cost and performance benefits of using Microsoft SQL Server on the Microsoft Windows NT and Windows 2000 platforms have fueled the growth of SQL Server as a platfor
Microsoft Targets Nonprofessional Programmers
(John Foley) Microsoft disclosed plans to release inexpensive, lightweight versions of its Visual Studio developer’s tools and SQL Server database for nonprofessional developers. The stripped-down editions of Microsoft’s flagship development environment and database are aimed at students, hobbyi
IBM Tools Eye Java-to-Non-Java Integration
(Vance McCarthy) Over the past few weeks, IBM has left no doubt that business-level integration and workflow are not just add-ons anymore — these are core platform services. IBM WebSphere and DB2 products have both added significant support for cross-platform data-driven integration.
Watching SQL Execute on Oracle – Part I
(James Koopmann) Do you have SQL running within your database? Of course you do. This article is the first in a series to introduce you to a method of finding information about the SQL your users are executing in your databases. Your ability as a DBA to detect who is accessing the database and th