John Papa [MVP C#]

.NET Code Samples, Data Access, and Other Musings

May 2007 - Posts

Using SMO for DDL with SQL Server

My June 2007 Data Points column has been posted to the MSDN Magazine web site. This edition is titled "SQL Server Management Objects".

Here is an excerpt from the article:

"Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition Language (DDL) commands. Using SQL SMO you can also connect to SQL Server, iterate through a collection of database objects and perform a variety of tasks against them.

In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks. Specifically, I cover topics such as how to design your project to use SMO and how to connect to a server. I also walk through a sample application that issues DDL or Data Manipulation Language (DML) commands against the database. Finally, I demonstrate how to use SMO to perform database backups, restores, and backup verification."

Posted May 25 2007, 10:48 AM by John Papa with 2 comment(s)

Filed under: SQL

Want Some Exposure? Write for angryCoder.com

My boss, Jonathon Goodyear, has just relaunched his online web site http://www.angrycoder.com/ that promotes technical articles and forums. If any of you are interested in adding to your exposure you can create an account on angrycoder.com, create a profile, and submit some articles. The site still gets tons of hits/activity as it is one of the first ASP.NET driven eZines on the internet.

Anyway, if you are interested take a look at www.angrycoder.com.

Posted May 18 2007, 02:12 PM by John Papa with no comments

Last Wish of a Child

There is a boy, Shane, in a school local to my home town. Shane is dying of cancer and is part of "Make a Wish". When Make a Wish asked him his wish Shane said he would like 1 million birthday cards for his 8^th birthday on May 30^th. There is a large effort underway by means of word of mouth to fufill Shane's birthday wish. If you can spare a moment, please fill out a birthday card for Shane and send it to his school at the following address. Ms Dunkel will make sure they get to Shane.

Judi Dunkel
c/o Schuylerville Elementary School
14 Spring Street
Schuylerville, NY 12871

We all dream that we can make a difference in someone's life. Sometimes it seems impossible that we can make any difference at all alone. But if we pull together, imagine what we can do.

Posted May 14 2007, 11:28 PM by John Papa with 2 comment(s)

Filed under: Random Stuff

Code to Gather RSS Feeds

I recently wrote an article for SimpleTalk.com titled Gathering RSS Feeds Using Visual Studio and RSS.NET. The article is now online and available to read. Here is the abstract for this article:

Integrating RSS feeds into applications has become very popular. There are several tools (such as Microsoft Outlook 2007) available to read blogs and news from RSS feeds. There are also some tools available (such as RSS.NET and the ASP.NET team's RSS Toolkit) that can aid you in the development of customizing feeds in your applications. This article will use the RSS.NET assembly, which can be freely downloaded and used from http://www.rssdotnet.com/.

For those who are not familiar with SimpleTalk, it is a web site that publishes articles on various technology topics. The site is operated by Red Gate Software, which has some popular database tools that many of us use.