Upcoming at TechED: Web Based SQL Server Management Tool (Shared Source!)

Visual Studio .NET 2003 shipped a web based sample application for management of SQL Server, based on ASP.NET and SQL-DMO. We’re currently working on an updated version of that tool. This is a quick list of the things that we change: Revamped UI Improved navigation Improved architecture to make adding new components easier Fully based…


SQL Server 2005 Easter Egg

In an interview with Gert Drapers, SQLCMD was mentioned as SQL Server 2005’s Easter Egg (Gert: “one of the biggest productivity gains for DBA’s in terms of automation”). I hope that I can pull this feature somewhat out of obscurity 🙂 Watch the SQL Server 2005 Scripting Webcast which covers most of SQLCMD’s features. And when…


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, are fully manageable with SMO. Here is a quick sample to get you…


Scripting in Microsoft SQL Server 2005 Web Cast Resources

This article contains extra information with regard to the web cast “Scripting in Microsoft SQL Server 2005 ” that was held on 6/22/2005 9:30-11:00 PST. Q&A Log Question: Is sql server management studio part of standard edition ?Answer: Yes. Every edition except for Express Question: Is there an option to show the template scripts without the big,…


Scripting in Microsoft SQL Server 2005 — Web Cast has finished

I just finished the Scripting in Microsoft SQL Server 2005 webcast. Thanks all for being online (and also thank you MVP’s for answering questions!) I was a little nervous doing this (it’s a big deck with lots of demos) but I think it went quite OK. Let me know if you have any requests/comments! Q&A,…



Q: Is SQL-DMO still supported with SQL Server 2005?A: Yes, SQL-DMO will be fully supported (albeit officially deprecated), however it will not be able to make use of any new SQL Server 2005 features. SQL-DMO will be available through a special ‘backward compatibility redist’ (filename = SQLServer2005_BC.msi) that will contain various other components besides SQL-DMO….


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 case Capture Mode comes in handy. This…


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 of adjective and noun to indicate bewilderment). For people who, unlike me,…



Q: With which SQL Server versions is SMO compatible?A: SQL Server 2000, and SQL Server 2005. Q: Is there going to be a redist for SMO?A: Yes, is a combined redist that contains, SMO, RMO, AMO. NMO, DTS Runtime. This is downloadable from the web: http://www.microsoft.com/downloads/details.aspx?FamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC. File name is SQLServer2005_XMO.msi (and there are 64 bit…


Index for SQL Server related articles

I’m starting to post articles around SMO and other topics, like WMI, SQLCMD, and other areas. This index will be helpful to get quick access to these posts. Hope you like the posts. If you do (or don’t), please let me know! SMO and DMO Tuning your SMO Application Part 1 Tuning your SMO Application…