Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SMO Samples » SQL Server   (RSS)
Sorry, but there are no more tags available to filter with.
Tuesday, October 25, 2005 9:47 AM

SMO Samples Galore

With much of the SQL Server 2005 devcelopment behind us, I am starting to have some more time to post some SMO samples . Most of these are inspired on questions in the beta newsgroups or the SMO/DMO forum . Additionally, SQL Server 2005 ships with a pretty
Posted by mwories | 3 Comments
Filed under: ,
Tuesday, October 25, 2005 9:24 AM

SMO Sample: Which SQL Server version is supported by the property?

Purpose of sample: List metadata information about SMO object properties
Posted by mwories | 1 Comments
Filed under: ,
Monday, October 24, 2005 6:07 PM

SMO Sample: Create and Start a Job

Purpose of sample: Create simple job and start the job after creation.
Posted by mwories | 5 Comments
Filed under: ,
Tuesday, October 18, 2005 2:53 PM

SMO Sample: Backup database to Mirrors

Purpose of sample: Backup database to various mirrors
Posted by mwories | 1 Comments
Filed under: ,
Tuesday, October 18, 2005 2:42 PM

SMO Sample: Partitions

Purpose of sample: create a partition function and partition scheme on an existing database
Posted by mwories | 1 Comments
Filed under: ,
Tuesday, October 18, 2005 2:31 PM

SMO Sample: Transfer

Purpose of sample: Transfer a database; all objects and data
Posted by mwories | 3 Comments
Filed under: ,
Tuesday, October 18, 2005 2:26 PM

SMO Sample: Table column default constraint

Purpose of sample: show how a column constraint can be created.
Posted by mwories | 1 Comments
Filed under: ,
Friday, June 24, 2005 1:07 PM

SQL Server: Table Partitioning in SQL Server 2005

Table and Index partitioning is one if the new SQL Server 2005 features that willl improve life for the DBA and application developer quite a bit. It allows Indexes and Tables to be partitioned across multiple file groups. Partitioned tables and indexes,
Posted by mwories | 2 Comments
Filed under: ,
Tuesday, May 31, 2005 3:51 PM

SQL Server: Capture Object changes with SMO Capture Mode

In a previous article I have showed how a SMO object can be serialized into a Transact-SQL script, which allows you to recreate the object. What if you want to have the script that is emitted when you changed one or more properties of an object? In that
Posted by mwories | 0 Comments
Filed under: ,
Saturday, May 07, 2005 12:51 PM

SQL Server: SMO Scripting Basics

Let's first clarify what I mean by "scripting". It often happens during talks or when I explain SMO fundamentals that eyes gloss over, shortly after which the "what * do you mean by scripting" question pops up (replace the * with your favorite combination
Posted by mwories | 52 Comments
Filed under: ,
Monday, May 02, 2005 2:21 AM

SQL Server: Tuning your SMO Application for great performance -- PART 2

In the previous post I provided you with a fundamental tool to minimize the amount of SQL statements emitted and therefore limit expensive network round-trips (and SQL statements) using the Server.SetDefaultInitFields() method. In this post I will provide
Posted by mwories | 53 Comments
Filed under: ,
Friday, April 22, 2005 1:16 PM

SQL Server: Tuning your SMO Application for great performance - PART 1 (featured at TechED)

SQL Server Management Objects -- performance tuning part 1
Posted by mwories | 37 Comments
Filed under: ,
 
Page view tracker