DatabaseJournal.com Staff

This article is the second in my new series that focuses on alerts and errors within the SQL Server Agent subsystem. In this article I am going to describe how to create new alert definitions. First, let’s recap the definition and pointers for the use of SQL Server Agent Alerts from my previous article: Alert […]

Database Abstraction and Atomic Operations and Classes Explored By Justin Vincent The Lazy Sod Maybe it’s just me, but after building database driven websites in PHP for the past six years I am starting to get more than a little tired of repeating myself. What I mean to say is… how many times, on how […]

MCSE, MCSD, MCDBAmaubert@swynk.comhttp://www.2000trainers.com Hello, my name is Mike Aubert and welcome to my homepage on DatabaseJournal.com. I am an IT consultant and technical trainer currently based out of Florida. My main areas of expertise include Windows NT/2000 networking, SQL Server, Visual Basic, and network design. Although I have worked on a diverse variety of projects […]

This VBscript scripts publications on all SQL Servers within your network. It’s useful for organizations the have implemented large amounts of replication. Set up is as follows: A “Servers” table containing all the SQL Servers in the organization should be created. Servers ServerName varcha(XX) ScriptDDL. Tinyint (values 0 or 1) 1 = Script, 0 = […]

[From Macworld UK] IBM is seeking feedback from the Mac community about whether it should port its DB2 relational database software to Mac OS X. The company has launched a survey into the feasibility of the move, which reads: “If you, or your clients, use or develop on Mac OS X we want to hear […]

As every SQL Server DBA might be aware, the default port for SQL Server on which it listens is 1433. But this holds only for the default instance. In a multi-instance environment, the port allocation is dynamic and is potentially different every time SQL Server is restarted. This script can be used to find the […]

bszabo@databasejournal.com Having started out as a database administrator for a company that did not really even know it had a database has lead me on a journey that has come full circle. In 1992 I started working for a company that was using an Informix database running on DOS to store its prospecting system. After […]

MCSE, MCSD, MCDBAmaubert@swynk.comhttp://www.2000trainers.com Hello, my name is Mike Aubert and welcome to my homepage on DatabaseJournal.com. I am an IT consultant and technical trainer currently based out of Florida. My main areas of expertise include Windows NT/2000 networking, SQL Server, Visual Basic, and network design. Although I have worked on a diverse variety of projects […]

Ian Gilfillan lives in Cape Town, South Africa. He is the author of the book ‘Mastering MySQL 4’, published by Sybex, and has been working with MySQL since 1997. These days he develops mainly in PHP and MySQL, although confesses to starting out with BASIC and COBOL, way back when, and still has a soft […]

iecdba@Yahoo.com Eli works at Israel Electric Company as a Senior Application DBA in Oracle and MS SQL Server. He also has certifications from Microsoft and BrainBench in Oracle and SQL Server database administration and implementation. Mr. Leiba holds a B.S. in Computer Science since 1991 and has 11 years experience working in the database field. […]

sumitdig@hotmail.com Articles:

Provides Shared Customers with Enhanced Support and Delivers Joint Service Solutions for Simpler Management 9.30.02.  EMC Corporation and Oracle Corporation today announced the opening of the Oracle and EMC Joint Service Center (JSC), delivering both deeper service support and quicker problem resolution for their shared customers. Staffed by service engineers from both companies, the Oracle […]