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…

2

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,…

2

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,…


DMO FAQ

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….

10