asp.net session SQL server kaydetmek

asp.net sessionları veri tabanına kaydetmek istersek C:\Windows\Microsoft.NET\Framework\version altından  aşağıdaki komutu çalıştırarak sql server session tutar hale getirebiliri.z

For Adding SQL mode session state
C:\ >aspnet_regsql -S localhost -U sa -P wrox -ssadd -sstype p
Start adding session state.
...........
Finished.
For Remove SQL mode session state
C:\ >aspnet_regsql -S localhost -U sa -P wrox -ssremove -sstype p
Start adding session state.
...........
Finished.
kullanılacak web.config satırı ise

<sessionState mode="SQLServer"sqlConnectionString="Data Source=localhost;User ID=***;Password=***"cookieless="false"timeout="1000" />

drupal welcome screen remover

Welcome to your new Drupal website!

Please follow these steps to set up and start using your website:.....

 ---------------------------------------------------------------------

if you remove drupal welcome screen you can add  your thema  css file 

#first-time { display:none; } 

that is ok!  

drupal add prefix sql command

you can use this sql command but if you have different tables so that you must to add or delete here ;

RENAME TABLE
   access TO drupal_access,
   accesslog TO drupal_accesslog,
   actions TO drupal_actions,
   actions_aid TO drupal_actions_aid,
   aggregator_category TO drupal_aggregator_category,
   aggregator_category_feed TO drupal_aggregator_category_feed,
   aggregator_category_item TO drupal_aggregator_category_item,
   aggregator_feed TO drupal_aggregator_feed,
   aggregator_item TO drupal_aggregator_item,
   authmap TO drupal_authmap,
   batch TO drupal_batch ,
   blocks TO drupal_blocks,
   blocks_roles TO drupal_blocks_roles,
   blogapi_files TO drupal_blogapi_files,
   boxes TO drupal_boxes,
   cache TO drupal_cache,
   cache_block TO drupal_cache_block,
   cache_content TO drupal_cache_content,
   cache_filter TO drupal_cache_filter,
   cache_form TO drupal_cache_form,
   cache_menu TO drupal_cache_menu,
   cache_page TO drupal_cache_page,
   cache_update TO drupal_cache_update,
   cache_views TO drupal_cache_views,
   cache_views_data TO drupal_cache_views_data,
   comments TO drupal_comments,
   contact TO drupal_contact,
   content_group TO drupal_content_group,
   content_group_fields TO drupal_content_group_fields,
   content_node_field TO drupal_content_node_field,
   content_node_field_instance TO drupal_content_node_field_instance,
   content_type_resim TO drupal_content_type_resim,
   files TO drupal_files,
   filters TO drupal_filters,
   filter_formats TO drupal_filter_formats,
   flood TO drupal_flood,
   history TO drupal_history,
   imagecache_action TO drupal_imagecache_action,
   imagecache_preset TO drupal_imagecache_preset,
   imce_files TO drupal_imce_files,
   languages TO drupal_languages,
   locales_source TO drupal_locales_source,
   locales_target TO drupal_locales_target,
   menu_custom TO drupal_menu_custom,
   menu_links TO drupal_menu_links,
   menu_router TO drupal_menu_router,
   node TO drupal_node,
   node_access TO drupal_node_access,
   node_comment_statistics TO drupal_node_comment_statistics,
   node_counter TO drupal_node_counter,
   node_revisions TO drupal_node_revisions,
   node_type TO drupal_node_type,
   openid_association TO drupal_openid_association,
   openid_nonce TO drupal_openid_nonce,
   permission TO drupal_permission,
   poll TO drupal_poll,
   poll_choices TO drupal_poll_choices,
   poll_votes TO drupal_poll_votes,
   profile_fields TO drupal_profile_fields,
   profile_values TO drupal_profile_values,
   role TO drupal_role,
   search_dataset TO drupal_search_dataset,
   search_index TO drupal_search_index,
   search_node_links TO drupal_search_node_links,
   search_total TO drupal_search_total,
   semaphore TO drupal_semaphore,
   sessions TO drupal_sessions,
   system TO drupal_system,
   term_data TO drupal_term_data,
   term_hierarchy TO drupal_term_hierarchy,
   term_node TO drupal_term_node,
   term_relation TO drupal_term_relation,
   term_synonym TO drupal_term_synonym,
   upload TO drupal_upload,
   url_alias TO drupal_url_alias,
   users TO drupal_users,
   users_roles TO drupal_users_roles,
   variable TO drupal_variable,
   views_display TO drupal_views_display,
   views_object_cache TO drupal_views_object_cache,
   views_view TO drupal_views_view,
   vocabulary TO drupal_vocabulary,
   vocabulary_node_types TO drupal_vocabulary_node_types,
   watchdog TO drupal_watchdog,
   wysiwyg TO drupal_wysiwyg;

Seninki kaç santim? - Greenpeace

Seninki kaç santim? - Greenpeace:
"2050’de dünyadaki balık stokları tükenecek.
Denizleri hala sonsuz bereket kaynağı olarak görüyorsanız çok yanılıyorsunuz.
Büyük balıkların %90’ı çoktan yakalandı.
Toplam balık stoklarının %60’ı bitti.
Gerı kalan %40 ise 40 yıl içinde son bulacak.
Balıkların bittiği gün deniz yaşamı da bitecek."

Windows ile Uyumlu Antivirusler

Windows Ailesiyle uyumlu antiviruslere bu sitelerden ulaşabiliriz.
Antivirus alırken bu sitelerde listelenen antivirusleri almanızı tavsiye ederiz.
http://www.microsoft.com/windows/antivirus-partners/windows-7.aspx
http://www.microsoft.com/windows/antivirus-partners/windows-vista.aspx
http://www.microsoft.com/windows/antivirus-partners/windows-xp.aspx

FTP 7.5 IIS Kullanıcı için Erişim

IIS üzerinde ftp erişimi için ya active directory kullanıcısı gerekliydi(active directory kurulu değilse normal windows kullanıcısı).FTP 7 ile birlikte IIS kullanıcılarınıda FTP kullanmaları için yapılandırabilmekteyiz.
Böylece her bir ftp hesabı için bir windows kullanıcısı açma gibi bir saçmalıkla uğraşmıyoruz.

IIS Kullanıcıları ftp üzerinde kullanmak için  bu adresi incelemekte fayda var.

SQL SERVER yeni schema eklemek ve şemaya kullanıcı atamak

MSSQL SERVER da burada gördüğüm kodu paylaşmak istedim.
Bu kod seçili tabloda;

• yeni bir login oluşturur.
• yeni bir kullanıcı oluşturur  ve loginini belirttiğimiz login yapar
• tablo sahibini ayarlar
• yeni bir schema oluştururur
• şema ile kullanıcıyı eşleştirir

yani schema ile kullanıcı eşleştirmesini ayarlar.

USE tempdb


GO

CREATE LOGIN u1 WITH PASSWORD = 'Mdfjd$sakj943857l7sdfh##30'

CREATE USER u1 WITH DEFAULT_SCHEMA = u1

GO

GRANT CREATE TABLE to u1

GO

CREATE SCHEMA sch1

GO

CREATE SCHEMA u1 AUTHORIZATION u1

GO

EXECUTE AS user = 'u1'

GO

CREATE TABLE t1(c1 int)

GO

revert

GO

SELECT user_name(uid) , * FROM sysobjects WHERE name = 't1'

GO