Every so often, I have to do database administration activities, like restore a database (typically a DotNetNuke database downloaded from a hosted site).

I know the details are in the SQL BOL, but I usually have to hunt for them. Pinal Dave's site comes to the rescue with a good abbreviated rundown of the RESTORE commands.

Pinal Dave's site is packed with lots of useful database information and I would highly recommend it to up and coming DBAs. He is a regular columnist for SQL Server Magazine.

 

Well, I finally have deposited my source code from the Nova CodeCamp presentation on SQL CLR here on my blog.

 

I apologize for taking so long. I needed to update some of the code and strip out any source code control references.

 

SQLCLRUDA.Zip (29.89 KB)

 

My presentation slides can be found in a blog entry below.

Here is a little commentary that I dispensed at my recent Nova CodeCamp presentation with regards to user defined aggregates written using SQL CLR for the Microsoft SQL Server. SQL 2008 has improved the user defined aggregate feature, but it currently comes at a price. First I discuss the attribute setting to implement the feature, then I provide necessary information on how to deploy it!

 

For those developers building user defined aggregates (UDA) in SQL Server 2008, you now can build an aggregate that exceeds the 8000 byte limitation in SQL Server 2005.

 

To implement this feature, you set the MaxByteSize to -1. This will allow the UDA to grow to a size above 8000 bytes up to 2 GB. An example of the attribute setting is shown below.

 

 

Great so far. Now here is where the problem starts. You cannot deploy an assembly with a UDA having this setting from within Visual Studio 2008. You have to deploy the assembly manually.

If you attempt to deploy the UDA with the above attribute, you will get the following message:

 

Error: 'MaxByteSize' property specified was not found.

 

You can find information on MSDN about the MaxByteSize setting here.

 

http://www.novacodecamp.org/

Here is my presentation from the Nova CodeCamp held on December 6th in Reson, Virginia.

Dec 2008 Nova CodeCamp.pptx (198.08 KB)

Error when installing SQL Server 2008 Adventureworks database sample. If you download the install package from CodePlex, you may get an error when you attempt to install the database due to Filestream access not being set properly.

On Saturday, March 29th, software developers from around the Metro DC area met to listen to presentations by over a dozen software experts. The presentations included a range of topics from new technologies being released by Microsoft to practices to improve quality and delivery management.

This event was free to the public and was hosted by Strayer University in Woodbridge, Virginia. Attendance was over 80, with some attendees coming from as far away as York County.

John Morales at Nova CodeCamp Event discussing AJAX Development

Jeff Schoolcraft and I coordinated this event, but it was the volunteers and speakers that donated their time that made this event a success. We were fortunate to receive sponsorship from several companies and organizations.

You can find out more about Nova CodeCamp at www.novacodecamp.org.

Working with Microsoft MVP, Jeff Schoolcraft, we have organized a wonderful developer learning event on Saturday, March 29th at Strayer University in Woodbridge, Va.

CodeCamp SOUTH

Speakers include:

• Brian Noyes, Microsoft MVP
• Jonathan Cogley, Microsoft MVP
• Sahil Malik, Microsoft MVP
• Frank LaVigne, Microsoft MVP
• Antonio Chagoury, DotNetNuke Team Lead

and many more.

Topics to be covered include a host of new technologies along with some introductory courses. Here is a sample (you can see the rest at the NovaCodeCamp site).

• Visual Studio 2008
• SQL Server 2008
• SharePoint 2007
• DotNetNuke Module Development
• Office 2007 Development
• Service Oriented Architecture (SOA) Development
• Ajax
• Silverlight

For you developers, this is a golden opportunity to see presentations that would typically be presented at high priced conferences like Microsoft TechEd and VSLive. And it is FREE. However, registration is limited to the first 100 that sing up - so make your reservation today!