sql-dmo

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Connect to a server and its databases using SQL-DMO

Microsoft provides an object-oriented library for dealing with SQL objects: SQL-DMO SQL Distributed Management Objects. This article shows you the basic steps on how to connect to a server and its databases using SQL-DMO. Microsoft provides an object-oriented library for dealing with SQL objects: SQL-DMO (SQL...

Tags: SQL, Microsoft Corp., SQL-DMO, Databases, Storage, Arthur Fuller, database, oNames, server, SQL Server Newsletter, TechRepublic Inc., Object-oriented, Programming Languages, Ooa/Ood/Oop, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Technical articles 2005-07-26

Deploying ADP solutions

Rick Dobson discusses the new ADP hybrid file type, which provides Access' rapid application development capabilities and SQL Server's industrial-strength database handling.Microsoft recently introduced the new ADP file type. ADP is a hybrid file type: It has a graphical user interface GUI that resembles a traditional Access solution, but it...

Tags: Databases, Enterprise software, Rick Dobson, Automatic Data Processing Inc., Microsoft SQL Server, SQL-DMO, server, database

Technical articles 2000-02-02

Additional Resources

Developers Improve Responsiveness and Productivity at National Defense Department

Australian Defence Materiel Organisation DMO System Program Offices must retain and access maintenance and engineering records to help ensure the safety and airworthiness of hundreds of aircraft. Obtaining reports from the database took several days - potentially jeopardizing the Air Force's responsiveness. Aging systems became costly and difficult to maintain,...

Tags: Developer, Microsoft SQL Server, Microsoft Corp., U.S. Department Of Defense, Databases, 64-Bit, Enterprise Software, Software, Data Management, Processors, Semiconductors, Hardware, Components

Case studies

SQLDMO (exe)

SQLDMO is a technical article illuminates the functionality present in the SQL-DMO server architecture. This version is the first release on CNET Download.com.

Tags: Microsoft Corp., SQLDMO, Servers, Hardware

Software downloads 2007-08-30

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management

White papers 2001-07-19

SQL PathFinder for Oracle (msi)

SQL Pathfinder is for Oracle SQL programmers who live in an environment where multiple versions of SQL scripts and multiple SQL execution environments exist. Pathfinder determines the SQL path that SQL Plus will use, and traces and displays all of the script dependencies for your SQL script. The dependencies are...

Tags: Oracle Corp., SQL, SQL PathFinder, Pathfinder, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-11-21

Cache Monitor (zip)

Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...

Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-05-11

What is the difference between Oracle, SQL and PL/SQL?

Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...

Tags: Oracle Corp., PL/SQL, SQL

Blog posts 2006-05-30

Some resources on SQL Server 2005

Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner

Blog posts 2005-11-11

Transferring SQL Server logins between servers or instances

I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...

Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2007-09-25

EMS SQL Manager 2008 for SQL Server (zip)

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML...

Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

EMS SQL Manager 2008 Lite for SQL Server (zip)

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...

Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

BlackBall SQL Agent (exe)

The BlackBall SQL Agent fills the gap that Microsoft Express Edition 2005 left with its ommission of a SQL Server Agent. Use the BlackBall SQL Agent to automatically backup your SQL Server database at periodic intervals, or run other arbitrary SQL commands such as executing stored procedures.Also includes email notifications...

Tags: Microsoft SQL Server, SQL, BlackBall SQL Agent, E-mail, Databases, Enterprise Software, Programming Languages, Online Communications, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-06-29

How do I run code automatically when SQL Server starts?

The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. Today, consultant Tim Chapman gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on...

Tags: Stored Procedure, Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, John Sheesley

Blog posts 2008-11-10

Towards an Industrial Strength SQL/XML Infrastructure

XML has become an attractive data processing model for applications. SQL/XML is a SQL standard that integrates XML with SQL. It introduces the XML datatype as a native SQL datatype and defines XML generation functions in the SQL/XML 2003 standard. The goal for the next version of SQL/XML is integrating...

Tags: SQL, XML, Programming Languages, Databases, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management

White papers 2004-07-21

Fast Track DBA

I am looking for a "Boot Camp" for SQL DBA. I have some knowledge of it but I am trying to gain more experience and it helps that my company is going to pay for it. I am looking for something that is a 2 day Session ...any IdeasSQL ServerI...

Tags: Programming languages, Databases, jabney@..., SQL, server

Discussion threads 2005-06-14

SQL Tools Make Fast Work

The purpose of any interactive SQL tool is to let the user enter SQL statements and get results back. The term SQL statements includes PL/SQL blocks and now, in Oracle Database 10g Release 2, XML queries. SQL*Plus has long been the tool of choice for executing ad hoc SQL statements,...

Tags: Oracle Corp., SQL, Tool, SQL*Plus, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

White papers 2006-01-01

How do I... Configure transactional replication between two SQL Server 2005 systems?

Replication between sql 2000 and sql 2005This article was good for basic knowledge. Is it possible to use sql 2005 as a distributor and sql 2000 as a publisher. Subscriber could be any.ORsql 2000 as publisher and distributor but subscribers as sql 2005.Please point me if there is any reference...

Tags: Programming languages, Databases, Microsoft SQL Server 2005, alalani@..., Microsoft SQL Server, SQL

Discussion threads 2007-09-12

Apex SQL Report (exe)

Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a Web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports. New Apex SQL Report includes fusion charts, multi column sorting, grouping & filtering using Janus...

Tags: SQL, Apex SQL Tools, Apex SQL Report, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-01-30

SurroundCast (exe)

SurroundCast is a Digital Surround HD Radio Player with over 1000 HD Stations. Featuring iPod support and advanced SRS WOWXT Circle Surround II and Spatializer technology. Users can experience 3D Sound even with two speakers. SurroundCast includes AudioModeling, VST and DMO Playback Engine.Version 1.3.5.2 may include unspecified updates, enhancements, or...

Tags: SurroundCast, Digital Music, Digital Media, Personal Technology, Consumer Electronics

Software downloads 2006-07-28