{"id":2685,"date":"2012-07-23T15:36:30","date_gmt":"2012-07-23T15:36:30","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=2685"},"modified":"2019-02-28T11:11:52","modified_gmt":"2019-02-28T11:11:52","slug":"microsoft-sql-server-a-giris","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/microsoft-sql-server-a-giris\/","title":{"rendered":"Microsoft SQL Server a Giri\u015f"},"content":{"rendered":"

Merhaba De\u011ferli Arkada\u015flar,<\/p>\n

Bu yaz\u0131mda sizlere SQL Server veri taban\u0131 y\u00f6netim sistemini anlataca\u011f\u0131m. Oracle \u0131n veritaban\u0131 y\u00f6netim sistemi alan\u0131nda Piyasada s\u00fcrd\u00fcrm\u00fc\u015f oldu\u011fu Krall\u0131\u011f\u0131 g\u00f6ren Microsoft, ilk defa 1989 y\u0131l\u0131nda Sybase den SQL Server \u0131 sat\u0131n ald\u0131 ve b\u00f6ylece SQL Server 1.0 \u0131 piyasaya s\u00fcrd\u00fc. Esasen\u00a0 Sybase SQL Server 3.0 ile ayn\u0131 olan Microsoft SQL Server 1.0 bug\u00fcn SQL Server 2012 versiyonuyla beraber \u00e7ok b\u00fcy\u00fck mesafeler kat ederek Oracle ile k\u0131smen yar\u0131\u015fmaya ba\u015flad\u0131.<\/p>\n

\"\"<\/a><\/p>\n

<\/p>\n\n

Microsoft yetkililerinden \u00f6\u011frendi\u011fim bilgiye g\u00f6re SQL Server 2008 Enterprise R2 ile birlikte asl\u0131nda Microsoft d\u00fcnyaya bu alanda bende var\u0131m demi\u015f ve yine s\u00f6ylentilere g\u00f6re SQL Server 2012 ile beraber Microsoft art\u0131k \u00f6ne ge\u00e7me \u00e7abalar\u0131 i\u00e7ine girecekmi\u015f \ud83d\ude42 Bu bilgiler duydu\u011fum bilgiler oldu\u011fu i\u00e7in do\u011frulu\u011fu konusunda net bir \u015fey s\u00f6yleyemeyece\u011fim bunlar Bili\u015fim Paparazilerin de d\u00f6nen s\u00f6ylentiler :). \u015eimdi d\u00f6nelim SQL Servera ve \u00f6zelliklerine.<\/p>\n

SQL Server, en temel manada tan\u0131mlarsak ili\u015fkisel bir veritaban\u0131 y\u00f6netim sistemidir. SQL Server ile \u00c7ok yo\u011fun miktarda verileri i\u015fleyebilir bunlar\u0131 g\u00fcvenli bir \u015fekilde saklayabilirsiniz. Saklanan verileri analiz edip Raporlama yapabilirsiniz. Ayr\u0131ca SQL Server ile Client dan gelen talepler k\u0131sa s\u00fcre i\u00e7erisinde kar\u015f\u0131lan\u0131r.<\/p>\n

SQL Server ile OLTP(Online Transaction Processing) \u00a0veritabanlar\u0131n\u0131 ve OLAP (Online Analytical Processing) veritabanlar\u0131n\u0131 y\u00f6netilebilir. OLTP tipi veritabanlar\u0131 bir sistem \u00fczerindeki b\u00fct\u00fcn i\u015flemleri kaydeden veritaban\u0131 \u00e7e\u015fidiyken OLAP veritabanlar\u0131 OLTP veritabanlar\u0131ndan gelen hareketlerin tutuldu\u011fu daha b\u00fcy\u00fck ve genelde Analiz yapmak i\u00e7in kullan\u0131lan veritabanlar\u0131d\u0131r.<\/p>\n

