Simons SQL Blog : Samples

Using SMO from TSQL

simonsabin — Tue, 08 May 2007 11:51:42 GMT

If you are desperate to get your hands on the code I used in the SMO in TSQL demo I did at the usergroup meeting you can download it now from codeplex.

http://www.codeplex.com/SMOinTSQL

There are 2 projects in there one an SSMS project and one a C# project. Both can be opened using the TFS in codeplex. Or you can just download the code.

The instructions are non-existent at the moment but I am sure you can figure it out.

I am going to be posting my demo code to codeplex, if you are interested in contributing let me know and I will give you rights.

http://www.sqlskills.com/blogs/bobb/2007/03/13/TwoThingsYouCantDoInSQLCLR.aspx

SQL Server Samples are now live on Codeplex

simonsabin — Thu, 22 Mar 2007 20:36:22 GMT

Microsoft are in the process of retiring GotDotNet and replacing it with CodePlex.

CodePlex is a shared source website which allows you to upload projects and give access to other people to view/maintain.

The great feature is that it is using Team Foundation Server. This means that any one using Visual Studio with a Team suite client license can have full access to the Team foundation server. This is all done over HTTP.

A big step has been made by the SQL Server team in putting the samples on CodePlex (Thanks Ed) Whilst you can't have access to modify the source you can access all the component parts of the samples. This means you don't have to download all the samples to get the sample you want, and even better you don't have to download a complete sample you can access individual files, i.e. scripts, read me files, word documents etc.

So go and have a look http://www.codeplex.com/SqlServerSamples

This site also acts as a starting point for looking for other SQL Samples provided by the community.

SQL Server 2005 Samples - Where is the samplekey.snk

simonsabin — Fri, 05 Jan 2007 18:12:38 GMT

Did you know that whilst the samples are included on the install of SQL Server as with books online the most upto date versions can be found online.

Download details: SQL Server 2005 Samples and Sample Databases

Some of these samples include the source code for programs. these often require a key file to function. The file is not included in the install and so you have to create one. This can be done simply by issuing the following at the comman line.

sn -k C:\Program Files\Microsoft SQL Server\90\Samples\samplekey.snk

(assuming that you have installed the camples to the default location)

Here is some more information you need to know about the samples

http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/GettingStartedWithSQLSamples.htm