-- the following line sets the database to "Single User" mode
ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-- the following line sets the new collation
ALTER DATABASE DBNAME COLLATE COLLATIONNAME
-- the following line sets the database back to "Multi User" mode
ALTER DATABASE DBNAME SET MULTI_USER

DBNAME: Database name
COLLATIONNAME: New collation’s name. E.g.: Latin1_General_CI_AI

“A program that offers visibility, support and software for professional Web Developers and Designers”

Have you heard of Microsoft WebsiteSpark yet? WebsiteSpark is a global program by Microsoft to support Web Developers and Designers. If your company has 10 or fewer employees, you are eligible to enroll to the program and you will get the following opportunities, services and software for free for next 3 years!

For design, development, testing and demonstration of new websites:

1. Visual Studio Professional
2. Expression Studio 2 or 3 (1 user)
3. Expression Web 2 or 3 (up to 2 users)
4. Windows Web Server 2008 or R2 (when available)
5. SQL Server 2008 Web Edition

For production use:

1. Windows Web Server 2008 R2 (when available)
2. SQL Server 2008 Web Edition

Fee: A USD $100 Program Offering Fee is due when the Web development and design company exits the Program. As part of Microsoft’s commitment to small Web development and design service companies’ long term success, there are no upfront costs for companies to join WebsiteSpark.

Only for USD $100, you get all these. Enjoy!

http://www.microsoft.com/web/websitespark/default.aspx

http://www.devreach.com/Event/Schedule.aspx

For further information, please follow Martin Kulov’s blog. The following is a quote from his blog.

It is less than two months when DevReach 2009 will happen again in Sofia, Bulgaria. This is the forth edition of the wonderful conference gathering so many internationally recognized Microsoft Regional Directors, MVPs, INETA and TechEd speakers.

The event will take place on 12-13^th of October, in Arena Cinema Mladost, Sofia. We have selected this place in order to allow even more attendees than the last year. However keep in mind that space is still limited and we are expecting even more people to come, so make sure to reserve your seat in good time.

More than 44 sessions presented by more than 20 speakers in not less than 22 hours overall experience spanning in 2 days and 4 tracks. Many new things are still to come in the schedule. They will be announced here very soon.

In a follow up series of posts on my blog, I will try to highlight some of the new speakers that are coming this year. I hope this will give you better idea of how we change the schedule every single year to accommodate your needs.

Meanwhile – do not miss the 20% discount until 15^th of September. Check Registration page for more information of different benefits and passes.

Since it is being deprecated, all clients using System.Data.OracleClient are expected to migrate their applications to use ODP.NET (Oracle Data Provider for .NET).

For further reading, please visit http://blogs.msdn.com/adonet/archive/2009/06/15/system-data-oracleclient-update.aspx.

Türkiye’nin de bir projesi olduğunu da hatırlatmak isterim.

Personally, I am really excited to see these features in VS 2010. It will definitely be better than FTP deployment because it will be able to handle a lot of scenarios like IIS settings, web.config changes depending on the environment (release, debug, staging, production, etc.), database changes, GAC, etc. If you want, you may go ahead and give it a try, it is a Beta 2 release though.

P.S.: Currently, only web application projects are supported. According to the team, they are considering to support web site projects and pre-compilation scenarios in the future.

You may read the complete post here.

Good news is that ASP.NET MVC’s final version will be released next month, in February 2009.

Some important changes might be listed as below.

• “Create Controller” action in Visual Studio context menu in Solution Explorer.
• “Add View” action in Visual Studio context menu inside an Action method’s body. This will let you create an empty View or a View that has been specially created for the type that is being passed as a parameter to the View. E.g.: return View(user) will create a basic View that has “user” entity’s type’s properties.
• Ability to customize any kind of templates being used by MVC using T4 (Text Template Transformation Toolkit) – further reading. Both machine-wide and project-wide!
• RC release now includes a out of the box MSBuild task so you can compile the views within your ASP.NET MVC project.
• Views can work without Code-Behind files. You can still use the advantages of strongly typed base type. E.g.: Inherits=”System.Web.Mvc.ViewPage<MyCustomType>”
• To access the Model’s data, you don’t need to use “ViewData.Model” anymore. “Model” is a top-level property from now on. “ViewData.Model” still works though.
• An out of the box MSBuild task is included in the setup if you want to compile the code within the views.
• You are not required to use Bind attribute with Prefix value set to an empty string [Bind(Prefix="")] by the default behavior.
• Supports protection to “Cross-site request forgery” attacks with an out of the box attribute: ValidateAntiForgeryToken. You may apply this attribute to the actions that you want to protect.
• FileResult (an out of the box ActionResult) to response a file instead of some other views using an action. Also there is the new File() method to create and return a file.

Visit http://www.asp.net/mvc for more details.