SQL Server \u0131n Farkl\u0131 ama\u00e7lar ve durumlar i\u00e7in geli\u015ftirilmi\u015f farkl\u0131 versiyonlar\u0131 vard\u0131r. Bunlar a\u015fa\u011f\u0131daki gibidir.<\/p>\n

    \n
  1. SQL Server Enterprise Editon : Profesyonel ve y\u00f6netim alan\u0131nda b\u00fct\u00fcn tool ve \u00f6zellikleri i\u00e7eren bir s\u00fcr\u00fcmd\u00fcr.<\/li>\n
  2. SQL Server Standart Editon : Orta \u00f6l\u00e7ekli ve k\u00fc\u00e7\u00fck i\u015fletmeler i\u00e7in geli\u015ftirilmi\u015f bir \u00fcr\u00fcnd\u00fcr.<\/li>\n
  3. SQL Server Workgroup Edition<\/li>\n
  4. SQL Server Personal Editon<\/li>\n
  5. SQL Server Developer Editon<\/li>\n
  6. SQL Server Express \u00a0Edition<\/li>\n
  7. SQL Server WEB Edition<\/li>\n
  8. SQL Server Desktop Engine<\/li>\n<\/ol>\n

    SQL Server, Windows i\u015fletim sistemi \u00fczerinde ve yine Windows sunucular\u0131n da \u00e7al\u0131\u015fan bir yaz\u0131l\u0131md\u0131r. SQL server \u00e7al\u0131\u015f\u0131rken faydaland\u0131\u011f\u0131 baz\u0131 servisler \u015funlard\u0131r.<\/p>\n

      \n
    • MS SQL Server<\/li>\n
    • SQL Server Agent<\/li>\n
    • Microsoft Distributed Transaction Coordinator (MS \u00a0DTC)<\/li>\n<\/ul>\n

      MS SQL Server<\/strong> : \u0130li\u015fkisel veritaban\u0131 y\u00f6netim sistemi \u00e7ekirde\u011fidir. Client dan gelen SQL ve T-SQL ifadelerini de\u011ferlendirir ve buna g\u00f6re text dosyalar\u0131n\u0131 y\u00f6netir. Ayr\u0131ca ayn\u0131 anda veriyi update etme gibi durumlar\u0131 y\u00f6netir.<\/p>\n

      SQL Server Agent<\/strong> : Veritaban\u0131m\u0131z\u0131n Ajan\u0131 olarak g\u00f6rev yapan bir servistir. Bu servis veritaban\u0131na bir job tan\u0131mlad\u0131\u011f\u0131m\u0131zda \u00a0yada otomatik yap\u0131lmas\u0131n\u0131 istedi\u011fimiz i\u015flemleri bizim yerimize yapmam\u0131z\u0131 sa\u011flar. Backup alma, Snapshot alma , mail yollama gibi i\u015flemleri belirli periyot tan\u0131mlayaraktan bizim yerimize yapabilen bir servistir.<\/p>\n

      Microsoft Distributed Transaction Coordinator (MS \u00a0DTC) :\u00a0<\/strong>Veritaban\u0131 \u00fczerinde olu\u015fan transaction lar\u0131 y\u00f6neten bir sistemdir. Farkl\u0131 veritaban\u0131 ve mimaride meydana gelen transactionlar\u0131 y\u00f6netmeye yarar.<\/p>\n

      B\u00f6ylece bir yaz\u0131m\u0131n daha sonuna gelinmi\u015f bulunmaktay\u0131m. Bir Sonraki yaz\u0131da bulu\u015fmak dile\u011fiyle Esen Kal\u0131n…<\/p>\n\n

      Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n

      – Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
      \n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Exadata Bak\u0131m ve Destek<\/span>
      \n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
      \n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Goldengate Bak\u0131m ve Destek<\/span>
      \n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Linux Bak\u0131m ve Destek<\/span>
      \n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Oracle EBS Bak\u0131m ve Destek<\/span>
      \n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Weblogic Bak\u0131m ve Destek<\/span>
      \n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
      \n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Oracle VM Server Bak\u0131m ve Destek<\/span>
      \n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Oracle EPPM Bak\u0131m ve Destek<\/span>
      \n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
      \n– Oracle Primavera Bak\u0131m ve Destek<\/span>
      \n– Oracle E\u011fitimleri<\/span>
      \n– SQL Server E\u011fitimleri<\/span>
      \n– Goldengate E\u011fitimleri<\/span>
      \n– Exadata E\u011fitimleri<\/span>
      \n– Linux E\u011fitimleri<\/span>
      \n– Oracle EBS E\u011fitimleri<\/span>
      \n– Oracle VM Server E\u011fitimleri<\/span>
      \n– Weblogic E\u011fitimleri<\/span>
      \n– Oracle EPPM E\u011fitimleri<\/span>
      \n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      Merhaba De\u011ferli Arkada\u015flar, Bu yaz\u0131mda sizlere SQL Server veri taban\u0131 y\u00f6netim sistemini anlataca\u011f\u0131m. Oracle \u0131n veritaban\u0131 y\u00f6netim sistemi alan\u0131nda Piyasada s\u00fcrd\u00fcrm\u00fc\u015f oldu\u011fu Krall\u0131\u011f\u0131 g\u00f6ren Microsoft, ilk defa 1989 y\u0131l\u0131nda Sybase den SQL Server \u0131 sat\u0131n ald\u0131 ve b\u00f6ylece SQL Server 1.0 \u0131 piyasaya s\u00fcrd\u00fc. Esasen\u00a0 Sybase SQL Server 3.0 ile ayn\u0131 olan Microsoft SQL Server …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,23],"tags":[508,1031,1038,1515,1577,1583,1584,1592,1616],"class_list":["post-2685","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-deveci","tag-mehmet-salih-deveci","tag-microsoft-sql-server","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-2008-dokumanlari","tag-sql-server-2008-konulari","tag-sql-server-a-giris"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=2685"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2685\/revisions"}],"predecessor-version":[{"id":5915,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2685\/revisions\/5915"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=2685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=2685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=2685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}