Automate the Publishing of Data Changes into DML Scripts
For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.
2009-11-02
3,438 reads
SQL-DMO
PowerSMO At Work Part I: DBA Scripts and Functions
Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO functions to manage the extended properties of SQL Server objects.
2007-03-13
3,271 reads
Automating Common SQL Server Tasks using DMO
The article's intention is to show how easy it is to use DMO (and its successor, SMO) from within SQL Server, and how any COM object that does not rely on events can be used.
2006-12-04
3,039 reads
Save Your Stored Procedures
Version control of stored procedures is not exactly a SQL Server 2000 strong point. In fact, it is downright abysmal and there have been lots of ideas and solutions put forth to solve the problem. Andy Warren brings us a new one that's small and lightweight and may help you after getting inspired at TechEd 2005.
2005-06-17
12,751 reads
More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,547 reads
SQL DMO Poster in PDF!
Last year we did a project with Lumigent to create a DMO poster. Part of the agreement allows us to now distribute the PDF version to our readers. It's about a 400k file, print size is 24x36. We hope you DMO users will find it useful.
2003-10-03
1,901 reads
VBScript Class to Return Backup Information
The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.
2003-08-28
6,826 reads
Introduction to SQL-DMO
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
39,064 reads
SQL-DMO - Using the '2' Objects
In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.
2002-09-02
5,785 reads
SQL-DMO for Beginners
How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
2002-08-29
12,881 reads
Blogs
T-SQL Tuesday #181: A Technology Present
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
Trace Flag 3625 Follow Up
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
The Hash Join III
Comments posted to this topic are about the item The Hash Join III
Continuous Learning
Comments posted to this topic are about the item Continuous Learning
Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric
Comments posted to this topic are about the item Virtualizing GCP data by using...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers