Welcome to MSDN Blogs Sign in | Join | Help

May 2005 - Posts

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 3:40 PM

Sql Server: Everything you always wanted to know about SMO Connections

There are several ways of controlling connections in SMO -- you can control pretty much any aspect of a SMO connection. Pooled connections Let's take a look at a typical way how you would obtain a connection using a simple C# sample: Server svr = new
Posted by mwories | 30 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: ,
 
Page view tracker