{"id":77,"date":"2016-02-26T15:18:56","date_gmt":"2016-02-26T13:18:56","guid":{"rendered":"http:\/\/www.erdoganozkaya.com.tr\/?p=77"},"modified":"2016-02-26T15:18:56","modified_gmt":"2016-02-26T13:18:56","slug":"ms-sql-server","status":"publish","type":"post","link":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/ms-sql-server.html","title":{"rendered":"MS SQL Server"},"content":{"rendered":"

– \u0130lk olarak 1989 y\u0131l\u0131nda, Oracle ve IBM\u2019e rakip olarak, Microsoft, Sybase ve Ashton-Tate\u2019in bir araya gelmesi ile OS\/2 i\u00e7in SQL Server 1.0 ad\u0131nda ortaya \u00e7\u0131km\u0131\u015ft\u0131r.
\n– SQL Server 6.0 ile birlikte Microsoft, Sybase ile yollar\u0131n\u0131 ay\u0131rm\u0131\u015f ve bundan sonraki s\u00fcr\u00fcmleri kendisi piyasaya s\u00fcrm\u00fc\u015ft\u00fcr.
\n– Daha sonra s\u0131ras\u0131yla Sql Server 2000,2005 ve 2008 adlar\u0131yla bilinen 8,9 ve 10. s\u00fcr\u00fcmleri \u00e7\u0131km\u0131\u015ft\u0131r.
\n<\/span>
\n– Sql Server 2000, daha \u00f6nceki s\u00fcr\u00fcmlerden farkl\u0131 olarak, 64 bit i\u00e7in de piyasaya s\u00fcr\u00fclm\u00fc\u015ft\u00fcr.
\n– Sql Server 2005 ile birlikte, veri tiplerine xml veri tipi dahil edilmi\u015ftir.
\n– Bu sayede T-Sql ile xml verileri \u00fczerinde \u00e7al\u0131\u015fmak kolayla\u015fm\u0131\u015ft\u0131r.
\n– 2005 s\u00fcr\u00fcm\u00fc ile Sql CLR ortaya \u00e7\u0131kart\u0131lm\u0131\u015ft\u0131r.
\n– CLR (Common Language Runtime), .Net dilleri ile Trigger, Prosed\u00fcr gibi nesneleri SQL Server i\u00e7erisine eklemeye izin verir.
\n– Ayr\u0131ca 2005 s\u00fcr\u00fcm\u00fc ile Database Mirroring \u00f6zelli\u011fi de Ms Sql Server\u2019a eklenmi\u015ftir.<\/p>\n

– 2008 s\u00fcr\u00fcm\u00fc ile ses,resim,video ve di\u011fer \u00e7oklu ortam dosyalar\u0131n\u0131 saklamak i\u00e7in BLOB (Binary Large Objects) veri tipi gelmi\u015ftir.
\n– Ayr\u0131ca mekansal verileri saklayan Spatial veri tipi ile dosyalar i\u00e7in Filestream veri tipi de eklenmi\u015ftir.<\/p>\n

Sql Server S\u00fcr\u00fcmleri<\/strong>
\n– Sql Server Compact Edition (Sql CE): Bu s\u00fcr\u00fcm Sql Mobile \u00fczerine kuruludur ve el terminalleri gibi mobil cihazlar\u0131n \u00fczerinde kullan\u0131l\u0131r.
\n– Di\u011fer s\u00fcr\u00fcmlere g\u00f6re bir \u00e7ok \u00f6zelli\u011fi eksiktir. \u00d6rne\u011fin, Stored Procedure ve View deste\u011fi bulunmamaktad\u0131r.
\n– Sql Server Express Edition: \u00dccretsiz s\u00fcr\u00fcmd\u00fcr. K\u00fc\u00e7\u00fck \u00e7apl\u0131 veritaban\u0131 gereksinimi oldu\u011funda kullan\u0131labilir.
\n– Sql Server Standard Edition: K\u00fc\u00e7\u00fck veya orta \u00f6l\u00e7ekli kurumlarda kullan\u0131lmas\u0131 uygundur. Maksimum 75 kullan\u0131c\u0131 deste\u011fi vard\u0131r.
\n– Sql Server Web Edition: Web tabanl\u0131 uygulamalar i\u00e7in optimize edilmi\u015f s\u00fcr\u00fcmd\u00fcr. Web hosting hizmeti veren firmalar i\u00e7in d\u00fc\u015f\u00fck maliyetli bir alternatiftir.
\n– Sql Server Workgroup Edition: Veritaban\u0131na ba\u011flanacak kullan\u0131c\u0131 say\u0131s\u0131 ve veritaban\u0131 b\u00fcy\u00fckl\u00fc\u011f\u00fc s\u0131n\u0131rland\u0131r\u0131lmam\u0131\u015ft\u0131r. Enterprise edition\u2019a g\u00f6re daha ucuzdur.
\n– Sql Server Enterprise Edition: Sql Server\u2019\u0131n t\u00fcm \u00f6zelliklerini i\u00e7eren s\u00fcr\u00fcmd\u00fcr.
\n– Sql Server Developer Edition: Enterprise Edition ile ayn\u0131 \u00f6zellikleri ta\u015f\u0131r. Fakat lisans \u015fart\u0131 gere\u011fi sadece test ve geli\u015ftirme ama\u00e7l\u0131 kullan\u0131labilir. Uygulama ve i\u015f ama\u00e7l\u0131 kullan\u0131ma ge\u00e7ildi\u011finde Enterprise Edition lisans\u0131 edinilmelidir.<\/p>\n

Servisler<\/strong>
\n– Kopyalama (Replication): Bu servis veritaban\u0131ndaki nesneleri senkronize etmek ve kopyalamak i\u00e7in kullan\u0131l\u0131r.
\n– Servis da\u011f\u0131t\u0131mc\u0131-al\u0131c\u0131 mant\u0131\u011f\u0131 ile \u00e7al\u0131\u015f\u0131r
\n– Bir da\u011f\u0131t\u0131mc\u0131 de\u011fi\u015fiklikleri al\u0131c\u0131lara da\u011f\u0131t\u0131r. Ve al\u0131c\u0131lar de\u011fi\u015fiklikleri alarak uygularlar.
\n– Analiz (Analysis): Sql server veritabanlar\u0131na veri madencili\u011fi yeteneklerini ekler.
\n– Raporlama (Reporting): Veritabanlar\u0131ndan elde edilen veriler \u00fczerinde rapor haz\u0131rlayan bir servistir. Y\u00f6netimi web tabanl\u0131d\u0131r.
\n– Bildirim (Notification): Al\u0131c\u0131lar belirli bir transaction\u2019\u0131n olmas\u0131 durumunda bildirim almak iEntegrasyon (Integration): Bu servis farkl\u0131 veri kaynaklar\u0131ndaki veriyi sql server\u2019a entegre etmek i\u00e7in kullan\u0131l\u0131r.
\n– Tam Text arama (Full Text Search): Bu servis, sql serverdaki yap\u0131land\u0131r\u0131lmam\u0131\u015f text datalar\u0131 \u00fczerinde indexleme yapar. Bu sayede s\u00fctunlar i\u00e7indeki textlerde arama yap\u0131labilir.
\n– LIKE deyimini kullanmaktan daha h\u0131zl\u0131 sonu\u00e7 vermektedir.
\n\u00e7in kaydolur. Transaction ger\u00e7ekle\u015fti\u011finde, bildirim servisi al\u0131c\u0131lara olay ile ilgili detayl\u0131 bilgi g\u00f6nderir.<\/p>\n

Kullan\u0131labilirlik \u2013 Ara\u00e7lar<\/strong>
\n– SQLCMD: Sql server \u00fczerinde sorgular\u0131n yaz\u0131lmas\u0131 ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131n\u0131 sa\u011flayan komut sat\u0131r\u0131 uygulamas\u0131d\u0131r.
\n– Visual Studio: Sql CLR\u2019in \u00e7al\u0131\u015ft\u0131raca\u011f\u0131 kodlar\u0131 yaz\u0131p, debug etmek i\u00e7in kullan\u0131labilir.
\n– Sql Server Management Studio: Sql server 2005 ve bundan sonraki s\u00fcr\u00fcmlerde bulunan, veritaban\u0131n\u0131 y\u00f6netme ve ayarlar\u0131n\u0131 d\u00fczenleme imkan\u0131 sa\u011flayan bir aray\u00fczd\u00fcr.
\n– Business Intelligence Development Studio: Visual Studio \u00fczerine, analiz, entegrasyon, veri madencili\u011fi raporlama gibi servislerin eklenmesi ile sunulan ara\u00e7t\u0131r.<\/p>\n

Al\u0131nt\u0131: trakya.edu.tr<\/p>\n","protected":false},"excerpt":{"rendered":"

– \u0130lk olarak 1989 y\u0131l\u0131nda, Oracle ve IBM\u2019e rakip olarak, Microsoft, Sybase ve Ashton-Tate\u2019in bir araya gelmesi ile OS\/2 i\u00e7in SQL Server 1.0 ad\u0131nda ortaya […]<\/p>\n","protected":false},"author":1,"featured_media":78,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5,4,1,3],"tags":[12,13,14,15],"_links":{"self":[{"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/77"}],"collection":[{"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/comments?post=77"}],"version-history":[{"count":1,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/77\/revisions"}],"predecessor-version":[{"id":79,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/77\/revisions\/79"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/media\/78"}],"wp:attachment":[{"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/categories?post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erdoganozkaya.com.tr\/index.php\/wp-json\/wp\/v2\/tags?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}