Browse by Tags

All Tags » SMO Samples   (RSS)
SMO Sample: Enable TCP/IP Server protocol of SQL Server 2005
10 February 06 05:09 PM | mwories | 4 Comments   
SMO Sample: Enable TCP/IP Server protocol of SQL Server 2005 Read More...
Filed under:
SMO Samples Galore
25 October 05 09:47 AM | mwories | 3 Comments   
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 Read More...
Filed under: ,
SMO Sample: Which SQL Server version is supported by the property?
25 October 05 09:24 AM | mwories | 1 Comments   
Purpose of sample: List metadata information about SMO object properties Read More...
Filed under: ,
SMO Sample: Create and Start a Job
24 October 05 06:07 PM | mwories | 5 Comments   
Purpose of sample: Create simple job and start the job after creation. Read More...
Filed under: ,
SMO Sample: Backup database to Mirrors
18 October 05 02:53 PM | mwories | 1 Comments   
Purpose of sample: Backup database to various mirrors Read More...
Filed under: ,
SMO Sample: Partitions
18 October 05 02:42 PM | mwories | 1 Comments   
Purpose of sample: create a partition function and partition scheme on an existing database Read More...
Filed under: ,
SMO Sample: Transfer
18 October 05 02:31 PM | mwories | 3 Comments   
Purpose of sample: Transfer a database; all objects and data Read More...
Filed under: ,
SMO Sample: Table column default constraint
18 October 05 02:26 PM | mwories | 1 Comments   
Purpose of sample: show how a column constraint can be created. Read More...
Filed under: ,
SQL Server: Table Partitioning in SQL Server 2005
24 June 05 01:07 PM | mwories | 2 Comments   
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, Read More...
Filed under: ,
SQL Server: Capture Object changes with SMO Capture Mode
31 May 05 03:51 PM | mwories | 0 Comments   
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 Read More...
Filed under: ,
SQL Server: SMO Scripting Basics
07 May 05 12:51 PM | mwories | 52 Comments   
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 Read More...
Filed under: ,
SQL Server: Tuning your SMO Application for great performance -- PART 2
02 May 05 02:21 AM | mwories | 53 Comments   
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 Read More...
Filed under: ,
SQL Server: Tuning your SMO Application for great performance - PART 1 (featured at TechED)
22 April 05 01:16 PM | mwories | 37 Comments   
SQL Server Management Objects -- performance tuning part 1 Read More...
Filed under: ,
Page view tracker