Fatih'in Notları

     I my database on Sql Server 2005, I have to change schema names from some username to dbo and I wrote the following sql statements which simply generates alter queries. All you have to do is to change 'Username Here' to actual username, it will generates alter queries for you and then just copy and execute them in query window.

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + p.Name FROM sys.Procedures p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = 'Username Here'

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + t.Name FROM sys.Tables t INNER JOIN
sys.Schemas s on t.schema_id = s.schema_id WHERE s.Name = 'Username Here'

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + v.Name FROM sys.Views v INNER JOIN
sys.Schemas s on v.schema_id = s.schema_id WHERE s.Name = 'Username Here'

English, Misc misc

Some Useful CheatSheet Links:

• .NET Format String Quick Reference [PDF]
• ASP.NET 2.0 Page Life Cycle & Common Events [PDF]
• Visual Studio 2005 Built-in Code Snippets (C#) [PDF]
• ASP.NET Page Life Cycle Diagram [PNG]
• Visual Studio 2005 Default Keybindings C# | VB (PDF)
• Microsoft ASP.NET AJAX Library
• VB.NET/C# Comparison
• HTML Character Entities
• CSS
• JavaScript
• XHTML (PDF)
• Regular Expressions
• Microformats
• ASP/VBScript

English, Misc misc

Program yazarken çokta fazla koda takılmam; asıl olan mimarisidir bence (tabi unutkan olmamın da koda takılmamamda etkisi olabilir ) Bir programı yazmaya başlarken ilk yaptığım benzer örnekleri incelemektir. Bu sayede benden önce edinilmiş olan deneyimleri görmüş olurum, deyim yerindeyse amerikayı tekrar keşfetmem. Google geliştiricileri de benim gibi düşünüyor olacak ki kod arama motorunu açmışlar  http://www.google.com/codesearch adresinde bulabileceğiniz bu arama motoru ile düzenli ifadeler (RegEx) kullanarak verilen desene uyan dosya ve klasörler içerisinde veya belirtilen programlama diline ait olan kaynak kodları içerisinde büyük/küçük harf duyarlı/duyarsız olarak kod örneği arayabilirsiniz. Hatta bu aramayı GPL, LGPL v.b. lisans türündeki kodlar üzerinde yapabilirsiniz.

    Oldukça faydalı, sizce de öyle değil mi!

Türkçe, Misc çeşitli

Microsoft has been started beta version of CodePlex, another open source project portal  after gotdotnet; but that one supported with aspx and team foundation server.

    Here is the discription of site with their own word : "CodePlex is an online software development environment for open and shared source developers to create, host and manage projects throughout the project lifecycle. It has been written from the ground up in C# using .NET 2.0 technology with Team Foundation Server on the back end. CodePlex is open to the public free of charge."

    Yo can visit web site at http://www.codeplex.com

English, Misc misc

On your start menu click on run and type Regedit on run dialog, this will open registery editor. Then browse to HKEY_CURRENT_USER \ Software \ Policies \ Microsoft \ Internet Explorer \ Control Panel (If path doesn't exist, you may create it yourself). Within that key you may enable any restriction you want, all you have to do is to add value of 1 as value (delete that entry to disable that restriction)

English, Misc misc