Vote for Telerik in Windows IT Pro Community Choice Awards

Another day, another online "community choice" awards competition. Like 'em or hate 'em, many people- especially those new to .NET- do rely on the results of these awards to try to figure which companies to pick to help them with their development. You, the experienced .NET developer already familiar with Telerik, obviously don't need community awards to tell you that Telerik's tools and support are industry leading, so this is your chance to help us tell others new to Telerik.

The "finalist" voting for the 2009 Windows IT Pro Community Choice Awards is open now through September 16th, but it's always best to vote right now or else you- like me- will forget. And since Windows IT Pro is not just for developers, there are a lot of categories in this voting you can ignore (if you're looking to save some time) where Telerik is not "competing." All we ask is for your votes in these categories:

• (#5)Best Business Intelligence & Reporting Product: Telerik Reporting
• (#10)Best Development Tool: Telerik RadControls
• (#27)Best Sharepoint Tool: Telerik RadControls for ASP.NET AJAX and Sharepoint
• (#30)Best Training & Certification Service: Falafel Software Online & Onsite Training
• (#32)Best Free or Open Source IT Tool: Telerik WebAii Framework
• (#33)Best Vendor Tech Support: Telerik!!

We've got some stiff competition in some of these categories- like competing against iTunes as the best free "IT Tool"- so we definitely appreciate each and every one of your votes. If you enjoy your Telerik tools and you appreciate the great work of the Telerik Support Team, take 15 seconds and vote now!

Vote in the 2009 Windows IT Pro Community Choice Awards

Service Pack 1 for Q2 2009 Telerik ASP.NET controls now available

If you missed the Q2 2009 release of the RadControls for ASP.NET AJAX, you really missed a good one. Not only did the release feature serveral brand new controls (Captcha, ListBox, BinaryImage, XmlHttpPanel) and tons of feature improvements (like client-side web service binding in RadScheduler), it also featured very few bugs!

A major release always tries to be as "bug free" as possible, but some bugs are a reality in all large software projects. For many major releases, Telerik will ship a "SP1" within 2 to 3 weeks of the release to address all reported issues and fix any major "release bugs." But with Q2 2009, there simply were not a lot of "critical" bugs! So here we are, about 7 weeks after the official release, with a service pack loaded with small improvements and tweaks for all RadControls.

Since so much time has passed since Q2, this really is a bigger than usual SP release. The release notes are a mile long, but I encourage you to browse through them to fully understand what's shipping. One thing you will not find in these release notes: breaking changes. There are none, as there never should be for a SP release!

If you're not interested in studying the notes for yourself, here are some of my favorite Q2 2009 SP1 build highlights:

• [VS Extensions] Full support for Visual Studio 2010 Beta 1, including new VS "code shortcuts"
• New "Copy" functionality in RadFileExplorer (hold Cntl + drag to copy item)
• Improved client-side API for web service binding with RadScheduler
• New RTL support in RadSplitter
• Over 20 fixes and improvements for RadEditor - including fix for "the Firefox break tag"
• Over 20 fixes and improvements for RadGrid
• Over 20 fixes and improvements for RadScheduler

The fixes in RadScheduler and RadEditor are going to benefit some of my projects right away, and I hope they do they same for you. There is no planned "SP2" for this release cycle, so enjoy the SP1 bits and then stay tuned for previews of our Q3 2009 bits in about a month!

Read release notes for Q2 2009 SP1 (2009.2.826)

Sitefinity now in Microsoft Web Platform Installer

The Web Platform Installer from Microsoft is a cool little "installation bootstrapper" that makes it very easy to install many .NET platforms and tools- both from Microsoft and 3rd party- with a few clicks of a button. It's a free tool and it's sole purpose is really just that: make it dead simple to install and configure .NET developer software. I use the Web PI (as it's called) almost elusively these days to install software like SQL Server 2008 Express, SQL Server Management Studio, ASP.NET MVC, and other Microsoft platform components. In fact, I've got the Web PI running right now on two new VMs installing fresh copies of SQL Server 2008. A new option has recently been added to the installer, though, and you can now install Telerik's Sitefinity Community Edition directly from the Web PI (right along with your other Microsoft software)! Sitefinity CE is available at no charge to the .NET community and can be used for both hobby and commercial websites. As part of the WPI, it will now be easier than ever to install and use Sitefinity for all your .NET CMS needs. Not easy enough for you? Sitefinity Evangelist Gabe Sumner has gone a step further and actually prepared a video showing you exactly how to use the new WPI feature. So, no more excuses. Give the WPI a try and install Sitefinity this weekend!

Register now for DevReach 2009, Save 15%

Have you ever wished you could go to a conference that had all the "big name" speakers from PDC and TechEd, but in a format where you could actually meet and hang-out with them? Then you probably want to make sure Bulgaria is in your travel plans this October, because the 4th Annual DevReach conference allows you to do just that. Telerik, in partnership with Kulov.net, is hosting another premiere event in Sofia, Bulgaria (home to Telerik's headquarters and all-around beautiful city in Eastern Europe) this October 12th and 13th. For less than $200, you get a 2-day conference pass to come learn from speakers like:

• Chris Sells, PM for Business Platforms at MSFT
• Richard Campbell, (does he need introduction?) .NET "rockstar"
• Kent Alstead, ASP.NET MVP & .NET genius
• Lino Tadros, CEO Falafel & .NET stand-up comedian
• Shawn Wildermuth, C# MVP & Silverlight trainer extraordinaire
• And on the list goes...

There really is no better value in .NET conferences anywhere in the world. And as if the price wasn't good enough at 120 eur ($170), if you register before September 15th, you save an additional 15%! As John Kellar might say, for the price of 2 or 3 books, you get face time for two days with all the authors. If you're in Eastern Europe (or Europe in general), you have no excuse. You need to find your way to DevReach. It will be the perfect way to have the PDC experience without making the long trip to LA. If you're not in Europe, you still don't have much excuse. Haven't you always wanted to visit a new country? I guarantee you'll have no better time visiting a new country than if you do it for DevReach in Bulgaria. In fact, if you make the trek from the US to DevReach, let me know, and I will personally show you around the city (with a little help from Telerik, of course!). So there you have it. DevReach 2009. October 12th and 13th. I will be your personal tour guide if you come. What more do you want? (Okay, I know there are lots of things you probably want more, but that's the best I can offer...) Register today to save your spot (space is limited) and get your discount. SIDE NOTE TO U.S. TRAVELERS: With the money you save (especially compared to the registration fee for other conferences), you can easily afford the flight. It's not as expensive as you might think. Round-trip from Texas right now is about $900 (with tax). So, flight + conference ticket still is less than the price of admission alone to PDC ($1600)! See you in Sofia.

Weekly Webinars resume tomorrow with Silverlight 3

Have you been missing your weekly dose of new, live Telerik webinar content? After a brief hiatus to let the Q2 2009 Release settle-in, and some time-off to accommodate everyone's summer R&R, it's time to get the Telerik Weekly Webinars back in gear. Getting things started tomorrow is Telerik DE Evan Hutnick who will be doing a new webinar on using the RadControls for Silverlight in Silverlight 3. Evan will explore the use of new Silverlight features, like validation, .NET RIA Services, and Out-of-browser apps, with the Telerik RadControls. (If you missed the announcement in the ASP.NET MVC excitement, Telerik officially shipped support for Silverlight 3 a few weeks ago.) Clear your morning and register now for this free event. As usual, the webinar will be this Thursday, August 27th (tomorrow!) at 11:00 AM Eastern. The event will also be recorded and uploaded to Telerik TV for on-demand viewing. Enjoy the webinar and stay tuned for next week's webinar details, where once again I will be your humble host. Register for free Telerik Silverlight developer webinar

TechPath shows-off use of Telerik Silverlight on Telerik TV

For those of you that enjoy seeing "real world" uses of the Telerik RadControls (and, really, who doesn't?), there is a freshly minted Telerik Real World episode now on Telerik TV. In this episode, Michael Petersen from TechPath and Jake Winett from Microsoft show-off a very cool (and very complex) reference application that TechPath built for Microsoft. The application was originally premiered at the NAB 2009 conference, and it represents a push by Microsoft to show how all of its technologies can be combined to create an efficent media workflow.

TechPath turned to Telerik to help deliver the rich UI that this application called for, specifically using the RadControls for Silverlight. TechPath had 8 weeks (!) to build and deliver version one of this application for NAB, so they needed UI components that were easy to use, easy to learn, and provided all of the powerful features they needed out-of-the-box. Check-out the video to see how TechPath used the RadControls for Silverlight to deliver their solution on time and then stay tuned for more great Telerik Real World episodes.

Watch TechPath Real World video on Telerik TV in full resolution

Making the most of Telerik support resources (update)

Have you ever asked yourself, "Where do I get help for finding help?" It's a question along the lines of who cuts my barber's hair? One of life's little quandaries. Fortunately, when it comes to Telerik support, you now have a new resoruce to "help you find help" in the form of a new video on Telerik TV (embedded above).

And this is not just for "n00bs." Sure, the information is basic, but it's very easy for you to overlook one of Telerik's many sources of information and knowledge when hunting answers if you've not recently acquainted yourself with all we have to offer. There are more than 10 unique types of "support" Telerik offers to help you with our tools and controls:

• Blogs
• Forums
• KB Articles
• Online Docs
• Videos
• Interactive Tutorials
• Code Library
• Online Demos
• Learning Guides
• Visual Studio Extensions
• Consulting
• And...Support Tickets!
• [UPDATE: I forgot to mention Training, too!]

Why so many types of support resources? Because we know that everyone learns in a different way, and we want to make sure no matter your learning style, we've got resources that help you get the job done with Telerik. Check out the video for more information and demos of some of Telerik's support options.

And don't forget...

If you have a Telerik question, your first stop for answers should always be telerik.com/support.

Watch video on Telerik TV in full resolution

Telerik Watch Minute: Silverlight 3 and Extensions for ASP.NET MVC

Building on yesterday's announcement of the new Telerik Extensions for ASP.NET MVC, this quick (about 7 minute) Telerik Watch Minute is another chance for you to learn about Telerik's newest product and hear answers to some of your more common questions. Of course, you can get many of these answers in the "unofficial FAQs" I've posted, but if you prefer to hear answers instead of reading them (or you just want some reinforcement), take a few minutes to watch this "news only" video. I've also tossed-in a quick introduction to another big Telerik announcement from yesterday that got buried in the ASP.NET MVC excitement- Telerik has released it's "official" support for the Silverlight 3 platform. Get the details in the video embedded above an enjoy another TWM. Watch this Telerik Watch Minute on Telerik TV (full resolution)

Telerik Extensions for ASP.NET MVC Unofficial FAQs (updated)

With the introduction of our brand new Telerik Extensions for ASP.NET MVC, I know there are a lot of questions in the community about this new product. New products always generate questions, but when you factor in the CTP nature of this release and the fact that this is Telerik's first open source product, the questions abound. To help ensure you get answers to all of your burning questions, I've compiled some answers to the most common questions I'm seeing (or expect to see) in the community. The "unofficial FAQs." If you have a question not answered, be sure to add it to the comments and I'll update the post with an answer (if I can). Telerik Extensions for ASP.NET MVC Unofficial FAQs Q: Why did Telerik build these extensions? ASP.NET MVC represents a very different way of building standards-based websites with .NET, and Telerik recognized that the current efforts to provide UI "components" for MVC were not fully embracing the principles of the platform. Telerik is providing a UI Extension framework for deploying reusable UI components in MVC views that is purpose built for the ASP.NET MVC platform- no postbacks, no Viewstate, no page life cycle. These new UI extensions will finally give MVC developers more productivity while creating views without sacrificing the concepts (like testability, clean HTML, SoC) that make MVC an important step forward for ASP.NET developers. Continue reading Telerik Extension Unofficial FAQs Q: Is Telerik transitioning to ASP.NET MVC? How does this affect the future of WebForms components? Definitely not! Just as Microsoft makes clear with the ASP.NET MVC framework, MVC is an option, not a replacement for ASP.NET WebForms. Telerik remains fully committed to the RadControls for ASP.NET AJAX and has a great road map of planned features for those controls. We are offering the Extensions for MVC for those developers that have decided to use MVC and want a more productive way to create rich views with .NET. Q: Are the Telerik Extensions really open source? Yes! In fact, they're licensed with the same OSI-approved license that covers the ASP.NET MVC framework- the Microsoft Public License (MS-PL). This is one of the simplest open source licenses out there, and one of the most "open." You are free to use the Telerik Extensions in any open source or commercial product. Q: What if I want support? What do I do if my company doesn't allow open source software? Telerik will make a commercial license for the Telerik Extensions available with the official release. This license will include Telerik's "legendary" dedicated support and it will make it possible for you to use the Extensions in an environment where open source software is hard to get approved. Pricing and additional commercial license details are not available at this time. Q: What's so special about the Telerik Extensions for ASP.NET MVC? How are they different from other UI components for MVC? The Telerik Extensions are the first UI "components" natively built for MVC. These are not "ports" of WebForms controls. Many of the solutions for MVC you see available today are trying to cram the WebForms model (or some hybrid version of it) in to MVC. The Telerik Extensions are built from scratch to embrace ASP.NET MVC. The Extensions are designed to easily work with MVC controllers and they render lightweight, clean HTML. They also work with any ASP.NET MVC view engine! Q: What are these wrappers for jQueryUI? Why would I use them? For this CTP release, we did not have time to begin building custom UI rendering on top of our new UI Extension framework. To show-off the framework's power, though, we created wrappers for several jQueryUI components. These wrappers demonstrate how the server-side API works and give you a sense for how our "homegrown" components will work in the official release. The wrappers are also open source and you can use them to gain a native .NET approach for adding jQueryUI components to your MVC views. Q: Will the jQuery wrappers be updated in the future? Will you cover more controls? Not by Telerik. These wrappers are "proofs of concept" designed to show-off the framework. Their source will be published and we encourage the community to adopt and enhance the wrappers to make jQueryUI as accessible as possible to MVC developers. Future releases of the Telerik Extensions will feature new UI components not built on jQueryUI. Q: When will we see Telerik components built-on the Extensions framework? In our next release, you will begin to see new, homegrown components added to the Telerik Extensions for ASP.NET MVC. Our plans are to start with three components for the first release: Grid, Menu, and TabStrip. These UI components will more closely match the skins of the existing RadControls for ASP.NET AJAX and will offer more rich functionality that Telerik customer's expect. Q: Wait! Telerik is building a TabStrip? I thought there was already a Tab component in the CTP?! True, but remember that the CTP components are simply previews of the framework's power. The components themselves are jQueryUI components, not custom designed Telerik UI Extensions. The CTP wrappers are not considered components in the official release of the Telerik Extensions. Custom-built Telerik UI Extensions not based on jQueryUI will be built for all MVC components, including TabStrip. Q: Will the Telerik components be based on ASP.NET AJAX? Will they use the same rendering as the WebForms controls? No on both accounts. The Telerik Extensions for ASP.NET MVC will be built on jQuery, the popular JavaScript library supported (officially) by Microsoft. The new UI Extensions will have a brand new HTML rendering model that is a clean as possible and that exclusively leverages jQuery on the client. The skins will be crafted to look identical to the skins for the RadControls for ASP.NET AJAX (for consistency), but the renderings will be different. We are working hard to leave as much control as possible in the developer's hands over what gets rendered to the page. Q: Can I use the Telerik Extensions in multiple ASP.NET MVC View Engines? Absolutely! Since these UI Extensions are built from the ground-up to support ASP.NET MVC, they are fully desiged to work with any ASP.NET MVC View Engine. In fact, the downloads on Telerik.com include two sample projects showing the Telerik Extensions used in the Spark and NHaml MVC view engines, in addition to the default ASPX view engine. Q: Where can I download the Telerik Extensions for ASP.NET MVC? You can download the source, binaries, sample projects, and documentation from Telerik.com. The complete source (and the source only) is also published on CodePlex. You can submit contributions through CodePlex if you want to help extend this open source project. Q: I don't see the MVC download in my Telerik.com account. How do I get it? If you do not see the download for the Telerik Extensions for ASP.NET MVC on your downloads page on Telerik.com, it means you have not yet accepted the "community license" for this download. Simply accept the license and the download link will be added to your list of available Telerik downloads. Q: Where can I offer my 2 cents on these new Extensions? There are official forums on Telerik.com dedicated to the Telerik Extensions for ASP.NET MVC. We are eager to hear your feedback and get your suggestions as we start the push towards the first official release of this product. Speak now or...speak later. But we'd prefer you speak-up early and often! Q: What's next for the Telerik Extensions for ASP.NET MVC? We are now turning our full attention to building the first three UI Extensions that will be part of the official release this fall. There will be at least one more preview release before the first version ships, and that will be your first chance to see some of the Telerik Extensions in action. Stay tuned to Telerik Watch and the Telerik Blogs for updates.

New Telerik ASP.NET MVC UI Extensions CTP launched today

Ready for some big news? If you're on Twitter then you've probably already seen this announcement (hint, hint), but I know from surveys that many of you are not in to the whole "Twitter-thing" (and I don't blame you). So, on to the news... Today Telerik announced (and released) the brand new Telerik Extensions for ASP.NET MVC, a completely open source and purpose built UI "component" suite for MVC. The announcement of this new product is significant for (at least) two reasons:

1. This is the first UI "component" approach built natively for ASP.NET MVC. These are not WebForms controls "hacked" or "squeezed" in to an MVC environment. This is a brand new UI Extension framework that fully embraces the values of ASP.NET MVC - lightweight rendering, clean HTML IDs, clear separation of concerns, easy testability, etc.- while helping make you more productive building MVC views. Our UI Extensions will work in any ASP.NET MVC View Engine, too, and the downloadable samples include projects using both Spark and NHaml.
2. This is Telerik's first open source product. As a small commercial company, it's obviously a big step to introduce a truly open source product. We have a strong desire to support the ASP.NET MVC community, though, and we know open platforms are important to many MVC developers. The source for the Telerik Extensions for ASP.NET MVC will be hosted on CodePlex (binaries on Telerik.com) and licensed under the Microsoft Public License (MS-PL) - the same license that governs the ASP.NET MVC framework. That means these UI Extensions are 100% free to use, modify, and do with what you please.

This first release is a CTP and only a preview of the power of the underlying UI Extension framework. To show-off the framework, we have included wrappers for some of the jQueryUI client-side components. These wrappers are "proofs-of-concept" meant only to highlight the framework's approach to defining UI in MVC, and in our next release you'll start to see new, custom-built Telerik UI Extensions, like Grid, Menu, and TabStrip. For now, be sure to read the full announcement post by Team Lead Atanas Korchev for all the important details and then jump-over to Telerik.com to download the CTP bits. We hope you enjoy this new open source product from Telerik and we look forward to hearing your feedback!

Audio transcript of Advanced OpenAccess ORM Interview now available

We don't usually make audio transcripts for Telerik TV videos available. There is no easy, automated way to do that (yet). But for the recent Advanced OpenAccess ORM Question and Answers interview with Team Lead Jan Blessenohl and Telerik CSO / Microsoft RD Stephen Forte, we made the extra effort to produce a complete transcript of the conversation. The interview contains lots of good information about OpenAccess, including:

• How mature is OpenAccess ORM?
• How does OpenAccess compare to Entity Framework?
• How does the future of LINQ impact Open Access?
• How do the new "advanced" features in the Q2 OpenAccess release work?
• How does the learning curve of OpenAccess compare to NHibernate?
• And, of course, what is the future of OpenAccess ORM?

So now in addition to our conversation, you can easily browse the content of what was said in the transcribed PDF. We hope this resource helps everyone access the information shared in this 50 minute discussion and we hope it helps you better understand OpenAccess ORM. (By the way, if anyone can type fast what they hear and wants to print money, go in to transcribing technical videos! Your competition is weak...) Download video transcript [PDF]

WinForms, Reporting Q2 2009 service packs now available

The first two service packs from the Q2 2009 release are now available for immediate download. The RadControls for WinForms and Telerik Reporting have each been updated to SP1 and these service packs are heavy hitters. Each delivers some compelling improvements (beyond bug fixes) to the suites and each is worth extra consideration even if you’re not dealing with any bugs. Highlights:

RadControls for WinForms (2009.2.9.729)

• 5 NEW events in RadDock, many new properties (giving you more control)
• New DocumentManager in RadDock (makes it easier to manage, manipulate Documents)
• New CommandManager in RadDock (register your own keyboard shortcuts)
• 8 NEW events in DragDropService, new properties
• 50+ bug fixes across all controls

There are 2 breaking changes, one in RadScheduler, one in RadTreeView. The TreeView change will not effect you immediately- it is simply a obsolete property that will be removed in Q3. The Scheduler change, though, is breaking. See the release notes for details.

Telerik Reporting (3.1.9.807)

• NEW! Medium Trust support (big improvement for shared environments)
• NEW support for hyperlinks in HtmlTextBox item (beginning of drill-down report support)
• Bug fixes in rendering, report viewers
• 15 bug fixes / improvements to Visual Studio design-time

The SP1s for the other suites are coming soon. The XAML service pack will likely ship next week and the ASP.NET SP will ship later this month. Also, for Q2 2009, we don’t expect to ship a second round of SPs. We were proud to find that our Q2 2009 release was very high quality, and the current SP round should address all reported issues. Make sure you use the Latest Internal Build tool to grab a hotfix if you need it between SP1 and Q3 2009 – which is now only about 3 months away!

Code: SQL script for dropping all Sitefinity objects

I don’t often post code snippets on Telerik Watch. I tend to save posts like that for the official Telerik Blogs or my more general Code Campground blog. But today I’ll make an exception since my snippet is covering a topic I rarely get to cover these days: Telerik Sitefinity CMS. I used to spend more time covering Sitefinity on Telerik Watch, but as that platform has grown and become increasingly popular (and powerful), I’ve let the experts (like Sitefinity Evangelist Gabe Sumner) bring you the regular news, updates, and snippets.

Today I faced the challenge of upgrading an old Sitefinity site (v3.0 – used by my wife for her class website) to the latest and greatest v3.6 SP2. Like a new OS install, I wanted to start with a “clean slate” instead of trying to work through an upgrade, and to do that I needed to remove all Sitefinity v3.0 objects from my SQL Server database.

Should be easy, but I’ve got a couple of challenges I’m sure some of you face:

• My SQL Server is hosted, meaning I don’t have complete control over the server to drop and recreate entire databases
• More significantly, this database is hosting tables for multiple applications- not just Sitefinity. I need to leave my other DB objects in-tact and only remove my Sitefinity-specific objects.

To solve my problem, I need a SQL script that will go through my database and delete all Sitefinity tables, stored procedures, and relationships. Thankfully, Sitefinity prefixes all of the objects it creates with either “sf_” or “telerik_”, so we can us that fact to create a script that will delete all objects that meet our prefix search criteria.

Continue reading to see SQL solution

Based on a helpful “generic” script on Paige Cook’s blog, the following script can be used delete all (and only) Sitefinity objects in a SQL Server database:

-- Drop all Sitefinity stored procs
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0
   AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
WHILE @name is not null
BEGIN
   SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
   EXEC (@SQL)
   PRINT 'Dropped Procedure: ' + @name
   SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0
       AND [name] > @name AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
END
GO

-- Drop any Sitefintiy views (none in current default install)
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0
   AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
   SELECT @SQL = 'DROP VIEW [dbo].[' + RTRIM(@name) +']'
   EXEC (@SQL)
   PRINT 'Dropped View: ' + @name
   SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0
       AND [name] > @name AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
END
GO


-- Drop any Sitefinity functions (none in current default install) 
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT')
   AND category = 0 AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
   SELECT @SQL = 'DROP FUNCTION [dbo].[' + RTRIM(@name) +']'
   EXEC (@SQL)
   PRINT 'Dropped Function: ' + @name
   SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT')
       AND category = 0 AND [name] > @name AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
END
GO

-- Drop all Sitefinity Foreign Key constraints 
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
   WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY'
   AND (TABLE_NAME LIKE 'sf_%' OR TABLE_NAME LIKE 'telerik_%') ORDER BY TABLE_NAME)
WHILE @name is not null
BEGIN
   SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
       WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY'
       AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
   WHILE @constraint IS NOT NULL
   BEGIN
       SELECT @SQL = 'ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT ' + RTRIM(@constraint)
       EXEC (@SQL)
       PRINT 'Dropped FK Constraint: ' + @constraint + ' on ' + @name
       SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
           WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY'
           AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
   END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
   WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY'
   AND (TABLE_NAME LIKE 'sf_%' OR TABLE_NAME LIKE 'telerik_%') ORDER BY TABLE_NAME)
END
GO

-- Drop all Sitefinity Primary Key constraints 
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
   WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY'
   AND (TABLE_NAME LIKE 'sf_%' OR TABLE_NAME LIKE 'telerik_%') ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
   SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
       WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY'
       AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
   WHILE @constraint is not null
   BEGIN
       SELECT @SQL = 'ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT ' + RTRIM(@constraint)
       EXEC (@SQL)
       PRINT 'Dropped PK Constraint: ' + @constraint + ' on ' + @name
       SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
           WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY'
           AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
   END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
   WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY'
   AND (TABLE_NAME LIKE 'sf_%' OR TABLE_NAME LIKE 'telerik_%') ORDER BY TABLE_NAME)
END
GO

-- Drop all Sitefinity tables
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0
   AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
   SELECT @SQL = 'DROP TABLE [dbo].[' + RTRIM(@name) +']'
   EXEC (@SQL)
   PRINT 'Dropped Table: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0
   AND [name] > @name AND ([name] LIKE 'sf_%' OR [name] LIKE 'telerik_%') ORDER BY [name])
END
GO

When this runs it will delete about 670 objects from your database, printing the name of each dropped object to the query output window. If you refresh your objects and still see Sitefinity objects in your database, just run the script a second time and that should fully clean your database. You now have a clean starting point to re-install Sitefinity in your database, and you’ve done your cleaning without touching any of your other, non-Sitefinity database objects. Hope this helps!